Re: Problem accessing logs after log rotation

Thank you for the reply,

 

That test was successful.  It returned all logs from the July 1, 2007 -> now.  This also worked for the logs2007xxxx table.

 

Do you have any idea how I can fix the queries so that the log2007xxxx and default all_logs queries run properly (ie. without setting a TO and FROM date?

 

 

Cheers,

 

Jon Whittington

 

From: Sergio Guzman [mailto:sergio@xxxxxxxxxxxxxx]
Sent: Thursday, July 05, 2007 10:44 AM
To: php-syslog-ng-support@xxxxxxxxxxxxxxxxxxxxx
Cc: Jon Whittington
Subject: Re: [Php-syslog-ng-support] Problem accessing logs after log rotation

 

 

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 selecting in the date fields let's say:

 

from:    2007-07-01 00:00:00

to:    now

 

I never get any results from yesterday or before, using the default form, only today's.

 

cheers,

 

-- 

Sergio Guzmán

San José, Costa Rica

Tel: (506) 258-5757

http://www.gridshield.net/

Gridshield: Protección y Monitoreo de Redes

 

 

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.10.0/886 - Release Date: 7/4/2007 1:40 PM

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.10.0/886 - Release Date: 7/4/2007 1:40 PM

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/

_______________________________________________
Php-syslog-ng-support mailing list
Php-syslog-ng-support@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support