Russell-IO / php-syslog-ng

Automatically exported from code.google.com/p/php-syslog-ng
1 stars 0 forks source link

No Logs Per Day, no date in DB, no 'time' in search&tail results #153

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What is the expected output? What do you see instead?
1. in /install/sql/dbsetup.sql in CREATE TABLE logs  is no 'datetime' column
2. no any data in TIME column in SEARCH or TAIL results
3. no LOGS PER DAY graph

What version of the product are you using? On what operating system?
logzilla-v2.9.9m
Ubuntu 9.04

Please provide any additional information below.
i created in DB.logs column DATETIME manually. As i can see syslog pushing 
data in DB correctly, datetime now present, but in SEARCH and TAIL RESULTS 
'time' column still empty..

Original issue reported on code.google.com by jevgenij...@gmail.com on 4 Nov 2009 at 1:20

GoogleCodeExporter commented 9 years ago
The datetime column has been replaced by FO and LO (first occurrence and last
occurrence) These fields are useful when deduplication is enabled. if dedup is 
not
enabled, the only the FO column will be displayed (which is the same as 
datetime).
The datetime column should no longer be in the install/dbsetup.sql file.
Did you use the web interface to do the install?

Original comment by cdu...@gmail.com on 13 Nov 2009 at 10:54

GoogleCodeExporter commented 9 years ago
Sorry, my mistake. I used syslog-ng.conf file from old release.
Now i replaced it with new and anything started to work perfectly.
Thanks for your response.

Original comment by jevgenij...@gmail.com on 16 Nov 2009 at 5:13

GoogleCodeExporter commented 9 years ago
Glad it's working.

Closing issue as resolved.
Thanks!

Original comment by cdu...@gmail.com on 18 Nov 2009 at 4:19