MySQL zerschossen bei Upgrade von 1.3.7 auf 1.4.3

**root666** · Jun 2nd 2017

Hallo,

eigentlich wollte ich meinem Home-Server nur mal eine neue Version von i-mscp gönnen. Leider kam es zu Fehlern.

Beim Updateprozess konnte er nicht mit dem eingegeben Passwort zu MySQL connecten. Also habe ich es manuell über die Konsole mit "mysql -u root -p" versucht. Auch hier kein Erfolg. Vielleicht hatte ich ja mein Passwort falsch notiert. Also hab ich es neu gesetzt aber auch danach konnte ich nicht connecten. Also MySQL entfernt und neu installiert (BACKUP von /etc/mysql und /var/lib/mysql vorhanden).
Leider auch damit kein Erfolg außer das sich der Dienst gar nicht mehr starten lässt. Dann wohl ein weiterer ungünstiger Fehler. Ich habe Ubuntu 14.04 auf 16.04 ein release upgrade gegönnt und dachte das behebt den Fehler. Aber auch hier immer noch gleiches Fehlerbild.

Code

mysql-server-core-5.7 (5.7.18-0ubuntu0.16.04.1) wird eingerichtet ...[ERROR] Package::FrontEnd::Installer::_copyPhpBinary: PHP `PHP_FPM_BIN_PATH' configuration parameter is not set.E: Problem executing scripts DPkg::Post-Invoke 'if [ -x /usr/local/sbin/imscp-dpkg-post-invoke.pl -a ${IMSCP_SETUP:=0} -eq 0 ]; then /usr/bin/perl /usr/local/sbin/imscp-dpkg-post-invoke.pl -d; fi'E: Sub-process returned an error code

Irgendwie scheint da schon beim upgrade der i-mscp version etwas schief gelaufen zu sein.
Hat noch jemand einen Rat? Für jeglichen Hinweis bin ich dankbar.

Code

Error: MySQL server has gone away
Upgrade process completed successfully.
Checking if update is needed.
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "restart" failed.
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: activating (auto-restart) (Result: exit-code) since Fri 2017-06-02 21:02:00 CEST; 48ms ago
Process: 19101 ExecStartPost=/usr/share/mysql/mysql-systemd-start post (code=exited, status=0/SUCCESS)
Process: 19100 ExecStart=/usr/sbin/mysqld (code=exited, status=2)
Process: 19089 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 19100 (code=exited, status=2)
Jun 02 21:02:00 gsrv systemd[1]: Failed to start MySQL Community Server.
Jun 02 21:02:00 gsrv systemd[1]: mysql.service: Unit entered failed state.
Jun 02 21:02:00 gsrv systemd[1]: mysql.service: Failed with result 'exit-code'.
Hint: Some lines were ellipsized, use -l to show in full.
dpkg: error processing package mysql-server-5.7 (--configure):
subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
mysql-server-5.7
E: Sub-process /usr/bin/dpkg returned an error code (1)

Display More

**Nuxwin** · Jun 2nd 2017

Quote from root666

mysql-server-core-5.7 (5.7.18-0ubuntu0.16.04.1) wird eingerichtet ...
[ERROR] Package::FrontEnd::Installer::_copyPhpBinary: PHP `PHP_FPM_BIN_PATH' configuration parameter is not set.
E: Problem executing scripts DPkg::Post-Invoke 'if [ -x /usr/local/sbin/imscp-dpkg-post-invoke.pl -a ${IMSCP_SETUP:=0} -eq 0 ]; then /usr/bin/perl /usr/local/sbin/imscp-dpkg-post-invoke.pl -d; fi'
E: Sub-process returned an error code

execute: rm -r /usr/local/sbin/imscp-dpkg-post-invoke.pl

Quote from root666

Jun 02 21:02:00 gsrv systemd[1]: Failed to start MySQL Community Server.
Jun 02 21:02:00 gsrv systemd[1]: mysql.service: Unit entered failed state.
Jun 02 21:02:00 gsrv systemd[1]: mysql.service: Failed with result 'exit-code'.
Hint: Some lines were ellipsized, use -l to show in full.
dpkg: error processing package mysql-server-5.7 (--configure):
subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
mysql-server-5.7
E: Sub-process /usr/bin/dpkg returned an error code (1)

