Arch Linux

Xinevic

Member

From: Belarus, Minsk

Registered: 2015-12-28

Posts: 49

[SOLVED] Unable to start akonadi services

Hi all.
I am unable to start akonadi service.
When I am trying to start it via akonadictl start I got

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QIBASE QSQLITE QSQLITE3 QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7 QTDS QTDS7
org.kde.pim.akonadiserver: Invalid database object during initial database connection
org.kde.pim.akonadiserver: Failed to remove runtime connection config file
org.kde.pim.akonadicontrol: Application 'akonadiserver' exited normally...

What I have done:
configured ~/.config/akonadi/akonadiserverrc file. Now it looks like this:

[%General]
Driver=QMYSQL
ExternalPayload=false
SizeThreshold=4096

[QMYSQL]
Host=localhost
Name=akonadi
Options="UNIX_SOCKET=/tmp/akonadi-pluhin.6FMBzg/mysql.socket"
Password=akonadi
ServerPath=/usr/bin/mysqld
StartServer=false
User=akonadi

Last edited by Xinevic (2018-02-22 09:22:31)

Xinevic

Member

From: Belarus, Minsk

Registered: 2015-12-28

Posts: 49

Re: [SOLVED] Unable to start akonadi services

Does anybody have idea?

archkdemax

Member

Registered: 2015-03-04

Posts: 4

Re: [SOLVED] Unable to start akonadi services

If you enable the "QMYSQL" because

QSqlDatabase: QMYSQL driver not loaded

maybe you have to enable it

Xinevic

Member

From: Belarus, Minsk

Registered: 2015-12-28

Posts: 49

Re: [SOLVED] Unable to start akonadi services

If you enable the "QMYSQL" because

QSqlDatabase: QMYSQL driver not loaded

maybe you have to enable it

And how can I do this? My MySQL database works, and different programs that use MySQL works too.

V1del

Forum Moderator

Registered: 2012-10-16

Posts: 21,740

Re: [SOLVED] Unable to start akonadi services

Did you create a schema and the respective user, see https://forum.kde.org/viewtopic.php?f=2 … 92#p350895 as well.

Xinevic

Member

From: Belarus, Minsk

Registered: 2015-12-28

Posts: 49

Re: [SOLVED] Unable to start akonadi services

Yes, I did it.
I think, if I didn't create user, I will got mysql connection error, not error with driver.

Xinevic

Member

From: Belarus, Minsk

Registered: 2015-12-28

Posts: 49

Re: [SOLVED] Unable to start akonadi services

Probably I found the problem:
Doing this:

ldd /usr/lib/qt/plugins/sqldrivers/libqsqlmysql.so

giving me the following:

	linux-vdso.so.1 (0x00007fff717b2000)
	libQt5Sql.so.5 => /usr/lib/libQt5Sql.so.5 (0x00007f56736b7000)
	libQt5Core.so.5 => /usr/lib/libQt5Core.so.5 (0x00007f5672fb1000)
	libmysqlclient.so.18 => not found
	libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x00007f5672c2a000)
	libc.so.6 => /usr/lib/libc.so.6 (0x00007f5672873000)
	libpthread.so.0 => /usr/lib/libpthread.so.0 (0x00007f5672655000)
	libsystemd.so.0 => /usr/lib/libsystemd.so.0 (0x00007f56723cf000)
	libz.so.1 => /usr/lib/libz.so.1 (0x00007f56721b8000)
	libicui18n.so.60 => /usr/lib/libicui18n.so.60 (0x00007f5671d15000)
	libicuuc.so.60 => /usr/lib/libicuuc.so.60 (0x00007f567195c000)
	libpcre2-16.so.0 => /usr/lib/libpcre2-16.so.0 (0x00007f56716e4000)
	libdouble-conversion.so.1 => /usr/lib/libdouble-conversion.so.1 (0x00007f56714d4000)
	libdl.so.2 => /usr/lib/libdl.so.2 (0x00007f56712d0000)
	libglib-2.0.so.0 => /usr/lib/libglib-2.0.so.0 (0x00007f5670fbb000)
	libm.so.6 => /usr/lib/libm.so.6 (0x00007f5670c6f000)
	libgcc_s.so.1 => /usr/lib/libgcc_s.so.1 (0x00007f5670a58000)
	/usr/lib64/ld-linux-x86-64.so.2 (0x00007f5673b14000)
	librt.so.1 => /usr/lib/librt.so.1 (0x00007f5670850000)
	liblzma.so.5 => /usr/lib/liblzma.so.5 (0x00007f567062a000)
	liblz4.so.1 => /usr/lib/liblz4.so.1 (0x00007f5670413000)
	libgcrypt.so.20 => /usr/lib/libgcrypt.so.20 (0x00007f56700f7000)
	libicudata.so.60 => /usr/lib/libicudata.so.60 (0x00007f566e54f000)
	libpcre.so.1 => /usr/lib/libpcre.so.1 (0x00007f566e2dc000)
	libgpg-error.so.0 => /usr/lib/libgpg-error.so.0 (0x00007f566e0c7000)

As I see it needs libmysqlclient.so.18 file and cannot find it. And I have mysql with version 5.7.21.
I think, I have to update my QT sql plugins. How can I do it?

archkdemax

Member

Registered: 2015-03-04

Posts: 4

Re: [SOLVED] Unable to start akonadi services

Reading on the net some suggest to do a downgrade of libmysqlclient, others to try to reinstall akanodi

Others make a symbolic link that also points to the version you're missing, but this option I do not know if it's valid

Scimmia

Fellow

Registered: 2012-09-01

Posts: 11,560

Re: [SOLVED] Unable to start akonadi services

Do NOT make symlinks.

Use lddtree from the pax-utils package, see what's actually linking to that version of the library, then rebuild it.

libmysqlclient.so.18 is part of mariadb, which is Arch's default mysql replacement. If you're using AUR packages to replace repo packages, this kind of thing is normal and something you have to be able to deal with.

Last edited by Scimmia (2018-02-20 17:40:35)

Xinevic

Member

From: Belarus, Minsk

Registered: 2015-12-28

Posts: 49

Re: [SOLVED] Unable to start akonadi services

Fixed by downgrading from mysql 5.7 to mysql 5.6

V1del

Forum Moderator

Registered: 2012-10-16

Posts: 21,740

Re: [SOLVED] Unable to start akonadi services

Please mark as [SOLVED] by editing your title.