Just now I saw the contents of the file .config/akonadi/akonadiconnectionrc and it reads as-

Code: Select all

[Data]
Method=UnixPath
UnixPath=/home/hunny/kde/share/akonadi/akonadiserver.socket

[DBUS]
Address="unix:abstract=/tmp/dbus-vTDfzn2iAW,guid=737b74c11e2327d546ac18e34bfbc224"


Is this fine, or something wrong?

Also, I see the following files/dirs in $KDEDIR/share/akonadi-

akonadiserver.socket db_data db_misc file_db_data mysql.conf

Do I have to copy some of these files to ~/.local/share/akonadi ? I randomly tried copying them there, but doesn't seem to work, everytime it just complains

Code: Select all

[akonadiserver] /usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/home/hunny/kde/share/akonadi/db_misc/mysql.socket' (2) when trying to connect
[akonadiserver] FATAL ERROR: Upgrade failed

Please remove the entire ~/.local/share/akonadi folder and ~/.config/akonadi/akonadiserverrc

After that, start Akonadi ( it will likely complain about the mysql database missing ) then stop it and run the mysql_install_db command.

I tried that, the output is here http://pastebin.com/TvBpRiDK .Doesn't seem to work, still stuck at the can't connect to MySQL through that socket

The content of your akonadiconnectionrc file is quite different to mine...

Please change the "UnixPath" entry to "/home/hunny/.local/share/akonadi/akonadiserver.socket"

Hmm, I think Akonadi starts correctly now, guessing because I can now start KMail, Kontact etc, though it always opens kres-migrator which stays there all the time saying "Starting Akonadi Server", weird, because akonadictl status says its already running. Is it normal?

Also, I tried to change the "UnixPath" entry to "/home/hunny/.local/share/akonadi/akonadiserver.socket" but whenever I start Akonadi, it resets to /home/hunny/kde/share/akonadi/akonadiserver.socket . Further, /home/hunny/.local/share/akonadi/akonadiserver.socket does not exist.

I gather all your other settings are stored in /home/hunny/kde/share/akonadi/ as well? ( such as the MySQL database )

Here's the content of that dir-

Code: Select all

hunny@hunny-laptop:~$ ls -R  kde/share/akonadi/
kde/share/akonadi/:
akonadi_control.error.old  akonadiserver.error.old  akonadiserver.socket  db_data  db_misc  file_db_data  mysql.conf

kde/share/akonadi/db_data:
akonadi           mysql-bin.000002  mysql-bin.000009  mysql-bin.000016  mysql-bin.000023  mysql-bin.000030  mysql-bin.index
hunny-laptop.pid  mysql-bin.000003  mysql-bin.000010  mysql-bin.000017  mysql-bin.000024  mysql-bin.000031  mysql.err
ibdata1           mysql-bin.000004  mysql-bin.000011  mysql-bin.000018  mysql-bin.000025  mysql-bin.000032  mysql.err.old
ib_logfile0       mysql-bin.000005  mysql-bin.000012  mysql-bin.000019  mysql-bin.000026  mysql-bin.000033
ib_logfile1       mysql-bin.000006  mysql-bin.000013  mysql-bin.000020  mysql-bin.000027  mysql-bin.000034
mysql             mysql-bin.000007  mysql-bin.000014  mysql-bin.000021  mysql-bin.000028  mysql-bin.000035
mysql-bin.000001  mysql-bin.000008  mysql-bin.000015  mysql-bin.000022  mysql-bin.000029  mysql-bin.000036

kde/share/akonadi/db_data/akonadi:
collectionattributetable.frm    collectionpimitemrelation.ibd  flagtable.ibd      pimitemflagrelation.frm  resourcetable.ibd
collectionattributetable.ibd    collectiontable.frm            mimetypetable.frm  pimitemflagrelation.ibd  schemaversiontable.frm
collectionmimetyperelation.frm  collectiontable.ibd            mimetypetable.ibd  pimitemtable.frm         schemaversiontable.ibd
collectionmimetyperelation.ibd  db.opt                         parttable.frm      pimitemtable.ibd
collectionpimitemrelation.frm   flagtable.frm                  parttable.ibd      resourcetable.frm

