[kdepim-users] [Kde-pim] Akonadi not starting / Installed with kAlarm
Daniel Vrátil
dvratil at kde.org
Tue Jul 12 11:09:26 BST 2016
On Tuesday, July 12, 2016 10:52:51 AM CEST Hessler, Klaus-Michael wrote:
> Hello Martin,
>
> thanks for reading and your advice. I've been on irc #akonadi first and
> found kde-pim at kde.org there; not even recognized that this is a mailing
> list. Sorry for that. Now I've found your reply in the internet and
> subscribed to the kdepim-users list.
>
> > > I had my very first contact with Akonadi when I installed kAlarm from
> > > the repository (kUBUNTU 16.04). There I got an error 'Akonadi service
> > > not running', the kAlarm-Menu greyed (not accessible). Pressing the
> > > button 'Start' runs into another error 'Akonadi service not running
> > > correctly', I got this message in German language here.
> > >
> > > I do not use any Akonadi-application (as far as I know), but I have a
> > > mySQL-server and -client running with several databases. The
> > > mySQL-server has been moved to a different harddisk.
> >
> > KAlarm is an Akonadi based application.
> >
> > > What can I do to solve that issue? Any help very appreciated.
> >
> > No idea, I think it offers you a way to see the error / self-test log of
> > Akonadi. Without that log I cannot say anymore more. You can also find it
> > below ~/.local/share/akonadi.
>
> Here some information from my system about akonadi and mySQL:
>
> File ~/.local/share/akonadi/akonadiserver.error:
> > "\nSql error: Table 'akonadi.SchemaVersionTable' doesn't exist QMYSQL:
> > Unable to execute query\nQuery: ALTER TABLE SchemaVersionTable ADD
> > COLUMN version INTEGER NOT NULL DEFAULT 0"
> > Unable to initialize database.
<snip>
>
> Bash $ akonadictl start:
> > Starting Akonadi Server...
> >
> > done.
> >
> > $ Connecting to deprecated signal
> > QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
> > search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin",
> > "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/local/games",
> > "/snap/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec",
> > "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin",
> > "/opt/mysql/sbin")
> > Found mysql_install_db: "/usr/bin/mysql_install_db"
> > Found mysqlcheck: "/usr/bin/mysqlcheck"
> > 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.relationtable OK
> > akonadi.relationtypetable OK
> > akonadi.resourcetable OK
> > akonadi.schemaversiontable OK
> > akonadi.tagattributetable OK
> > akonadi.tagremoteidresourcerelationtable OK
> > akonadi.tagtable OK
> > akonadi.tagtypetable OK
> > mysql.columns_priv OK
> > mysql.db OK
> > mysql.event OK
> > mysql.func OK
> > mysql.general_log OK
> > mysql.help_category OK
> > mysql.help_keyword OK
> > mysql.help_relation OK
> > mysql.help_topic OK
> > mysql.innodb_index_stats OK
> > mysql.innodb_table_stats OK
> > mysql.ndb_binlog_index OK
> > mysql.plugin OK
> > mysql.proc OK
> > mysql.procs_priv OK
> > mysql.proxies_priv OK
> > mysql.servers OK
> > mysql.slave_master_info OK
> > mysql.slave_relay_log_info OK
> > mysql.slave_worker_info OK
> > mysql.slow_log 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
> > MySQL version OK (required "5.1" , available "5.7" )
> > Database "akonadi" opened using driver "QMYSQL"
> > DbInitializer::run()
> > checking table "SchemaVersionTable"
> > "ALTER TABLE SchemaVersionTable ADD COLUMN version INTEGER NOT NULL
> > DEFAULT 0"
> > "\nSql error: Table 'akonadi.SchemaVersionTable' doesn't exist QMYSQL:
> > Unable to execute query\nQuery: ALTER TABLE SchemaVersionTable ADD
> > COLUMN version INTEGER NOT NULL DEFAULT 0"
> > Unable to initialize database.
> > terminating service threads
> > terminating connection threads
> > stopping db process
> > mysqladmin: query failed; error: 'Table
> > 'performance_schema.session_variables' doesn't exist'
> > Application 'akonadiserver' exited normally...
>
<snip>
> Bash $ sudo service mysql status:
> > ● mysql.service - MySQL Community Server
> >
> > Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor
> >
> > preset: enabled)
> >
> > Active: active (running) since Do 2016-07-07 16:17:00 CEST; 26min ago
> >
> > Process: 915 ExecStartPost=/usr/share/mysql/mysql-systemd-start post
> >
> > (code=exited, status=0/SUCCESS)
> >
> > Process: 902 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre
> >
> > (code=exited, status=0/SUCCESS)
> >
> > Main PID: 910 (mysqld)
> >
> > CGroup: /system.slice/mysql.service
> >
> > └─910 /usr/sbin/mysqld
> >
> > Jul 07 16:16:59 IBM-X240 systemd[1]: Starting MySQL Community Server...
> > Jul 07 16:17:00 IBM-X240 systemd[1]: Started MySQL Community Server.
Akonadi runs its own MySQL database unless you configure it to use the system
one.
The errors above look very much like a problem in case-sensitive matching.What
version of MySQL (or MariaDB?) do you have?
You could try adding
lower_case_table_names = 1
to ~/.config/akonadi/mysql-local.conf
which should hopefully force case-insensitive matching.
Dan
>
> mySQL-console:
> > mysql> show variables like 'performance_schema';
> > +--------------------+-------+
> >
> > | Variable_name | Value |
> >
> > +--------------------+-------+
> >
> > | performance_schema | ON |
> >
> > +--------------------+-------+
>
> Thank you and best regards
> Michael
> _______________________________________________
> KDE PIM users mailing list
> Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users
--
Daniel Vrátil
www.dvratil.cz | dvratil at kde.org
IRC: dvratil on Freenode (#kde, #kontact, #akonadi, #fedora-kde)
GPG Key: 0x4D69557AECB13683
Fingerprint: 0ABD FA55 A4E6 BEA9 9A83 EA97 4D69 557A ECB1 3683
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kdepim-users/attachments/20160712/66d6fc38/attachment.sig>
More information about the kdepim-users
mailing list