topic Re: Syslog in Operating System - HP-UX

Syslog

Daniel Fourie — Tue, 10 Jun 2003 10:58:53 GMT

I need to log all my syslog messages to a database.

Can somebody help??

Re: Syslog

Karthik S S — Tue, 10 Jun 2003 11:20:38 GMT

As you must be aware that the syslog.log file is a text file and is dynamic by nature instead of loggin it again to a database you can retain snapshots of it by scheduling a to take a backup of that file at particular intervals. It also makes sense to have such cron job in place as you will losing the old syslog files after two successive reboot.

I think with oracle you can import the plain text files to the database (Using imp command). However I am not sure on how to constantly update the database with the growing syslog information.

Regards,
Karthik S S

Regards,
Karthik

Re: Syslog

Karthik S S — Tue, 10 Jun 2003 11:23:59 GMT

Hi,

I found a Doc. which is similar to you requirement. The following link explains how to save an Apache log file in a PostgreSQL database,

http://www.linuxworld.com/site-stories/2001/0910.pglogd.html

Regards,
Karthik S S

Re: Syslog

Laurent Laperrousaz — Thu, 12 Jun 2003 13:50:50 GMT

use a perl script based on the perl:multitail module which gives you means to tail a file.

You can parse any log

Then you can easily connect to your database thru the correct Perl module and insert records in a table...

That's it

Enjoy

Laurent

Re: Syslog

Massimo Bianchi — Thu, 12 Jun 2003 13:55:21 GMT

Hi,
apart from custom jobs, the syslog.log is never deleted untill reboot.

So, if you place a script rc that makes and additional copy of syslog, you can do all your processing offline.

Into which db you wuold kine to put the messages ?

HTH,
Massimo

Re: Syslog

David_246 — Thu, 12 Jun 2003 13:57:19 GMT

Hi mister matrix :)

I use logsurfer to redirect my syslog messages to, in my case, an e-mail program.
Why not redirect each new line to a database argument ?
It does require a little time.

If you really are interested in a daemon logsurfer running on your system collecting data from any logfile you specify, I am happy to help and give you the source. Please send an e-mail to me then at david.vandergeer@axa.nl

Regs David