[syslog-ng]Old Syslog Data

[Asif Iqbal]

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