[syslog-ng] syslog-ng & mysql set up for network devices only

Patrick Topping ptopping at pobox.com
Fri Mar 31 20:33:16 CEST 2006


I have a MySQL question that I hope does not sound to 'newbie-ish'..:-)  
I have just set up a new server for logging all the network devices.  
Syslog-ng is working fine and now I am ready to move onto setting up the 
MySQL side.  I was wondering if any had created a MySQL database 
specifically for network devices and if it was significantly different 
than what is on the following URL:

http://vermeer.org/display_doc.php?doc_id=1

CREATE TABLE logs (
host varchar(32) default NULL,
facility varchar(10) default NULL,
priority varchar(10) default NULL,
level varchar(10) default NULL,
tag varchar(10) default NULL,
date date default NULL,
time time default NULL,
program varchar(15) default NULL,
msg text,
seq int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (seq),
KEY host (host),
KEY seq (seq),
KEY program (program),
KEY time (time),
KEY date (date),
KEY priority (priority),
KEY facility (facility)
) TYPE=MyISAM;

The question that I have relates to following tables in the DB:

priority :  where would this come into play for network devices?

level:  not sure what this is

tag: where would this come into play for network devices?

program: where would this come into play for network devices?

If there is anyone who could help me with this network specific DB I 
would appreciate it.  Thanks in advance.

-Patrick









More information about the syslog-ng mailing list