Can't create anymore databases ??

Discussion in 'General' started by specon, Aug 23, 2008.

  1. specon

    specon New Member

    Hello,

    i already work for month's with ispconfig.
    yesterday i did an update to 2.2.24

    everything was fine, until today. I couldn't check my website anymore cause it gave me the error Database Error: Unable to connect to the database:Could not connect to MySQL.

    When i login as admin to the ispconfig pannel. And when i go to ISP site off gc-security.be
    when i click on options i can see that i cannot create anymore databases.

    it just disapeared and i dunno whats the problem???
    So my databases are gone, i can't create them anymore in the option window.

    what happend? and how do i fix it?

    greetings from belgium
    tom
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Maybe the update of the database structures failed. This may happen e.g. when the mysql user defined in /home/admispconfig/ispconfig/lib/config.inc.php does not has root permissions.

    Make sure that the user in this file has root permissions and is able to login to mysql and then run the update again.
     
  3. specon

    specon New Member

    Eumm

    Hey Till,

    That should do it again right?

    i mean will this solution bring back the create new database button in my option tab ?


    greetings
     
  4. falko

    falko Super Moderator ISPConfig Developer

    What's the output of
    Code:
    netstat -tap
    ? Is the MySQL user in /home/admispconfig/ispconfig/lib/config.inc.php root?
     
  5. specon

    specon New Member

    Reply

    Yes the user in the config file is ROOT.

    output off netstat -tap


    pluto:/home/admispconfig/ispconfig/lib# netstat -tap
    Active Internet connections (servers and established)
    Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
    tcp 0 0 *:mysql *:* LISTEN 8480/mysqld
    tcp 0 0 pluto.gc-security.:6666 *:* LISTEN 2668/ircd
    tcp 0 0 pluto.gc-security.:ircd *:* LISTEN 2668/ircd
    tcp 0 0 pluto.gc-security.:6668 *:* LISTEN 2668/ircd
    tcp 0 0 *:sunrpc *:* LISTEN 2099/portmap
    tcp 0 0 pluto.gc-security.:4400 *:* LISTEN 2668/ircd
    tcp 0 0 *:81 *:* LISTEN 10289/ispconfig_htt
    tcp 0 0 *:41970 *:* LISTEN 8214/rpc.statd
    tcp 0 0 *:ftp *:* LISTEN 9773/proftpd: (acce
    tcp 0 0 78-159-101-168.i:domain *:* LISTEN 11415/named
    tcp 0 0 78-159-101-167.i:domain *:* LISTEN 11415/named
    tcp 0 0 pluto.gc-securit:domain *:* LISTEN 11415/named
    tcp 0 0 localhost:domain *:* LISTEN 11415/named
    tcp 0 0 *:33333 *:* LISTEN 3124/psybnc
    tcp 0 0 *:smtp *:* LISTEN 9735/master
    tcp 0 0 localhost:953 *:* LISTEN 11415/named
    tcp 0 0 pluto.gc-security:35012 administrator.jolt:4400 ESTABLISHED2668/ircd
    tcp 0 0 78-159-101-167.in:59098 pluto.gc-security.:ircd ESTABLISHED3124/psybnc
    tcp 0 0 pluto.gc-security:33333 205.255-176-91.ad:46221 ESTABLISHED3124/psybnc
    tcp 0 0 pluto.gc-security.:ircd 78-159-101-167.in:59098 ESTABLISHED2668/ircd
    tcp6 0 0 *:imaps *:* LISTEN 28245/couriertcpd
    tcp6 0 0 *:pop3s *:* LISTEN 28194/couriertcpd
    tcp6 0 0 *:pop3 *:* LISTEN 12503/couriertcpd
    tcp6 0 0 *:imap2 *:* LISTEN 12593/couriertcpd
    tcp6 0 0 *:www *:* LISTEN 411/apache2
    tcp6 0 0 *:ssh *:* LISTEN 747/sshd
    tcp6 0 0 *:smtp *:* LISTEN 9735/master
    tcp6 0 0 localhost:953 *:* LISTEN 11415/named
    tcp6 0 0 *:https *:* LISTEN 411/apache2
    tcp6 0 2880 78-159-101-167.inte:ssh 205.255-176-91.ad:38135 ESTABLISHED20059/1
    pluto:/home/admispconfig/ispconfig/lib#
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Yes, this is most likely the solution for your problem, otherwise I dont have posted it ;)
     
  7. specon

    specon New Member

    doesn't work till

    It doesn't work, your solution.
     
  8. falko

    falko Super Moderator ISPConfig Developer

    Is the MySQL user in /home/admispconfig/ispconfig/lib/config.inc.php root?

    Are there any MySQL errors in your logs when you try to create a database?
     

Share This Page