Re: Akonadi Database maintenance

[Johannes Zarl-Zierl <johannes@zarl-zierl.at>]

Hi,

This doesn't work for me, either (tested on two sid machines):

$ mysql_upgrade --socket=~/.local/share/akonadi/socket-mani
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
FATAL ERROR: Upgrade failed


On Mittwoch, 16. August 2017 13:05:02 CEST Martin Steigerwald wrote:
> You are running mysql_upgrade as the user Akonadi is running in?

I can't talk for anxiousmac, but I do run it as the same user, within my 
desktop session.

> Is MySQL/MariaDB, well Akonadi, running? MySQL/MariaDB needs to run for the
> command to be able to contact it.

Mysql is running:
 3068 ?        Sl     0:12 /usr/sbin/mysqld --defaults-file=/home/zing/.local/
share/akonadi/mysql.conf --datadir=/home/zing/.local/share/akonadi/db_data/ --
socket=/tmp/akonadi-zing.F1xri4/mysql.socket

Using the socket file directly (instead of the symlink, as shown above) does 
not make a difference.
I also tried adding the "--defaults-file" option to mysql_upgrade, but that is 
not recognised (even though the man page says otherwise).

> What does mysql.err log say?

Nothing at all. I've got the startup messages and the obvious "Native table 
XYZ has the wrong structure" messages, but after the version/socket line there 
are no messages.

  Johannes