I installed KDE 4.4 in a computer with OpenSuSE 11.2 x86_64. It
installed almost without problems.

But I have a problem I can't resolve. It is Kontact or Kmail don't
start, they show starting akonadi server ... then I obtained the next
errors:

Akonadi control process not registered at DBus
Akonadi server process not registered at DBus

I tried the advice in /http://userbase.kde.org/Akonadi modifying
//etc/apparmor.d/usr.sbin.mysqld-akonadi but this file doesn't exists or
///etc/apparmor.d/usr.sbin.mysqld. I deactivated AppArmor but it doesn't
work.

Also, I proved to create a kres-migratorrc with migration enabled to
false. But it didn't resolve the problem.

I don't think the problem is nepomuk, it seems to work well. Moreover,
my nepomukservrc is similar to that.

I executed akonadictl start from console and it showed the next messages:

Starting Akonadi Server...


Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)


[akonadiserver] search paths: ("/usr/lib64/mpi/gcc/openmpi/bin",
"/home/alfonso/bin", "/usr/local/bin", "/usr/bin", "/bin",
"/usr/bin/X11", "/usr/X11R6/bin", "/usr/games", "/opt/kde3/bin",
"/usr/lib64/jvm/jre/bin", "/usr/lib/mit/bin", "/usr/lib/mit/sbin",
"/usr/NX/bin", "/usr/sbin", "/usr/sbin", "/usr/sbin", "/usr/local/sbin",
"/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec",
"/opt/local/lib/mysql5/bin")


done.


[akonadiserver] Database process exited unexpectedly during initial
connection!

[akonadiserver] executable: "/usr/sbin/mysqld"


[akonadiserver] arguments:
("--defaults-file=/home/alfonso/.local/share/akonadi//mysql.conf",
"--datadir=/home/alfonso/.local/share/akonadi/db_data/",
"--socket=/home/alfonso/.local/share/akonadi/db_misc/mysql.socket")



[akonadiserver] stdout: ""


[akonadiserver] stderr: "100211 16:33:10 [ERROR] Wrong option to
sql-mode. Option(s) given:
strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat


[akonadiserver] Alternatives are:
'REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','?','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','ALLOW_INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'



[akonadiserver] : Success


[akonadiserver] 100211 16:33:10 [ERROR] Aborting


[akonadiserver]


[akonadiserver] "


[akonadiserver] exit code: 1


[akonadiserver] process error: "Unknown error"


[akonadiserver] "[


[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40b949]


[akonadiserver] 1: akonadiserver [0x40be92]


[akonadiserver] 2: /lib64/libc.so.6 [0x7fe4a7f5d560]


[akonadiserver] 3: /lib64/libc.so.6(gsignal+0x35) [0x7fe4a7f5d4e5]


[akonadiserver] 4: /lib64/libc.so.6(abort+0x180) [0x7fe4a7f5e9b0]


[akonadiserver] 5:
/usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74)
[0x7fe4a910e894]

[akonadiserver] 6:
akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40ced8]


[akonadiserver] 7:
/usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x78)
[0x7fe4a919d308]

[akonadiserver] 8: /usr/lib64/libQtCore.so.4 [0x7fe4a91ae619]


[akonadiserver] 9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39)
[0x7fe4a91af819]

[akonadiserver] 10:
/usr/lib64/libakonadiprivate.so.1(_ZN6QDebugD1Ev+0x4e) [0x7fe4a956aa6e]


[akonadiserver] 11:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer25startMysqlDatabaseProcessEv+0x1a41)
[0x7fe4a95756a1]
[akonadiserver] 12:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x2d8)
[0x7fe4a9577a68]
[akonadiserver] 13:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x76)
[0x7fe4a9577c96]

[akonadiserver] 14:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a)
[0x7fe4a9578f8a]

[akonadiserver] 15: akonadiserver(main+0x3a4) [0x406504]


[akonadiserver] 16: /lib64/libc.so.6(__libc_start_main+0xfd)
[0x7fe4a7f49a7d]

[akonadiserver] 17: akonadiserver [0x406069]


[akonadiserver] ]


[akonadiserver] "


ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)

alfonso@hinata:~/.kde4/share/config> [akonadiserver] search paths:
("/usr/lib64/mpi/gcc/openmpi/bin", "/home/alfonso/bin",
"/usr/local/bin", "/usr/bin", "/bin", "/usr/bin/X11", "/usr/X11R6/bin",
"/usr/games", "/opt/kde3/bin", "/usr/lib64/jvm/jre/bin",
"/usr/lib/mit/bin", "/usr/lib/mit/sbin", "/usr/NX/bin", "/usr/sbin",
"/usr/sbin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec",
"/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin")


