Syslog-ng - Historie editací

Quimi v 15. 8. 2012, 09:36

2012-08-15T09:36:17Z

← Starší verze		Verze z 15. 8. 2012, 09:36
Řádek 19:		Řádek 19:
	Do /etc/syslog-ng/syslog-ng.conf přidejte:		Do /etc/syslog-ng/syslog-ng.conf přidejte:

	# Zdroj bude sit		# Zdroj bude sit
	source s_network {		source s_network {
	udp(ip("0.0.0.0") port(514));		udp(ip("0.0.0.0") port(514));
	};		};

	# Cil bude MySQL databaze - staci vytvorit databazi, pokud ma uzivatel prava, tabulka se vytvori sama		# Cil bude MySQL databaze - staci vytvorit databazi, pokud ma uzivatel prava, tabulka se vytvori sama
	destination d_mysql {		destination d_mysql {
	sql(type(mysql)		sql(type(mysql)
	host("localhost") username("syslogwriter") password("syslogwriter-password")		host("localhost") username("syslogwriter") password("syslogwriter-password")
	database("syslog")		database("syslog")
	table("logs")		table("logs")
	columns("host", "facility", "priority", "level", "tag", "datetime", "program", "msg")		columns("host", "facility", "priority", "level", "tag", "datetime", "program", "msg")
	values("$HOST_FROM", "$FACILITY", "$PRIORITY", "$LEVEL", "$TAG", "$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC", "$PROGRAM", "$MSG")		values("$HOST_FROM", "$FACILITY", "$PRIORITY", "$LEVEL", "$TAG", "$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC", "$PROGRAM", "$MSG")
	indexes("host", "facility", "priority", "datetime", "program"));		indexes("host", "facility", "priority", "datetime", "program"));
	};		};

	log { source(s_network); destination(d_mysql); };		log { source(s_network); destination(d_mysql); };

Quimi v 15. 8. 2012, 09:35

2012-08-15T09:35:47Z

@@ Řádek 3: / Řádek 3: @@
   apt-get install syslog-ng libdbd-mysql
 source s_network {
          udp(ip("0.0.0.0") port(514));
 };
 destination d_mysql {
          sql(type(mysql)
@@ Řádek 17: / Řádek 35: @@
 };
-CREATE DATABASE `syslog` DEFAULT CHARACTER SET utf8 COLLATE utf8_czech_ci;
+ log { source(s_network); destination(d_mysql); };

Quimi v 15. 8. 2012, 08:50

2012-08-15T08:50:06Z

← Starší verze		Verze z 15. 8. 2012, 08:50
Řádek 1:		Řádek 1:
	Instalace:		Instalace:

	apt-get install syslog-ng		apt-get install syslog-ng libdbd-mysql

			source s_network {
			udp(ip("0.0.0.0") port(514));
			};

	destination d_mysql {		destination d_mysql {

Quimi: Založena nová stránka: Instalace: apt-get install syslog-ng destination d_mysql { sql(type(mysql) host("localhost") username("syslogwriter") password("syslogwriter-password") ...

2012-08-15T08:38:54Z

Založena nová stránka: Instalace: apt-get install syslog-ng destination d_mysql { sql(type(mysql) host("localhost") username("syslogwriter") password("syslogwriter-password") ...

Nová stránka

Instalace:

apt-get install syslog-ng

destination d_mysql {
sql(type(mysql)
host("localhost") username("syslogwriter") password("syslogwriter-password")
database("syslog")
table("logs")
columns("host", "facility", "priority", "level", "tag", "datetime", "program", "msg")
values("$HOST_FROM", "$FACILITY", "$PRIORITY", "$LEVEL", "$TAG", "$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC", "$PROGRAM", "$MSG")
indexes("host", "facility", "priority", "datetime", "program"));
};

CREATE DATABASE `syslog` DEFAULT CHARACTER SET utf8 COLLATE utf8_czech_ci;

CREATE USER 'syslogwriter'@'localhost' IDENTIFIED BY 'syslogwriter-password';

GRANT USAGE ON * . * TO 'syslogwriter'@'localhost' IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

GRANT ALL PRIVILEGES ON `syslog` . * TO 'syslogwriter'@'localhost';