This forum has been archived. All content is frozen. Please use KDE Discuss instead.

[Solved]Akonadi doesn't find QtSQL

Tags: akonadi, qt, qtsql, kmail, libqsqlmysql, mysql akonadi, qt, qtsql, kmail, libqsqlmysql, mysql akonadi, qt, qtsql, kmail, libqsqlmysql, mysql
(comma "," separated)
User avatar
zuargo
Registered Member
Posts
60
Karma
0
OS

[Solved]Akonadi doesn't find QtSQL

Sat Apr 09, 2011 10:21 pm
Hello everyone

Today I have updated KDE to 4.6.2 on my Archlinux x86.

When I start KMail (1.13.6) I get this message:

Screenshot

The first line in the message catches my attention:

Databse driver not found
Details:
The QtSQL driver 'QMYSQL' is required by your current Akonadi server configuration.
The following drivers are installed: QSQLITE, QSQLITE3, QODBC3, QODBC, QPSQL7, QPSQL.
Make sure the required driver is installed.


So, I was reading here: http://userbase.kde.org/Akonadi_4.4/Tro ... erequisite.

Considering that I have compiled Qt-4.7.2 by myself using an oficial PKGBUILD with a little changes (you can see it here), I have paid attention to this:

If you compile Qt4 yourself, make sure to tell the configure script to build in MySQL support by passing it the following option:
-plugin-sql-mysql


But if you see the PKGBUILD it has the flag:

Code: Select all
-plugin-sql-{psql,mysql,sqlite,odbc}


I guess as that flag enabled the QtSQL driver on my system.

Also, the same web page says:

The driver you need is libqsqlmysql.so


So, I ran a command to see if that file exists on my system:

Code: Select all
$ pacman -Ql | grep libqsqlmysql.so
qt /usr/lib/qt/plugins/sqldrivers/libqsqlmysql.so


As you see the file is on my system and it is provided by the package qt.

Furthermore, in the named web page, a little further down, of the text that I have cited, says:

Then configure and make as above. But the make install doesn't copy the driver. So you have to copy it by yourself:
cp <qt-src-dir>/qt-everywhere-opensource-src-4.6.0/plugins/sqldrivers/libqsqlmysql.so /usr/local/bin/sqldrivers/


As you see it says that the libqsqlmysql.so file must be copied to /usr/local/bin/sqldrivers/ (doesn't name a specific distribution) and if you look a little fhurter up, when I post the terminal output after running the pacman command, you will see that the named .so file, in my system, is on the route /usr/lib/qt/plugins/sqldrivers/.

Maybe this is the problem.

Plase help me, I have four email accounts and it is so tired to go account by account reading my emails. Becouse, also, and related to this latter thing, when kmail shows the error message I can't acces to the display area, there where you can read your emails. I just can acces to the main menu, here a screenshot:

Screenshot

Thanks in advance

Greetings

EDIT: are the [img] tag disabled?, I can't see the images by using that tag :P

Last edited by zuargo on Wed Apr 13, 2011 2:31 pm, edited 1 time in total.
User avatar
bcooksley
Administrator
Posts
19765
Karma
87
OS
Try removing ~/.config/Trolltech.conf


KDE Sysadmin
[img]content/bcooksley_sig.png[/img]
User avatar
zuargo
Registered Member
Posts
60
Karma
0
OS
Bad luck, it does not work :(

I don't understand why Akonady cannot detect libqsqlmysql.so if it is on my system.

Anyway, thank you by your reply :)
User avatar
ivan
KDE Developer
Posts
918
Karma
14
OS
Try typing
akonadictl stop
akonadictl start
in terminal

The sql driver issue reported can turn out not to be an sql driver issue at all. (for me, the error was a binary incompatible boost library version)

It is a small chance, but it is worth a shot :)


Image
User avatar
zuargo
Registered Member
Posts
60
Karma
0
OS
Already, before, I tried stop and restart akonadi using the GUI (not trough a terminal) but it did not work. I had the same error message as that one, in the first screenshot, in my first post here.

So, I did that you said, here the results:

Code: Select all
$ akonadictl stop
Akonadi is not running.


Code: Select all
$ akonadictl start
Starting Akonadi Server...
   done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
