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 10th January 2012, 05:02
crazylamp crazylamp is offline
Junior Member
 
Join Date: Jul 2010
Posts: 6
Thanks: 0
Thanked 1 Time in 1 Post
Default ISPconfig 3: can't add new database

When I add a new database(c1test, etc), there was no error occur in the UI, and it seems create database succesfully.. but acctualy there is no 'c1test' exist in the mysql database..
and the apache log as bellow:

Code:
[Tue Jan 10 11:36:13 2012] [error] [client 113.96.206.237] PHP Notice:  Undefined index: remote_access in /usr/local/ispconfig/interface/lib/classes/validate_database.inc.php on line 39, referer: https://www.xxx.com:82/index.php
[Tue Jan 10 11:36:13 2012] [error] [client 113.96.206.237] PHP Notice:  Undefined index: on_after_insert in /usr/local/ispconfig/interface/lib/classes/plugin.inc.php on line 139, referer: https://www.xxx.com:82/index.php
[Tue Jan 10 11:36:13 2012] [error] [client 113.96.206.237] PHP Notice:  Undefined index: sites:on_after_insert in /usr/local/ispconfig/interface/lib/classes/plugin.inc.php on line 139, referer: https://www.xxx.com:82/index.php
[Tue Jan 10 11:36:13 2012] [error] [client 113.96.206.237] PHP Notice:  Undefined index: sites:database:on_after_insert in /usr/local/ispconfig/interface/lib/classes/plugin.inc.php on line 139, referer: https://www.xxx.com:82/index.php
[Tue Jan 10 11:36:13 2012] [error] [client 113.96.206.237] PHP Notice:  Undefined index: return_to_url in /usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php on line 218, referer: https://www.xxx.com:82/index.php
I can create database before..

Does anybody knows what happening?...

Thanks for any of your help..
Reply With Quote
Sponsored Links
  #2  
Old 10th January 2012, 07:45
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

Just a guess: Have you changed the mysql root passwort without changing it in /usr/local/ispconfig/server/lib/mysql_clientdb.conf? If thats the case, then ispconfig can not create new databases anymore until you change the password in that file too.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 10th January 2012, 08:32
crazylamp crazylamp is offline
Junior Member
 
Join Date: Jul 2010
Posts: 6
Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
Originally Posted by till View Post
Just a guess: Have you changed the mysql root passwort without changing it in /usr/local/ispconfig/server/lib/mysql_clientdb.conf? If thats the case, then ispconfig can not create new databases anymore until you change the password in that file too.
no, i did not change the mysql root password..
Reply With Quote
  #4  
Old 10th January 2012, 08:39
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

Please check if you are able to login to mysql with the username and password on the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf

If that works, then enable debugging in ispconfig and create a new database and post the debug output that you get in the ispconfig.log:

http://www.faqforge.com/linux/contro...n-ispconfig-3/
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 11th January 2012, 04:31
crazylamp crazylamp is offline
Junior Member
 
Join Date: Jul 2010
Posts: 6
Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
Originally Posted by till View Post
Please check if you are able to login to mysql with the username and password on the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf

If that works, then enable debugging in ispconfig and create a new database and post the debug output that you get in the ispconfig.log:

http://www.faqforge.com/linux/contro...n-ispconfig-3/
It works now. Thank you till.

I enabled debugging in ispconfig and i found the monitor_data table was broken.. I just repaird it and everything is ok now..
But i have no idear of how the monitor_data table broken.

Thank you so much, till.
Reply With Quote
  #6  
Old 18th January 2012, 19:10
ArchEnemy ArchEnemy is offline
Junior Member
 
Join Date: Jan 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default No clues on debug mode

Hello,

I have the same problem with ispconfig 3.0.4.2.Can't create database. If I'm looking at dbispconfig database at web_database table I can see the newly added data base.

I can log on with root and password on the mysql server with the mysql client.


And the debug give me no clues.

ispcongih log :

2012-01-18 17:57 xx.xxxxxx.xx Debug There is already an instance of server.php running. Exiting.
2012-01-18 17:56 xx.xxxxxx.xx Debug There is already an instance of server.php running. Exiting.
2012-01-18 17:55 xx.xxxxxx.xx Debug There is already an instance of server.php running. Exiting.
2012-01-18 17:54 xx.xxxxxx.xx Debug There is already an instance of server.php running. Exiting.
2012-01-18 17:53 xx.xxxxxx.xx Debug There is already an instance of server.php running. Exiting.
2012-01-18 17:52 xx.xxxxxx.xx Debug There is already an instance of server.php running. Exiting.
2012-01-18 17:51 xx.xxxxxx.xx Debug There is already an instance of server.php running. Exiting.
2012-01-18 17:50 xx.xxxxxx.xx Debug There is already an instance of server.php running. Exiting.
2012-01-18 17:49 xx.xxxxxx.xx Debug There is already an instance of server.php running. Exiting.
2012-01-18 17:48 xx.xxxxxx.xx Debug There is already an instance of server.php running. Exiting.
2012-01-18 17:47 xx.xxxxxx.xx Debug There is already an instance of server.php running. Exiting.

Any help would be appreciate.

ArchEnemy
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
Problems with SpamSnake ClamAV (Sanesecurity Signatures) tmaleshafske HOWTO-Related Questions 0 21st September 2010 01:59
Hosting multiple websites and webmail dmwcool Installation/Configuration 8 30th March 2010 03:15
ISPConfig not creating user database boxxa General 1 7th February 2009 10:54
Database naming in ISPConfig 2.2.21 different from previous versions rsun Installation/Configuration 1 18th February 2008 17:34
ISPConfig 2.3.2-dev released till General 9 4th June 2007 10:46


All times are GMT +2. The time now is 13:32.


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