MYSQL 5.7 migrate to mariadb problems

K

Kronus

Verified User
Joined
May 31, 2007
Messages
48
OS = Centos 6.9
mysql version 5.7



i have tried to change mysql to mariadb and have not been suscessful.

i run custombuild and it does this
Code: 
[root@server custombuild]# ./build mysql
Cannot find /usr/bin/mysqldump
Found /usr/local/directadmin/custombuild/mysql/MariaDB-10.1.28-centos6-x86_64-client.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-10.1.28-centos6-x86_64-devel.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-10.1.28-centos6-x86_64-server.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-10.1.28-centos6-x86_64-common.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-10.1.28-centos6-x86_64-compat.rpm
Installing dependencies...
Found /usr/local/directadmin/custombuild/mysql/
Installing libjemalloc...
Found /usr/local/directadmin/custombuild/mysql/jemalloc-3.6.0-1.el6.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/jemalloc-devel-3.6.0-1.el6.x86_64.rpm
warning: /usr/local/directadmin/custombuild/mysql/jemalloc-3.6.0-1.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
Preparing...                ########################################### [100%]
   1:jemalloc               ########################################### [ 50%]
   2:jemalloc-devel         ########################################### [100%]
Installing galera...
Found /usr/local/directadmin/custombuild/mysql/galera-25.3.20-1.rhel6.el6.x86_64.rpm
warning: /usr/local/directadmin/custombuild/mysql/galera-25.3.20-1.rhel6.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
Preparing...                ########################################### [100%]
   1:galera                 ########################################### [100%]
Stopping mysqld ...
Cannot find /usr/bin/mysql, installing MariaDB
warning: MariaDB-10.1.28-centos6-x86_64-client.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
error: open of MariaDB-10.1.28-centos6-x86_64-shared.rpm failed: No such file or directory
Ensuring local-infile is disabled for security reasons in MySQL configuration file...
Giving mysqld a few seconds to start up...
cp: cannot stat `/usr/lib/libmysqlclient.so': No such file or directory
Restarting MySQL.
[root@server custombuild]# service mysqld restart
mysqld: unrecognized service

have checked logs and everything i can think of

any help would be appreciated
 
tried again with 10.2

got same error with same file missing however this is what is found in folder
/usr/local/directadmin/scripts/packages
Code: 
da_exim-4.87-1.x86_64.rpm                  MariaDB-10.2.10-centos6-x86_64-compat.rpm  MySQL-devel-5.5.31-1.linux2.6.x86_64.rpm   proftpd-1.3.4b-1.x86_64.rpm
majordomo-1.94.5                           MariaDB-10.2.10-centos6-x86_64-devel.rpm   MySQL-server-5.5.31-1.linux2.6.x86_64.rpm  proftpd-standalone-1.3.4b-1.x86_64.rpm
majordomo-1.94.5.tar.gz                    MariaDB-10.2.10-centos6-x86_64-server.rpm  MySQL-shared-5.5.31-1.linux2.6.x86_64.rpm  services.tar.gz
MariaDB-10.2.10-centos6-x86_64-client.rpm  MariaDB-10.2.10-centos6-x86_64-shared.rpm  ncftp-3.2.5                                services.tar.gz.md5
MariaDB-10.2.10-centos6-x86_64-common.rpm  MySQL-client-5.5.31-1.linux2.6.x86_64.rpm  ncftp-3.2.5-src.tar.gz                     sysbk.tar.gz

the file is there but the script seems to not be able to find it.
 
Custombuild uses /usr/local/directadmin/custombuild/mysql/ to store rpm packages of MySQL/MariaDB.

Make sure you've got the latest custombuild script by running:

Code: 
./build update
 
i did
I also downloaded the file to the /usr/local/directadmin/custombuild/mysql/ folder now i get this error
service mysqld restart
ERROR! MySQL server PID file could not be found!
Starting MySQL.171115 12:11:13 mysqld_safe Logging to '/var/log/mysqld.log'.
171115 12:11:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
ERROR!
ERROR! Failed to restart server.
 
ok i got it

I had to remove the my.cnf file

is this normal or should i edit it to see what the issue is ?
 
I don't know what is wrong there. Probably you have depreciated and not supported directives there. It's all should be written in the error log.
 
thanks for the help it did point me in the right direction to get it working.

will investigate the log files and go from there

Thanks again
 
I have to say I ran into the same problem with CustomBuild 2.0 (1.0.18).

On a freshly installed server I did all the updates and selected mysql 5.7 (5.6 is in blue so I think this is the version installed) and mariadb 10.2 did the updates and it was working. On phpmyadmin I saw the mariadb is still on 5.5... so I changed the value of mysql_inst from no to mariadb and this time I got the update for 10.2. For some reason I got the same error, nothing was working anymore.

I reinstalled the server and never touched the mysql version, just changed mariadb to 10.2 and changed mysql_inst to mariadb. This time I had no problems. What I think is a bit strange is that in CustomBuild it shows mysql 5.6 in blue which is default but when I check my sql version in the console it shows 5.7. So I guess when I selected 5.7 in the first install it messed up because 5.7 was already on there?

Not sure whats going on though.
 
You must log in or register to reply here.
Back
Top