Page 1 of 3
Add database error
Posted: Sat Jun 21, 2014 4:42 am
by 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"
Re: Add database error
Posted: Sat Jun 21, 2014 5:40 pm
by imperio
Hi,
show me please vestacp config
Re: Add database error
Posted: Sat Jun 21, 2014 5:50 pm
by 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'
Re: Add database error
Posted: Sat Jun 21, 2014 6:01 pm
by imperio
Do you have mysql.conf ?
/usr/local/vesta/conf/
Re: Add database error
Posted: Sat Jun 21, 2014 6:38 pm
by 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'
Re: Add database error
Posted: Sat Jun 21, 2014 6:42 pm
by imperio
passwords in /root/my.cnf and mysql.conf are identical ?
can you login into phpmyadmin under root with mysql-root password ?
Re: Add database error
Posted: Sat Jun 21, 2014 6:57 pm
by minhduc0512
imperio wrote: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
Re: Add database error
Posted: Sat Jun 21, 2014 7:11 pm
by 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
Re: Add database error
Posted: Sat Jun 21, 2014 7:15 pm
by minhduc0512
When I edit html form in developer mode of browsers, add value "localhost" into field HOST, I can add database
Re: Add database error
Posted: Sat Jun 21, 2014 7:23 pm
by minhduc0512
imperio wrote: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