You are not logged in.

#1 2011-09-13 21:04:04

Zibi1981
Member
From: Poland
Registered: 2008-01-31
Posts: 670

Akonadi configuration

Hi there smile

Recently I reinstalled my Arch Linux from scratch. The system was old, many, many, many times up-graded and many apps didn't work as I wanted them to, so I decided to start a new Arch installation, especially when a new kernel branch emerged. Of course I still have issues with some apps, and one of the most important is the one regarding Akonadi. I've read the entry in Arch's Wiki, but not all is clear to me, especially this part

First, you need to set up the database using the following commands (replace password with the correct one):

CREATE DATABASE akonadi;
 GRANT ALL PRIVILEGES ON akonadi.* TO 'akonadiuser' IDENTIFIED BY 'password';
 FLUSH PRIVILEGES;

How to execute those commands?


"... being a Linux user is sort of like living in a house inhabited by a large family of carpenters and architects. Every morning when you wake up, the house is a little different. Maybe there is a new turret, or some walls have moved. Or perhaps someone has temporarily removed the floor under your bed."

MSI Raider GE78HX 13VI-032PL

Offline

#2 2011-09-13 23:41:14

George
Member
Registered: 2011-05-11
Posts: 165

Re: Akonadi configuration

You don't need to do that unless you're trying to make akonadi use a system wide installation of mysql rather than starting its own server. The only reason AFAIK to do that is to save some resources if you have several different applications using mysql and you don't want them all to run their own copy.

Offline

#3 2011-09-14 05:18:55

Zibi1981
Member
From: Poland
Registered: 2008-01-31
Posts: 670

Re: Akonadi configuration

Well, it would be a good idea to have every application using the same server, but still I don't know how to execute those commands...


"... being a Linux user is sort of like living in a house inhabited by a large family of carpenters and architects. Every morning when you wake up, the house is a little different. Maybe there is a new turret, or some walls have moved. Or perhaps someone has temporarily removed the floor under your bed."

MSI Raider GE78HX 13VI-032PL

Offline

#4 2011-09-14 09:33:19

George
Member
Registered: 2011-05-11
Posts: 165

Re: Akonadi configuration

Those commands need to be carried out by the mysql superuser in a mysql prompt which you get to by;

mysql -p -u root

If you're going to do that then you'll need to follow https://wiki.archlinux.org/index.php/MySQL to get the system installation going first.

However although you might expect there to be an improvement from only using a single db, one person who tried it found that it made no noticable difference to them[1] , but in the process did write a tutorial you may find useful if you're going to try the same [2]
[1] http://noughmad.eu/using-single-database-kde-programs
[2] http://userbase.kde.org/Tutorials/Shared_Database

Offline

#5 2011-09-14 19:53:03

Zibi1981
Member
From: Poland
Registered: 2008-01-31
Posts: 670

Re: Akonadi configuration

O.K., I followed the instructions on that links you shared, but still haven't moved a bit with my Akonadi config. When I try to run Akonadi I see 3 error messages.

Akonadi Server Self-Test Report
===============================

Test 1:  SUCCESS
--------

Database driver found.
Details: The QtSQL driver 'QMYSQL' is required by your current Akonadi server configuration and was found on your system.

File content of '/home/zbyszek/.config/akonadi/akonadiserverrc':
[%General]
Driver=QMYSQL

[QMYSQL]
Name=akonadi
Host=localhost
ServerPath=/usr/bin/mysqld
StartServer=false
User=akonadiuser
Password=<password>
Options=

[Debug]
Tracer=null


Test 2:  SUCCESS
--------

Akonadi is not running as root
Details: Akonadi is not running as a root/administrator user, which is the recommended setup for a secure system.

Test 3:  SKIP
--------

MySQL server executable not tested.
Details: The current configuration does not require an internal MySQL server.

Test 4:  SKIP
--------

MySQL server error log not tested.
Details: The current configuration does not require an internal MySQL server.

Test 5:  SKIP
--------

MySQL server configuration not tested.
Details: The current configuration does not require an internal MySQL server.

Test 6:  SUCCESS
--------

