I'm making fixes for that stuff.
Its the .XXXX that is causing parsing problems, so I'm just removing that part
in the event_list function.
Javier
MOYA Yves wrote:
> 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
>
>
>
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Javier Szyszlican, Project Leader, JFFNMS
[EMAIL PROTECTED]
I hope JFFNMS or I were helpful to you, if you
can, please donate at http://jffnms.org/donate
-------------------------------------------------------
This SF.Net email is sponsored by Oracle Space Sweepstakes
Want to be the first software developer in space?
Enter now for the Oracle Space Sweepstakes!
http://ads.osdn.com/?ad_idt12&alloc_id344&op=click
_______________________________________________
jffnms-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jffnms-users