Display More

There is something wrong with your Mysql Installation. Without further details we cannot help. That is not i-MSCP related.

**root666** · Jun 2nd 2017

Thx Nuxwin,

rm -r /usr/local/sbin/imscp-dpkg-post-invoke.pl has removed the Error.

I have fully removed mysql, also /etc/mysql and /var/lib/mysql
After reinstalling mysql works now fine.
mysql>

ok, now im doing "perl imscp-autoinstall -d" again, but how get i my mysql-data back?

I have a backup from /var/lib/mysql, whats now to do? Only copy the backup files to /var/lib/mysql and restart the mysql server and do a "perl imscp-autoinstall -r" after this?

EDIT: oh pls remind the backup data are from mysql-server-5.5, now its mysql-server-5.7 installed.

Upgrade was successfull and i have done the following commands.

but i get this error:

Code

[FATAL] iMSCP::Dialog::InputValidation::isAvailableSqlUser: Error while executing statement: Table 'imscp.sql_user' doesn't exist at /var/www/imscp/engine/setup/../PerlLib/iMSCP/Dialog/InputValidation.pm line 460.

**Nuxwin** · Jun 3rd 2017

Quote from root666

ok, now im doing "perl imscp-autoinstall -d" again, but how get i my mysql-data back?

I have a backup from /var/lib/mysql, whats now to do? Only copy the backup files to /var/lib/mysql and restart the mysql server and do a "perl imscp-autoinstall -r" after this?

EDIT: oh pls remind the backup data are from mysql-server-5.5, now its mysql-server-5.7 installed.

That not so simple..

Well, I would suggest the following:

Purge all MySQL packages again
Rsync your /var/lib/mysql backup
Rsync your /etc/mysql backup (I hope you have also the backup)
Install MySQL 5.7 manually (Upgrade should take place automatically).
Update your root SQL password: dpkg-reconfigure mysql-server-5.7

Once done, you should be able to rerun i-MSCP installer.

**root666** · Jun 4th 2017

ok i have wasted to many time to fix this with 16.04 and mysql-server-5.7. So i have fresh reeinstalled my server with 14.04.05 (mysql-server-5.5), then installed i-mscp 1.3.7 and rsync my backup back. After a few hours to fix some things i have running all domains (except domains with database in the background, problem see below). After this i have updated i-mscp to version 1.4.3.
One problem left. It seems a problem with the sql users for the customer domains. Before (vers. 1.3.7) i have a button "login with phpmyadmin", now there on the same position i have only the options "Passwort aktualisieren/change password" or "delete". Before (vers. 1.3.7 login over the button) and now vers. 1.4.3 the login directly in phpmyadmin with the sql- users failed. Cant login in phpmyadmin with the customer sql-users. I have changed /var/www/imscp/gui/public/tools/pma/config.inc.php and login with "root".

mysql --> imscp --> sql_users (all users listed)

mysql --> imcsp_pma --> pma_userconfig (all users listed)

mysql --> home --> databases --> (select a user database) check rights --> (only debian-sys-maint, imscp_user and root listed)
Is there a way to fix this without delete and add all sql users by hand?

EDIT:
ok i have fixed the sql users by hand. im done. so the problem seems to be solved. Thx Nuxwin for your support.

Für alle anderen mit solchen Problemen anbei ein paar Links:
Serverumzug i-mscp: https://blog-speedy.de/serverumzug-i-mscp/
Reset MySQL-Password: https://itler.net/mysql-root-p…t-zuruecksetzen-resetten/ oder MySQL root funzt nach Update nicht mehr

phpmyadmin als root user nutzen:
change $cfg['Servers'][$i]['AllowRoot'] to "true" : /var/www/imscp/gui/public/tools/pma/config.inc.php
dannach: service imscp_panel restart

**Nuxwin** · Jun 4th 2017

Quote from root666

phpmyadmin als root user nutzen:
change $cfg['Servers'][$i]['AllowRoot'] to "true" : /var/www/imscp/gui/public/tools/pma/config.inc.php
dannach: service imscp_panel restart

There is not need to use SQL root user there... Simply use the imscp_user in place.

MySQL zerschossen bei Upgrade von 1.3.7 auf 1.4.3

Share

Daily visitors