Re: [Kde-pim] Akonadi not starting / Installed with kAlarm

Daniel Vrátil <[email protected]> Tue, 12 Jul 2016 12:09:26 +0200
Newsgroups	gmane.comp.kde.users.pim
Organization	KDE
Message-ID	<2347502.N3v3vat39U@mjollnir>
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 [email protected] 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 | [email protected]
IRC: dvratil on Freenode (#kde, #kontact, #akonadi, #fedora-kde)

GPG Key: 0x4D69557AECB13683
Fingerprint: 0ABD FA55 A4E6 BEA9 9A83 EA97 4D69 557A ECB1 3683

_______________________________________________
KDE PIM users mailing list
Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users
signature.asc (application/pgp-signature, 819 B)