-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
feikong0119 said the following on 20/04/09 10:05:
> May you give me an example??
Don't know if it is what you are asking, but this is an example from a working
server:
$ModLoad ommysql # load the output driver (use ompgsql for PostgreSQL)
$template dbFormat,"insert into SystemEvents (Message, Facility,FromHost,
Priority, DeviceReportedTime, ReceivedAt, InfoUnitID, SysLogTag, EventSource,
Fac
ilityText, SeverityText, PriorityText) values ('%msg%', %syslogfacility%,
'%source%',%syslogpriority%, '%timereported:::date-mysql%',
'%timegenerated:::dat
e-mysql%', %iut%, '%syslogtag%', '%programname%', '%syslogfacility-text%',
'%syslogseverity-text%', '%syslogpriority-text%')",sql
*.* :ommysql:localhost,xxxxxxxxxx,yyyyyyyyyyy,pppppppppp;dbFormat
Put db, username and password instead of xxxxx yyyyyy and ppppp
Ciao,
luigi
- --
/
+--[Luigi Rosa]--
\
Only one human captain has ever survived battle with a Minbari fleet.
He is behind me.
You are in front of me.
If you value your lives, be somewhere else.
--Delenn "Severed Dreams"
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAknsSt0ACgkQ3kWu7Tfl6ZQ+vwCgxQZ2v0bE6MGECdCxnYWpl/43
v1UAoJ0j5IA7f/VoPgXWI7GlVEk+rsk+
=bqxB
-----END PGP SIGNATURE-----
_______________________________________________
rsyslog mailing list
http://lists.adiscon.net/mailman/listinfo/rsyslog
http://www.rsyslog.com
