[jffnms-users] syslog-ng and postgresql - date of events problem

[MOYA Yves]

Hello,   I have a script who takes syslog-ng log for make sql for insert into jffnms database in table syslog to use with pgsql command.   An extract of this sql is:   INSERT INTO syslog (date, date_logged, host, message) VALUES ('2005-05-19 09:13:59', NOW(), '192.168.16.69/192.168.16.69', 'May 19 2005 10:06:40 PIXLAN2LAN : %PIX-4-106023: Deny udp src outside:10.1.254.172/14247 dst inside:192.168.1.2/14247 by access-group \"outside_access_in\"');   The type of date_logged is timestamp in table syslog in pgsql database but the php (maybe?) use as timestamp without time zone. So when I go to the site, in the events the date is wrong.   In the database I have:   21853;"773";"2005-05-19 08:52:29";"43";"1";"Login";"successful";"Yoann";"from 192.168.16.150";"0";"1";"0" 21857;"774";"2005-05-19 08:53:17.766829";"29";"1";"inside:SERV1/389";"deny";"outside:10.17.254.2/2548";"udp192.168.16.69/192.168.16.69";"594";"1";"0"   The date in the event viewer appeared as “1 Jan 00:59:59” for the event 21857 but appeared good for the event 21853.   Have you an idea for corrected this? A parameter for NOW()?   Thanks,   Yves