[akonadiserver] Database process exited unexpectedly during initial
connection!

[akonadiserver] executable: "/usr/sbin/mysqld"


[akonadiserver] arguments:
("--defaults-file=/home/alfonso/.local/share/akonadi//mysql.conf",
"--datadir=/home/alfonso/.local/share/akonadi/db_data/",
"--socket=/home/alfonso/.local/share/akonadi/db_misc/mysql.socket")



[akonadiserver] stdout: ""


[akonadiserver] stderr: "100211 16:33:10 [ERROR] Wrong option to
sql-mode. Option(s) given:
strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat


[akonadiserver] Alternatives are:
'REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','?','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','ALLOW_INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'



[akonadiserver] : Success


[akonadiserver] 100211 16:33:10 [ERROR] Aborting


[akonadiserver]


[akonadiserver] "


[akonadiserver] exit code: 1


[akonadiserver] process error: "Unknown error"


[akonadiserver] "[


[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40b949]


[akonadiserver] 1: akonadiserver [0x40be92]


[akonadiserver] 2: /lib64/libc.so.6 [0x7fa736ded560]


[akonadiserver] 3: /lib64/libc.so.6(gsignal+0x35) [0x7fa736ded4e5]


[akonadiserver] 4: /lib64/libc.so.6(abort+0x180) [0x7fa736dee9b0]


[akonadiserver] 5:
/usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74)
[0x7fa737f9e894]

[akonadiserver] 6:
akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40ced8]


[akonadiserver] 7:
/usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x78)
[0x7fa73802d308]

[akonadiserver] 8: /usr/lib64/libQtCore.so.4 [0x7fa73803e619]


[akonadiserver] 9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39)
[0x7fa73803f819]

[akonadiserver] 10:
/usr/lib64/libakonadiprivate.so.1(_ZN6QDebugD1Ev+0x4e) [0x7fa7383faa6e]


[akonadiserver] 11:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer25startMysqlDatabaseProcessEv+0x1a41)
[0x7fa7384056a1]
[akonadiserver] 12:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x2d8)
[0x7fa738407a68]
[akonadiserver] 13:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x76)
[0x7fa738407c96]

[akonadiserver] 14:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a)
[0x7fa738408f8a]

[akonadiserver] 15: akonadiserver(main+0x3a4) [0x406504]


[akonadiserver] 16: /lib64/libc.so.6(__libc_start_main+0xfd)
[0x7fa736dd9a7d]

[akonadiserver] 17: akonadiserver [0x406069]


[akonadiserver] ]


[akonadiserver] "


ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)

[akonadiserver] search paths: ("/usr/lib64/mpi/gcc/openmpi/bin",
"/home/alfonso/bin", "/usr/local/bin", "/usr/bin", "/bin",
"/usr/bin/X11", "/usr/X11R6/bin", "/usr/games", "/opt/kde3/bin",
"/usr/lib64/jvm/jre/bin", "/usr/lib/mit/bin", "/usr/lib/mit/sbin",
"/usr/NX/bin", "/usr/sbin", "/usr/sbin", "/usr/sbin", "/usr/local/sbin",
"/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec",
"/opt/local/lib/mysql5/bin")


[akonadiserver] Database process exited unexpectedly during initial
connection!

[akonadiserver] executable: "/usr/sbin/mysqld"


[akonadiserver] arguments:
("--defaults-file=/home/alfonso/.local/share/akonadi//mysql.conf",
"--datadir=/home/alfonso/.local/share/akonadi/db_data/",
"--socket=/home/alfonso/.local/share/akonadi/db_misc/mysql.socket")



[akonadiserver] stdout: ""


[akonadiserver] stderr: "100211 16:33:10 [ERROR] Wrong option to
sql-mode. Option(s) given:
strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat


[akonadiserver] Alternatives are:
'REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','?','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','ALLOW_INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'



[akonadiserver] : Success


[akonadiserver] 100211 16:33:10 [ERROR] Aborting


[akonadiserver]


[akonadiserver] "


[akonadiserver] exit code: 1


[akonadiserver] process error: "Unknown error"


[akonadiserver] "[


[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40b949]


[akonadiserver] 1: akonadiserver [0x40be92]


[akonadiserver] 2: /lib64/libc.so.6 [0x7fd8c658d560]


[akonadiserver] 3: /lib64/libc.so.6(gsignal+0x35) [0x7fd8c658d4e5]


[akonadiserver] 4: /lib64/libc.so.6(abort+0x180) [0x7fd8c658e9b0]


[akonadiserver] 5:
/usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74)
[0x7fd8c773e894]

[akonadiserver] 6:
akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40ced8]


[akonadiserver] 7:
/usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x78)
[0x7fd8c77cd308]

