[Akonadi] [Bug 425228] New: Akonadi Server Fails to Start with MariaDB installed

[bugzilla_noreply at kde.org]

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

            Bug ID: 425228
           Summary: Akonadi Server Fails to Start with MariaDB installed
           Product: Akonadi
           Version: 5.14.3
          Platform: Neon Packages
                OS: Linux
            Status: REPORTED
          Severity: crash
          Priority: NOR
         Component: server
          Assignee: kdepim-bugs at kde.org
          Reporter: yo at jacky.wtf
  Target Milestone: ---

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

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