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 July 2010, 15:04
damir damir is offline
Senior Member
 
Join Date: Jun 2006
Posts: 375
Thanks: 11
Thanked 51 Times in 42 Posts
Default Dbispconfig log tables are getting large and not getting deleted.

I have couple of questions regarding log tables in dbispconfig.

I'm running Debian Lenny 5.0.4 with 3 ispconfig server, one master and two slaves. I saw that my backups of ispconfig .sql files where over 40MB and that was strange because i have not added that many clients.

I compared with .sql backup before i upgraded to 3.0.2.1 from 3.0.1.6 and old ones are 2-3MB large. I logged in through phpmyadmin and saw that monitor_data tables is 12MB large and sys_log 23MB.

Somehow they are not deleted or is there any rotation or scripts that deletes those files? Can i empty those tables without affecting dbispconfig functionality.

Going through log files i can see millions of following warning messages:

Slave 1:
DB::query(DELETE FROM monitor_data WHERE type ='sys_log' AND created < 1279196702) -> mysql_query SELECT command denied to user 'ispcsrv2'@'mail.server.com' for column 'type' in table 'monitor_data'

Slave 2:
DB::query(DELETE FROM monitor_data WHERE type ='sys_log' AND created < 1279196702) -> mysql_query SELECT command denied to user 'ispcsrv3'@'web.server.com' for column 'type' in table 'monitor_data'

Thanx in advance
Reply With Quote
Sponsored Links
  #2  
Old 15th July 2010, 15:33
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

Update to ISPConfig 3.0.2.2 and select to reconfigure the database permissions when you update the slave.
__________________
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:
damir (15th July 2010)
  #3  
Old 15th July 2010, 15:38
damir damir is offline
Senior Member
 
Join Date: Jun 2006
Posts: 375
Thanks: 11
Thanked 51 Times in 42 Posts
Default

I will try that. Do i need to manually delete logs from tables or is it the script that does the cleaning of current logs?
Reply With Quote
  #4  
Old 15th July 2010, 15:41
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
 
Default

The script will do the cleanup on a nightly basis after you updated master and slaves.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
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


All times are GMT +2. The time now is 16:19.


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