Am Dienstag, 14. Juli 2015, 19:51:54 schrieb Martin Steigerwald: […] > With newest akonadi-backend-mysql package from unstable it is not possible > to replace mysql with mariadb. > > I have just switched and will test for a while. So far looks good. > > See: > > > Bug#746651: akonadi-backend-mysql: please make it possible to use with > MariaDB packages > https://bugs.debian.org/746651
So far so good, there are just one issue: It complains about missing fields and tables in mysql table and recommends to run mysql_upgrade script. This however is not inside mariadb-server-core but in mariadb-server: martin@merkaba:~> dpkg -L mariadb-server-core-10.0 | grep upgrade martin@merkaba:~> dpkg -L mariadb-server-10.0 | grep upgrade /usr/bin/mysql_upgrade /usr/share/man/man1/mysql_upgrade.1.gz /var/lib/mysql-upgrade Thus one has to install a full MariaDB server to do the upgrade. The upgrade then works as following: martin@merkaba:~/.local/share/akonadi> mysql_upgrade --defaults- file=mysql.conf --socket=/tmp/akonadi-martin.MekFVe/mysql.socket MySQL upgrade detected Phase 1/6: Checking and upgrading mysql database Processing databases mysql mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.servers OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Phase 2/6: Fixing views from mysql Phase 3/6: Running 'mysql_fix_privilege_tables' Phase 4/6: Fixing table and database names Phase 5/6: Checking and upgrading tables Processing databases akonadi akonadi.collectionattributetable OK akonadi.collectionmimetyperelation OK akonadi.collectionpimitemrelation OK akonadi.collectiontable OK akonadi.flagtable OK akonadi.mimetypetable OK akonadi.parttable OK akonadi.parttypetable OK akonadi.pimitemflagrelation OK akonadi.pimitemtable OK akonadi.pimitemtagrelation OK akonadi.resourcetable OK akonadi.schemaversiontable OK akonadi.tagattributetable OK akonadi.tagremoteidresourcerelationtable OK akonadi.tagtable OK akonadi.tagtypetable OK information_schema performance_schema Phase 6/6: Running 'FLUSH PRIVILEGES' OK Then all is nice :) I am not sure whether both options are needed, but just the --defaults-file option was not enough. I reported a bug about including mysql_upgrade script in core package: Bug#793977: mariadb-server-core-10.0: please include mysql_upgrade for application started mariadb server I think this process ideally would be automatically triggered by Akonadi, but well as AkonadiNext may replace it, it may not be worthwhile to still implement it, as it can be fixed manually and it didn´t seem to affect availability of the database to Akonadi. Ciao, -- Martin -- To UNSUBSCRIBE, email to debian-kde-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: https://lists.debian.org/3193162.FzYXBNJqgK@merkaba
