We are starting CHRISTMAS Sale. Get 30% OFF on lifetime licenses with code: FYSKK72

MySQL -> MariaDB how to change in web gui?

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
AdamiPL
Posts: 21
Joined: Sat Dec 20, 2014 8:33 am

MySQL -> MariaDB how to change in web gui?

Postby AdamiPL » Wed Nov 18, 2015 12:44 pm

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?

Image

bw i shows that mysql is running

tjebbeke
Collaborator
Posts: 757
Joined: Mon May 11, 2015 8:43 am
Contact:

Re: MySQL -> MariaDB how to change in web gui?

Postby tjebbeke » Thu Nov 19, 2015 11:49 am

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

AdamiPL
Posts: 21
Joined: Sat Dec 20, 2014 8:33 am

Re: MySQL -> MariaDB how to change in web gui?

Postby AdamiPL » Thu Nov 19, 2015 1:48 pm

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
Collaborator
Posts: 757
Joined: Mon May 11, 2015 8:43 am
Contact:

Re: MySQL -> MariaDB how to change in web gui?

Postby tjebbeke » Thu Nov 19, 2015 4:45 pm

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
Posts: 21
Joined: Sat Dec 20, 2014 8:33 am

Re: MySQL -> MariaDB how to change in web gui?

Postby AdamiPL » Thu Nov 19, 2015 4:56 pm

thats the print screen from phpmyadmin

Image

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
Collaborator
Posts: 757
Joined: Mon May 11, 2015 8:43 am
Contact:

Re: MySQL -> MariaDB how to change in web gui?

Postby tjebbeke » Thu Nov 19, 2015 5:17 pm

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

AdamiPL
Posts: 21
Joined: Sat Dec 20, 2014 8:33 am

Re: MySQL -> MariaDB how to change in web gui?

Postby AdamiPL » Thu Nov 19, 2015 5:25 pm

maybe...

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

rlasmar
Posts: 5
Joined: Fri Oct 07, 2016 3:46 pm

Re: MySQL -> MariaDB how to change in web gui?

Postby rlasmar » Fri Oct 07, 2016 4:02 pm

AdamiPL wrote:thats the print screen from phpmyadmin

Image

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?
Image

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:
Image

danimalweb
Posts: 8
Joined: Mon Nov 09, 2015 2:09 am

Re: MySQL -> MariaDB how to change in web gui?

Postby danimalweb » Wed Nov 16, 2016 10:58 pm

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
Posts: 29
Joined: Tue Mar 31, 2015 7:31 am

Re: MySQL -> MariaDB how to change in web gui?

Postby n0rton » Sat Nov 19, 2016 2:22 pm

hy,

can add in instalations for optionals install mysql or mariadb?


Return to “Database Server”



Who is online

Users browsing this forum: No registered users and 5 guests