| Summary: | Table 'mysql.servers' doesn't exist | ||
|---|---|---|---|
| Product: | [Frameworks and Libraries] Akonadi | Reporter: | Nick Shaforostoff <shafff> |
| Component: | server | Assignee: | Volker Krause <vkrause> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | bugs, christopherheiny, gokcen.eraslan, Heinrich20, kde, l.prugger, null, rdieter, romainguinot, sitter |
| Priority: | NOR | ||
| Version: | 4.2 | ||
| Target Milestone: | --- | ||
| Platform: | Debian testing | ||
| OS: | Unspecified | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
|
Description
Nick Shaforostoff
2009-02-24 00:08:04 UTC
Have just solved that one out : You need to run /usr/bin/mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data It will install the mysql database which is missing in the instance that akonadi uses. This probably should be run by Akonadi's first run script in the sources this is done in ./server/src/storage/akonadi-mysql-server.sh but it seems that this file isn't installed i don't like the increased complexity. i could live with sqlite on a netbook, but until then i apt-get purge kontact. maybe it should be executed in bool Akonadi::DataStore::init() from server/src/storage/datastore.cpp *** Bug 218204 has been marked as a duplicate of this bug. *** *** Bug 178157 has been marked as a duplicate of this bug. *** Kubuntu bug report: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/448705 SVN commit 1105780 by vkrause: Some MySQL versions need an explicit run of mysql_install_db when creating the database initially. So, let's do that if mysql_install_db is found. BUG: 185395 M +9 -0 dbconfigmysql.cpp M +1 -0 dbconfigmysql.h WebSVN link: http://websvn.kde.org/?view=rev&revision=1105780 SVN commit 1111602 by nlecureuil: Backport commit 1105780 Use mysql_upgrade to fix creation of some tables when the db already exist BUG:185395 M +16 -0 akonadi.cpp M +12 -0 storage/dbconfig.cpp WebSVN link: http://websvn.kde.org/?view=rev&revision=1111602 SVN commit 1111609 by nlecureuil: Add forgotten file in previous commit BUG:185395 M +6 -0 dbconfig.h WebSVN link: http://websvn.kde.org/?view=rev&revision=1111609 SVN commit 1111611 by nlecureuil: Forward port of commit 1105780 Change mysql_install_db by using --force and give it a default conf file to use BUG:185395 M +9 -2 dbconfigmysql.cpp M +1 -0 dbconfigmysql.h WebSVN link: http://websvn.kde.org/?view=rev&revision=1111611 *** Bug 232702 has been marked as a duplicate of this bug. *** When I try to start akonadi via 'akonadictl restart command', I'm getting "[akonadiserver] FATAL ERROR: Upgrade failed" error. I can easily reproduce the error with the command below: mysql_upgrade --socket=/home/hede/.local/share/akonadi/db_misc/mysql.socket Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' '--socket=/home/gokcen/.local/share/akonadi/db_misc/mysql.socket' Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' '--socket=/home/gokcen/.local/share/akonadi/db_misc/mysql.socket' akonadi.collectionattributetable OK akonadi.collectionmimetyperelation OK akonadi.collectionpimitemrelation OK akonadi.collectiontable OK akonadi.flagtable OK akonadi.mimetypetable OK akonadi.parttable OK akonadi.pimitemflagrelation OK akonadi.pimitemtable OK akonadi.resourcetable OK akonadi.schemaversiontable OK Running 'mysql_fix_privilege_tables'... ERROR 1049 (42000): Unknown database 'mysql' FATAL ERROR: Upgrade failed "mysql_fix_privilege_tables" command fails to execute since there is no DB named 'mysql' in Akonadi. Is this normal or a distro specific issue? (I'm using MySQL 5.1.41 / Akonadi 1.3 branch from kdesupport / KDE 4.4) The problem is in this commit[1], /etc/akonadi/mysql-global.conf path is hardcoded, but this can be changed during build time using -DCONFIG_INSTALL_DIR=/foo. XdgBaseDirs::findResourceFile( "config", QLatin1String( "akonadi/mysql-global.conf" )) should be used instead. Can you fix this? PS: Also in server/src/storage/akonadi-mysql-server.sh file, there is a line "globalconfig=$KDEDIR/share/akonadi/mysql-global.conf". You may be change this also. [1] http://websvn.kde.org/?revision=1111602&view=revision was planned. i do it now SVN commit 1112923 by nlecureuil: Fix hardcoded conf file tks to : Gokcen Erasla CCBUG:185395 CCMAIL:gokcen@pardus.org.tr M +2 -1 akonadi.cpp WebSVN link: http://websvn.kde.org/?view=rev&revision=1112923 SVN commit 1112925 by nlecureuil: Forward port commit 1112923 CCBUG:185395 M +2 -1 dbconfigmysql.cpp WebSVN link: http://websvn.kde.org/?view=rev&revision=1112925 *** Bug 240695 has been marked as a duplicate of this bug. *** |