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
Update to ISPConfig 3.0.2.2 and select to reconfigure the database permissions when you update the slave.
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?