MySQL -> MariaDB how to change in web gui?

[AdamiPL]

Hi
I have Centos 6.7 with new vestacp.
i removed mysql and installed MariaDB10 but in web control panel i still see MySQL, how to "swap" for MariaDB?



bw i shows that mysql is running

[tjebbeke]

Can you run: v-list-sys-config and can you check if /usr/lib/systemd/system/mariadb.service exist?

[AdamiPL]

Code: Select all

WEB_SYSTEM:          httpd
WEB_RGROUPS:         apache
WEB_PORT:            8080
WEB_SSL_PORT:        8443
WEB_SSL:             mod_ssl
PROXY_SYSTEM:        nginx
PROXY_PORT:          80
PROXY_SSL_PORT:      443
STATS_SYSTEM:        webalizer,awstats
FTP_SYSTEM:          vsftpd
DNS_SYSTEM:          named
MAIL_SYSTEM:         exim
ANTIVIRUS_SYSTEM:    clamav
ANTISPAM_SYSTEM:     spamassassin
IMAP_SYSTEM:         dovecot
CRON_SYSTEM:         crond
FIREWALL_SYSTEM:     iptables
FIREWALL_EXTENSION:  fail2ban
BACKUP_SYSTEM:       local,ftp
LANGUAGE:            en
VERSION:             0.9.8
DB_SYSTEM:           mysql
DISK_QUOTA:          no

Code: Select all

bash: cd: /usr/lib/systemd/system/: No such file or directory
[root@mail admin]# whereis mariadb.service
mariadb:
[root@mail admin]# find / -name mariadb.service
[root@mail admin]#

[tjebbeke]

Are you sure you have installed mariaDB? Normally this is automatically adjusted in vestaCP. You can try to replace mysql with mariadb in /usr/local/vesta/conf/vesta.conf.

[AdamiPL]

thats the print screen from phpmyadmin



I'm changed in vesta.config, and now i see in panel, but is inactive

Code: Select all

[root@mail admin]# mysql -v
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 22517
Server version: 10.0.22-MariaDB MariaDB Server

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Reading history-file /root/.mysql_history
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

[tjebbeke]

MySQL and MariaDB are almost the same. I would change back your vesta.conf. Maybe someone else knows a solution here?

[AdamiPL]

maybe...

this works properly on Centos 7.1 but there is other problem with exim.. cannot receive mails, and login via mail client.

[rlasmar]

thats the print screen from phpmyadmin



I'm changed in vesta.config, and now i see in panel, but is inactive

Code: Select all

[root@mail admin]# mysql -v
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 22517
Server version: 10.0.22-MariaDB MariaDB Server

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Reading history-file /root/.mysql_history
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Did you solved the problem of mariadb inactive?
I use ubuntu 14.04 and I followed the below instructions to install mariadb 10.
1. apt-get install software-properties-common
2. apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
3. add-apt-repository 'deb [arch=amd64,i386,ppc64el] http://mirror.edatel.net.co/mariadb/repo/10.1/ubuntu trusty main'
4. apt-get update
5. apt-get install mariadb-server

I restarted the server, but vestacp still showing mysql instead mariadb. So I edited the file /usr/local/vesta/conf/vesta.conf and change database from mysql to mariadb. I restarted vestacp - service vestacp restart - and now it shows mariadb on panel, but it's inactive and grey. Anyone one knows a solution?


The command "mysql -V" shows me:
mysql Ver 15.1 Distrib 10.1.18-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

On phpmyadmin shows MariaDB:

[danimalweb]

I have a similar issue after updating to PHP7-fpm.

I have updated WEB Backend: php7.0-fpm in vesta.conf.

It Stops / Starts and restarts via the admin panel, it is always grayed out, like it's not running, but it is running fine.

Any help?

Thanks!

[n0rton]

hy,

can add in instalations for optionals install mysql or mariadb?