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