Page 1 of 1

Can't add new databases

Posted: Mon Mar 07, 2016 3:25 am
by VENAXIS
Hello there,

I don't know what happened that caused this, but suddenly I can no longer add new databases via VestaCP. The host field is empty for some reason. So if I ignore the host and add a new DP I get this message:
Field "host" can not be blank.
This is the weird empty host field:
Image

So I tried editing the field manually and force adding the option "localhost" using Firefox's developer tools, and this is the error I get:
Image
Image

And is it normal for the database type to be Mysqld instead of mysql? I tried changing it to mysql and the host to localhost using Firefox's developer tools and this is what I got:
Image
Image

I've also checked the passwords on /root/.my.cnf and mysql.conf and they match. What could be the problem?

*Please note that I have run yum update via root on my ssh a few days ago and it updated vesta, but not sure if this is the reason for this.

I'm running Centos 6.7 (Final).

Re: Can't add new databases

Posted: Wed Mar 09, 2016 10:42 am
by VENAXIS
Any help would be appreciated!

Re: Can't add new databases

Posted: Wed Mar 09, 2016 11:26 am
by skurudo
Check this file:
/usr/local/vesta/conf/vesta.conf

And this line:
DB_SYSTEM -> mysqld

Re: Can't add new databases

Posted: Sat Apr 23, 2016 2:22 pm
by Scoilime
Hello, same problem here:
v-list-database-types
TYPES
----------
mysqld
v-list-database-hosts
HOST MAX_DB U_DB_BASES SUSPENDED DATE
------ ------ ------ ------ ------
localhost 500 1 no 2015-09-15
WEB_SYSTEM='httpd'
WEB_RGROUPS='apache'
WEB_PORT='8080'
WEB_SSL='mod_ssl'
WEB_SSL_PORT='8443'
PROXY_SYSTEM='nginx'
PROXY_PORT='80'
PROXY_SSL_PORT='443'
FTP_SYSTEM='vsftpd'
MAIL_SYSTEM='exim'
IMAP_SYSTEM='dovecot'
ANTIVIRUS_SYSTEM=''
ANTISPAM_SYSTEM=''
DB_SYSTEM='mysqld'
DNS_SYSTEM='named'
STATS_SYSTEM='webalizer,awstats'
BACKUP_SYSTEM='local'
CRON_SYSTEM='crond'
DISK_QUOTA='yes'
FIREWALL_SYSTEM='iptables'
FIREWALL_EXTENSION='fail2ban'
REPOSITORY='cmmnt'
VERSION='0.9.8'
LANGUAGE='es'
I've also checked the passwords on /root/.my.cnf and mysql.conf and they match.

Thanks in advance.

Re: Can't add new databases

Posted: Mon Apr 25, 2016 10:07 am
by skurudo
Scoilime wrote:Hello, same problem here
CentOS too? Which version?

Re: Can't add new databases

Posted: Tue Apr 26, 2016 10:20 am
by Scoilime
Hello skurudo,

CentOS release 6.7 (Final)

Re: Can't add new databases

Posted: Mon Jul 18, 2016 11:42 am
by kandalf
Any update about this issue?

Re: Can't add new databases

Posted: Tue Jul 26, 2016 1:34 am
by feliphe
Any update about this issue? ²

Re: Can't add new databases

Posted: Tue Jul 26, 2016 6:27 am
by skurudo
feliphe wrote:Any update about this issue? ²
Update to .16 version first, then test.

Re: Can't add new databases

Posted: Mon Sep 23, 2019 10:11 am
by SarCasM
Hi,

I am having the same issue. The host is empty and cannot select any. I am using CentOS release 6.10 (Final) and MySQL 8. Can you help me?