domain and database not creating

[crypted]

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.



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

[till]

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.

[crypted]

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.

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

[crypted]

I let it sit for about three hours, and it fixed itself. And now the databases are being created. That was really messed up.

Now, onto another problem. http://www.howtoforge.com/forums/showthread.php?p=225406#post225406