Posts by ezafiro

ezafiro · Oct 3rd 2016

Migration finally succeed, I just drop the php-script I used to rebuild the sql permessions:

PHP

<?php
$mysqli = new mysqli("localhost", "root", "", "imscp");
if ($mysqli->connect_errno) {
printf("Connect failed: %s\n", $mysqli->connect_error);
exit();
}
$query = "
SELECT
sqlu_name as dbuser,
sqlu_host as dbhost,
sqld_name as dbname,
sqlu_pass as dbpass
FROM sql_user sqlu
INNER JOIN sql_database sqldb
ON sqlu.sqld_id = sqldb.sqld_id
";
if ($result = $mysqli->query($query)) {
while ($row = $result->fetch_assoc()) {
$query2 = "GRANT ALL ON `{$row['dbname']}`.* TO '{$row['dbuser']}'@'{$row['dbhost']}' IDENTIFIED BY '{$row['dbpass']}';";
$mysqli->query($query2);
echo $query2."\n";
}
$result->free();
}
?>

Display More

ezafiro · Oct 2nd 2016

I fixed this issue by deleting imscp.conf and imscp.conf.old and then rerun

Code

perl imscp-autoinstall -d

but now I noticed, that the installer doesn't seem to recreate the mysql users
Is there any hidden flag or any script available to regenerate mysql users from imscp database?

ezafiro · Oct 2nd 2016

What I have tried:

Code

# uninstall mysqlservice mysql stopapt-get purge mysql-server mysql-common mysql*apt-get autoclean; sudo apt-get clean; sudo apt-get autoremove;rm -R /etc/mysql/rm -R /var/lib/mysql/# install maria dbapt-get install mariadb-server

Then I restored the backup (not backed up mysql, sys, information_schema tables)
I edited /etc/imscp/imscp.conf and set SQL_SERVER to mariadb_10.0 (using 10.0.27-MariaDB-0ubuntu0.16.04.1)

Then I rerun installer

Code

perl imscp-autoinstall -r sql

but installer still offers me only to install mysql5.7 and remote server

What Am I missing?

ezafiro · Sep 30th 2016

Quote from Ninos

This is because you cannot simply switch from mysql 5.7 to mariadb without migrating your data. Here you need to switch manually.

Can you please help me with the necessary steps?

1. mysqldump all databases
2. uninstall all mysql packages via apt
3. install mariadb packages via apt
4. import mysqldump backup
5. rerun installer

Did I miss something?

ezafiro · Sep 30th 2016

Hi guys,

I'm trying to switch from mysql to mariadb.

It seems that this previously was possible via:

Code

perl imscp-autoinstall -r sql

but the installer only offers me mysql und remote server as option (see screenshot)

Has support for mariadb been removed or what am I doing wrong?

I'm on ubuntu 16.04 and imscp 1.3.1