.\" Man page generated from reStructuredText.
.
.TH AUTOMX_SQL 5 "02/08/2013" "" "automx"
.SH NAME
automx_sql \- automx SQL backend configuration parameters
.
.nr rst2man-indent-level 0
.
.de1 rstReportMargin
\\$1 \\n[an-margin]
level \\n[rst2man-indent-level]
level margin: \\n[rst2man-indent\\n[rst2man-indent-level]]
-
\\n[rst2man-indent0]
\\n[rst2man-indent1]
\\n[rst2man-indent2]
..
.de1 INDENT
.\" .rstReportMargin pre:
. RS \\$1
. nr rst2man-indent\\n[rst2man-indent-level] \\n[an-margin]
. nr rst2man-indent-level +1
.\" .rstReportMargin post:
..
.de UNINDENT
. RE
.\" indent \\n[an-margin]
.\" old: \\n[rst2man-indent\\n[rst2man-indent-level]]
.nr rst2man-indent-level -1
.\" new: \\n[rst2man-indent\\n[rst2man-indent-level]]
.in \\n[rst2man-indent\\n[rst2man-indent-level]]u
..
.SH DESCRIPTION
.sp
The automx_sql(5) man page specifies all parameters that control access from within automx to a SQL backend.
.SH PARAMETERS
.INDENT 0.0
.TP
.B host (default: none)
Specifies one or more SQL servers separated by commas. Each server specification must provide database driver, username and password to access a database on a host as shown in the following example:
.INDENT 7.0
.INDENT 3.5
.sp
.nf
.ft C
host = driver://username:password@hostname/database
.ft P
.fi
.UNINDENT
.UNINDENT
.sp
\fBIMPORTANT:\fP
.INDENT 7.0
.INDENT 3.5
Subsequent servers to the first serve only for fallback purposes, i.e. a server to the right will only be queried if the server left to it cannot be reached. If a server can be reached no further attempts will be made regardless if the query returned a result or not.
.UNINDENT
.UNINDENT
.TP
.B query (default: none)
Specifies the query that should be sent to the database specified with the host parameter:
.INDENT 7.0
.INDENT 3.5
query = SELECT displayname, mailaddr FROM mail WHERE mailaddr=\(aq%s\(aq;
.UNINDENT
.UNINDENT
.sp
\fBNOTE:\fP
.INDENT 7.0
.INDENT 3.5
See the section called “Macros and Variables” in automx.conf(5) for a list of available query macros.
.UNINDENT
.UNINDENT
.TP
.B result_attrs (default: none)
Specifies the attributes whose values should be used in an automx account setup:
.INDENT 7.0
.INDENT 3.5
result_attrs = displayname, mailaddr
.UNINDENT
.UNINDENT
.UNINDENT
.SH AUTHORS
.INDENT 0.0
.TP
.B Christian Roessner <\fI\%cr@sys4.de\fP>
Wrote the program.
.TP
.B Patrick Ben Koetter <\fI\%p@sys4.de\fP>
Wrote the documentation.
.UNINDENT
.SH SEE ALSO
.sp
\fI\%automx(8)\fP, \fI\%automx.conf(5)\fP, \fI\%automx_ldap(5)\fP, \fI\%automx_script(5)\fP, \fI\%automx_sql(5)\fP, \fI\%automx\-test(1)\fP
.SH COPYRIGHT
This document has been placed in the public domain.
.\" Generated by docutils manpage writer.
.