Re: [Php-syslog-ng-support] Logrotate.php

2006-09-19 Thread Vadim Pushkin
OK, this is diff from what I am running and from what Ian posted, but I will run this and let you know my results tomorrow.' Thanks! .vp >Hmmm... >Not sure, try this script: > >#!/usr/bin/php >// Copyright (C) 2005 Claus Lund, [EMAIL PROTECTED] >echo "\nStarting logrotate\n"; >echo date("Y-m-d

Re: [Php-syslog-ng-support] Logrotate.php

2006-09-19 Thread Clayton Dukes
Hmmm... Not sure, try this script: #!/usr/bin/php $tableDate) { echo "Dropping ".$value."!\n"; $query = "DROP TABLE ".$value; perform_query($query, $dbLink); } }

Re: [Php-syslog-ng-support] Logrotate.php

2006-09-19 Thread Vadim Pushkin
but both logs20060917 and logs20060917 are *not* older than 2. If I set this to 90, then I will have to wait 90 days to encounter this bug. It keeps the proper tablename in the pulldown, the tables exist, and contain data, but I am unable to search them using the GUI. .vp >Well that's why, i

Re: [Php-syslog-ng-support] Logrotate.php

2006-09-19 Thread Clayton Dukes
Well that's why, if you set retention to 2, it will delete anything older. Try setting to 90 On 9/19/06, Vadim Pushkin <[EMAIL PROTECTED]> wrote: > HI Clayton; > > Welcome back! > > I am still having one issue, I am able to see data when using the pulldown > for either: > > logs > all_logs > logs

Re: [Php-syslog-ng-support] Logrotate.php

2006-09-19 Thread Vadim Pushkin
HI Clayton; Welcome back! I am still having one issue, I am able to see data when using the pulldown for either: logs all_logs logs20060919 (today) I am *unable* to see any data for either: logs20060917 (two days ago) logs20060918 (yesterday) Incidentally, all_logs and logs contain only wh

Re: [Php-syslog-ng-support] Logrotate.php

2006-09-19 Thread Clayton Dukes
I've confirmed that the logrotate fixes are working as well. On 8/31/06, Vadim Pushkin <[EMAIL PROTECTED]> wrote: > Great news Ian. Are you also able to see data within the various logs with > a date? > > Regards, > > .vp > > >I incorporated MattW's fix into logrotate.php which you can find as a