Check if file /data/.local/share/akonadi//mysql.conf exists

It exists

and you have read permissions. Try to open it in a text editor.

I can edit it without any problem cuz its permissions are: -rw-r--r--

Very good.

You could try running the command manually that Akonadi is failing to execute:

Code: Select all

/usr/sbin/mysqld-akonadi --defaults-file=/data/.local/share/akonadi//mysql.conf --datadir=/data/.local/share/akonadi/db_data/ --socket=/data/.local/share/akonadi/db_misc/mysql.socket


Alternatively try using mysqld (without -akonadi)

Given that you can read the file, any process you run should be able to do it as well unless something like AppArmor is interfering.

In case neither command works even when you run it manually, try some of the AppArmor related hints here (just in case it is unfortunately AppArmor related after all)
http://userbase.kde.org/Akonadi_4.4/Tro ... g#Apparmor

Cheers,
_

You could try running the command manually that Akonadi is failing to execute:

Code: Select all

/usr/sbin/mysqld-akonadi --defaults-file=/data/.local/share/akonadi//mysql.conf --datadir=/data/.local/share/akonadi/db_data/ --socket=/data/.local/share/akonadi/db_misc/mysql.socket

When I tried this command I got the following error although I'm sure that permissions of /data/.local/share/akonadi//mysql.conf and /data/.local/share/akonadi/db_data/ are correct (I noticed that /data/.local/share/akonadi/db_misc/ is completely empty).

Code: Select all

mbnoimi@admino-mbnoimi ~ $ /usr/sbin/mysqld-akonadi --defaults-file=/data/.local/share/akonadi//mysql.conf --datadir=/data/.local/share/akonadi/db_data/ --socket=/data/.local/share/akonadi/db_misc/mysql.socket
Could not open required defaults file: /data/.local/share/akonadi//mysql.conf
Fatal error in defaults handling. Program aborted
101231  6:56:48 [Warning] Can't create test file /data/.local/share/akonadi/db_data/admino-mbnoimi.lower-test
101231  6:56:48 [Warning] Can't create test file /data/.local/share/akonadi/db_data/admino-mbnoimi.lower-test
101231  6:56:48 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld-akonadi: Can't find file: './mysql/plugin.frm' (errno: 13)
101231  6:56:48 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
101231  6:56:48  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.


Alternatively try using mysqld (without -akonadi)

It works but I got same error message from Akonadi when I run KMail!

In case neither command works even when you run it manually, try some of the AppArmor related hints here (just in case it is unfortunately AppArmor related after all)

I tried to run sudo aa-complain mysqld but I got:

Code: Select all

sudo: aa-complain: command not found

so I tried to replace mysqld by mysqld-akonadi but I got same thing (sudo: aa-complain: command not found)
Also I added the following at last line (before '}') in /etc/apparmor.d/usr.sbin.mysqld-akonadi file

Code: Select all