akonadictl found and usable
Details: The program '/usr/bin/akonadictl' to control the Akonadi server was found and could be executed successfully.
Result:
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
Akonadi 1.6.0


Test 7:  ERROR
--------

Akonadi control process not registered at D-Bus.
Details: The Akonadi control process is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup.

Test 8:  ERROR
--------

Akonadi server process not registered at D-Bus.
Details: The Akonadi server process is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup.

Test 9:  SUCCESS
--------

Nepomuk search service registered at D-Bus.
Details: The Nepomuk search service is registered at D-Bus which typically indicates it is operational.

Test 10:  SUCCESS
--------

Nepomuk search service uses an appropriate backend. 
Details: The Nepomuk search service uses one of the recommended backends.

Test 11:  SKIP
--------

Protocol version check not possible.
Details: Without a connection to the server it is not possible to check if the protocol version meets the requirements.

Test 12:  ERROR
--------

No resource agents found.
Details: No resource agents have been found, Akonadi is not usable without at least one. This usually means that no resource agents are installed or that there is a setup problem. The following paths have been searched: '/usr/share/akonadi/agents'. The XDG_DATA_DIRS environment variable is set to '/usr/share/:/usr/local/share/'; make sure this includes all paths where Akonadi agents are installed.

Directory listing of '/usr/share/akonadi/agents':
akonotesresource.desktop
birthdaysresource.desktop
calendarsearchagent.desktop
contactsresource.desktop
davgroupwareresource.desktop
icalresource.desktop
imapresource.desktop
invitationsagent.desktop
kabcresource.desktop
kcalresource.desktop
kdeaccountsresource.desktop
knutresource.desktop
kolabproxyresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
maildispatcheragent.desktop
mboxresource.desktop
microblog.desktop
mixedmaildirresource.desktop
mtdummyresource.desktop
nepomukcalendarfeeder.desktop
nepomukcontactfeeder.desktop
nepomukemailfeeder.desktop
nepomuktagresource.desktop
nntpresource.desktop
notesresource.desktop
openxchangeresource.desktop
pop3resource.desktop
vcarddirresource.desktop
vcardresource.desktop

Environment variable XDG_DATA_DIRS is set to '/usr/share/:/usr/local/share/'

Test 13:  SUCCESS
--------

No current Akonadi server error log found.
Details: The Akonadi server did not report any errors during its current startup.

Test 14:  SUCCESS
--------

No previous Akonadi server error log found.
Details: The Akonadi server did not report any errors during its previous startup.

Test 15:  SUCCESS
--------

No current Akonadi control error log found.
Details: The Akonadi control process did not report any errors during its current startup.

Test 16:  SUCCESS
--------

No previous Akonadi control error log found.
Details: The Akonadi control process did not report any errors during its previous startup.

Do anyone have a working Akonadi anyway? I get a feeling, that it's kind of crapware with which everyone has plenty of issues...


"... being a Linux user is sort of like living in a house inhabited by a large family of carpenters and architects. Every morning when you wake up, the house is a little different. Maybe there is a new turret, or some walls have moved. Or perhaps someone has temporarily removed the floor under your bed."

MSI Raider GE78HX 13VI-032PL

Offline

#6 2011-09-14 21:18:52

George
Member
Registered: 2011-05-11
Posts: 165

Re: Akonadi configuration

Zibi1981 wrote:

Do anyone have a working Akonadi anyway? I get a feeling, that it's kind of crapware with which everyone has plenty of issues...

Well I do for one, and I've not had any major issues for a long time, as ever you're going to be hearing more from people who are having trouble than from those who find it works fine for them.

If you're going to be experimenting with akonadi I'd suggest you install kdepim-akonadiconsole which is a debug browser for akonadi.

