From b467b44dae691c14cd2ddbaf90467e75063a237b Mon Sep 17 00:00:00 2001
From: Rainer Gerhards This module provides native support for logging to MySQL databases. It offers
superior performance over the more generic omlibdbi module.
Configuration Directives: ommysql mostly uses the "old style" configuration, with almost everything on the
-action line itself. A few newer features are being migrated to the new style-config
-directive configuration system.
+ Action Parameters: Legacy (pre-v6) Configuration Directives: ommysql mostly uses the "very old style" (v0) configuration, with almost everything on the
+action line itself.
+
-
+
Permits to select
+
Name or address of the MySQL server
+
Permits to select
a non-standard port for the MySQL server. The default is 0, which means the
-system default port is used. There is no need to specify this directive unless
+system default port is used. There is no need to specify this parameter unless
you know the server is running on a non-standard listen port.
-
Permits the selection
+
Database to use
+
logon userid used to connect to server. Must have proper permissions.
+
the user's password
+
Template to use when submitting messages.
+
Permits the selection
of an optional MySQL Client Library configuration file (my.cnf) for extended
configuration functionality. The use of this configuration directive is necessary
only if you have a non-standard environment or if fine-grained control over the
database connection is desired.
Permits the selection of the
-section within the configuration file specified by the $OmMySQLConfigFile directive.
+
Permits the selection of the
+section within the configuration file specified by the myselconfig.file parameter.
This will likely only be used where the database administrator provides a single
configuration file with multiple profiles.
-
This configuration directive is ignored unless $OmMySQLConfigFile is also used
-in the rsyslog configration file.
+
This configuration parameter is ignored unless mysqlconfig.file is also used.
If omitted, the MySQL Client Library default of "client" will be used.
+
@@ -57,15 +66,20 @@ database "syslog_db" on mysqlsever.example.com. The server is
being accessed under the account of "user" with password "pwd".
:ommysql:database-server,database-name,database-userid,database-password
All parameters should be filled in for a successful connect.
Legacy Sample:
+The same as above, but in legacy config format (pre rsyslog-v6): +
[rsyslog.conf overview] [manual index] [rsyslog site]
This documentation is part of the
-rsyslog
-project.
-Copyright © 2008, 2009 by Rainer Gerhards and
+rsyslog project.
+Copyright © 2008-2012 by Rainer Gerhards and
Adiscon.
-Released under the GNU GPL version 3 or higher.