Re: [syslog-ng]Old Syslog Data

On Tue, 23 Dec 2003, Michael Boman wrote:

Date: Tue, 23 Dec 2003 09:44:09 +0800 From: Michael Boman <michael.boman@securecirt.com> Reply-To: syslog-ng@lists.balabit.hu To: Syslog-NG ML <syslog-ng@lists.balabit.hu> Subject: Re: [syslog-ng]Old Syslog Data

On Tue, 2003-12-23 at 03:45, Asif Iqbal wrote:

...

Hi All

I am using syslog-ng which pipes the log to mysql database in this format

host, facility, priority, level, tag, date, time, program, msg

I installed the php plugin and now I can browse through the web real fast.

Is there a way I can push all the previous logs in the database in the same format ? That way users can also look at the previous datam

Thanks

Were you running syslogd or syslog-ng (and log to a file) before? By

I was using syslogd in the past until I found this awesome tool

default neither of these formats contain facility and priority settings, but apart from that there shouldn't be any problems importing the old logs into a database with some perl scripting.

Any hint or example would be greatly appreciated

For speed reasons I would cut up the message with a unique delimeter and use mysqlimport instead of hundreds if not thousands of INSERT commands, but of course the later also works.

Best regards Michael Boman

Thanks a lot -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08 There's no place like 127.0.0.1