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 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. 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 -- Michael Boman Security Architect, SecureCiRT Pte Ltd http://www.securecirt.com