[akonadiserver] 8: /usr/lib64/libQtCore.so.4 [0x7fd8c77de619]


[akonadiserver] 9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39)
[0x7fd8c77df819]

[akonadiserver] 10:
/usr/lib64/libakonadiprivate.so.1(_ZN6QDebugD1Ev+0x4e) [0x7fd8c7b9aa6e]


[akonadiserver] 11:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer25startMysqlDatabaseProcessEv+0x1a41)
[0x7fd8c7ba56a1]
[akonadiserver] 12:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x2d8)
[0x7fd8c7ba7a68]
[akonadiserver] 13:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x76)
[0x7fd8c7ba7c96]

[akonadiserver] 14:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a)
[0x7fd8c7ba8f8a]

[akonadiserver] 15: akonadiserver(main+0x3a4) [0x406504]


[akonadiserver] 16: /lib64/libc.so.6(__libc_start_main+0xfd)
[0x7fd8c6579a7d]

[akonadiserver] 17: akonadiserver [0x406069]


[akonadiserver] "


ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)

[akonadiserver] search paths: ("/usr/lib64/mpi/gcc/openmpi/bin",
"/home/alfonso/bin", "/usr/local/bin", "/usr/bin", "/bin",
"/usr/bin/X11", "/usr/X11R6/bin", "/usr/games", "/opt/kde3/bin",
"/usr/lib64/jvm/jre/bin", "/usr/lib/mit/bin", "/usr/lib/mit/sbin",
"/usr/NX/bin", "/usr/sbin", "/usr/sbin", "/usr/sbin", "/usr/local/sbin",
"/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec",
"/opt/local/lib/mysql5/bin")


[akonadiserver] Database process exited unexpectedly during initial
connection!
[akonadiserver] executable: "/usr/sbin/mysqld"
[akonadiserver] arguments:
("--defaults-file=/home/alfonso/.local/share/akonadi//mysql.conf",
"--datadir=/home/alfonso/.local/share/akonadi/db_data/",
"--socket=/home/alfonso/.local/share/akonadi/db_misc/mysql.socket")
[akonadiserver] stdout: ""
[akonadiserver] stderr: "100211 16:33:10 [ERROR] Wrong option to
sql-mode. Option(s) given:
strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat
[akonadiserver] Alternatives are:
'REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','?','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','ALLOW_INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'
[akonadiserver] : Success
[akonadiserver] 100211 16:33:10 [ERROR] Aborting
[akonadiserver]
[akonadiserver] "
[akonadiserver] exit code: 1
[akonadiserver] process error: "Unknown error"
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40b949]
[akonadiserver] 1: akonadiserver [0x40be92]
[akonadiserver] 2: /lib64/libc.so.6 [0x7f7fa272a560]
[akonadiserver] 3: /lib64/libc.so.6(gsignal+0x35) [0x7f7fa272a4e5]
[akonadiserver] 4: /lib64/libc.so.6(abort+0x180) [0x7f7fa272b9b0]
[akonadiserver] 5:
/usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74)
[0x7f7fa38db894]
[akonadiserver] 6:
akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40ced8]
[akonadiserver] 7:
/usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x78) [0x7f7fa396a308]
[akonadiserver] 8: /usr/lib64/libQtCore.so.4 [0x7f7fa397b619]
[akonadiserver] 9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39)
[0x7f7fa397c819]
[akonadiserver] 10:
/usr/lib64/libakonadiprivate.so.1(_ZN6QDebugD1Ev+0x4e) [0x7f7fa3d37a6e]
[akonadiserver] 11:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer25startMysqlDatabaseProcessEv+0x1a41)
[0x7f7fa3d426a1]
[akonadiserver] 12:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x2d8)
[0x7f7fa3d44a68]
[akonadiserver] 13:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x76)
[0x7f7fa3d44c96]
[akonadiserver] 14:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a)
[0x7f7fa3d45f8a]
[akonadiserver] 15: akonadiserver(main+0x3a4) [0x406504]
[akonadiserver] 16: /lib64/libc.so.6(__libc_start_main+0xfd)
[0x7f7fa2716a7d]
[akonadiserver] 17: akonadiserver [0x406069]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)
"akonadiserver" crashed too often and will not be restarted!

Can some help me, please?

Greetings.

Alfonso

I resolved the problem deleting all the file associated with akonadi and kontact (and related applications: kmail, ...) in my home directory,

Now kontact is working without problems.

Is there other solution to this issue, less radical I mean? My problem is very similar. When I start Akonadi manually or first start KMail (which automatically starts Akonadi without problems), then Kontact also starts without issues. Unfortunately if Kontact is started in first place it won't run.
Also mysql.err contains following entries

Code: Select all

