Page 1 of 1
MySQL -> MariaDB how to change in web gui?
Posted: Wed Nov 18, 2015 12:44 pm
by 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
Re: MySQL -> MariaDB how to change in web gui?
Posted: Thu Nov 19, 2015 11:49 am
by tjebbeke
Can you run: v-list-sys-config and can you check if /usr/lib/systemd/system/mariadb.service exist?
Re: MySQL -> MariaDB how to change in web gui?
Posted: Thu Nov 19, 2015 1:48 pm
by 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]#
Re: MySQL -> MariaDB how to change in web gui?
Posted: Thu Nov 19, 2015 4:45 pm
by 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.
Re: MySQL -> MariaDB how to change in web gui?
Posted: Thu Nov 19, 2015 4:56 pm
by 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.
Re: MySQL -> MariaDB how to change in web gui?
Posted: Thu Nov 19, 2015 5:17 pm
by tjebbeke
MySQL and MariaDB are almost the same. I would change back your vesta.conf. Maybe someone else knows a solution here?
Re: MySQL -> MariaDB how to change in web gui?
Posted: Thu Nov 19, 2015 5:25 pm
by AdamiPL
maybe...
this works properly on Centos 7.1 but there is other problem with exim.. cannot receive mails, and login via mail client.
Re: MySQL -> MariaDB how to change in web gui?
Posted: Fri Oct 07, 2016 4:02 pm
by rlasmar
AdamiPL wrote: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:
Re: MySQL -> MariaDB how to change in web gui?
Posted: Wed Nov 16, 2016 10:58 pm
by 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!
Re: MySQL -> MariaDB how to change in web gui?
Posted: Sat Nov 19, 2016 2:22 pm
by n0rton
hy,
can add in instalations for optionals install mysql or mariadb?