[SOLVED] akonadi mysql mariadb kmail korganizer trouble on current and with kde4 and kde5

mrapathy · 10-21-2017, 09:44 PM

Hello. I am running slackware current with alien bobs kde5 and akonadi does not seem to want to work.

running akonadictl start I get this.

Code:

bash-4.4$ akonadictl start
QStandardPaths: XDG_RUNTIME_DIR not set, defaulting to '/tmp/runtime-kmfdm'
QStandardPaths: XDG_RUNTIME_DIR not set, defaulting to '/tmp/runtime-kmfdm'
QStandardPaths: XDG_RUNTIME_DIR not set, defaulting to '/tmp/runtime-kmfdm'
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
bash-4.4$ QStandardPaths: XDG_RUNTIME_DIR not set, defaulting to '/tmp/runtime-kmfdm'
org.kde.pim.akonadiserver: database server stopped unexpectedly
org.kde.pim.akonadiserver: Database process exited unexpectedly during initial connection!
org.kde.pim.akonadiserver: executable: "/usr/libexec/mysqld"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/kmfdm/.local/share/akonadi/mysql.conf", "--datadir=/home/kmfdm/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-kmfdm.Povp3U/mysql.socket", "--pid-file=/tmp/akonadi-kmfdm.Povp3U/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: "2017-10-21 21:39:33 140631930431296 [Note] /usr/libexec/mysqld (mysqld 10.2.9-MariaDB) starting as process 8385 ...\n"
org.kde.pim.akonadiserver: exit code: 7
org.kde.pim.akonadiserver: process error: "Unknown error"
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/akonadi-kmfdm.Povp3U/mysql.socket' (2)'
Check that mysqld is running and that the socket: '/tmp/akonadi-kmfdm.Povp3U/mysql.socket' exists!
org.kde.pim.akonadiserver: Failed to remove runtime connection config file
org.kde.pim.akonadicontrol: Application 'akonadiserver' exited normally...

running kmail it tries to start akonadi but fails.

MySQL server log errors

Code:

2017-10-21 21:46:39 140080982271808 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-10-21 21:46:39 140080982271808 [Note] InnoDB: Uses event mutexes
2017-10-21 21:46:39 140080982271808 [Note] InnoDB: Compressed tables use zlib 1.2.11
2017-10-21 21:46:39 140080982271808 [Note] InnoDB: Using Linux native AIO
2017-10-21 21:46:39 140080982271808 [Note] InnoDB: Number of pools: 1
2017-10-21 21:46:39 140080982271808 [Note] InnoDB: Using SSE2 crc32 instructions
2017-10-21 21:46:39 140080982271808 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M
2017-10-21 21:46:39 140080982271808 [Note] InnoDB: Completed initialization of buffer pool
2017-10-21 21:46:39 140080674993920 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-10-21 21:46:39 140080982271808 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-21 21:46:39 140080982271808 [Note] InnoDB: 128 out of 128 rollback segments are active.
2017-10-21 21:46:39 140080982271808 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-10-21 21:46:39 140080982271808 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-10-21 21:46:39 140080982271808 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-10-21 21:46:39 140080982271808 [Note] InnoDB: Waiting for purge to start
2017-10-21 21:46:39 140080982271808 [Note] InnoDB: 5.7.19 started; log sequence number 16334348
2017-10-21 21:46:39 140080509327104 [Note] InnoDB: Loading buffer pool(s) from /home/kmfdm/.local/share/akonadi/db_data/ib_buffer_pool
2017-10-21 21:46:39 140080509327104 [Note] InnoDB: Buffer pool(s) load completed at 171021 21:46:39
2017-10-21 21:46:39 140080982271808 [Note] Plugin 'FEEDBACK' is disabled.
2017-10-21 21:46:39 140080982271808 [ERROR] /usr/libexec/mysqld: unknown variable 'innodb_additional_mem_pool_size=1M'
2017-10-21 21:46:39 140080982271808 [ERROR] Aborting

attached pic has some info

appreciate any help. saw another thread with similar problem but fix was not clearly suggested though thread was labeled solved unreasonably

Richard Cranium · 10-21-2017, 10:00 PM

See https://dev.mysql.com/doc/refman/5.7...arameters.html and look for innodb_additional_mem_pool_size.

In short, it's been removed on your version of mysqld.

mrapathy · 10-22-2017, 06:30 PM

okay, how do I fix it?

I dont have mysql installed just mariadb which from as I understand is supposed to be a perfect replacement.

ppr:kut · 10-23-2017, 12:59 AM

How did you upgrade? What versions do you have installed? Did you relogin since updating?

The latest akonadi package should fix that on its own

Richard Cranium · 10-23-2017, 01:37 AM

Quote:

Originally Posted by mrapathy

okay, how do I fix it?

I dont have mysql installed just mariadb which from as I understand is supposed to be a perfect replacement.

Does this look familiar? It was in your first post.

Code:

org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/kmfdm/.local/share/akonadi/mysql.conf", "--datadir=/home/kmfdm/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-kmfdm.Povp3U/mysql.socket", "--pid-file=/tmp/akonadi-kmfdm.Povp3U/mysql.pid")

If you look inside the highlighted file, you'll probably find some lines like...

Code:

# memory pool InnoDB uses to store data dictionary information and other internal data structures (default:1M)
innodb_additional_mem_pool_size=1M

Delete them or comment out the innodb_additional_mem_pool_size line.

mrapathy · 10-23-2017, 01:54 PM

thanks marking thread solved.

though one minor problem I cant open kmail from icon or menu but just pop open a bash console type kmail and it works. korganizer is working from menu havent tried desktop icon.

mrapathy · 10-23-2017, 01:55 PM

Quote:

Originally Posted by ppr:kut

How did you upgrade? What versions do you have installed? Did you relogin since updating?

The latest akonadi package should fix that on its own

upgraded using slackpkg to current then got alien bobs rsync kde5. not sure I did it properly.

Richard Cranium · 10-23-2017, 03:30 PM

OT: Just noticed the band reference in the user name on your box.

More on topic, you should be able to tell KDE to run the launch command in a terminal. I don't use KDE, so I can't directly help you with that, but there should be a property of the launcher that states "run in terminal" or similar.

allend · 10-28-2017, 08:43 AM

FWIW - I just hit this on a fresh install of Slackware64-14.2 from an official DVD that was then upgraded to -current using slackpkg. I commented out the deprecated line 'innodb_additional_mem_pool_size=1M' in ~/.local/share/akonadi/mysql.conf and then needed to delete the akonadiserver.error files in the same directory to get Korganizer to start.