100213 19:49:08 [Note] Plugin 'FEDERATED' is disabled.
100213 19:49:08 [Note] Plugin 'ndbcluster' is disabled.
100213 19:49:09  InnoDB: Started; log sequence number 0 310702
100213 19:49:09 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
100213 19:49:09 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
100213 19:49:09 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.42-log'  socket: '/home/zbyszek/.local/share/akonadi/db_misc/mysql.socket'  port: 0  Source distribution

Any ideas?

Achilleus wrote:Is there other solution to this issue, less radical I mean? My problem is very similar. When I start Akonadi manually or first start KMail (which automatically starts Akonadi without problems), then Kontact also starts without issues. Unfortunately if Kontact is started in first place it won't run.
Also mysql.err contains following entries

Code: Select all

100213 19:49:08 [Note] Plugin 'FEDERATED' is disabled.
100213 19:49:08 [Note] Plugin 'ndbcluster' is disabled.
100213 19:49:09  InnoDB: Started; log sequence number 0 310702
100213 19:49:09 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
100213 19:49:09 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
100213 19:49:09 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.42-log'  socket: '/home/zbyszek/.local/share/akonadi/db_misc/mysql.socket'  port: 0  Source distribution

Any ideas?

Hi.

You can visit the page:

http://userbase.kde.org/Akonadi

4.5 looks similar your problem, perhaps it can be useful.

I did what was written there, that is copied /usr/share/config/akonadi/mysql-global.conf to ~/.config/akonadi/mysql-local.conf and uncommented the line sql_mode=strict_trans_tables, but after restart the same problem still persists.

Silly question, but did you re-start KDE after doing this? I'm thinking that maybe something needs initialising, and that's the easiest way to do it.

Yes, I restarted the whole system, as I wrote above.

You will need to run the mysql_install_db command as noted on the http://userbase.kde.org/Akonadi page, as your database has already been created. The only other alternative is to remove the databases since that setting only affects new databases ( in terms of table creation )

bcooksley wrote:You will need to run the mysql_install_db command as noted on the http://userbase.kde.org/Akonadi page, as your database has already been created. The only other alternative is to remove the databases since that setting only affects new databases ( in terms of table creation )

I wasn't able to find any info on this command, but I have found this

Common Problems
Kontact doesn't start - and doesn't tell me anything

If Kontact doesn't start, and you see no error messages, check that Akonadi is running. Akonadi should start on demand, but currently (January 2010) it doesn't. You have to start it before Kontact will start up if you have any migrated resources (most likely KAddressBook). Use the AkonadiTray icon to start it.

Oops...

Try running:

Code: Select all

mysql_install_db --basedir=/home/$username/.local/share/akonadi/db_data

Here's what I've got

Code: Select all

[zbyszek@barca ~]$ mysql_install_db --basedir=/home/zbyszek/.local/share/akonadi/db_data

FATAL ERROR: Could not find my_print_defaults

The following directories were searched:

    /home/zbyszek/.local/share/akonadi/db_data/bin
    /home/zbyszek/.local/share/akonadi/db_data/extra

If you compiled from source, you need to run 'make install' to
copy the software into the correct location ready for operation.

If you are using a binary release, you must either be at the top
level of the extracted archive, or pass the --basedir option
pointing to that location.


Hmm....
Do you have valuable data stored in Akonadi?

If you don't, try moving /home/zbyszek/.local/share/akonadi/db_data somewhere else.

Otherwise, I don't know why that command doesn't work on your system. Check your mysql installation.

AFAIK my installation of MySQL is fine. The packages that I have installed on my system are as follows

Code: Select all

extra/libmysqlclient 5.1.42-2
     MySQL client libraries
extra/mysql 5.1.42-2
     A fast SQL database server
extra/mysql-clients 5.1.42-2
     MySQL client tools


and mysqld is running. I'll try to move Akonadi's database and see if it helps.

Please make sure mysqld isn't running when trying to execute that command. It can be stopped by stopping Akonadi:

Code: Select all

akonadictl stop

After moving /home/zbyszek/.local/share/akonadi/db_data I still get the following error

Code: Select all

100220 11:33:03 [Note] Plugin 'FEDERATED' is disabled.
100220 11:33:03 [Note] Plugin 'ndbcluster' is disabled.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
100220 11:33:03  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100220 11:33:03  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 64 MB
InnoDB: Database physically writes the file full: wait...
100220 11:33:05  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 64 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
100220 11:33:07  InnoDB: Started; log sequence number 0 0
100220 11:33:07 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
100220 11:33:07 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
100220 11:33:07 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.42-log'  socket: '/home/zbyszek/.local/share/akonadi/db_misc/mysql.socket'  port: 0  Source distribution