You say "When I try to run akonadi", how are you trying? Did you use akonadictl (re)start?
Are you running a full kde session, if so then akonadi should be started automatically when you login (unless you've disabled it at some point in the past and copied the config files to your new install).

Offline

#7 2011-09-16 16:49:45

Zibi1981
Member
From: Poland
Registered: 2008-01-31
Posts: 670

Re: Akonadi configuration

First - I already have kdepim-akonadiconsole installed, but it's not very useful when one can't run Akonadi...

Second - Usually I try to run it by rigt-clicking on the Akonadi Tray icon and selecting "Run Akonadi". Akonadi doesn't start with my system. Here's what I got when trying to run it in console

[root@myhost zbyszek]# akonadictl restart
D-Bus session bus is not available!
"[
0: akonadictl(_Z11akBacktracev+0x34) [0x40cfd4]
1: akonadictl() [0x40d36c]
2: /lib/libc.so.6(+0x347b0) [0x7f54a36497b0]
3: /lib/libc.so.6(gsignal+0x35) [0x7f54a3649735]
4: /lib/libc.so.6(abort+0x17b) [0x7f54a364abab]
5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7f54a48184f4]
6: akonadictl(_ZN15FileDebugStream9writeDataEPKcx+0x92) [0x40e862]
7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xaf) [0x7f54a48a602f]
8: /usr/lib/libQtCore.so.4(+0x101773) [0x7f54a48ae773]
9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7f54a48b75f9]
10: akonadictl(_ZN13AkApplicationC1ERiPPc+0x13a) [0x408efa]
11: akonadictl(main+0x27) [0x407447]
12: /lib/libc.so.6(__libc_start_main+0xed) [0x7f54a363613d]
13: akonadictl() [0x408285]
]
"

Third - I run a full KDE session.


"... being a Linux user is sort of like living in a house inhabited by a large family of carpenters and architects. Every morning when you wake up, the house is a little different. Maybe there is a new turret, or some walls have moved. Or perhaps someone has temporarily removed the floor under your bed."

MSI Raider GE78HX 13VI-032PL

Offline

#8 2011-09-16 17:09:51

Loose_Control
Member
From: Germany
Registered: 2011-01-11
Posts: 136

Re: Akonadi configuration

why are you starting akonadi as root? o_O

Offline

#9 2011-09-16 17:23:50

George
Member
Registered: 2011-05-11
Posts: 165

Re: Akonadi configuration

Akonadi is not a system wide thing, even if you insist on using a systemwide mysql db you still need to start akonadi as your usual user.

Offline

#10 2011-09-16 18:50:38

Zibi1981
Member
From: Poland
Registered: 2008-01-31
Posts: 670

Re: Akonadi configuration

O.K., my fault. Now as a regular user...

[zbyszek@myhost ~]$ akonadictl start
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
Starting Akonadi Server...
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
   done.
