Syslog-ng mysql php - Cronologia

WikiSysop il 13:15, 8 gen 2020

2020-01-08T13:15:08Z

← Versione meno recente		Versione delle 13:15, 8 gen 2020
Riga 41:		Riga 41:
	Reference: http://www.rsyslog.com/doc-rsyslog_php_syslog_ng.html		Reference: http://www.rsyslog.com/doc-rsyslog_php_syslog_ng.html

			[[Categoria:Unix]]
	[[Categoria:OpenSource]]		[[Categoria:OpenSource]]
	[[Categoria:Linux]]		[[Categoria:Linux]]

WikiSysop il 10:27, 14 mag 2010

2010-05-14T10:27:30Z

← Versione meno recente		Versione delle 10:27, 14 mag 2010
Riga 36:		Riga 36:

	$template syslog-ng,"insert into logs(host, facility, priority, tag, date, time, msg) values ('%HOSTNAME%', %syslogfacility%, %syslogpriority%, '%syslogtag%', '%timereported:::date-mysql%', '%timereported:::date-mysql%', '%msg%')", SQL		$template syslog-ng,"insert into logs(host, facility, priority, tag, date, time, msg) values ('%HOSTNAME%', %syslogfacility%, %syslogpriority%, '%syslogtag%', '%timereported:::date-mysql%', '%timereported:::date-mysql%', '%msg%')", SQL
	. :ommydb:mysql-server,syslog,user,pass;syslog-ng		. :ommydb:mysql-server,syslog,user,pass;syslog-ng
	</pre>		</pre>

WikiSysop il 10:25, 14 mag 2010

2010-05-14T10:25:38Z

Nuova pagina

=Syslog-ng web gui=

*configurare syslog-ng in modo da scrivere i log in mysql

http://plone.jcu.edu.au/hpc/staff/projects/php-syslog-ng/configuration-of-syslog-ng/

*installare php-syslog-ng da http://code.google.com/p/php-syslog-ng/downloads/list

*Se utilizzate syslog-ng aggiungere le seguenti righe a /etc/syslog-ng/syslog-ng.conf

<pre>
destination d_mysql { program("/usr/bin/mysql --user=syslogfeeder --password=XXXXXXXXX syslog < /var/log/mysql.pipe");
pipe("/var/log/mysql.pipe"
template("INSERT INTO logs (host,facility,priority,level,tag,datetime,program,msg,seq)
VALUES ('$HOST','$FACILITY','$PRIORITY','$LEVEL','$TAG','$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC','$PROGRAM','$MSG','$SEQ');\n")
template-escape(yes)); };

log {
source(s_all);
destination(d_mysql);
};
</pre>

*Se invece si utilizza rsyslog, aggiungere in /etc/rsyslog.conf
<pre>

$ModLoad ommysql
*.* :ommysql:database-server,database-name,database-userid,database-password

$template syslog-ng,"insert into logs(host, facility, priority, tag, date, time, msg) values ('%HOSTNAME%', %syslogfacility%, %syslogpriority%, '%syslogtag%', '%timereported:::date-mysql%', '%timereported:::date-mysql%', '%msg%')", SQL
*.* :ommydb:mysql-server,syslog,user,pass;syslog-ng
</pre>

Reference: http://www.rsyslog.com/doc-rsyslog_php_syslog_ng.html

[[Categoria:OpenSource]]
[[Categoria:Linux]]