domain and database not creating

Discussion in 'Installation/Configuration' started by crypted, Apr 15, 2010.

  1. crypted

    crypted New Member

    I'm having issues with ISPCONFIG now.

    I re-established almost all accounts.

    1) A domain that I created in the Panel has not been created in the /var/www/ at all.
    2) A database that I created has not been setup in /var/lib/mysql/.

    This just started happening. I got everything else added up to this point.


    Code:
    my:/var/www/derekgordon.com/web# nano /var/log/ispconfig/ispconfig.log 
    
      GNU nano 2.0.7                      File: /var/log/ispconfig/ispconfig.log                                                    
    
    14.04.2010-19:02 - ERROR - Unable to connect to the databaseCan't create database 'c1peruvian'; database exists
    14.04.2010-20:44 - ERROR - Unable to connect to the databaseCan't create database 'c3pwcsportsman'; database exists
    
    Those databases do exist though. No other errors are available in Monitor.

    So, I deleted those databases. I tried to recreate them and still no new DATABASES are being created in /var/lib/mysql/ by ISPCONFIG.

    I have no clue how to view a job queue to see if something's stuck.

    I tried the ispconfig/server.sh script. Nothing.

    my:/usr/local# /usr/local/ispconfig/server/server.sh
    my:/usr/local#

    y:/var/lib/mysql# /usr/local/ispconfig/server/server.sh
    /usr/bin/fail2ban-client

    hangs on fail2 ban
     
    Last edited: Apr 15, 2010
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    You can not add a new database in ispconfig that already exist in mysql as there can be only one database with the same name or it will cause the errtor that you see above. The configuration system will halt then for security reasons so that no new config chnages will be processed anymore.

    To fix this, delete the old mysql databases so that ISPConfig can recreate them and also delete the errors in the system log of the ispconfig monitor (there is a delet button in the error lines) to confirm that you fixed the mysql problem.
     
  3. crypted

    crypted New Member

    I never created these outside of ISPCONFIG. It created the databases orginally, and it then tried to recreate them on its own.

    I deleted the databases right away and cleared the error log.

    Now, when I add databases, the Control Panel will list the databases (thinks they are made) but they do not exist in /var/lib/mysql/.

    ISPCONFIG is sill refusing to continue working properly on the backend. But there are no errors that I can find.

    Code:
    my:/var/lib# cd mysql
    my:/var/lib/mysql# ls -lah
    total 21M
    drwxr-xr-x  8 mysql mysql 4.0K 2010-04-15 11:39 .
    drwxr-xr-x 40 root  root  4.0K 2010-04-15 01:38 ..
    drwx------  2 mysql mysql 4.0K 2010-04-15 03:12 c1areyouliberal
    drwx------  2 mysql mysql 4.0K 2009-11-13 22:27 c1cupfiji
    drwx------  2 mysql mysql 4.0K 2010-04-12 14:02 c1inter5
    drwx------  2 mysql mysql 4.0K 2010-01-05 18:09 c1sebastianlodge
    drwx------  2 mysql mysql 4.0K 2010-04-14 11:31 dbispconfig
    -rw-r--r--  1 root  root     0 2010-04-14 10:30 debian-5.0.flag
    -rw-rw----  1 mysql mysql  10M 2010-04-15 11:35 ibdata1
    -rw-rw----  1 mysql mysql 5.0M 2010-04-15 11:39 ib_logfile0
    -rw-rw----  1 mysql mysql 5.0M 2010-04-14 10:30 ib_logfile1
    drwxr-xr-x  2 mysql root  4.0K 2010-04-14 10:30 mysql
    -rw-------  1 root  root     7 2010-04-14 10:30 mysql_upgrade_info
    my:/var/lib/mysql# 


    Suddenly, after making this post an hour ago, the Monitor is showing some issues:

    2010-04-15 12:24 my.derekgordon.com Error Unable to connect to the databaseCan't create database 'c1derekgor'; database exists
    Delete
    2010-04-15 12:24 my.derekgordon.com Error Error while dropping mysql user: c1derekgord Operation DROP USER failed for 'c1derekgord'@'%'
    Delete
    2010-04-15 12:24 my.derekgordon.com Error Unable to connect to the databaseCan't create database 'c1derekgord'; database exists
    Delete
    2010-04-15 12:24 my.derekgordon.com Error Error while dropping mysql database: c1peruvian Can't drop database 'c1peruvian'; database doesn't exist
    Delete
    2010-04-15 12:24 my.derekgordon.com Error Error while dropping mysql database: c3pwcsportsman Can't drop database 'c3pwcsportsman'; database doesn't exist
    Delete
    2010-04-15 12:24 my.derekgordon.com Error Error while dropping mysql user: c1derekgordon1 Operation DROP USER failed for 'c1derekgordon1'@'%'
    Delete
    2010-04-14 20:44 my.derekgordon.com Debug Unable to connect to the databaseCan't create database 'c3pwcsportsman'; database exists
    2010-04-14 19:02 my.derekgordon.com Debug Unable to connect to the databaseCan't create database 'c1peruvian'; database exists
     

    Attached Files:

    Last edited: Apr 15, 2010
  4. crypted

    crypted New Member

Share This Page