Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section Database Server
  • Search

Can't add new databases

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
10 posts • Page 1 of 1
VENAXIS
Posts: 13
Joined: Sat Oct 10, 2015 11:10 am

Can't add new databases
  • Quote

Post by VENAXIS » Mon Mar 07, 2016 3:25 am

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).
Top

VENAXIS
Posts: 13
Joined: Sat Oct 10, 2015 11:10 am

Re: Can't add new databases
  • Quote

Post by VENAXIS » Wed Mar 09, 2016 10:42 am

Any help would be appreciated!
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: Can't add new databases
  • Quote

Post by skurudo » Wed Mar 09, 2016 11:26 am

Check this file:
/usr/local/vesta/conf/vesta.conf

And this line:
DB_SYSTEM -> mysqld
Top

Scoilime
Posts: 2
Joined: Sat Apr 23, 2016 2:16 pm

Re: Can't add new databases
  • Quote

Post by Scoilime » Sat Apr 23, 2016 2:22 pm

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.
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: Can't add new databases
  • Quote

Post by skurudo » Mon Apr 25, 2016 10:07 am

Scoilime wrote:Hello, same problem here
CentOS too? Which version?
Top

Scoilime
Posts: 2
Joined: Sat Apr 23, 2016 2:16 pm

Re: Can't add new databases
  • Quote

Post by Scoilime » Tue Apr 26, 2016 10:20 am

Hello skurudo,

CentOS release 6.7 (Final)
Top

kandalf
Posts: 87
Joined: Tue May 13, 2014 11:53 pm

Re: Can't add new databases
  • Quote

Post by kandalf » Mon Jul 18, 2016 11:42 am

Any update about this issue?
Top

feliphe
Posts: 4
Joined: Tue Jul 19, 2016 4:01 pm

Re: Can't add new databases
  • Quote

Post by feliphe » Tue Jul 26, 2016 1:34 am

Any update about this issue? ²
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: Can't add new databases
  • Quote

Post by skurudo » Tue Jul 26, 2016 6:27 am

feliphe wrote:Any update about this issue? ²
Update to .16 version first, then test.
Top

SarCasM
Posts: 1
Joined: Mon Sep 23, 2019 10:05 am

Os: CentOS 5x
Web: apache + nginx
Re: Can't add new databases
  • Quote

Post by SarCasM » Mon Sep 23, 2019 10:11 am

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?
Top


Post Reply
  • Print view

10 posts • Page 1 of 1

Return to “Database Server”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password