package crash while installing mariadb

**fulltilt** · Apr 30th 2014

just tried replace mysql 5.1 with mariadb 5.5 but the re-configuration fails with package errors
re-installed mysql but it seems that apache is not working or fcgid has been changed to fastcgi
also mail is not working:

I tried to upgrade to 1.1.5 but getting this:
iMSCP::Requirements::_programVersions: Unable to find PHP version: No output
iMSCP::Execute::getExitCode: External command died with signal 11, without coredump

main::setupAskServerIps: Unable to retrieve server IPs: Error while executing
query: Unknown table engine 'InnoDB'
iMSCP::Debug::END: Exit code: 1

Code

authdaemond: failed to connect to mysql server (server=localhost, userid=admin): Access denied for user 'admin'@'localhost' (using password: YES)
The following NEW packages will be installed:
courier-authlib-mysql libdbd-mysql-perl libmysqlclient16 mysql-client-5.1
mysql-common mysql-server-5.1 mysql-server-core-5.1 php5-mysql
proftpd-mod-mysql
Configuration file `/etc/mysql/my.cnf', does not exist on system.
Installing new config file as you requested.
Selecting previously deselected package mysql-server-5.1.
(Reading database ... 80218 files and directories currently installed.)
Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.73-1_amd64.deb) ...
Aborting downgrade from (at least) 5.5 to 5.1.
If are sure you want to downgrade to 5.1, remove the file
/var/lib/mysql/debian-*.flag and try installing again.
dpkg: error processing
/var/cache/apt/archives/mysql-server-5.1_5.1.73-1_amd64.deb (--unpack):
subprocess new pre-installation script returned error exit status 1
configured to not write apport reports
Selecting previously deselected package courier-authlib-mysql.
Unpacking courier-authlib-mysql (from
.../courier-authlib-mysql_0.63.0-3_amd64.deb) ...
Selecting previously deselected package php5-mysql.
Unpacking php5-mysql (from .../php5-mysql_5.3.3-7+squeeze19_amd64.deb) ...
Selecting previously deselected package proftpd-mod-mysql.
Unpacking proftpd-mod-mysql (from
.../proftpd-mod-mysql_1.3.3a-6squeeze7_amd64.deb) ...
Errors were encountered while processing:
/var/cache/apt/archives/mysql-server-5.1_5.1.73-1_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
iMSCP::Debug::END: Exit code: 100

Display More

**fulltilt** · Apr 30th 2014

got it back to mysql 5.1 and imscp 1.1.2
not sure if an upgrade will work for now, is it possible testing an upgrade w/o changing files - dry run?

--- edit ---
If I click the user button in CP it get this error msg. is this because of the failed 1.1.5 update?

Code

SQLSTATE[HY093]: Invalid parameter number: no parameters were bound
Query was:
SELECT `admin_name`, `admin_status` FROM `admin` WHERE `admin_id` = ?

**fulltilt** · Apr 30th 2014

OK, could be solved by importing complete imscp sql backup ...
but for the upgrade, is it possible testing an upgrade w/o changing files as a dry run?

Smallserver · Apr 30th 2014

Why not test it in a vm?

**fulltilt** · May 1st 2014

I'm not quite sure about the reason for the crash ... could be a package or configuration problem
I had already tested migration to mariadb in a Vbox with same database and it worked well, maybe the special my.cnf from mysql is not compatible with mariadb ...
But I guess it would be a good idea to test in a VM with same packages and config files.

package crash while installing mariadb

Share

Daily visitors