[zbyszek@myhost ~]$ Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi/db_misc" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
Creating symlink from "/tmp/akonadi-zbyszek.s4qUJG" to "/socket-myhost" failed 
Could not create socket directory for Akonadi. 
QDir::mkdir: Empty or null file name(s)
search paths:  ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/sbin", "/usr/sbin", "/sbin", "/opt/java/jre/bin", "/usr/bin/core_perl", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin") 
Found mysql_install_db:  "/usr/bin/mysql_install_db" 
Found mysqlcheck:  "/usr/bin/mysqlcheck" 
Failed to use database "akonadi" 
Database error: "Can't connect to local MySQL server through socket '/home/zbyszek//mysql.socket' (2) QMYSQL: Unable to connect" 
Trying to create database now... 
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
Creating symlink from "/tmp/akonadi-zbyszek.3gBN7y" to "/socket-myhost" failed 
Could not create socket directory for Akonadi. 
QDir::mkdir: Empty or null file name(s)
QIODevice::putChar: Closed device
Database error: Cannot open database.
QIODevice::putChar: Closed device
Last driver error: "QMYSQL: Unable to connect"
QIODevice::putChar: Closed device
Last database error: "Can't connect to local MySQL server through socket '/home/zbyszek//mysql.socket' (2)"
QIODevice::putChar: Closed device
Unable to open database "Can't connect to local MySQL server through socket '/home/zbyszek//mysql.socket' (2) QMYSQL: Unable to connect"
QIODevice::putChar: Closed device
"[                                                                                                                                                           
0: akonadiserver(_Z11akBacktracev+0x34) [0x446d54]                                                                                                           
1: akonadiserver() [0x4470ec]                                                                                                                                
2: /lib/libc.so.6(+0x347b0) [0x7f208f2147b0]                                                                                                                 
3: /lib/libc.so.6(gsignal+0x35) [0x7f208f214735]                                                                                                             
4: /lib/libc.so.6(abort+0x17b) [0x7f208f215bab]
5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7f2090e964f4]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x92) [0x4485e2]
7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xaf) [0x7f2090f2402f]
8: /usr/lib/libQtCore.so.4(+0x101773) [0x7f2090f2c773]
9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7f2090f355f9]
10: akonadiserver() [0x44bf43]
11: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x35) [0x44d1b5]
12: akonadiserver(main+0x19a) [0x44177a]
13: /lib/libc.so.6(__libc_start_main+0xed) [0x7f208f20113d]
14: akonadiserver() [0x441ee1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi/db_misc" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
Creating symlink from "/tmp/akonadi-zbyszek.aKb2QK" to "/socket-myhost" failed 
Could not create socket directory for Akonadi. 
QDir::mkdir: Empty or null file name(s)
search paths:  ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/sbin", "/usr/sbin", "/sbin", "/opt/java/jre/bin", "/usr/bin/core_perl", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin") 
Found mysql_install_db:  "/usr/bin/mysql_install_db" 
Found mysqlcheck:  "/usr/bin/mysqlcheck" 
Failed to use database "akonadi" 
Database error: "Can't connect to local MySQL server through socket '/home/zbyszek//mysql.socket' (2) QMYSQL: Unable to connect" 
Trying to create database now... 
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
Creating symlink from "/tmp/akonadi-zbyszek.OSDuiD" to "/socket-myhost" failed 
Could not create socket directory for Akonadi. 
QDir::mkdir: Empty or null file name(s)
QIODevice::putChar: Closed device
Database error: Cannot open database.
QIODevice::putChar: Closed device
Last driver error: "QMYSQL: Unable to connect"
QIODevice::putChar: Closed device
Last database error: "Can't connect to local MySQL server through socket '/home/zbyszek//mysql.socket' (2)"
QIODevice::putChar: Closed device
Unable to open database "Can't connect to local MySQL server through socket '/home/zbyszek//mysql.socket' (2) QMYSQL: Unable to connect"
QIODevice::putChar: Closed device
"[
0: akonadiserver(_Z11akBacktracev+0x34) [0x446d54]
1: akonadiserver() [0x4470ec]
2: /lib/libc.so.6(+0x347b0) [0x7f0e936c67b0]
3: /lib/libc.so.6(gsignal+0x35) [0x7f0e936c6735]
4: /lib/libc.so.6(abort+0x17b) [0x7f0e936c7bab]
5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7f0e953484f4]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x92) [0x4485e2]
7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xaf) [0x7f0e953d602f]
8: /usr/lib/libQtCore.so.4(+0x101773) [0x7f0e953de773]
9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7f0e953e75f9]
10: akonadiserver() [0x44bf43]
11: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x35) [0x44d1b5]
12: akonadiserver(main+0x19a) [0x44177a]
13: /lib/libc.so.6(__libc_start_main+0xed) [0x7f0e936b313d]
14: akonadiserver() [0x441ee1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi/db_misc" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
Creating symlink from "/tmp/akonadi-zbyszek.qaaquN" to "/socket-myhost" failed 
Could not create socket directory for Akonadi. 
QDir::mkdir: Empty or null file name(s)
search paths:  ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/sbin", "/usr/sbin", "/sbin", "/opt/java/jre/bin", "/usr/bin/core_perl", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin") 
Found mysql_install_db:  "/usr/bin/mysql_install_db" 
Found mysqlcheck:  "/usr/bin/mysqlcheck" 
Failed to use database "akonadi" 
Database error: "Can't connect to local MySQL server through socket '/home/zbyszek//mysql.socket' (2) QMYSQL: Unable to connect" 
Trying to create database now... 
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
Creating symlink from "/tmp/akonadi-zbyszek.9j77ZF" to "/socket-myhost" failed 
Could not create socket directory for Akonadi. 
QDir::mkdir: Empty or null file name(s)
QIODevice::putChar: Closed device
Database error: Cannot open database.
QIODevice::putChar: Closed device
Last driver error: "QMYSQL: Unable to connect"
QIODevice::putChar: Closed device
Last database error: "Can't connect to local MySQL server through socket '/home/zbyszek//mysql.socket' (2)"
QIODevice::putChar: Closed device
Unable to open database "Can't connect to local MySQL server through socket '/home/zbyszek//mysql.socket' (2) QMYSQL: Unable to connect"
QIODevice::putChar: Closed device
"[
0: akonadiserver(_Z11akBacktracev+0x34) [0x446d54]
1: akonadiserver() [0x4470ec]
2: /lib/libc.so.6(+0x347b0) [0x7fa0f63f77b0]
3: /lib/libc.so.6(gsignal+0x35) [0x7fa0f63f7735]
4: /lib/libc.so.6(abort+0x17b) [0x7fa0f63f8bab]
5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7fa0f80794f4]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x92) [0x4485e2]
7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xaf) [0x7fa0f810702f]
8: /usr/lib/libQtCore.so.4(+0x101773) [0x7fa0f810f773]
9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7fa0f81185f9]
10: akonadiserver() [0x44bf43]
11: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x35) [0x44d1b5]
12: akonadiserver(main+0x19a) [0x44177a]
13: /lib/libc.so.6(__libc_start_main+0xed) [0x7fa0f63e413d]
14: akonadiserver() [0x441ee1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi/db_misc" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
Creating symlink from "/tmp/akonadi-zbyszek.G86BxP" to "/socket-myhost" failed 
Could not create socket directory for Akonadi. 
QDir::mkdir: Empty or null file name(s)
search paths:  ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/sbin", "/usr/sbin", "/sbin", "/opt/java/jre/bin", "/usr/bin/core_perl", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin") 
Found mysql_install_db:  "/usr/bin/mysql_install_db" 
Found mysqlcheck:  "/usr/bin/mysqlcheck" 
Failed to use database "akonadi" 
Database error: "Can't connect to local MySQL server through socket '/home/zbyszek//mysql.socket' (2) QMYSQL: Unable to connect" 
Trying to create database now... 
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
XdgBaseDirs::saveDir: failed to create directory ' "/home/zbyszek/.local/share/akonadi" ' 
Creating symlink from "/tmp/akonadi-zbyszek.PYn57H" to "/socket-myhost" failed 
Could not create socket directory for Akonadi. 
QDir::mkdir: Empty or null file name(s)
QIODevice::putChar: Closed device
Database error: Cannot open database.
QIODevice::putChar: Closed device
Last driver error: "QMYSQL: Unable to connect"
QIODevice::putChar: Closed device
Last database error: "Can't connect to local MySQL server through socket '/home/zbyszek//mysql.socket' (2)"
QIODevice::putChar: Closed device
Unable to open database "Can't connect to local MySQL server through socket '/home/zbyszek//mysql.socket' (2) QMYSQL: Unable to connect"
QIODevice::putChar: Closed device
"[
0: akonadiserver(_Z11akBacktracev+0x34) [0x446d54]
1: akonadiserver() [0x4470ec]
2: /lib/libc.so.6(+0x347b0) [0x7f924e1d17b0]
3: /lib/libc.so.6(gsignal+0x35) [0x7f924e1d1735]
4: /lib/libc.so.6(abort+0x17b) [0x7f924e1d2bab]
5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7f924fe534f4]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x92) [0x4485e2]
7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xaf) [0x7f924fee102f]
8: /usr/lib/libQtCore.so.4(+0x101773) [0x7f924fee9773]
9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7f924fef25f9]
10: akonadiserver() [0x44bf43]
11: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x35) [0x44d1b5]
12: akonadiserver(main+0x19a) [0x44177a]
13: /lib/libc.so.6(__libc_start_main+0xed) [0x7f924e1be13d]
14: akonadiserver() [0x441ee1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted! 

"... being a Linux user is sort of like living in a house inhabited by a large family of carpenters and architects. Every morning when you wake up, the house is a little different. Maybe there is a new turret, or some walls have moved. Or perhaps someone has temporarily removed the floor under your bed."

MSI Raider GE78HX 13VI-032PL

Offline

#11 2011-09-16 18:57:04

Loose_Control
Member
From: Germany
Registered: 2011-01-11
Posts: 136

Re: Akonadi configuration

is /home/zbyszek/.local/share/akonadi owned by you or root? delete it or change ownership to your user account (and everything in it) and try starting akonadi again

edit
i think the best way is too delete the akonadi folder and then run this:
mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/ --basedir=/usr
start akonadi after that and it should work without trouble...

Last edited by Loose_Control (2011-09-16 19:03:02)

Offline

#12 2011-09-16 18:57:34

George
Member
Registered: 2011-05-11
Posts: 165

Re: Akonadi configuration

How's your system for free space? If you've got plenty free, check the permissions on the directories mentioned in the error message, perhaps they got messed up when you tried to start akonadi as root.

Offline

#13 2011-09-16 20:38:43

Zibi1981
Member
From: Poland
Registered: 2008-01-31
Posts: 670

Re: Akonadi configuration

I have plenty of gigabytes free, so it's not a problem with space. It could be a problem with permission to ~/.share/akonadi folder, but I'm not sure. Here's how it looks regarding ownership of this folder

[zbyszek@myhost ~]$ cd /home/zbyszek/.local/share/
[zbyszek@myhost share]$ ls -l
razem 12
drwxr-xr-x 3 zbyszek wheel 4096 09-16 22:33 akonadi
drwxr-xr-x 2 zbyszek wheel 4096 09-11 19:00 applications
drwxr-xr-x 4 zbyszek wheel 4096 09-11 13:21 Trash
Loose_Control wrote:

is /home/zbyszek/.local/share/akonadi owned by you or root? delete it or change ownership to your user account (and everything in it) and try starting akonadi again

edit
i think the best way is too delete the akonadi folder and then run this:
mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/ --basedir=/usr
start akonadi after that and it should work without trouble...

[zbyszek@myhost .local]$ mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/ --basedir=/usr
WARNING: The host 'myhost' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h myhost password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /usr/mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/scripts/mysqlbug script!

Last edited by Zibi1981 (2011-09-16 20:42:44)


"... being a Linux user is sort of like living in a house inhabited by a large family of carpenters and architects. Every morning when you wake up, the house is a little different. Maybe there is a new turret, or some walls have moved. Or perhaps someone has temporarily removed the floor under your bed."

MSI Raider GE78HX 13VI-032PL

Offline

#14 2011-09-16 21:20:53

Loose_Control
Member
From: Germany
Registered: 2011-01-11
Posts: 136

Re: Akonadi configuration

hm is your /etc/hosts set up correctly maybe that's why akonadi is not working because of this "Creating symlink from "/tmp/akonadi-zbyszek.s4qUJG" to "/socket-myhost" failed" considering the "WARNING: The host 'myhost' could not be looked up with resolveip." error you should take a look at this

https://wiki.archlinux.org/index.php/Co … e_hostname
fix /etc/hosts and try starting akonadi again after a reboot

Last edited by Loose_Control (2011-09-16 21:25:37)

Offline

#15 2011-09-16 21:38:36

George
Member
Registered: 2011-05-11
Posts: 165

Re: Akonadi configuration

Could you just clarify whether you're still trying to use a system wide db for akonadi or are you trying (at least for now) to use the standard config? It doesn't make any difference to the hostname issue that Loose_Control mentioned but would be useful to know for any futher troubleshooting.

Offline

#16 2011-09-18 19:09:07

Zibi1981
Member
From: Poland
Registered: 2008-01-31
Posts: 670

Re: Akonadi configuration

Well, finally I was able to at least partially solve my problem with Akonadi. Once more I followed the tips published here and here with some modifications (i.e. I have put StartServer=true instead of StartServer=false in ~/.config/akonadi/akonadiserverrc), and after restarting Arch Akonadi was running. I don't have any idea why this hadn't been working before.

George wrote:

Could you just clarify whether you're still trying to use a system wide db for akonadi or are you trying (at least for now) to use the standard config? It doesn't make any difference to the hostname issue that Loose_Control mentioned but would be useful to know for any futher troubleshooting.

I think I use system wide database, although I'm not sure.

Now I have different issue which can be seen on this print-screen.

[ url=http://imageshack.us/photo/my-images/26/zrzutekranu1b.png/][ img]http://img26.imageshack.us/img26/6444/zrzutekranu1b.png[/img ][/url ]

(Moderator: The image you included is still far too big, see https://wiki.archlinux.org/index.php/Fo … s_and_Code. Please fix your url statement above accordingly.)

Where are those files located exactly?

Last edited by bernarcher (2011-09-18 19:24:22)


"... being a Linux user is sort of like living in a house inhabited by a large family of carpenters and architects. Every morning when you wake up, the house is a little different. Maybe there is a new turret, or some walls have moved. Or perhaps someone has temporarily removed the floor under your bed."

MSI Raider GE78HX 13VI-032PL

Offline

#17 2011-09-18 19:26:12

George
Member
Registered: 2011-05-11
Posts: 165

Re: Akonadi configuration

Select the resource and click on modify, you'll probably find that there's no filename specified in which case you can select where to save it (I've put the files in .local).
You can just delete the one named akonadi_ical_resource_0 as you only need one calendar configured to start with.

Offline

#18 2011-09-18 22:11:07

Zibi1981
Member
From: Poland
Registered: 2008-01-31
Posts: 670

Re: Akonadi configuration

O.K., that was quite easy, but was is this akonadi_ical_resource_0 resource precisely?


"... being a Linux user is sort of like living in a house inhabited by a large family of carpenters and architects. Every morning when you wake up, the house is a little different. Maybe there is a new turret, or some walls have moved. Or perhaps someone has temporarily removed the floor under your bed."

MSI Raider GE78HX 13VI-032PL

Offline

#19 2011-09-18 22:24:02

George
Member
Registered: 2011-05-11
Posts: 165

Re: Akonadi configuration

Akonadi refers to sources of information (can be emails, appointments, notes etc.) as resources, akonadi_ical_resource_0 was an automatically added calendar resource (note the icon, identical to personal calendar) backed by an iCalendar (http://en.wikipedia.org/wiki/ICalendar) file. The resource called Personal Calendar also stores its info in an ical file but it has a more useful name so that was why I suggested deleting the other and correcting the Personal Calendar one.

Offline

#20 2011-09-19 08:44:40

Zibi1981
Member
From: Poland
Registered: 2008-01-31
Posts: 670

Re: Akonadi configuration

I have removed akonadi_ical_resource_0 and this "problem" is gone, but I have another tongue Besides GMail (IMAP) I have added my second e-mail account which uses POP3 protocol. Now every 5 minutes I see a pop-up window asking me for my KWallet password. How to make it to remember my password?


"... being a Linux user is sort of like living in a house inhabited by a large family of carpenters and architects. Every morning when you wake up, the house is a little different. Maybe there is a new turret, or some walls have moved. Or perhaps someone has temporarily removed the floor under your bed."

MSI Raider GE78HX 13VI-032PL

Offline

#21 2011-09-19 09:44:22

George
Member
Registered: 2011-05-11
Posts: 165

Re: Akonadi configuration

You could try changing the kwallet settings (somewhere in systemsettings) to stop it from closing the wallet, apart from that I don't really have any idea as I don't use POP or have a kwallet password.

Offline

#22 2011-09-20 10:52:01

Zibi1981
Member
From: Poland
Registered: 2008-01-31
Posts: 670

Re: Akonadi configuration

And is there a way to make KWallet to remember the password, even after the system has been restarted?

Last edited by Zibi1981 (2011-09-20 10:52:30)


"... being a Linux user is sort of like living in a house inhabited by a large family of carpenters and architects. Every morning when you wake up, the house is a little different. Maybe there is a new turret, or some walls have moved. Or perhaps someone has temporarily removed the floor under your bed."

MSI Raider GE78HX 13VI-032PL

Offline

#23 2011-09-20 13:14:58

George
Member
Registered: 2011-05-11
Posts: 165

Re: Akonadi configuration

That sounds rather like a bug to me. Try deleting all entries in the kmail and perhaps pop folders in kwalletmanager to see if that helps.

Offline

Board footer

Powered by FluxBB