Rozdíly

Zde můžete vidět rozdíly mezi vybranou verzí a aktuální verzí dané stránky.

--- linux:system:syslog [15.02.2012 08:29]
mtalma [Instalace]
+++ linux:system:syslog [13.03.2020 18:43] (aktuální)
@@ Řádek 43: / Řádek 43: @@
   *nainstalovat syslog-ng 2.1
-==== sysog-ng.conf ====
-<code>
+  -<code>mkfifo /var/log/mysql.pipe</code>
+  -mysql<code>
+create database syslog-ng;
+use syslog;
+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, datetime datetime default NULL, program varchar(15) default NULL, msg text, seq bigint(20) unsigned NOT NULL auto_increment, PRIMARY KEY (seq), KEY host (host), KEY program (program), KEY datetime (datetime), KEY priority (priority), KEY facility (facility) ) TYPE=MyISAM;
+</code>
+  -sysog-ng.conf<code>
 source s_remote {
 	udp();
@@ Řádek 50: / Řádek 56: @@
 };
 destination d_mysql {
-	program("/usr/bin/mysql --user=USERNAME --password=PASSWORD syslog < /var/log/mysql.pipe");
+	program("/usr/bin/mysql --user=USERNAME --password=PASSWORD syslog-ng < /var/log/mysql.pipe");
 	pipe("/var/log/mysql.pipe" template("INSERT INTO logs (host, facility, priority, level, tag, datetime, program, msg) VALUES ( '$HOST', '$FACILITY', '$PRIORITY', '$LEVEL', '$TAG', '$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC','$PROGRAM', '$MSG' );\n") template-escape(yes));
 };
 log { source(s_remote); destination(d_mysql); };
 </code>