Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 15th April 2010, 08:24
crypted crypted is offline
Senior Member
 
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 14 Times in 6 Posts
Default domain and database not creating

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 by crypted; 15th April 2010 at 09:21.
Reply With Quote
Sponsored Links
  #2  
Old 15th April 2010, 10:18
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,046
Thanks: 826
Thanked 5,389 Times in 4,234 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 15th April 2010, 16:55
crypted crypted is offline
Senior Member
 
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 14 Times in 6 Posts
Default

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 Images
 

Last edited by crypted; 15th April 2010 at 18:35.
Reply With Quote
  #4  
Old 16th April 2010, 03:09
crypted crypted is offline
Senior Member
 
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 14 Times in 6 Posts
 
Default

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/sho...406#post225406
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
freebsd 7, samba 3, domain controller alexdimarco Suggest HOWTO 6 5th November 2010 16:54
Postfix not responding to telnet CarbonCopy Server Operation 6 8th May 2009 05:39
CentoS doesn't send the emails vaio1 Installation/Configuration 18 5th November 2008 17:51
OpenLDAP + Samba Domain Controller On Ubuntu 7.10 E1sbaer HOWTO-Related Questions 3 7th May 2008 18:41
Problem with the apache (I can't start ist) M.Behrens Installation/Configuration 11 31st March 2006 10:48


All times are GMT +2. The time now is 02:12.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.