Bug 366400

Summary:	After upgrading PIM: Akonadi fails to start
Product:	[KDE Neon] neon	Reporter:	Bernhard Scheirle <bernhard+kde>
Component:	general	Assignee:	Neon Bugs <neon-bugs-null>
Status:	RESOLVED FIXED
Severity:	normal	CC:	jr, kde, lnxusr, neon-bugs-null, sitter, stefanprobst, subdiff
Priority:	NOR
Version First Reported In:	unspecified
Target Milestone:	---
Platform:	Neon
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:
Sentry Crash Report:
Attachments:	Upgrade log Start log

Description Bernhard Scheirle 2016-08-04 08:18:14 UTC

After upgrading the PIM Applications from the ubuntu packages to the kde neon user packages the akonadiserver fails to start

See the attached upgrade and start log.

Reproducible: Always

Steps to Reproduce:
1. Upgrade Packages
2. start akonadi: `akonadictl start`

Actual Results:  
Akonadi does not start

Expected Results:  
Akonadi starts

Comment 1 Bernhard Scheirle 2016-08-04 08:18:42 UTC

Created attachment 100445 [details]
Upgrade log

Comment 2 Bernhard Scheirle 2016-08-04 08:18:59 UTC

Created attachment 100446 [details]
Start log

Comment 3 Bernhard Scheirle 2016-08-04 08:44:49 UTC

To exclude errors from my old configuration I also tried `akonadictl --instance mynewcustominstance332 start`.

But I get the same result.
The start log is nearly the same (different database/config paths) and akonadi tries to initialize the database which also fails: 

mysqld: [ERROR] Could not open required defaults file: /etc/xdg/akonadi/mysql-global.conf
mysqld: [ERROR] Fatal error in defaults handling. Program aborted!

Comment 4 Roman Gilg 2016-08-04 11:37:59 UTC

This problem has been confirmed by several people on the Neon Telegram group including me. Here is my start log: https://paste.kde.org/pidq3mblw

Comment 5 Jonathan Riddell 2016-08-04 11:59:13 UTC

which flavour of neon?

Comment 6 Roman Gilg 2016-08-04 12:02:14 UTC

User edition

Comment 7 Jonathan Riddell 2016-08-04 12:19:40 UTC

Can you open /etc/xdg/akonadi/mysql-global.conf ?

Do you have /var/lib/mysql-files ?

Comment 8 Jonathan Riddell 2016-08-04 12:31:52 UTC

Please post output of   
dpkg --get-selections | grep mysql
I'm curious to see if you have the full mysql-server installed
Do you know if you intend to have the full server installed?

Comment 9 Roman Gilg 2016-08-04 12:46:18 UTC

/etc/xdg/akonadi/mysql-global.conf:
https://paste.kde.org/pqluaqtke

Creating directory /var/lib/mysql-files with 755 rights solves the problem.

Full mysql-server installed, not intended.

Comment 10 Bernhard Scheirle 2016-08-04 14:14:05 UTC

> Can you open /etc/xdg/akonadi/mysql-global.conf ?
Yes https://paste.kde.org/pbshldhur/j4tbuh

>  Do you have /var/lib/mysql-files ?
No

> Please post output of : dpkg --get-selections | grep mysql
akonadi-backend-mysql                           install
libmysqlclient-dev                              install
libmysqlclient20:amd64                          install
libmysqld-dev                                   install
libqt4-sql-mysql:amd64                          install
libqt5sql5-mysql:amd64                          install
mysql-client-core-5.7                           install
mysql-common                                    install
mysql-server-core-5.7                           install

> Creating directory /var/lib/mysql-files solves the problem.
I can confirm this

Comment 11 Jonathan Riddell 2016-10-19 13:04:33 UTC

*** Bug 366512 has been marked as a duplicate of this bug. ***

Comment 12 Jonathan Riddell 2016-10-19 13:05:11 UTC

added /var/lib/mysql-files to neon-settings

Comment 13 lnxusr 2016-10-19 17:38:37 UTC

Creating directory /var/lib/mysql-files solves this problem for me as well.  This is on a fresh install of 16.10.

Comment 14 Jonathan Riddell 2016-10-19 18:00:41 UTC

fixed in neon-settings