kde/share/akonadi/db_data/mysql:
columns_priv.frm  general_log.CSM    help_topic.frm        proc.frm        tables_priv.frm            time_zone_transition.frm
columns_priv.MYD  general_log.CSV    help_topic.MYD        proc.MYD        tables_priv.MYD            time_zone_transition.MYD
columns_priv.MYI  general_log.frm    help_topic.MYI        proc.MYI        tables_priv.MYI            time_zone_transition.MYI
db.frm            help_category.frm  host.frm              procs_priv.frm  time_zone.frm              time_zone_transition_type.frm
db.MYD            help_category.MYD  host.MYD              procs_priv.MYD  time_zone_leap_second.frm  time_zone_transition_type.MYD
db.MYI            help_category.MYI  host.MYI              procs_priv.MYI  time_zone_leap_second.MYD  time_zone_transition_type.MYI
event.frm         help_keyword.frm   ndb_binlog_index.frm  servers.frm     time_zone_leap_second.MYI  user.frm
event.MYD         help_keyword.MYD   ndb_binlog_index.MYD  servers.MYD     time_zone.MYD              user.MYD
event.MYI         help_keyword.MYI   ndb_binlog_index.MYI  servers.MYI     time_zone.MYI              user.MYI
func.frm          help_relation.frm  plugin.frm            slow_log.CSM    time_zone_name.frm
func.MYD          help_relation.MYD  plugin.MYD            slow_log.CSV    time_zone_name.MYD
func.MYI          help_relation.MYI  plugin.MYI            slow_log.frm    time_zone_name.MYI

kde/share/akonadi/db_misc:
mysql.socket

kde/share/akonadi/file_db_data:

Is it fine or something is wrong?

In your case, the commands will need to be adjusted, as the location of the preference directory ~/.local is different on your system.

Code: Select all

mysql_install_db --datadir=$HOME/kde/share/akonadi/db_data/

It gives the following output-

Code: Select all

hunny@hunny-laptop:~$ mysql_install_db --datadir=$HOME/kde/share/akonadi/db_data/
Installing MySQL system tables...
100530 21:14:32 [Warning] Can't create test file /home/hunny/kde/share/akonadi/db_data/hunny-laptop.lower-test
100530 21:14:32 [Warning] Can't create test file /home/hunny/kde/share/akonadi/db_data/hunny-laptop.lower-test

Installation of system tables failed!  Examine the logs in
/home/hunny/kde/share/akonadi/db_data/ for more information.

You can try to start the mysqld daemon with:

    shell> /usr/sbin/mysqld --skip-grant &

and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /home/hunny/kde/share/akonadi/db_data/ that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com/.  Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/scripts/mysqlbug script!

The file at /home/hunny/kde/share/akonadi/db_data/mysql.err contains http://pastebin.com/V4THgh2b .

It appears that Akonadi may have been running. Please run "akonadictl stop" then the above command again, and finally "akonadictl start" if it encounters no errors.

No, the problem is still there with akonadi stopped. As a matter of fact, its not even starting now
Another friend of mine who has trunk build on same distro as mine is having exactly the same problem. I suspect it maybe that the distro installed akonadi maybe conflicting. Is this possible?

I also have exactly the problem above. Right now I suspect it might be a problem with mysql. The problem appeared when trying to upgrade from Karmic to Lucid.

Without akonadi KDE is unusable since it does affect other programs like digikam too.



I have created a new user to avoid problems from a previous version but this "new" user cannot start akanodi as well. (All other users on this computer are having the same problem)

As a workaround to these problems, I use the system wide instance of MySQL for Akonadi, which solves all issues regarding MySQL functionality ( and reduces memory usage if you need it for other things, which I do ).

Is http://userbase.kde.org/Akonadi_4.4/Tro ... .4_Upgrade relevant?

@bcooksley
How to configure to achieve that?

@annew
I'm afraid no, as mine is a clean install, not an upgrade.