[Bug 13669] New: Webinstaller fails on MySQL 5.6
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 Bug ID: 13669 Summary: Webinstaller fails on MySQL 5.6 Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs@lists.koha-community.org Reporter: tomascohen@gmail.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com Due to a change in MySQL 5.6 [1] the web installer fails to load the kohastructure.sql and the chosen sample data files. This is because C4::Installer::load_sql relies on a command line call to the mysql binary, which from now on doesn't support passing the user password as parameter on the command line, YAY! [1] http://dev.mysql.com/doc/refman/5.6/en/upgrading-from-previous-series.html -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |tomascohen@gmail.com |ity.org | -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org --- Comment #1 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Tomás, I have installed MySQL server 5.6 (Server version: 5.6.25 MySQL Community Server (GPL)) and it seems to work, could you confirm? I have followed http://www.debiantutorials.com/install-mysql-server-5-6-debian-7-8/ and then install Koha, select all the sample data files and all is inserted :) -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 --- Comment #2 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Whaou, crazy last hour. So I decided to keep this version, just to test. And... at least 2 things are broken (I stopped the experience quickly): 1/ prove t/db_dependent/Acquisition.t t/db_dependent/Acquisition.t .. 1/87 DBD::mysql::st execute failed: Data too long for column 'budget_code' at row 1 at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1832. Because aqbudgets.budget_code is varchar(30) and the test try to insert a 31 string chars: budget_code_test_getordersbybib 2/ On creating an order, Software error: addorder.pl: DBIx::Class::Storage::DBI::_dbh_execute(): Field 'budgetgroup_id' doesn't have a default value at /home/koha/src/Koha/Acquisition/Order.pm line 47 And yes it does not have a default value. Conclusion: We are not ready at all for MySQL 5.6 -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 --- Comment #3 from Jonathan Druart <jonathan.druart@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.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 --- Comment #4 from Tomás Cohen Arazi <tomascohen@gmail.com> ---
% sudo apt-get install mariadb-server mariadb-client
[ ok ] Starting MariaDB database server: mysqld.
\o/
Weeeeee -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |http://bugs.koha-community. | |org/bugzilla3/show_bug.cgi? | |id=14637 -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |http://bugs.koha-community. | |org/bugzilla3/show_bug.cgi? | |id=14952 -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org