Bug#844535: akonadi: akonadiserver fails to start for normal users without mysql-server-5.5 installed
Control: reassign -1 mysql-5.5 5.5.53-0+deb8u1 Control: retitle -1 mysql-server-core-5.5 should install mysql-files 2016-11-16 22:00 GMT+01:00 Maximiliano Curia : > ¡Hola Bálint! > > El 2016-11-16 a las 19:58 +0100, Bálint Réczey escribió: >>> >>> Do you have the updated conffile? > > >> It seem so: >> vagrant@vagrant:~$ grep secure -A1 -B1 /etc/akonadi/mysql-global.conf # >> Unset the export dir check as only the full mysql-server package creates it >> secure_file_priv= > > > Ok, this file is then used to update the ~/.local/share/akonadi/mysql.conf > file. Does this file has the secure_file_priv= line in it? No, but removing it made akonadi update it and now akonadi works. > >> Do you have /var/lib/mysql-files on you fixed system? > > > No, I don't have that directory. I think the package shipping mysqld should create it since mysqld expects it to exist. Reassigning to mysql to see if maintainer agrees. Thanks for the help in triaging! Cheers, Balint
Processed: Re: Bug#844535: akonadi: akonadiserver fails to start for normal users without mysql-server-5.5 installed
Processing control commands: > reassign -1 mysql-5.5 5.5.53-0+deb8u1 Bug #844535 [akonadi-server] akonadi: akonadiserver fails to start for normal users without mysql-server-5.5 installed Bug reassigned from package 'akonadi-server' to 'mysql-5.5'. No longer marked as found in versions akonadi/1.13.0-2+deb8u2. Ignoring request to alter fixed versions of bug #844535 to the same values previously set Bug #844535 [mysql-5.5] akonadi: akonadiserver fails to start for normal users without mysql-server-5.5 installed There is no source info for the package 'mysql-5.5' at version '5.5.53-0+deb8u1' with architecture '' Unable to make a source version for version '5.5.53-0+deb8u1' Marked as found in versions 5.5.53-0+deb8u1. > retitle -1 mysql-server-core-5.5 should install mysql-files Bug #844535 [mysql-5.5] akonadi: akonadiserver fails to start for normal users without mysql-server-5.5 installed Changed Bug title to 'mysql-server-core-5.5 should install mysql-files' from 'akonadi: akonadiserver fails to start for normal users without mysql-server-5.5 installed'. -- 844535: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=844535 Debian Bug Tracking System Contact ow...@bugs.debian.org with problems
Bug#844535: akonadi: akonadiserver fails to start for normal users without mysql-server-5.5 installed
Hi Maximiliano, 2016-11-16 18:46 GMT+01:00 Maximiliano Curia : > ¡Hola Bálint! > > El 2016-11-16 a las 17:55 +0100, Bálint Réczey escribió: >> >> Mysql-server-core-5.5 5.5.53-0+deb8u1 broke akonadi for root user: >> #843534. Akonadi got updated, but now it expects /var/lib/mysql-files to be >> present on the system: > > > The directory /var/lib/mysql-files is the default value of the configuration > option "secure_file_priv" (of the section mysqld), the only change in > akonadi 1.13.0-2+deb8u2 is to set: > secure_file_priv= > in the global akonadi configuration for the mysql backend > (/etc/akonadi/mysql-global.conf) this is in the akonadi-backend-mysql > package. > > Was your akonadi-backend-mysql updated? Yes: vagrant@vagrant:~$ dpkg -l akonadi-backend-mysql Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad) ||/ Name Version Architecture Description +++--===-===-= ii akonadi-backend-mysql1.13.0-2+deb8u2 all MySQL storage backend for Akonadi > > Do you have the updated conffile? It seem so: vagrant@vagrant:~$ grep secure -A1 -B1 /etc/akonadi/mysql-global.conf # Unset the export dir check as only the full mysql-server package creates it secure_file_priv= Do you have /var/lib/mysql-files on you fixed system? Cheers, Balint
Bug#844535: akonadi: akonadiserver fails to start for normal users without mysql-server-5.5 installed
¡Hola Bálint! El 2016-11-16 a las 17:55 +0100, Bálint Réczey escribió: Mysql-server-core-5.5 5.5.53-0+deb8u1 broke akonadi for root user: #843534. Akonadi got updated, but now it expects /var/lib/mysql-files to be present on the system: The directory /var/lib/mysql-files is the default value of the configuration option "secure_file_priv" (of the section mysqld), the only change in akonadi 1.13.0-2+deb8u2 is to set: secure_file_priv= in the global akonadi configuration for the mysql backend (/etc/akonadi/mysql-global.conf) this is in the akonadi-backend-mysql package. Was your akonadi-backend-mysql updated? Do you have the updated conffile? Happy hacking, -- "Some people worry that artificial intelligence will make us feel inferior, but then, anybody in his right mind should have an inferiority complex every time he looks at a flower." -- Alan Kay Saludos /\/\ /\ >< `/ signature.asc Description: PGP signature
Bug#844535: akonadi: akonadiserver fails to start for normal users without mysql-server-5.5 installed
Package: akonadi-server Version: 1.13.0-2+deb8u2 Severity: important Dear akonadi Maintainers, Mysql-server-core-5.5 5.5.53-0+deb8u1 broke akonadi for root user: #843534. Akonadi got updated, but now it expects /var/lib/mysql-files to be present on the system: ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) search paths: ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/games", "/usr/games", "/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" Database process exited unexpectedly during initial connection! executable: "/usr/sbin/mysqld" arguments: ("--defaults-file=/home/vagrant/.local/share/akonadi/mysql.conf", "--datadir=/home/vagrant/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-vagrant.9LSx7K/mysql.socket") stdout: "" stderr: "/usr/sbin/mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2) 161116 10:36:33 [ERROR] Failed to access directory for --secure-file-priv. Please make sure that directory exists and is accessible by MySQL Server. Supplied value : /var/lib/mysql-files 161116 10:36:33 [ERROR] Aborting This directory is created in mysql-server-5.5's postinst script in 5.5.53-0+deb8u1. I suggest fixing this issue in two steps: 1. Creating the directory in mysql-server-core-5.5's postinst in 5.5.53-0+deb8u2 2. Depending on mysql-server-core-5.5 (>= 5.5.53-0+deb8u2) in akonadi 1.13.0-2+deb8u3 If you agree with the suggested solution please clone the bug to mysql-5.5 to let step 1. start. Cheers, Balint PS: /var/lib/mysql-files is left on the system after mysqld-server-5.5 is removed which may be a problem to solve in the mysql fix.