We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
MySQL -> MariaDB how to change in web gui?
MySQL -> MariaDB how to change in web gui?
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
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
-
- Collaborator
- Posts: 783
- Joined: Mon May 11, 2015 8:43 am
- Contact:
- Os: CentOS 6x
- Web: apache + nginx
Re: MySQL -> MariaDB how to change in web gui?
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?
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]#
-
- Collaborator
- Posts: 783
- Joined: Mon May 11, 2015 8:43 am
- Contact:
- Os: CentOS 6x
- Web: apache + nginx
Re: MySQL -> MariaDB how to change in web gui?
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?
thats the print screen from phpmyadmin
I'm changed in vesta.config, and now i see in panel, but is inactive
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.
-
- Collaborator
- Posts: 783
- Joined: Mon May 11, 2015 8:43 am
- Contact:
- Os: CentOS 6x
- Web: apache + nginx
Re: MySQL -> MariaDB how to change in web gui?
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?
maybe...
this works properly on Centos 7.1 but there is other problem with exim.. cannot receive mails, and login via mail client.
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?
Did you solved the problem of mariadb inactive?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.
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:
-
- Posts: 8
- Joined: Mon Nov 09, 2015 2:09 am
Re: MySQL -> MariaDB how to change in web gui?
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!
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?
hy,
can add in instalations for optionals install mysql or mariadb?
can add in instalations for optionals install mysql or mariadb?