[Solved] MariaBD status:active but not active in VestaCP

[Piercer]

Kindly help: service mariadb status shows active , but in VestaCP it is grey - not active. Happened after upgrade from Mariadb 10.5.3 to 10.5.4
All web sites are working just fine. No errors. Only VestaCP doesn't understand that mysql is running. Thanks!!!

[Piercer]

In /usr/local/vesta/conf/vesta.conf changed
DB_SYSTEM='mariadb'

(was db_system="mysql')

[darkleech]

In /usr/local/vesta/conf/vesta.conf changed
DB_SYSTEM='mariadb'

(was db_system="mysql')

У меня в этом случае пропадает сервер при добавлении баз и в настройках сервера, сам сервис mariadb работает, перезагружается, но базы не могу создать.

[vibol]

i'm testing with Centos7 + Apache + Nginx + MariaDB 10.5.5 ..

problem::: mariadb greyed out in vestacp server/service list
# edit -> /usr/local/vesta/conf/vesta.conf
# add/edit this line::: DB_SYSTEM='mariadb'
# fixed

problem::: can't add database because host blank
# <copy> /usr/local/vesta/conf/mysql.conf <to> /usr/local/vesta/conf/mariadb.conf
# command::: cp /usr/local/vesta/conf/mysql.conf /usr/local/vesta/conf/mariadb.conf
# fixed

problem::: created user/db can't login from phpmyadmin
# not yet fixed, i think vestacp not yet full support 10.5.5 mariadb, or not support 'mariadb' TYPE from v-add-database

[Piercer]

done all that vibol advised. Works just fine but cannot create DB via VESTA CP

error: mysql type is invalid

mysql Ver 15.1 Distrib 10.5.7-MariaDB, for Linux (x86_64) using readline 5.1

[Cooper]

Is this solved? thanks!

problem::: created user/db can't login from phpmyadmin
# not yet fixed, i think vestacp not yet full support 10.5.5 mariadb, or not support 'mariadb' TYPE from v-add-database

[anuradhan]

goto

nano /etc/mysql/conf.d/mysql.cnf

change line1
from
[mysql]
to
[mysqld]

Error: mysql type is invalid
will go away

[vstcp]

goto

nano /etc/mysql/conf.d/mysql.cnf

change line1
from
[mysql]
to
[mysqld]

Error: mysql type is invalid
will go away

This does not seem to work anymore after upgrading to MariaDB 10.6.9 (probably already not from v10.5 onward when they changed mysql/mariadb commands).

When trying with DB_SYSTEM = [mariadb,mysql] in vesta.conf
the mariadb status goes grey in the web GUI /list/server/
How can this be avoided?

Also, the DB creation /add/db needs the "mysql" selected, selecting "mariadb" as type does not work lateron for the db work itself (e.g. in PMA). Changing the script "v-add-database" at line with type=${5-mysql} into {5-mariadb} does not provide a solution either.

Besides the above, the vesta version number is not correct in the vesta.conf file, which could be corrected manually of course, but perhaps there is another conflict and it needs the wrong version number for something?

Thank you in advance for anyone's helpful ideas!

[bogdan_di]

Code: Select all

find /usr/local/vesta/conf/ -name vesta.conf | xargs sed -i "s/DB_SYSTEM='mysql'/DB_SYSTEM='mysql,mariadb'/g"

[lpcs007]

I have the same problem, but I couldn't solve it with the same solution as in the topic.

I upgraded MariaDB to 10.11.2 following topic viewtopic.php?p=73011#p73011 and the database is working fine. But the list of Vesta services appears as offline even though the service is online.

In vesta configuration file has DB_SYSTEM='mysql'. If I change to mariadb the service appears as online but when I create the database the phpmyadmin link does not work. It's like phpmyadmin is related to mysql service and not mariadb.

I already tried other topics, but I didn't find the solution.

I am using CentOS 7.9