Update from 1.2.17 -> 1.3.0 (incl. Server Change) Operation Create User for imscp_user failed

**dimon** · Jul 30th 2016

Hello together,

today I try to move to a new server with a new upgrade of imscp from 1.2.17 -> 1.3.0

And I do the same prodecure as Viktor
Upgrade 1.1.2 to 1.3

and get the same failure message:

Code

[ERROR] iMSCP::Stepper::_callback: Could not create the imscp_user@localhost SQL user: Error while executing statement: Operation CREATE USER failed for 'imscp_user'@'localhost' at /usr/src/imscp/engine/PerlLib/Servers/sqld/mysql.pm line 181, <$fh> line 370.
autoinstaller::Functions::install: An error occurred while performing installation steps

what is the correct step to fix it?

BR

**Viktor** · Jul 30th 2016

Hallo,

you can test this.

Save the file "/etc/mysql/debian.cnf" from the new server.

Copy this file from the old server to the new server.

Run perl imscp-autoinstall -dr

Test it is now working.

Viktor

**dimon** · Jul 31st 2016

Hi Viktor,

thx for your quick answer.

But I also change from debian to ubuntu so I don't have on the new server a debain.conf.

old server:
debian 8.5
mysql 5.5.49

new server:
ubuntu 14.04.4
mysql 5.7.14

To fix the problem I set manually the grant access rights to the root user back.

Code

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';mysql> FLUSH PRIVILEGES;

But now a get the next issue

Code

[ERROR] iMSCP::Stepper::_callback: Could not create the imscp_user@localhost SQL user: Error while executing statement: Unknown column 'password_last_changed' in 'mysql.user' at /usr/src/imscp/engine/PerlLib/Servers/sqld/mysql.pm line 181, <$fh> line 370.
autoinstaller::Functions::install: An error occurred while performing installation steps

**dimon** · Jul 31st 2016

problem fixed.

Code

mysql_upgrade -u root -p

**Nuxwin** · Jul 31st 2016

@demon

Don't forget that Ubuntu is based on Debian. The debian.cnf file is also provided by Ubuntu packages... There is only one case where that file is not relevant (not provided): That is when you use mysql community server (from MySQL repository) which is your case because you use Ubuntu Trusty (14.04) that doesn't provides MySQL 5.7.

For instance, on Ubuntu Xenial:

Code

root@srv1:~# lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 16.04.1 LTS
Release: 16.04
Codename: xenial
root@srv1:~# ls -la /etc/mysql/
total 32
drwxr-xr-x 4 root root 4096 juil. 31 04:06 .
drwxr-xr-x 96 root root 4096 juil. 31 10:12 ..
drwxr-xr-x 2 root root 4096 juil. 31 04:11 conf.d
-rw------- 1 root root 317 juil. 31 04:06 debian.cnf
-rwxr-xr-x 1 root root 120 juil. 20 20:08 debian-start
lrwxrwxrwx 1 root root 24 juil. 31 04:05 my.cnf -> /etc/alternatives/my.cnf
-rw-r--r-- 1 root root 839 juil. 14 18:09 my.cnf.fallback
-rw-r--r-- 1 root root 682 juil. 11 15:36 mysql.cnf
drwxr-xr-x 2 root root 4096 juil. 31 04:06 mysql.conf.d
root@srv1:~#

Display More

To resume

With Ubuntu Trusty (14.04), MySQL 5.7 is installed from MySQL repository: https://github.com/i-MSCP/imsc…/packages-trusty.xml#L114

With Ubuntu Xenial (16.04), MySQL 5.7 is installed from Ubuntu official repository: https://github.com/i-MSCP/imsc…u/packages-xenial.xml#L93

Update from 1.2.17 -> 1.3.0 (incl. Server Change) Operation Create User for imscp_user failed

Share

Daily visitors