Add database error

[minhduc0512]

I have added the database previously normal, but today, I can not add database and notice "Field "host" can not be blank.".
Field Host empty, I don't know why, previously field host is "localhost"

[imperio]

Hi,
show me please vestacp config

Code: Select all

/usr/local/vesta/conf/vesta.conf

[minhduc0512]

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='mysql'
DNS_SYSTEM='named'
STATS_SYSTEM='webalizer,awstats'
BACKUP_SYSTEM='local'
CRON_SYSTEM='crond'
DISK_QUOTA='no'
REPOSITORY='cmmnt'
VERSION='0.9.8'
LANGUAGE='en'

[imperio]

Do you have mysql.conf ?
/usr/local/vesta/conf/

[minhduc0512]

yes. this is content of mysql.conf
HOST='localhost' USER='root' PASSWORD='my password' CHARSETS='UTF8,LATIN1,WIN1250,WIN1251,WIN1252,WIN1256,WIN1258,KOI8' MAX_DB='500' U_SYS_USERS='vietsport' U_DB_BASES='2' SUSPENDED='no' TIME='15:06:38' DATE='2014-06-20'

[imperio]

passwords in /root/my.cnf and mysql.conf are identical ?
can you login into phpmyadmin under root with mysql-root password ?

[minhduc0512]

passwords in /root/my.cnf and mysql.conf are identical ?
can you login into phpmyadmin under root with mysql-root password ?

passwords in /root/my.cnf and mysql.conf are different. I use phpmyadmin to change sql root password and change password in mysql.conf
I have just change password in root/my.cnf similar password in mysql.conf, I still can't add database

I can login into phpmyadmin

[imperio]

Show me result of this commands

Code: Select all

v-list-database-hosts
v-list-database-types

try to restart vestacp and mysql-server

Code: Select all

service vesta restart
service mysql restart

I have just change password in root/my.cnf similar password in mysql.conf

conversely

[minhduc0512]

When I edit html form in developer mode of browsers, add value "localhost" into field HOST, I can add database

[minhduc0512]

Show me result of this commands

Code: Select all

v-list-database-hosts
v-list-database-types

try to restart vestacp and mysql-server

Code: Select all

service vesta restart
service mysql restart

I have just change password in root/my.cnf similar password in mysql.conf

conversely

v-list-database-hosts
result:
HOST MAX_DB U_DB_BASE SUSPENDED DATE
localhost 500 3 no 2014-06-20

v-list-database-types
result
TYPES
mysql

I have restart all vesta service. Still can't add database