summaryrefslogtreecommitdiffstats
path: root/doc/ommysql.html
diff options
context:
space:
mode:
authorRainer Gerhards <rgerhards@adiscon.com>2008-08-12 16:08:09 +0200
committerRainer Gerhards <rgerhards@adiscon.com>2008-08-12 16:08:09 +0200
commit02f768c37dac9dde424bbd31e378482750fc276c (patch)
tree440b44f612e4db65396da32af10caa5091f96013 /doc/ommysql.html
parent018b2f4c86ca2e4849156db1b1d5b6b3ea9b3e0c (diff)
downloadrsyslog-02f768c37dac9dde424bbd31e378482750fc276c.tar.gz
rsyslog-02f768c37dac9dde424bbd31e378482750fc276c.tar.xz
rsyslog-02f768c37dac9dde424bbd31e378482750fc276c.zip
enhanced ommysql to support custom port to connect to server
Port can be set via new $ActionOmmysqlServerPort config directive Note: this was a very minor change and thus deemed appropriate to be done in the stable release.
Diffstat (limited to 'doc/ommysql.html')
-rw-r--r--doc/ommysql.html46
1 files changed, 46 insertions, 0 deletions
diff --git a/doc/ommysql.html b/doc/ommysql.html
new file mode 100644
index 00000000..79d913eb
--- /dev/null
+++ b/doc/ommysql.html
@@ -0,0 +1,46 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html><head>
+<meta http-equiv="Content-Language" content="en">
+<title>MySQL Database Output Module</title>
+</head>
+
+<body>
+<h1>MySQL Database Output Module</h1>
+<p><b>Module Name:&nbsp;&nbsp;&nbsp; ommysql</b></p>
+<p><b>Author: </b>Michael Meckelein (Initial Author) / Rainer Gerhards
+&lt;rgerhards@adiscon.com&gt;</p>
+<p><b>Description</b>:</p>
+<p>This module provides native support for logging to MySQL databases. It offers
+superior performance over the more generic <a href="omlibdbi.html">omlibdbi</a> module.
+</p>
+<p><b>Configuration Directives</b>:</p>
+<p>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.
+<ul>
+<li><b>$ActionOmmysqlServerPort &lt;port&gt;</b><br>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
+you know the server is running on a non-standard listen port.
+<li>Action parameters:
+<br><b>:ommysql:database-server,database-name,database-userid,database-password</b>
+<br>All parameters should be filled in for a successful connect.
+</ul>
+<p><b>Sample:</b></p>
+<p>The following sample writes all syslog messages to the
+database "syslog_db" on mysqlsever.example.com. The server is
+being accessed under the account of "user" with password "pwd".
+</p>
+<textarea rows="5" cols="80">$ModLoad ommysql
+$ActionOmmysqlServerPort 1234 # use non-standard port
+*.*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :ommysql:mysqlserver.example.com,syslog_db,user,pwd
+</textarea>
+<p>[<a href="rsyslog_conf.html">rsyslog.conf overview</a>]
+[<a href="manual.html">manual index</a>] [<a href="http://www.rsyslog.com/">rsyslog site</a>]</p>
+<p><font size="2">This documentation is part of the
+<a href="http://www.rsyslog.com/">rsyslog</a>
+project.<br>
+Copyright &copy; 2008 by <a href="http://www.gerhards.net/rainer">Rainer Gerhards</a> and
+<a href="http://www.adiscon.com/">Adiscon</a>.
+Released under the GNU GPL version 3 or higher.</font></p>
+</body></html>