I think, i have the same problem (even after 5 Trials, to install a fresh Lucid Lynx (Kubuntu) without the old /home-Folder).
My last error-log ($HOME/.local/share/akonadi/db_data/mysql.err) is this:
100728 8:12:58 [Note] Plugin 'FEDERATED' is disabled.
100728 8:12:59 InnoDB: Started; log sequence number 0 130014
100728 8:13:00 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
100728 8:13:00 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
100728 8:13:00 [Note] /usr/sbin/mysqld-akonadi: ready for connections.
Version: '5.1.41-3ubuntu11-log' socket: '/home/muelux/.local/share/akonadi/db_misc/mysql.socket' port: 0 (Ubuntu)
** First, akonadi came with:
Test 14: 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 /usr/share/akonadi/agents'. The XDG_DATA_DIRS environment variable is set to '/usr/share:/usr/share:/usr/local/share', make sure this includes all paths where Akonadi agents are installed to.
Test 16: ERROR
--------
Previous Akonadi server error log found.
Details: The Akonadi server did report error during its previous startup into <a href='/home/muelux/.local/share/akonadi/akonadiserver.error.old'>/home/muelux/.local/share/akonadi/akonadiserver.error.old</a>.
File content of '/home/muelux/.local/share/akonadi/akonadiserver.error.old':
Control process died, committing suicide!
"akonadiserver" [out] "Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' '--socket=/home/muelux/.local/share/akonadi/db_misc/mysql.socket'
"
[akonadiserver] /usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/home/muelux/.local/share/akonadi/db_misc/mysql.socket' (2) when trying to connect
[akonadiserver] FATAL ERROR: Upgrade failed
[akonadiserver] Failed to use database "akonadi"
[akonadiserver] Query error: "Unknown database 'akonadi' QMYSQL: Unable to execute query"
[akonadiserver] Database error: "Can't connect to local MySQL server through socket '/home/muelux/.local/share/akonadi/db_misc/mysql.socket' (2) QMYSQL: Unable to connect"
[akonadiserver] Trying to create database now...
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
...]
### it creates a new database with log-messages (extract):
I think, i have the same problem (even after 5 Trials, to install a fresh Lucid Lynx (Kubuntu) without the old /home-Folder). .local/ share/akonadi/ db_data/ mysql.err) is this:
My last error-log ($HOME/
100728 8:12:58 [Note] Plugin 'FEDERATED' is disabled. time_zone_ leap_second' doesn't exist trying to live without them mysqld- akonadi: ready for connections. 3ubuntu11- log' socket: '/home/ muelux/ .local/ share/akonadi/ db_misc/ mysql.socket' port: 0 (Ubuntu)
100728 8:12:59 InnoDB: Started; log sequence number 0 130014
100728 8:13:00 [Warning] Can't open and lock time zone table: Table 'mysql.
100728 8:13:00 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
100728 8:13:00 [Note] /usr/sbin/
Version: '5.1.41-
** First, akonadi came with:
Test 14: ERROR
--------
No resource agents found. akonadi/ agents /usr/share/ akonadi/ agents' . The XDG_DATA_DIRS environment variable is set to '/usr/share: /usr/share: /usr/local/ share', make sure this includes all paths where Akonadi agents are installed to.
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/
Test 16: ERROR
--------
Previous Akonadi server error log found. home/muelux/ .local/ share/akonadi/ akonadiserver. error.old' >/home/ muelux/ .local/ share/akonadi/ akonadiserver. error.old< /a>.
Details: The Akonadi server did report error during its previous startup into <a href='/
File content of '/home/ muelux/ .local/ share/akonadi/ akonadiserver. error.old' :
Control process died, committing suicide!
*** I tried:
sudo apt-get install virtuoso-server mysql-server-5.1 local/share/ akonadi $HOME/. local/share/ akonadi/ db_data/ $HOME/. local/share/ akonadi/ db_misc/ mysql.socket
rm -r $HOME/.
akonadictl start
mysql_install_db --datadir=
mysql_upgrade --socket=
akonadictl stop
akonadictl start
*** after that it came with:
"akonadiserver" [out] "Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket= /var/run/ mysqld/ mysqld. sock' '--socket= /home/muelux/ .local/ share/akonadi/ db_misc/ mysql.socket' mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/home/ muelux/ .local/ share/akonadi/ db_misc/ mysql.socket' (2) when trying to connect muelux/ .local/ share/akonadi/ db_misc/ mysql.socket' (2) QMYSQL: Unable to connect"
"
[akonadiserver] /usr/bin/
[akonadiserver] FATAL ERROR: Upgrade failed
[akonadiserver] Failed to use database "akonadi"
[akonadiserver] Query error: "Unknown database 'akonadi' QMYSQL: Unable to execute query"
[akonadiserver] Database error: "Can't connect to local MySQL server through socket '/home/
[akonadiserver] Trying to create database now...
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
...]
### it creates a new database with log-messages (extract):
[akonadiserver] DbInitializer: :run() done Interface: :serviceOwnerCh anged(QString, QString, QString) :unhideAllPimIt ems() akonadi/ agents" urce.desktop" , "contactsresour ce.desktop" , "icalresource. desktop" , "imapresource. desktop" , "kabcresource. desktop" , "kcalresource. desktop" , "knutresource. desktop" , "kolabproxyreso urce.desktop" , "localbookmarks resource. desktop" , "maildirresourc e.desktop" , "maildispatcher agent.desktop" , "mboxresource. desktop" , "microblog. desktop" , "mtdummyresourc e.desktop" , "nepomukcalenda rfeeder. desktop" , "nepomukcontact feeder. desktop" , "nepomuktagreso urce.desktop" , "nntpresource. desktop" , "notesresource. desktop" , "pop3resource. desktop" , "vcarddirresour ce.desktop" , "vcardresource. desktop" ) birthdays_ resource" 0 ("Resource") contacts_ resource" 1 ("Resource")
[akonadiserver] skipping update 2
[akonadiserver] skipping update 3
[akonadiserver] skipping update 4
[akonadiserver] skipping update 8
[akonadiserver] skipping update 10
[akonadiserver] skipping update 12
[akonadiserver] skipping update 13
[akonadiserver] skipping update 14
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Connecting to deprecated signal QDBusConnection
[akonadiserver] DataStore:
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
PLUGINS: "/usr/share/
PLUGINS: ("birthdaysreso
search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games")
PLUGINS inserting: "akonadi_
PLUGINS inserting: "akonadi_
### the last messages belongs to kmail, i guess:
[akonadiserver] Database "akonadi" opened using driver "QMYSQL" akonadi_ maildispatcher_ agent] akonadi_ maildispatcher_ agent(1849) /libakonadi Akonadi: :DefaultResourc eJob::slotResul t: "Unknown resource" akonadi_ maildispatcher_ agent] akonadi_ maildispatcher_ agent(1849) /libakonadi Akonadi: :ResourceScanJo b::Private: :fetchResult: "Unknown resource" akonadi_ maildispatcher_ agent] akonadi_ maildispatcher_ agent(1849) /libakonadi Akonadi: :SpecialCollect ionsRequestJobP rivate: :resourceScanRe sult: Failed to request resource "akonadi_ maildir_ resource_ 0" : "Unbekannter Fehler. (Unknown resource)" akonadi_ maildispatcher_ agent] akonadi_ maildispatcher_ agent(1849) OutboxQueue: :Private: :localFoldersRe questResult: Failed to get outbox folder. akonadi_ nepomuk_ contact_ feeder] Connecting to deprecated signal QDBusConnection Interface: :serviceOwnerCh anged(QString, QString, QString)
[/usr/bin/
[/usr/bin/
[/usr/bin/
[/usr/bin/
[/usr/bin/
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
So, after two month of trial and error upgrading to Kubuntu 10.04 i think i have to give up ;-(