[Akonadi] [Bug 409224] kmail with >=mariadb-10.4.6: not able to refresh email list: Unable to append status flags

[Thomas Fischer]

https://bugs.kde.org/show_bug.cgi?id=409224

Thomas Fischer <fischer at unix-ag.uni-kl.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |fischer at unix-ag.uni-kl.de

--- Comment #10 from Thomas Fischer <fischer at unix-ag.uni-kl.de> ---
On Arch Linux and maybe other Linux distributions, the socket FSO
'mysql.socket' is not located in /tmp/akonadi-*/ but in
/run/user/*/akonadi/default/ instead.

Thus, the two commands to run become:
mysql -S /run/user/$(id -u)/akonadi/default/mysql.socket  -e 'create database
mysql' && mysql_upgrade -S /run/user/$(id -u)/akonadi/default/mysql.socket

At least for me, after running both commands KMail/Akonadi starts fetching and
listing mails again.

(In reply to Piotr from comment #7)
> Workaround wasn't working for me:
> 
> piorek at dreadnought ~ $ mysql_upgrade
> --socket=/tmp/akonadi-piorek.XXXXXX/mysql.socket
> Version check failed. Got the following error when calling the 'mysql'
> command line client
> ERROR 1049 (42000): Unknown database 'mysql'
> FATAL ERROR: Upgrade failed
> 
> Had to create DB mysql first (CREATE DATABASE mysql;). This fixed the
> problem and upgrade succeeded. Looks like KMail is working fine so far.

-- 
You are receiving this mail because:
You are the assignee for the bug.