Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 19th May 2009, 00:29
binaryrogue binaryrogue is offline
Member
 
Join Date: Apr 2008
Posts: 89
Thanks: 5
Thanked 0 Times in 0 Posts
Default Creating of Database stopped working

If I go to: [Sites --> Database] and create a new database under my server, it creates it and shows that it was created. If I look at the actual database, it's not there. The users were never created as well...

I have create a few other database the same way before and it was fine. It just won't create the databases and privileges any longer even though it shows on the interface.

any logs for me to look at to see why ispconfig is not creating the databases?

Update* - I see the entries being created under [dbispconfnig --> web_database] but the actual database and user does not get created.

Last edited by binaryrogue; 19th May 2009 at 01:25.
Reply With Quote
Sponsored Links
  #2  
Old 19th May 2009, 09:21
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,486
Thanks: 813
Thanked 5,256 Times in 4,121 Posts
Default

as usual, take a look in the monitor and search for error messages.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 19th May 2009, 18:35
binaryrogue binaryrogue is offline
Member
 
Join Date: Apr 2008
Posts: 89
Thanks: 5
Thanked 0 Times in 0 Posts
Default

Seems to be too many connections to the database? php errors?

When I open up my ispconfig ui, I get this:

HTML Code:
Too many connections
If I look at the server processes under phpmyadmin, I get a ton of lines that says:

HTML Code:
ispconfig localhost dbispconfig sleep
If I do a ps aux | grep "php" | wc -l on the cli, there are 292 php processes.
Reply With Quote
  #4  
Old 20th May 2009, 01:14
binaryrogue binaryrogue is offline
Member
 
Join Date: Apr 2008
Posts: 89
Thanks: 5
Thanked 0 Times in 0 Posts
Default

What's the process that writes the data from web_database to creating the actual database?

I have two Ispconfig servers doing replication. If I create a database on server1, it does not create the database. If I create a database on server2 it creates just fine. This was all working before.. so something must have broke.

note - I have never logged onto the second ispconfig to do anything.
Reply With Quote
  #5  
Old 20th May 2009, 10:22
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,486
Thanks: 813
Thanked 5,256 Times in 4,121 Posts
Default

I haope that you did not logged into the second server to create the databse or your system is now ina inconsistent state as you can not have 2 controlpanels in a replication setup!

Does the master node has current monitoring data from the slave? If not, then there is most likely a mysql permission problem that prevents the slave to connect to the master server or you blocked the connection with a firewall.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 20th May 2009, 23:38
binaryrogue binaryrogue is offline
Member
 
Join Date: Apr 2008
Posts: 89
Thanks: 5
Thanked 0 Times in 0 Posts
 
Default

I don't know what it was, but the last email domain I created under the Email section seemed to caused the issue some how.. Doing a top cmomand on the server showed a a lot of process trying to create a virtual user inbox and couldn't. I remove the email domain and it all started to work again. I was able to create databases on the primary server once again.

I don't know exactly what the issue was..
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
ispconfig stopped creating Maildir etc bwrob Installation/Configuration 2 7th May 2010 22:07
GeoIP not working? Possible bad database? lordshadow HOWTO-Related Questions 3 18th March 2009 18:53
Mail System doesnt work! crichton Installation/Configuration 3 17th September 2007 23:49
ISPConfig 2.2.14 released till General 48 19th July 2007 23:46
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 01:08.


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