Re: [Php-syslog-ng-support] Problem accessing logs after log rotation

2007-07-05 Thread Clayton Dukes
ahh yes, the ol date entry issue -- unfortunatley it's on the "to do" list. If anyone feels like fixing it, have at it :-) On 7/5/07, Jon Whittington <[EMAIL PROTECTED]> wrote: Thank you for the reply, That test was successful. It returned all logs from the July 1, 2007 -> now. This also

Re: [Php-syslog-ng-support] Problem accessing logs after log rotation

2007-07-05 Thread Jon Whittington
Thank you for the reply, That test was successful. It returned all logs from the July 1, 2007 -> now. This also worked for the logs2007 table. Do you have any idea how I can fix the queries so that the log2007 and default all_logs queries run properly (ie. without setting a TO a

Re: [Php-syslog-ng-support] Problem accessing logs after log rotation

2007-07-05 Thread Sergio Guzman
On Jul 5, 2007, at 7:28 AM, Jon Whittington wrote: Summary: The complete logs are confirmed in the Database – the web application just isn’t able to retrieve anything except the current day. It seems to me that it's something with the query itself. Have to tried using all_logs, and

Re: [Php-syslog-ng-support] Problem accessing logs after log rotation

2007-07-05 Thread Jon Whittington
I wasn’t able to locate a log file for the script (I didn’t create one), But I ran the cron job manually. Here are some details: 1. Contents of the cronjob: [EMAIL PROTECTED] cron.daily]# cat syslogrotate #!/bin/sh php /var/www/html/php-syslog-ng/scripts/logrotate.php 2.

Re: [Php-syslog-ng-support] Problem accessing logs after log rotation

2007-07-05 Thread Clayton Dukes
take a loog at the script's log file (or the output from running logrotate.php) and let me know whet it is. On 7/5/07, Jon Whittington <[EMAIL PROTECTED]> wrote: Hello, I have run into a bit of snag with my php-syslog-ng installation since enabling the logrotation feature. When the logr

[Php-syslog-ng-support] Problem accessing logs after log rotation

2007-07-05 Thread Jon Whittington
Hello, I have run into a bit of snag with my php-syslog-ng installation since enabling the logrotation feature. When the logrotation script runs (at midnight) it creates the correct log2007 table and all_logs merge table but when trying to search the data from these tables nothing is