Akonadi on f10 (again)

Tue Mar 10 04:54:08 UTC 2009

On Sunday 01 March 2009, Kevin Kofler wrote:
>Gene Heskett wrote:
>> [akonadiserver] 090301 15:32:16 [ERROR] Fatal error: Please read
>> ["Security" section of the manual to find out how
>> to run mysqld as root!
>
>So mysql is refusing to run as root the way Akonadi is configuring it. :-/ I
>hate apps doing that. The mysql.conf Akonadi writes out probably needs to
>be fixed for that.
>
>> But. mysqld is running, quite a few copies of it in fact, and all are
>> running as the user mysql.
>> Now, I already had mysql installed on the F8 install, and setup then for
>> mythtv's use.  Is there some special mysql configuration that didn't get
>> done that would allow Akonadi to use it?
>
>kcmshell4 kcm_akonadi
>uncheck "Use internal MySQL server" and configure your MySQL server there.

Ok, I think I did that, setting it to akonadi as user and passwords, but I 
left the line about a unix socket at the bottom of the form as is.  Then I ran 
mysqladministrator and added akonadi as a new user, and assigned the same 
passwords.  But when I tried to start the akonadi server, the window 
eventually pops up listing a number of checks.  Since that window shrinks to 
nothing in about 10 seconds, and faster if you try to scroll down the list, I 
finally gave up and copied it to the clipboard, so there that is:

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

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

Database driver found.
Details: The QtSQL driver 'QMYSQL' is required by your current Akonadi server 
configuration.
The following drivers are installed: QSQLITE, QMYSQL3, QMYSQL.
Make sure the required driver is installed.

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

[QMYSQL]
Name=akonadi
User=akonadi
Password=akonadi
Options="UNIX_SOCKET=/root/.local/share/akonadi/db_misc/mysql.socket"
ServerPath=/usr/libexec/mysqld
StartServer=false
Host=coyote.coyote.den

[Debug]
Tracer=null

Test 2:  SKIP
--------

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

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

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

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

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

Test 5:  SUCCESS
--------

akonadictl found and usable
Details: The program '/usr/bin/akonadictl' to control the Akonadi server was 
found and could be executed successfully.
Result:
Akonadi Control: stopped
Akonadi Server: stopped

Test 6:  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 7:  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 8:  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 9:  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/kde-settings/kde-
profile/default/share:/usr/local/share:/usr/share', make sure this includes 
all paths where Akonadi agents are installed to.

Directory listing of '/usr/share/akonadi/agents':
distlistresource.desktop
icalresource.desktop
imaplibresource.desktop
kabcresource.desktop
kcalresource.desktop
knutresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
mailthreaderagent.desktop
nepomukcontactfeeder.desktop
nepomukemailfeeder.desktop
nepomuktagresource.desktop
nntpresource.desktop
strigifeeder.desktop
vcarddirresource.desktop
vcardresource.desktop

Environment variable XDG_DATA_DIRS is set to '/usr/share/kde-settings/kde-
profile/default/share:/usr/local/share:/usr/share'

Test 10:  ERROR
--------

Current Akonadi server error log found.
Details: The Akonadi server did report error during startup into <a 
href='/root/.local/share/akonadi/akonadiserver.error'>/root/.local/share/akonadi/akonadiserver.error</a>.

File content of '/root/.local/share/akonadi/akonadiserver.error':
Unable to open database "Access denied for user 'akonadi'@'%' to database 
'akonadi' QMYSQL: Unable to connect" 
"[
0: akonadiserver(_Z10kBacktracev+0x35) [0x8051f75]
1: akonadiserver [0x8052456]
2: [0xffffe400]
3: [0xffffe424]
4: /lib/libc.so.6(gsignal+0x50) [0x45251460]
5: /lib/libc.so.6(abort+0x188) [0x45252e28]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x95) 
[0x45f9d855]
7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8053164]
8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x9e) [0x4602b3ce]
9: /usr/lib/libQtCore.so.4 [0x4603839e]
10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68) [0x46038698]
11: akonadiserver(_ZN6QDebugD1Ev+0x44) [0x804d674]
12: 
/usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x586) 
[0x45c65116]
13: 
/usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x56) 
[0x45c65d06]
14: akonadiserver(main+0x398) [0x804c9e8]
15: /lib/libc.so.6(__libc_start_main+0xe5) [0x4523c6e5]
16: akonadiserver [0x804c581]
]
" 

Test 11:  ERROR
--------

Previous Akonadi server error log found.
Details: The Akonadi server did report error during its previous startup into 
<a 
href='/root/.local/share/akonadi/akonadiserver.error.old'>/root/.local/share/akonadi/akonadiserver.error.old</a>.

File content of '/root/.local/share/akonadi/akonadiserver.error.old':
Unable to open database "Access denied for user 'akonadi'@'%' to database 
'akonadi' QMYSQL: Unable to connect" 
"[
0: akonadiserver(_Z10kBacktracev+0x35) [0x8051f75]
1: akonadiserver [0x8052456]
2: [0xffffe400]
3: [0xffffe424]
4: /lib/libc.so.6(gsignal+0x50) [0x45251460]
5: /lib/libc.so.6(abort+0x188) [0x45252e28]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x95) 
[0x45f9d855]
7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8053164]
8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x9e) [0x4602b3ce]
9: /usr/lib/libQtCore.so.4 [0x4603839e]
10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68) [0x46038698]
11: akonadiserver(_ZN6QDebugD1Ev+0x44) [0x804d674]
12: 
/usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x586) 
[0x45c65116]
13: 
/usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x56) 
[0x45c65d06]
14: akonadiserver(main+0x398) [0x804c9e8]
15: /lib/libc.so.6(__libc_start_main+0xe5) [0x4523c6e5]
16: akonadiserver [0x804c581]
]
" 

Test 12:  SUCCESS
--------

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

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

No previous Akonadi control error log found.
Details: The Akonadi control process did not report any errors during its 
previous startup.
============================
There are several programs that at one time or another have bitched about D-
Bus problems, but if it has a configuration utility, its not in my menu's.

A ps -ea search says

[root at coyote amanda-2.6.2alpha-20090308]# ps -ea|grep dbus
 2012 ?        00:00:01 dbus-daemon
 3041 ?        00:00:00 dbus-launch
 3042 ?        00:00:01 dbus-daemon

What do I need to do next?

-- 
Cheers, Gene
"There are four boxes to be used in defense of liberty:
 soap, ballot, jury, and ammo. Please use in that order."
-Ed Howdershelt (Author)
Excuse me, but didn't I tell you there's NO HOPE for the survival of
OFFSET PRINTING?