@{HOME}/.Private/** rwk,

once again nothing changed!

I forgot to provide you akonadictl and apparmor reloading log:

Code: Select all

mbnoimi@admino-mbnoimi ~ $ akonadictl stop
Akonadi is not running.
mbnoimi@admino-mbnoimi ~ $ sudo /etc/init.d/apparmor reload
 * Reloading AppArmor profiles                                                                                                                                                          Skipping profile in /etc/apparmor.d/disable: usr.bin.firefox
                                                                                                                                                                                 [ OK ]
mbnoimi@admino-mbnoimi ~ $ akonadictl start
Starting Akonadi Server...
   done.
mbnoimi@admino-mbnoimi ~ $ Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
[akonadiserver] search paths:  ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
[akonadiserver] Found mysql_install_db:  "/usr/bin/mysql_install_db"
[akonadiserver] Found mysql_upgrade:  "/usr/bin/mysql_upgrade"
"akonadiserver" [out] "Looking for 'mysql' as: /usr/bin/mysql
"
"akonadiserver" [out] "Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
"
"akonadiserver" [out] "This installation of MySQL is already upgraded to 5.1.49, use --force if you still need to run mysql_upgrade
"
[akonadiserver] Database process exited unexpectedly during initial connection!
[akonadiserver] executable: "/usr/sbin/mysqld-akonadi"
[akonadiserver] arguments: ("--defaults-file=/data/.local/share/akonadi//mysql.conf", "--datadir", "/data/.local/share/akonadi/db_data/", "--socket=/data/.local/share/akonadi/db_misc/mysql.socket")
[akonadiserver] stdout: ""
[akonadiserver] stderr: "Could not open required defaults file: /data/.local/share/akonadi//mysql.conf
[akonadiserver] Fatal error in defaults handling. Program aborted
[akonadiserver] 101231  7:18:26 [Warning] Can't create test file /data/.local/share/akonadi/db_data/admino-mbnoimi.lower-test
[akonadiserver] 101231  7:18:26 [Warning] Can't create test file /data/.local/share/akonadi/db_data/admino-mbnoimi.lower-test
[akonadiserver] 101231  7:18:26 [Note] Plugin 'FEDERATED' is disabled.
[akonadiserver] /usr/sbin/mysqld-akonadi: Can't find file: './mysql/plugin.frm' (errno: 13)
[akonadiserver] 101231  7:18:26 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
[akonadiserver] 101231  7:18:26  InnoDB: Operating system error number 13 in a file operation.
[akonadiserver] InnoDB: The error means mysqld does not have the access rights to
[akonadiserver] InnoDB: the directory.
[akonadiserver] InnoDB: File name ./ibdata1
[akonadiserver] InnoDB: File operation call: 'open'.
[akonadiserver] InnoDB: Cannot continue operation.
[akonadiserver] "
[akonadiserver] exit code: 1
[akonadiserver] process error: "Unknown error"
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40af99]
[akonadiserver] 1: akonadiserver() [0x40b4ea]
[akonadiserver] 2: /lib/libc.so.6(+0x33c20) [0x7f5cb5902c20]
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7f5cb5902ba5]
[akonadiserver] 4: /lib/libc.so.6(abort+0x180) [0x7f5cb59066b0]
[akonadiserver] 5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7f5cb6ae5864]
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40c5d8]
[akonadiserver] 7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x77) [0x7f5cb6b774a7]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(+0x10ba59) [0x7f5cb6b84a59]
[akonadiserver] 9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7f5cb6b85c69]
[akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x49) [0x4068f9]
[akonadiserver] 11: /usr/lib/libakonadiprivate.so.1(_ZN13DbConfigMysql19startInternalServerEv+0x19ad) [0x7f5cb70076ad]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0xdd) [0x7f5cb6f718cd]
[akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0xd7) [0x7f5cb6f737e7]
[akonadiserver] 14: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a) [0x7f5cb6f751ea]
[akonadiserver] 15: akonadiserver(main+0x404) [0x405df4]
[akonadiserver] 16: /lib/libc.so.6(__libc_start_main+0xfe) [0x7f5cb58edd8e]
[akonadiserver] 17: akonadiserver() [0x4058f9]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
[akonadiserver] search paths:  ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
[akonadiserver] Found mysql_install_db:  "/usr/bin/mysql_install_db"
[akonadiserver] Found mysql_upgrade:  "/usr/bin/mysql_upgrade"
"akonadiserver" [out] "Looking for 'mysql' as: /usr/bin/mysql
"
"akonadiserver" [out] "Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
"
"akonadiserver" [out] "This installation of MySQL is already upgraded to 5.1.49, use --force if you still need to run mysql_upgrade
"
[akonadiserver] Database process exited unexpectedly during initial connection!
[akonadiserver] executable: "/usr/sbin/mysqld-akonadi"
[akonadiserver] arguments: ("--defaults-file=/data/.local/share/akonadi//mysql.conf", "--datadir", "/data/.local/share/akonadi/db_data/", "--socket=/data/.local/share/akonadi/db_misc/mysql.socket")
[akonadiserver] stdout: ""
[akonadiserver] stderr: "Could not open required defaults file: /data/.local/share/akonadi//mysql.conf
[akonadiserver] Fatal error in defaults handling. Program aborted
[akonadiserver] 101231  7:18:26 [Warning] Can't create test file /data/.local/share/akonadi/db_data/admino-mbnoimi.lower-test
[akonadiserver] 101231  7:18:26 [Warning] Can't create test file /data/.local/share/akonadi/db_data/admino-mbnoimi.lower-test
[akonadiserver] 101231  7:18:26 [Note] Plugin 'FEDERATED' is disabled.
[akonadiserver] /usr/sbin/mysqld-akonadi: Can't find file: './mysql/plugin.frm' (errno: 13)
[akonadiserver] 101231  7:18:26 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
[akonadiserver] 101231  7:18:26  InnoDB: Operating system error number 13 in a file operation.
[akonadiserver] InnoDB: The error means mysqld does not have the access rights to
[akonadiserver] InnoDB: the directory.
[akonadiserver] InnoDB: File name ./ibdata1
[akonadiserver] InnoDB: File operation call: 'open'.
[akonadiserver] InnoDB: Cannot continue operation.
[akonadiserver] "
[akonadiserver] exit code: 1
[akonadiserver] process error: "Unknown error"
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40af99]
[akonadiserver] 1: akonadiserver() [0x40b4ea]
[akonadiserver] 2: /lib/libc.so.6(+0x33c20) [0x7ff0a6f77c20]
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7ff0a6f77ba5]
[akonadiserver] 4: /lib/libc.so.6(abort+0x180) [0x7ff0a6f7b6b0]
[akonadiserver] 5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7ff0a815a864]
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40c5d8]
[akonadiserver] 7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x77) [0x7ff0a81ec4a7]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(+0x10ba59) [0x7ff0a81f9a59]
[akonadiserver] 9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7ff0a81fac69]
[akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x49) [0x4068f9]
[akonadiserver] 11: /usr/lib/libakonadiprivate.so.1(_ZN13DbConfigMysql19startInternalServerEv+0x19ad) [0x7ff0a867c6ad]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0xdd) [0x7ff0a85e68cd]
[akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0xd7) [0x7ff0a85e87e7]
[akonadiserver] 14: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a) [0x7ff0a85ea1ea]
[akonadiserver] 15: akonadiserver(main+0x404) [0x405df4]
[akonadiserver] 16: /lib/libc.so.6(__libc_start_main+0xfe) [0x7ff0a6f62d8e]
[akonadiserver] 17: akonadiserver() [0x4058f9]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
[akonadiserver] search paths:  ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
[akonadiserver] Found mysql_install_db:  "/usr/bin/mysql_install_db"
[akonadiserver] Found mysql_upgrade:  "/usr/bin/mysql_upgrade"
"akonadiserver" [out] "Looking for 'mysql' as: /usr/bin/mysql
"
"akonadiserver" [out] "Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
"
"akonadiserver" [out] "This installation of MySQL is already upgraded to 5.1.49, use --force if you still need to run mysql_upgrade
"
[akonadiserver] Database process exited unexpectedly during initial connection!
[akonadiserver] executable: "/usr/sbin/mysqld-akonadi"
[akonadiserver] arguments: ("--defaults-file=/data/.local/share/akonadi//mysql.conf", "--datadir", "/data/.local/share/akonadi/db_data/", "--socket=/data/.local/share/akonadi/db_misc/mysql.socket")
[akonadiserver] stdout: ""
[akonadiserver] stderr: "Could not open required defaults file: /data/.local/share/akonadi//mysql.conf
[akonadiserver] Fatal error in defaults handling. Program aborted
[akonadiserver] 101231  7:18:26 [Warning] Can't create test file /data/.local/share/akonadi/db_data/admino-mbnoimi.lower-test
[akonadiserver] 101231  7:18:26 [Warning] Can't create test file /data/.local/share/akonadi/db_data/admino-mbnoimi.lower-test
[akonadiserver] 101231  7:18:26 [Note] Plugin 'FEDERATED' is disabled.
[akonadiserver] /usr/sbin/mysqld-akonadi: Can't find file: './mysql/plugin.frm' (errno: 13)
[akonadiserver] 101231  7:18:26 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
[akonadiserver] 101231  7:18:26  InnoDB: Operating system error number 13 in a file operation.
[akonadiserver] InnoDB: The error means mysqld does not have the access rights to
[akonadiserver] InnoDB: the directory.
[akonadiserver] InnoDB: File name ./ibdata1
[akonadiserver] InnoDB: File operation call: 'open'.
[akonadiserver] InnoDB: Cannot continue operation.
[akonadiserver] "
[akonadiserver] exit code: 1
[akonadiserver] process error: "Unknown error"
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40af99]
[akonadiserver] 1: akonadiserver() [0x40b4ea]
[akonadiserver] 2: /lib/libc.so.6(+0x33c20) [0x7fcf67706c20]
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7fcf67706ba5]
[akonadiserver] 4: /lib/libc.so.6(abort+0x180) [0x7fcf6770a6b0]
[akonadiserver] 5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7fcf688e9864]
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40c5d8]
[akonadiserver] 7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x77) [0x7fcf6897b4a7]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(+0x10ba59) [0x7fcf68988a59]
[akonadiserver] 9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7fcf68989c69]
[akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x49) [0x4068f9]
[akonadiserver] 11: /usr/lib/libakonadiprivate.so.1(_ZN13DbConfigMysql19startInternalServerEv+0x19ad) [0x7fcf68e0b6ad]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0xdd) [0x7fcf68d758cd]
[akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0xd7) [0x7fcf68d777e7]
[akonadiserver] 14: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a) [0x7fcf68d791ea]
[akonadiserver] 15: akonadiserver(main+0x404) [0x405df4]
[akonadiserver] 16: /lib/libc.so.6(__libc_start_main+0xfe) [0x7fcf676f1d8e]
[akonadiserver] 17: akonadiserver() [0x4058f9]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
[akonadiserver] search paths:  ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
[akonadiserver] Found mysql_install_db:  "/usr/bin/mysql_install_db"
[akonadiserver] Found mysql_upgrade:  "/usr/bin/mysql_upgrade"
"akonadiserver" [out] "Looking for 'mysql' as: /usr/bin/mysql
"
"akonadiserver" [out] "Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
"
"akonadiserver" [out] "This installation of MySQL is already upgraded to 5.1.49, use --force if you still need to run mysql_upgrade
"
[akonadiserver] Database process exited unexpectedly during initial connection!
[akonadiserver] executable: "/usr/sbin/mysqld-akonadi"
[akonadiserver] arguments: ("--defaults-file=/data/.local/share/akonadi//mysql.conf", "--datadir", "/data/.local/share/akonadi/db_data/", "--socket=/data/.local/share/akonadi/db_misc/mysql.socket")
[akonadiserver] stdout: ""
[akonadiserver] stderr: "Could not open required defaults file: /data/.local/share/akonadi//mysql.conf
[akonadiserver] Fatal error in defaults handling. Program aborted
[akonadiserver] 101231  7:18:26 [Warning] Can't create test file /data/.local/share/akonadi/db_data/admino-mbnoimi.lower-test
[akonadiserver] 101231  7:18:26 [Warning] Can't create test file /data/.local/share/akonadi/db_data/admino-mbnoimi.lower-test
[akonadiserver] 101231  7:18:26 [Note] Plugin 'FEDERATED' is disabled.
[akonadiserver] /usr/sbin/mysqld-akonadi: Can't find file: './mysql/plugin.frm' (errno: 13)
[akonadiserver] 101231  7:18:26 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
[akonadiserver] 101231  7:18:26  InnoDB: Operating system error number 13 in a file operation.
[akonadiserver] InnoDB: The error means mysqld does not have the access rights to
[akonadiserver] InnoDB: the directory.
[akonadiserver] InnoDB: File name ./ibdata1
[akonadiserver] InnoDB: File operation call: 'open'.
[akonadiserver] InnoDB: Cannot continue operation.
[akonadiserver] "
[akonadiserver] exit code: 1
[akonadiserver] process error: "Unknown error"
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40af99]
[akonadiserver] 1: akonadiserver() [0x40b4ea]
[akonadiserver] 2: /lib/libc.so.6(+0x33c20) [0x7f22fa201c20]
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7f22fa201ba5]
[akonadiserver] 4: /lib/libc.so.6(abort+0x180) [0x7f22fa2056b0]
[akonadiserver] 5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7f22fb3e4864]
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40c5d8]
[akonadiserver] 7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x77) [0x7f22fb4764a7]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(+0x10ba59) [0x7f22fb483a59]
[akonadiserver] 9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7f22fb484c69]
[akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x49) [0x4068f9]
[akonadiserver] 11: /usr/lib/libakonadiprivate.so.1(_ZN13DbConfigMysql19startInternalServerEv+0x19ad) [0x7f22fb9066ad]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0xdd) [0x7f22fb8708cd]
[akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0xd7) [0x7f22fb8727e7]
[akonadiserver] 14: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a) [0x7f22fb8741ea]
[akonadiserver] 15: akonadiserver(main+0x404) [0x405df4]
[akonadiserver] 16: /lib/libc.so.6(__libc_start_main+0xfe) [0x7f22fa1ecd8e]
[akonadiserver] 17: akonadiserver() [0x4058f9]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!

mbnoimi wrote:

Alternatively try using mysqld (without -akonadi)

It works but I got same error message from Akonadi when I run KMail!

You mean running the command manually worked without error?

In this case you can try changing the command Akonadi is executing by running:
kcmshell4 kcm_akonadi

second tab.

mbnoimi wrote:

In case neither command works even when you run it manually, try some of the AppArmor related hints here (just in case it is unfortunately AppArmor related after all)

I tried to run sudo aa-complain mysqld but I got:

Code: Select all

sudo: aa-complain: command not found

so I tried to replace mysqld by mysqld-akonadi but I got same thing (sudo: aa-complain: command not found)

Seems the AppArmor complain tool is not installed. Never been on any AppArmor system so no idea which package that would be in.

mbnoimi wrote:Also I added the following at last line (before '}') in /etc/apparmor.d/usr.sbin.mysqld-akonadi file

Code: Select all

@{HOME}/.Private/** rwk,

once again nothing changed!

Well, in your case the path would have to be something like /data/**

Cheers,
_

You mean running the command manually worked without error?

I mean the terminal didn't show any error but as soon as I run KMail the last error message appears.

you can try changing the command is executing by running:
kcmshell4 kcm_akonadi
second tab.

once again, when I click start button I get same error message addition new error about mysql!!!! so I think it's better to get back running /usr/sbin/mysqld-akonadi

Code: Select all

101231 13:17:59 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
101231 13:17:59  InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.


Well, in your case the path would have to be something like /data/**

wow... you're absolutely right I modified it and then restarted apparmor and akonadi but I got a new error about mysql!!!

Code: Select all

101231 13:30:35 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
101231 13:30:35  InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.

Finally I could fix this issue by installing libshibsp4 which is enabling FEDERATED for mysql... Thanks you a lot.

now Kontact (KMail) works but my PC becomes crazy -takes all computer resources- till about 5 minutes and then back ok.. does this related to Akonadi or not?

Strigi indexes my home folder (/data) without indexing hidden folders... does this affecting on initializing Kontact (do I've to enable indexing hidden folders too?)

My computer hardware is:
Processor: Intel core 2 due E7500 @ 2.93GHz
Memory: 2GiB

The new error was most likely caused by the mysqld instance you started manually.

It already operates on the data files so the new instance logged errors.

Might be better to reboot once or stop Akonadi and kill all remaining mysqld processes for that user.

Cheers,
_

The new error was most likely caused by the mysqld instance you started manually.

Thx, now there is no error exists.. I just asked why Kontact starting-up becomes very slow (takes huge resources)

Might be better to reboot once or stop Akonadi and kill all remaining mysqld processes for that user.

I rooted my machine... Kontact still slow at starting-up stage (I tested it many times).

Strigi indexing is unrelated to Akonadi, you can even switch it off without impact on Akonadi.

Do you see any other process taking lots of CPU resources?

Cheers,
_

Do you see any other process taking lots of CPU resources?

No.

by the way Akonadi crashed in one of my tests during starting-up stage of Kontact that's mean there is some issue with Akonadi.

anda_skoa wrote:True, but it looks like the issues caused by AppArmor and Ubuntu is the only distribution (AFAIK) shiping with such a setup.

Wrong, openSuse also has AppArmor installed and running.

I am also having issues with this same problem. I have posted a request for help on the openSuse forum (http://forums.opensuse.org/english/get-technical-help-here/applications/452479-akonadi-problems.html), but no one has replied yet.

I was just about to wipe the disk and start over with a reinstall until I saw this post. SQL and D-Bus registering are the problems on my machine. I'll see if I can fix it via these posts.

Guys I gave up, thanks for all of you.

I prefer to use Thunderbird now instead of wasting my time with these unresolved problems. KMail becomes sooooo slow and the Kontacts too which they drive me crazy.

I think your AppArmor is interfering.