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 15th March 2011, 18:20
stresao stresao is offline
Junior Member
 
Join Date: Mar 2011
Posts: 4
Thanks: 2
Thanked 0 Times in 0 Posts
Default Not removing mysql jobs in pool

Hi!

I have a multiserver setup in mirror with master to master mysql replication. Lately I'm having severals problems with databases with ISPConfig.

When I create or delete a database, the cron server.sh do it right but it does not dissapears from sys_datalog and the cron gets stucked the next time because the database exits.

I have to manual delete the job from the sys_datalog sql to get things done... but I have to do that every time I manipulated any database trough ISPConfig.

Can anybody help me?

Regards.
Reply With Quote
Sponsored Links
  #2  
Old 15th March 2011, 18:32
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,733
Thanks: 840
Thanked 5,596 Times in 4,407 Posts
Default

Quote:
does not dissapears from sys_datalog
Thats intended, jobs shall not be removed there when they are finished. Removing them manually or truncating the table will corrupt the system as it resets the ID. The jobs get kept there for 30 days. Instead of removing the job, the last processed job id is stored in the "updated" column of the server table.

Did you mirror the ispconfig database or just the client databases?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
stresao (15th March 2011)
  #3  
Old 15th March 2011, 18:34
stresao stresao is offline
Junior Member
 
Join Date: Mar 2011
Posts: 4
Thanks: 2
Thanked 0 Times in 0 Posts
Default

Thanks for respondo Till,

Every server has his own database (like docs says). The first server is dbispconfig1 and the second is dbispconfig2.

About the database replication the dbispconfig1 does not exists in server2.

when I added a new database and run server.sh I see:

15.03.2011-17:34 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
15.03.2011-17:34 - DEBUG - Found 1 changes, starting update process.
15.03.2011-17:34 - DEBUG - Calling function 'db_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_insert'.
15.03.2011-17:34 - DEBUG - Created MySQL database: XXXXXX

Warning: mysql_select_db(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 96

Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 63

Warning: mysql_error(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 64
15.03.2011-17:34 - DEBUG - Processed datalog_id 1391

Warning: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 176

Warning: mysql_select_db(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 96

Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 63

Warning: mysql_error(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 64

Warning: mysql_select_db(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 96

Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 63

Warning: mysql_error(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 64
15.03.2011-17:34 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock

Warning: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 176

Warning: mysql_select_db(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 96

Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 63

Warning: mysql_error(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 64

Warning: mysql_select_db(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 96

Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 63

Warning: mysql_error(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 64
finished.


When I run server.sh again it says:



15.03.2011-17:38 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
15.03.2011-17:38 - DEBUG - Found 1 changes, starting update process.
15.03.2011-17:38 - DEBUG - Calling function 'db_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_insert'.
15.03.2011-17:38 - DEBUG - Unable to create the database: Can't create database 'jon_arribas_1'; database exists

Warning: mysql_select_db(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 96

Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 63

Warning: mysql_error(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 64
15.03.2011-17:38 - DEBUG - Processed datalog_id 1391

Warning: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 176

Warning: mysql_select_db(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 96

Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 63

Warning: mysql_error(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 64

Warning: mysql_select_db(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 96

Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 63

Warning: mysql_error(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 64
15.03.2011-17:38 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock

Warning: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 176

Warning: mysql_select_db(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 96

Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 63

Warning: mysql_error(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 64

Last edited by stresao; 15th March 2011 at 18:42.
Reply With Quote
  #4  
Old 15th March 2011, 18:43
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,733
Thanks: 840
Thanked 5,596 Times in 4,407 Posts
Default

Ok, so there seems a different problem. ISPConfig has to stop the processing because its not able to create the mysql database.

Please check that the root login details which are required to create new mysql databases in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf are correct.

And the ispconfig version that you use is 3.0.3.2?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
stresao (15th March 2011)
  #5  
Old 15th March 2011, 18:46
stresao stresao is offline
Junior Member
 
Join Date: Mar 2011
Posts: 4
Thanks: 2
Thanked 0 Times in 0 Posts
Default

Thanks again Till,

It's incredible but the database is created!

The version is 3.0.3.2 and the login details are correct.

I'm going crazy!
Reply With Quote
  #6  
Old 19th April 2011, 00:02
klocika klocika is offline
Junior Member
 
Join Date: Sep 2008
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Till, Stresao,

Same problem here. Did you find the solution?

PHP Warning: mysql_select_db(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 96
PHP Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 63
PHP Warning: mysql_error(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 64

Thank you
Reply With Quote
  #7  
Old 19th April 2011, 20:48
stresao stresao is offline
Junior Member
 
Join Date: Mar 2011
Posts: 4
Thanks: 2
Thanked 0 Times in 0 Posts
Default Reinstall

I had to Reinstall :-(

Quote:
Originally Posted by klocika View Post
Hi Till, Stresao,

Same problem here. Did you find the solution?

PHP Warning: mysql_select_db(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 96
PHP Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 63
PHP Warning: mysql_error(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 64

Thank you
Reply With Quote
  #8  
Old 19th April 2011, 20:57
klocika klocika is offline
Junior Member
 
Join Date: Sep 2008
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'm sad as read this.

My system is working fine, if I stop server.sh CRON. All I have to do is run server.sh when changing anything than kill.

It would be nice to find the solution.

My setup has 100+ websites, I don't want to rebuild.

Anyway, thanks for your reply.
Reply With Quote
  #9  
Old 20th April 2011, 10:25
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,733
Thanks: 840
Thanked 5,596 Times in 4,407 Posts
Default

I dont think that a reinstall is required. What exactly did you do or reconfigure or update on the server before the problem started?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #10  
Old 20th April 2011, 11:03
klocika klocika is offline
Junior Member
 
Join Date: Sep 2008
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Thanks for your reply Till,

The problem is occured since I installed zend.
My ISPConfig was 3.0.3.2, i've updated to 3.0.3.3 but still persists.

ISPConfig can access the database, but the CRON crashes I have to kill it everytime.
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
CPU load locks up box. Apache or MYSQL related. crypted General 61 29th October 2010 23:16
Squirrelmail login failure Cracklefish Installation/Configuration 9 30th June 2010 21:38
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 14:58
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04


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


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