[Koha-bugs] [Bug 13669] Webinstaller fails on MySQL 5.6

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669

--- Comment #3 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
Ha, I should mention: It tooks me a while to reinstall mariadb-server:

% sudo apt-get install mariadb-server

The following extra packages will be installed:
  mariadb-server-10.0 mariadb-server-core-10.0
Suggested packages:
  mariadb-test tinyca
The following packages will be REMOVED:
  mysql-community-server
The following NEW packages will be installed:
  mariadb-server mariadb-server-10.0 mariadb-server-core-10.0

Preconfiguring packages ...
dpkg: mysql-community-server: dependency problems, but removing anyway as you
requested:
 koha-deps depends on mysql-server | virtual-mysql-server; however:
  Package mysql-server is not installed.
  Package virtual-mysql-server is not installed.
  Package mysql-community-server which provides virtual-mysql-server is to be
removed.
  Package mysql-server-5.5 which provides virtual-mysql-server is not
installed.
  Package mariadb-server-10.0 which provides virtual-mysql-server is not
installed.

(Reading database ... 66642 files and directories currently installed.)
Removing mysql-community-server (5.6.25-2debian8) ...
......
[info] MySQL Community Server 5.6.25 is stopped.
Processing triggers for man-db (2.6.7.1-1) ...
Selecting previously unselected package mariadb-server-10.0.
(Reading database ... 66539 files and directories currently installed.)
Preparing to unpack .../mariadb-server-10.0_10.0.19-1_i386.deb ...
/etc/init.d/mysql: line 38: mysqld: command not found
[info] MySQL Community Server  is already stopped.
Unpacking mariadb-server-10.0 (10.0.19-1) ...
dpkg: error processing archive
/var/cache/apt/archives/mariadb-server-10.0_10.0.19-1_i386.deb (--unpack):
 trying to overwrite '/usr/share/mysql/errmsg-utf8.txt', which is also in
package mysql-common 5.6.25-2debian8
dpkg-deb: error: subprocess paste was killed by signal (Broken pipe)
Selecting previously unselected package mariadb-server-core-10.0.
Preparing to unpack .../mariadb-server-core-10.0_10.0.19-1_i386.deb ...
Unpacking mariadb-server-core-10.0 (10.0.19-1) ...
dpkg: error processing archive
/var/cache/apt/archives/mariadb-server-core-10.0_10.0.19-1_i386.deb (--unpack):
 trying to overwrite '/usr/share/mysql/hungarian/errmsg.sys', which is also in
package mysql-common 5.6.25-2debian8
dpkg-deb: error: subprocess paste was killed by signal (Broken pipe)


% sudo apt-get remove mysql-server-5.6
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Note, selecting 'mysql-community-server' instead of 'mysql-server-5.6'
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 koha-deps : Depends: mysql-server but it is not going to be installed or
                      virtual-mysql-server
 mariadb-server : Depends: mariadb-server-10.0 (>= 10.0.19-1) but it is not
going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a
solution).

% sudo apt-get -f install
dpkg: error processing archive
/var/cache/apt/archives/mariadb-server-core-10.0_10.0.19-1_i386.deb (--unpack):
 trying to overwrite '/usr/share/mysql/hungarian/errmsg.sys', which is also in
package mysql-common 5.6.25-2debian8
dpkg-deb: error: subprocess paste was killed by signal (Broken pipe)
Preparing to unpack .../mariadb-server-10.0_10.0.19-1_i386.deb ...
/etc/init.d/mysql: line 38: mysqld: command not found
[info] MySQL Community Server  is already stopped.
Unpacking mariadb-server-10.0 (10.0.19-1) ...
dpkg: error processing archive
/var/cache/apt/archives/mariadb-server-10.0_10.0.19-1_i386.deb (--unpack):
 trying to overwrite '/usr/share/mysql/errmsg-utf8.txt', which is also in
package mysql-common 5.6.25-2debian8
dpkg-deb: error: subprocess paste was killed by signal (Broken pipe)
Processing triggers for man-db (2.6.7.1-1) ...
Errors were encountered while processing:
 /var/cache/apt/archives/mariadb-server-core-10.0_10.0.19-1_i386.deb
 /var/cache/apt/archives/mariadb-server-10.0_10.0.19-1_i386.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

Commenting /etc/apt/sources.list/mysql.list

% sudo apt-get update

% sudo apt-get -f install
If are sure you want to downgrade to 5.5, remove the file
/var/lib/mysql/debian-*.flag and try installing again.
dpkg: error processing archive
/var/cache/apt/archives/mysql-server-5.5_5.5.43-0+deb8u1_i386.deb (--unpack):
 subprocess new pre-installation script returned error exit status 1

% sudo rm /var/lib/mysql/debian-10.0.flag

% sudo apt-get -f install 
[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . failed!

# I'm getting angry
% sudo apt-get purge mysql-server mysql-client mysql-common mysql-client-5.5
mysql-server-5.5

% sudo apt-get install mariadb-server mariadb-client

[ ok ] Starting MariaDB database server: mysqld.


\o/

-- 
You are receiving this mail because:
You are watching all bug changes.