[zuargo@zuargo-archlinux ~]$ search paths:  ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/sbin", "/usr/sbin", "/sbin", "/usr/share/java/apache-ant/bin", "/opt/java/bin", "/opt/java/db/bin", "/opt/java/jre/bin", "/usr/bin/core_perl", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db:  "/usr/bin/mysql_install_db"
Found mysqlcheck:  "/usr/bin/mysqlcheck"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3 QODBC3 QODBC QPSQL7 QPSQL
Invalid database object during database server startup
"[
0: akonadiserver(_Z11akBacktracev+0x35) [0x8087295]
1: akonadiserver() [0x808773b]
2: [0xb782a400]
3: [0xb782a424]
4: /lib/libc.so.6(gsignal+0x52) [0xb6f0fdb2]
5: /lib/libc.so.6(abort+0x17c) [0xb6f1164c]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x82) [0xb75a7a72]
7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8089ac4]
8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8f) [0xb764aabf]
9: /usr/lib/libQtCore.so.4(+0x107057) [0xb7656057]
10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD2Ev+0x3e) [0xb766084e]
11: akonadiserver(_ZN6QDebugD1Ev+0x44) [0x8082b34]
12: akonadiserver(_ZN13DbConfigMysql19startInternalServerEv+0x31f0) [0x81109e0]
13: akonadiserver(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0xe3) [0x8089ed3]
14: akonadiserver() [0x808ca70]
15: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x3d) [0x808e03d]
16: akonadiserver(main+0x219) [0x8081fa9]
17: /lib/libc.so.6(__libc_start_main+0xe7) [0xb6efbdc7]
18: akonadiserver() [0x8081cc1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/sbin", "/usr/sbin", "/sbin", "/usr/share/java/apache-ant/bin", "/opt/java/bin", "/opt/java/db/bin", "/opt/java/jre/bin", "/usr/bin/core_perl", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db:  "/usr/bin/mysql_install_db"
Found mysqlcheck:  "/usr/bin/mysqlcheck"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3 QODBC3 QODBC QPSQL7 QPSQL
Invalid database object during database server startup
"[
0: akonadiserver(_Z11akBacktracev+0x35) [0x8087295]
1: akonadiserver() [0x808773b]
2: [0xb7712400]
3: [0xb7712424]
4: /lib/libc.so.6(gsignal+0x52) [0xb6df7db2]
5: /lib/libc.so.6(abort+0x17c) [0xb6df964c]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x82) [0xb748fa72]
7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8089ac4]
8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8f) [0xb7532abf]
9: /usr/lib/libQtCore.so.4(+0x107057) [0xb753e057]
10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD2Ev+0x3e) [0xb754884e]
11: akonadiserver(_ZN6QDebugD1Ev+0x44) [0x8082b34]
12: akonadiserver(_ZN13DbConfigMysql19startInternalServerEv+0x31f0) [0x81109e0]
13: akonadiserver(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0xe3) [0x8089ed3]
14: akonadiserver() [0x808ca70]
15: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x3d) [0x808e03d]
16: akonadiserver(main+0x219) [0x8081fa9]
17: /lib/libc.so.6(__libc_start_main+0xe7) [0xb6de3dc7]
18: akonadiserver() [0x8081cc1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/sbin", "/usr/sbin", "/sbin", "/usr/share/java/apache-ant/bin", "/opt/java/bin", "/opt/java/db/bin", "/opt/java/jre/bin", "/usr/bin/core_perl", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db:  "/usr/bin/mysql_install_db"
Found mysqlcheck:  "/usr/bin/mysqlcheck"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3 QODBC3 QODBC QPSQL7 QPSQL
Invalid database object during database server startup
"[
0: akonadiserver(_Z11akBacktracev+0x35) [0x8087295]
1: akonadiserver() [0x808773b]
2: [0xb76e9400]
3: [0xb76e9424]
4: /lib/libc.so.6(gsignal+0x52) [0xb6dcedb2]
5: /lib/libc.so.6(abort+0x17c) [0xb6dd064c]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x82) [0xb7466a72]
7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8089ac4]
8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8f) [0xb7509abf]
9: /usr/lib/libQtCore.so.4(+0x107057) [0xb7515057]
10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD2Ev+0x3e) [0xb751f84e]
11: akonadiserver(_ZN6QDebugD1Ev+0x44) [0x8082b34]
12: akonadiserver(_ZN13DbConfigMysql19startInternalServerEv+0x31f0) [0x81109e0]
13: akonadiserver(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0xe3) [0x8089ed3]
14: akonadiserver() [0x808ca70]
15: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x3d) [0x808e03d]
16: akonadiserver(main+0x219) [0x8081fa9]
17: /lib/libc.so.6(__libc_start_main+0xe7) [0xb6dbadc7]
18: akonadiserver() [0x8081cc1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/sbin", "/usr/sbin", "/sbin", "/usr/share/java/apache-ant/bin", "/opt/java/bin", "/opt/java/db/bin", "/opt/java/jre/bin", "/usr/bin/core_perl", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db:  "/usr/bin/mysql_install_db"
Found mysqlcheck:  "/usr/bin/mysqlcheck"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3 QODBC3 QODBC QPSQL7 QPSQL
Invalid database object during database server startup
"[
0: akonadiserver(_Z11akBacktracev+0x35) [0x8087295]
1: akonadiserver() [0x808773b]
2: [0xb78d6400]
3: [0xb78d6424]
4: /lib/libc.so.6(gsignal+0x52) [0xb6fbbdb2]
5: /lib/libc.so.6(abort+0x17c) [0xb6fbd64c]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x82) [0xb7653a72]
7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8089ac4]
8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8f) [0xb76f6abf]
9: /usr/lib/libQtCore.so.4(+0x107057) [0xb7702057]
10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD2Ev+0x3e) [0xb770c84e]
11: akonadiserver(_ZN6QDebugD1Ev+0x44) [0x8082b34]
12: akonadiserver(_ZN13DbConfigMysql19startInternalServerEv+0x31f0) [0x81109e0]
13: akonadiserver(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0xe3) [0x8089ed3]
14: akonadiserver() [0x808ca70]
15: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x3d) [0x808e03d]
16: akonadiserver(main+0x219) [0x8081fa9]
17: /lib/libc.so.6(__libc_start_main+0xe7) [0xb6fa7dc7]
18: akonadiserver() [0x8081cc1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!


It looks like a crash, maybe I should report all this at the KDE's bug tracker.

What do you think?
User avatar
bcooksley
Administrator
Posts
19765
Karma
87
OS
Can you create a new user and see if Akonadi detects the QtSql MySQL plugin there?


KDE Sysadmin
[img]content/bcooksley_sig.png[/img]
User avatar
ivan
KDE Developer
Posts
918
Karma
14
OS
Ok, this output confirmed that it can't find mysql plugin...

You can check whether libqsqlite.so is located in the same directory as the one for mysql. If that is the case, and it doesn't work for a new/clean user, then it is not the problem that it can not find the plugin, but it can't load it.

Again, the cause for something like that can be in missing dependencies of the qmysql plugin, or wrong abi of those dependencies.


Image
User avatar
zuargo
Registered Member
Posts
60
Karma
0
OS
bcooksley wrote:Can you create a new user and see if Akonadi detects the QtSql MySQL plugin there?


I did it, I had the same result (or at least very similar). When I launched KMail it showed the same message of error.

Also I ran akonadictl start:

Code: Select all
$ akonadictl start
Starting Akonadi Server...
   done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
[pipe@zuargo-archlinux ~]$ search paths:  ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/sbin", "/usr/sbin", "/sbin", "/usr/share/java/apache-ant/bin", "/opt/java/bin", "/opt/java/db/bin", "/opt/java/jre/bin", "/usr/bin/core_perl", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db:  "/usr/bin/mysql_install_db"
Found mysqlcheck:  "/usr/bin/mysqlcheck"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3 QODBC3 QODBC QPSQL7 QPSQL
Invalid database object during database server startup
"[
0: akonadiserver(_Z11akBacktracev+0x35) [0x8087295]
1: akonadiserver() [0x808773b]
2: [0xb77b1400]
3: [0xb77b1424]
4: /lib/libc.so.6(gsignal+0x52) [0xb6e96db2]
5: /lib/libc.so.6(abort+0x17c) [0xb6e9864c]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x82) [0xb752ea72]
7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8089ac4]
8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8f) [0xb75d1abf]
9: /usr/lib/libQtCore.so.4(+0x107057) [0xb75dd057]
10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD2Ev+0x3e) [0xb75e784e]
11: akonadiserver(_ZN6QDebugD1Ev+0x44) [0x8082b34]
12: akonadiserver(_ZN13DbConfigMysql19startInternalServerEv+0x31f0) [0x81109e0]
13: akonadiserver(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0xe3) [0x8089ed3]
14: akonadiserver() [0x808ca70]
15: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x3d) [0x808e03d]
16: akonadiserver(main+0x219) [0x8081fa9]
17: /lib/libc.so.6(__libc_start_main+0xe7) [0xb6e82dc7]
18: akonadiserver() [0x8081cc1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/sbin", "/usr/sbin", "/sbin", "/usr/share/java/apache-ant/bin", "/opt/java/bin", "/opt/java/db/bin", "/opt/java/jre/bin", "/usr/bin/core_perl", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db:  "/usr/bin/mysql_install_db"
Found mysqlcheck:  "/usr/bin/mysqlcheck"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3 QODBC3 QODBC QPSQL7 QPSQL
Invalid database object during database server startup
"[
0: akonadiserver(_Z11akBacktracev+0x35) [0x8087295]
1: akonadiserver() [0x808773b]
2: [0xb783f400]
3: [0xb783f424]
4: /lib/libc.so.6(gsignal+0x52) [0xb6f24db2]
5: /lib/libc.so.6(abort+0x17c) [0xb6f2664c]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x82) [0xb75bca72]
7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8089ac4]
8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8f) [0xb765fabf]
9: /usr/lib/libQtCore.so.4(+0x107057) [0xb766b057]
10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD2Ev+0x3e) [0xb767584e]
11: akonadiserver(_ZN6QDebugD1Ev+0x44) [0x8082b34]
12: akonadiserver(_ZN13DbConfigMysql19startInternalServerEv+0x31f0) [0x81109e0]
13: akonadiserver(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0xe3) [0x8089ed3]
14: akonadiserver() [0x808ca70]
15: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x3d) [0x808e03d]
16: akonadiserver(main+0x219) [0x8081fa9]
17: /lib/libc.so.6(__libc_start_main+0xe7) [0xb6f10dc7]
18: akonadiserver() [0x8081cc1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/sbin", "/usr/sbin", "/sbin", "/usr/share/java/apache-ant/bin", "/opt/java/bin", "/opt/java/db/bin", "/opt/java/jre/bin", "/usr/bin/core_perl", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db:  "/usr/bin/mysql_install_db"
Found mysqlcheck:  "/usr/bin/mysqlcheck"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3 QODBC3 QODBC QPSQL7 QPSQL
Invalid database object during database server startup
"[
0: akonadiserver(_Z11akBacktracev+0x35) [0x8087295]
1: akonadiserver() [0x808773b]
2: [0xb782e400]
3: [0xb782e424]
4: /lib/libc.so.6(gsignal+0x52) [0xb6f13db2]
5: /lib/libc.so.6(abort+0x17c) [0xb6f1564c]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x82) [0xb75aba72]
7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8089ac4]
8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8f) [0xb764eabf]
9: /usr/lib/libQtCore.so.4(+0x107057) [0xb765a057]
10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD2Ev+0x3e) [0xb766484e]
11: akonadiserver(_ZN6QDebugD1Ev+0x44) [0x8082b34]
12: akonadiserver(_ZN13DbConfigMysql19startInternalServerEv+0x31f0) [0x81109e0]
13: akonadiserver(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0xe3) [0x8089ed3]
14: akonadiserver() [0x808ca70]
15: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x3d) [0x808e03d]
16: akonadiserver(main+0x219) [0x8081fa9]
17: /lib/libc.so.6(__libc_start_main+0xe7) [0xb6effdc7]
18: akonadiserver() [0x8081cc1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/sbin", "/usr/sbin", "/sbin", "/usr/share/java/apache-ant/bin", "/opt/java/bin", "/opt/java/db/bin", "/opt/java/jre/bin", "/usr/bin/core_perl", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db:  "/usr/bin/mysql_install_db"
Found mysqlcheck:  "/usr/bin/mysqlcheck"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3 QODBC3 QODBC QPSQL7 QPSQL
Invalid database object during database server startup
"[
0: akonadiserver(_Z11akBacktracev+0x35) [0x8087295]
1: akonadiserver() [0x808773b]
2: [0xb7859400]
3: [0xb7859424]
4: /lib/libc.so.6(gsignal+0x52) [0xb6f3edb2]
5: /lib/libc.so.6(abort+0x17c) [0xb6f4064c]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x82) [0xb75d6a72]
7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8089ac4]
8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8f) [0xb7679abf]
9: /usr/lib/libQtCore.so.4(+0x107057) [0xb7685057]
10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD2Ev+0x3e) [0xb768f84e]
11: akonadiserver(_ZN6QDebugD1Ev+0x44) [0x8082b34]
12: akonadiserver(_ZN13DbConfigMysql19startInternalServerEv+0x31f0) [0x81109e0]
13: akonadiserver(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0xe3) [0x8089ed3]
14: akonadiserver() [0x808ca70]
15: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x3d) [0x808e03d]
16: akonadiserver(main+0x219) [0x8081fa9]
17: /lib/libc.so.6(__libc_start_main+0xe7) [0xb6f2adc7]
18: akonadiserver() [0x8081cc1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!


ivan wrote:Ok, this output confirmed that it can't find mysql plugin...

You can check whether libqsqlite.so is located in the same directory as the one for mysql. If that is the case, and it doesn't work for a new/clean user, then it is not the problem that it can not find the plugin, but it can't load it.

Again, the cause for something like that can be in missing dependencies of the qmysql plugin, or wrong abi of those dependencies.


I ran a command to check all files and folders installed by the package that provides mysql:

Code: Select all
$ pacman -Ql mysql
mysql /etc/
mysql /etc/mysql/
mysql /etc/mysql/my.cnf
mysql /etc/rc.d/
mysql /etc/rc.d/mysqld
mysql /usr/
mysql /usr/bin/
mysql /usr/bin/innochecksum
mysql /usr/bin/msql2mysql
mysql /usr/bin/my_print_defaults
mysql /usr/bin/myisam_ftdump
mysql /usr/bin/myisamchk
mysql /usr/bin/myisamlog
mysql /usr/bin/myisampack
mysql /usr/bin/mysql_client_test
mysql /usr/bin/mysql_convert_table_format
mysql /usr/bin/mysql_find_rows
mysql /usr/bin/mysql_fix_extensions
mysql /usr/bin/mysql_install_db
mysql /usr/bin/mysql_secure_installation
mysql /usr/bin/mysql_setpermission
mysql /usr/bin/mysql_tzinfo_to_sql
mysql /usr/bin/mysql_upgrade
mysql /usr/bin/mysql_waitpid
mysql /usr/bin/mysql_zap
mysql /usr/bin/mysqlaccess
mysql /usr/bin/mysqlaccess.conf
mysql /usr/bin/mysqlbinlog
mysql /usr/bin/mysqlbug
mysql /usr/bin/mysqld
mysql /usr/bin/mysqld_multi
mysql /usr/bin/mysqld_safe
mysql /usr/bin/mysqldumpslow
mysql /usr/bin/mysqlhotcopy
mysql /usr/bin/mysqltest
mysql /usr/bin/perror
mysql /usr/bin/replace
mysql /usr/bin/resolve_stack_dump
mysql /usr/bin/resolveip
mysql /usr/lib/
mysql /usr/lib/mysql/
mysql /usr/lib/mysql/plugin/
mysql /usr/lib/mysql/plugin/adt_null.so
mysql /usr/lib/mysql/plugin/auth.so
mysql /usr/lib/mysql/plugin/auth_socket.so
mysql /usr/lib/mysql/plugin/auth_test_plugin.so
mysql /usr/lib/mysql/plugin/debug/
mysql /usr/lib/mysql/plugin/libdaemon_example.so
mysql /usr/lib/mysql/plugin/mypluglib.so
mysql /usr/lib/mysql/plugin/qa_auth_client.so
mysql /usr/lib/mysql/plugin/qa_auth_interface.so
mysql /usr/lib/mysql/plugin/qa_auth_server.so
mysql /usr/lib/mysql/plugin/semisync_master.so
mysql /usr/lib/mysql/plugin/semisync_slave.so
mysql /usr/share/
mysql /usr/share/man/
mysql /usr/share/man/man1/
mysql /usr/share/man/man1/comp_err.1.gz
mysql /usr/share/man/man1/innochecksum.1.gz
mysql /usr/share/man/man1/msql2mysql.1.gz
mysql /usr/share/man/man1/my_print_defaults.1.gz
mysql /usr/share/man/man1/myisam_ftdump.1.gz
mysql /usr/share/man/man1/myisamchk.1.gz
mysql /usr/share/man/man1/myisamlog.1.gz
mysql /usr/share/man/man1/myisampack.1.gz
mysql /usr/share/man/man1/mysql-stress-test.pl.1.gz
mysql /usr/share/man/man1/mysql-test-run.pl.1.gz
mysql /usr/share/man/man1/mysql.server.1.gz
mysql /usr/share/man/man1/mysql_client_test.1.gz
mysql /usr/share/man/man1/mysql_convert_table_format.1.gz
mysql /usr/share/man/man1/mysql_find_rows.1.gz
mysql /usr/share/man/man1/mysql_fix_extensions.1.gz
mysql /usr/share/man/man1/mysql_install_db.1.gz
mysql /usr/share/man/man1/mysql_secure_installation.1.gz
mysql /usr/share/man/man1/mysql_setpermission.1.gz
mysql /usr/share/man/man1/mysql_tzinfo_to_sql.1.gz
mysql /usr/share/man/man1/mysql_upgrade.1.gz
mysql /usr/share/man/man1/mysql_waitpid.1.gz
mysql /usr/share/man/man1/mysql_zap.1.gz
mysql /usr/share/man/man1/mysqlaccess.1.gz
mysql /usr/share/man/man1/mysqlbinlog.1.gz
mysql /usr/share/man/man1/mysqlbug.1.gz
mysql /usr/share/man/man1/mysqld_multi.1.gz
mysql /usr/share/man/man1/mysqld_safe.1.gz
mysql /usr/share/man/man1/mysqldumpslow.1.gz
mysql /usr/share/man/man1/mysqlhotcopy.1.gz
mysql /usr/share/man/man1/mysqlman.1.gz
mysql /usr/share/man/man1/mysqltest.1.gz
mysql /usr/share/man/man1/perror.1.gz
mysql /usr/share/man/man1/replace.1.gz
mysql /usr/share/man/man1/resolve_stack_dump.1.gz
mysql /usr/share/man/man1/resolveip.1.gz
mysql /usr/share/man/man8/
mysql /usr/share/man/man8/mysqld.8.gz
mysql /usr/share/mysql/
mysql /usr/share/mysql/COPYING
mysql /usr/share/mysql/INSTALL-BINARY
mysql /usr/share/mysql/README
mysql /usr/share/mysql/aclocal/
mysql /usr/share/mysql/aclocal/mysql.m4
mysql /usr/share/mysql/binary-configure
mysql /usr/share/mysql/charsets/
mysql /usr/share/mysql/charsets/Index.xml
mysql /usr/share/mysql/charsets/README
mysql /usr/share/mysql/charsets/armscii8.xml
mysql /usr/share/mysql/charsets/ascii.xml
mysql /usr/share/mysql/charsets/cp1250.xml
mysql /usr/share/mysql/charsets/cp1251.xml
mysql /usr/share/mysql/charsets/cp1256.xml
mysql /usr/share/mysql/charsets/cp1257.xml
mysql /usr/share/mysql/charsets/cp850.xml
mysql /usr/share/mysql/charsets/cp852.xml
mysql /usr/share/mysql/charsets/cp866.xml
mysql /usr/share/mysql/charsets/dec8.xml
mysql /usr/share/mysql/charsets/geostd8.xml
mysql /usr/share/mysql/charsets/greek.xml
mysql /usr/share/mysql/charsets/hebrew.xml
mysql /usr/share/mysql/charsets/hp8.xml
mysql /usr/share/mysql/charsets/keybcs2.xml
mysql /usr/share/mysql/charsets/koi8r.xml
mysql /usr/share/mysql/charsets/koi8u.xml
mysql /usr/share/mysql/charsets/latin1.xml
mysql /usr/share/mysql/charsets/latin2.xml
mysql /usr/share/mysql/charsets/latin5.xml
mysql /usr/share/mysql/charsets/latin7.xml
mysql /usr/share/mysql/charsets/macce.xml
mysql /usr/share/mysql/charsets/macroman.xml
mysql /usr/share/mysql/charsets/swe7.xml
mysql /usr/share/mysql/config.huge.ini
mysql /usr/share/mysql/config.medium.ini
mysql /usr/share/mysql/config.small.ini
mysql /usr/share/mysql/czech/
mysql /usr/share/mysql/czech/errmsg.sys
mysql /usr/share/mysql/danish/
mysql /usr/share/mysql/danish/errmsg.sys
mysql /usr/share/mysql/docs/
mysql /usr/share/mysql/docs/mysql.info
mysql /usr/share/mysql/dutch/
mysql /usr/share/mysql/dutch/errmsg.sys
mysql /usr/share/mysql/english/
mysql /usr/share/mysql/english/errmsg.sys
mysql /usr/share/mysql/errmsg-utf8.txt
mysql /usr/share/mysql/estonian/
mysql /usr/share/mysql/estonian/errmsg.sys
mysql /usr/share/mysql/fill_help_tables.sql
mysql /usr/share/mysql/french/
mysql /usr/share/mysql/french/errmsg.sys
mysql /usr/share/mysql/german/
mysql /usr/share/mysql/german/errmsg.sys
mysql /usr/share/mysql/greek/
mysql /usr/share/mysql/greek/errmsg.sys
mysql /usr/share/mysql/hungarian/
mysql /usr/share/mysql/hungarian/errmsg.sys
mysql /usr/share/mysql/italian/
mysql /usr/share/mysql/italian/errmsg.sys
mysql /usr/share/mysql/japanese/
mysql /usr/share/mysql/japanese/errmsg.sys
mysql /usr/share/mysql/korean/
mysql /usr/share/mysql/korean/errmsg.sys
mysql /usr/share/mysql/magic
mysql /usr/share/mysql/my-huge.cnf
mysql /usr/share/mysql/my-innodb-heavy-4G.cnf
mysql /usr/share/mysql/my-large.cnf
mysql /usr/share/mysql/my-medium.cnf
mysql /usr/share/mysql/my-small.cnf
mysql /usr/share/mysql/mysql-log-rotate
mysql /usr/share/mysql/mysql.server
mysql /usr/share/mysql/mysql_system_tables.sql
mysql /usr/share/mysql/mysql_system_tables_data.sql
mysql /usr/share/mysql/mysql_test_data_timezone.sql
mysql /usr/share/mysql/mysqld_multi.server
mysql /usr/share/mysql/ndb-config-2-node.ini
mysql /usr/share/mysql/norwegian-ny/
mysql /usr/share/mysql/norwegian-ny/errmsg.sys
mysql /usr/share/mysql/norwegian/
mysql /usr/share/mysql/norwegian/errmsg.sys
mysql /usr/share/mysql/polish/
mysql /usr/share/mysql/polish/errmsg.sys
mysql /usr/share/mysql/portuguese/
mysql /usr/share/mysql/portuguese/errmsg.sys
mysql /usr/share/mysql/romanian/
mysql /usr/share/mysql/romanian/errmsg.sys
mysql /usr/share/mysql/russian/
mysql /usr/share/mysql/russian/errmsg.sys
mysql /usr/share/mysql/serbian/
mysql /usr/share/mysql/serbian/errmsg.sys
mysql /usr/share/mysql/slovak/
mysql /usr/share/mysql/slovak/errmsg.sys
mysql /usr/share/mysql/spanish/
mysql /usr/share/mysql/spanish/errmsg.sys
mysql /usr/share/mysql/swedish/
mysql /usr/share/mysql/swedish/errmsg.sys
mysql /usr/share/mysql/ukrainian/
mysql /usr/share/mysql/ukrainian/errmsg.sys
mysql /var/
mysql /var/lib/
mysql /var/lib/mysql/
mysql /var/lib/mysql/mysql/
mysql /var/lib/mysql/mysql/.empty
mysql /var/lib/mysql/test/
mysql /var/lib/mysql/test/.empty


After I searched on my system by all files called libqsqlite.so:

Code: Select all
$ sudo find / -name "libqsqlite.so"
Contraseña:
/home/zuargo/Paquetes/qt/pkg/qt/usr/lib/qt/plugins/sqldrivers/libqsqlite.so
/home/zuargo/Paquetes/qt/src/qt-everywhere-opensource-src-4.7.2/plugins/sqldrivers/libqsqlite.so
/usr/lib/qt/plugins/sqldrivers/libqsqlite.so


As you see libqsqlite.so is not located in any folder provided by mysql package.

Also I searched by libqsqlmysql.so on my sistem:

Code: Select all
$ sudo find / -name "libqsqlmysql.so"
Contraseña:
/home/zuargo/Paquetes/qt/pkg/qt/usr/lib/qt/plugins/sqldrivers/libqsqlmysql.so
/home/zuargo/Paquetes/qt/src/qt-everywhere-opensource-src-4.7.2/plugins/sqldrivers/libqsqlmysql.so
/usr/lib/qt/plugins/sqldrivers/libqsqlmysql.so


Same issue than libqsqlite.so, as you see libqsqlmysql.so is not located in any folder provided by mysql package.

I think Akonadi can not find the libqsqlite.so and libqsqlmysql.so files
User avatar
ivan
KDE Developer
Posts
918
Karma
14
OS
Since both mysql and sqlite plugins are there, in the same folders, it definitely can find the plugin but it can't load it for some reason.

We need someone who knows how to get the qtplugin related issues debug output.


Image
User avatar
zuargo
Registered Member
Posts
60
Karma
0
OS
Well, here the solution:

I ran:

Code: Select all
$ ldd /usr/lib/qt/plugins/sqldrivers/libqsqlmysql.so
        linux-gate.so.1 =>  (0xb77dc000)
        libmysqlclient.so.16 => not found
        libQtSql.so.4 => /usr/lib/libQtSql.so.4 (0xb7767000)
        libQtCore.so.4 => /usr/lib/libQtCore.so.4 (0xb74b1000)
        libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xb73c3000)
        libgcc_s.so.1 => /usr/lib/libgcc_s.so.1 (0xb73a8000)
        libc.so.6 => /lib/libc.so.6 (0xb725d000)
        libpthread.so.0 => /lib/libpthread.so.0 (0xb7244000)
        libz.so.1 => /usr/lib/libz.so.1 (0xb722f000)
        libdl.so.2 => /lib/libdl.so.2 (0xb722b000)
        libgthread-2.0.so.0 => /usr/lib/libgthread-2.0.so.0 (0xb7227000)
        librt.so.1 => /lib/librt.so.1 (0xb721d000)
        libglib-2.0.so.0 => /usr/lib/libglib-2.0.so.0 (0xb714c000)
        libm.so.6 => /lib/libm.so.6 (0xb7126000)
        /lib/ld-linux.so.2 (0xb77dd000)
        libpcre.so.0 => /lib/libpcre.so.0 (0xb70e9000)


As you see libqsqlmysql.so needs libmysqlclient.so.16 and it is missing.

On Archlinux libmysqlclient.so.16 is provided by the package libmysqlclient but, when I builded Qt, I had installed libmysqlclient-5.5.11, wich one provides libmysqlclient.so.18 not libmysqlclient.so.16.

So, the solution was downgrade libmysqlclient-5.5.11 to libmysqlclient-5.5.9 (or any another version of this package that provides libmysqlclient.so.16). Or rebuild Qt with libmysqlclient-5.5.11 installed on the system (which provides libmysqlclient.so.18).

I tried both solutions and both worked

Thanks so much to Christophe Giboudeaux who helped me here https://bugs.kde.org/show_bug.cgi?id=270720 to find this solution to the problem.

Also, thank you so much guys, ivan and bcooksley, by the help :)
aguinaldoalves
Registered Member
Posts
1
Karma
0
I solved the problem by reinstalling Akonadi

apt-get install akonadi* --reinstall


Bookmarks



Who is online

Registered users: Bing [Bot], Evergrowing, Google [Bot]