Bug 425228

Summary: Akonadi Server Fails to Start with MariaDB installed
Product: [Frameworks and Libraries] Akonadi Reporter: yo
Component: serverAssignee: kdepim bugs <kdepim-bugs>
Status: RESOLVED WORKSFORME    
Severity: crash CC: wbauer1
Priority: NOR    
Version: 5.14.3   
Target Milestone: ---   
Platform: Neon   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:

Description yo 2020-08-11 17:18:47 UTC
SUMMARY

Akonadi doesn't seem to be able to reset / restore  a new setup when MariaDB is used.


STEPS TO REPRODUCE
1. Have the MySQL setup installed.
2. Switch to MariaDB
3. Reset local Akonadi data directories.

OBSERVED RESULT

Crashes and prevents any PIM tool from being used.


EXPECTED RESULT

Starting up PIM to use email, calendar, etc


SOFTWARE/OS VERSIONS
Windows: 
macOS: 
Linux/KDE Plasma: 
(available in About System)
KDE Plasma Version: 
KDE Frameworks Version: 
Qt Version: 

ADDITIONAL INFORMATION

Here's some console output:
❯ akonadictl start
org.kde.pim.akonadictl: Starting Akonadi Server...
org.kde.pim.akonadictl:    done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
Installing MariaDB/MySQL system tables in '/home/deku/.local/share/akonadi/db_data/' ...
Could not open required defaults file: /etc/xdg/akonadi/mysql-global.conf
Fatal error in defaults handling. Program aborted

Installation of system tables failed!  Examine the logs in
/home/deku/.local/share/akonadi/db_data/ for more information.

The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:

    shell> /usr/bin/mysql_install_db --defaults-file=~/.my.cnf

You can also try to start the mysqld daemon with:

    shell> /usr/sbin/mysqld --skip-grant-tables --general-log &

and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/bin/mysql -u root mysql
    mysql> show tables;

Try 'mysqld --help' if you have problems with paths.  Using
--general-log gives you a log in /home/deku/.local/share/akonadi/db_data/ that may be helpful.

The latest information about mysql_install_db is available at
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
You can find the latest source at https://downloads.mariadb.org and
the maria-discuss email list at https://launchpad.net/~maria-discuss

Please check all of the above before submitting a bug report
at http://mariadb.org/jira
Comment 1 Wolfgang Bauer 2020-08-13 10:25:36 UTC
Looks like a packaging error, /etc/xdg/akonadi/mysql-global.conf seems to be missing/cannot be opened:
(In reply to yo from comment #0)
> Could not open required defaults file: /etc/xdg/akonadi/mysql-global.conf
> Fatal error in defaults handling. Program aborted

You probably should report this to your distribution.


If you are using KDE Neon, I suppose it's related to bug#411093...
Comment 2 Justin Zobel 2022-10-12 03:49:41 UTC
Thank you for reporting this crash in KDE software. As it has been a while since this issue was reported, can we please ask you to see if you can reproduce the crash with a recent software version?

If you can reproduce the issue, please change the status to "CONFIRMED" when replying. Thank you!
Comment 3 Bug Janitor Service 2022-10-27 05:04:39 UTC
Dear Bug Submitter,

This bug has been in NEEDSINFO status with no change for at least
15 days. Please provide the requested information as soon as
possible and set the bug status as REPORTED. Due to regular bug
tracker maintenance, if the bug is still in NEEDSINFO status with
no change in 30 days the bug will be closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

If you have already provided the requested information, please
mark the bug as REPORTED so that the KDE team knows that the bug is
ready to be confirmed.

Thank you for helping us make KDE software even better for everyone!
Comment 4 Bug Janitor Service 2022-11-11 05:21:17 UTC
This bug has been in NEEDSINFO status with no change for at least
30 days. The bug is now closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

Thank you for helping us make KDE software even better for everyone!