Hello Mikael; Here are my current issues.
1. Logrotate (the one that comes stock because I was unable to work out several bugs with the "modified" version) does not rotate to the correct number of days. My LOGROTATE entry has a 2. Here is what my syslog DB has in terms of tables as of right now: mysql> show tables; +------------------ | Tables_in_syslog +----------------- | actions | all_logs | cemdb | logs | logs20060717 | logs20060718 | logs20060719 | search_cache | user_access | users +----------------- 10 rows in set (0.00 sec) 2. This AM, I had to edit all_logs.MRG, had to remove logs20060716, which was no longer available, presumably dropped as it should have been, but why not logs20060717 as well? PS I am running logrotate at 00:15 HRS and without the removal of logs20060716, the front-end would not work. The below is as of right now (mid-day). [root /]# cat /var/lib/mysql/syslog/all_logs.MRG logs logs20060717 logs20060718 logs20060719 3. Within mysql, tablename "search_cache" shows hostnames in "logs" for srv-www-001, this was one of the "canned" hostnames that Clayton provided as a test. They *do not* live in the logs table, though they *may* live under all_logs, so why are they still there? And how do I remove them? With regads to MERGE tables, what version of MySql are you running? I *believe* that this feature will not work on earlier version of MySql. I hope someone, hopefully someone with far more ability to do something about this than I, will find this info useful :) .vp >From: "Freeman, Michael" <[EMAIL PROTECTED]> >Did you get anywhere with logrotate.php? >Can someone please explain to me what is going on with MERGE tables in >2.9.2? >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf >Of Vadim Pushkin >Sent: Saturday, July 15, 2006 2:00 PM >To: php-syslog-ng-support@lists.sourceforge.net >Subject: [Php-syslog-ng-support] LogRotate (V2.9.2 tested) > >Hello All; > >I've downloaded and am testing the latest (2.9.2) and have set LOGROTATE >to >2 within my config.php file. So far, I now have 3 days worth of data, >when I should have just 2. > >I have *not* re-created my SQL db, and assuming this does not matter, am >I the only one with this problem? > >Thanks, > >.vp ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Php-syslog-ng-support mailing list Php-syslog-ng-support@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
