Gecko [ www.ctm-euromeuble.fr ]

Name	Size	Permission	Date
ADDRESS_CLASS_README.html	13.12 KB	-rw-r--r--	2020-02-16 20:59
ADDRESS_REWRITING_README.html	51.57 KB	-rw-r--r--	2020-02-16 20:59
ADDRESS_VERIFICATION_README.html	29.08 KB	-rw-r--r--	2020-02-16 20:59
BACKSCATTER_README.html	14.58 KB	-rw-r--r--	2020-02-16 20:59
BASIC_CONFIGURATION_README.html	28.25 KB	-rw-r--r--	2020-02-16 20:59
BUILTIN_FILTER_README.html	19.44 KB	-rw-r--r--	2020-02-16 20:59
CDB_README.html	4.01 KB	-rw-r--r--	2020-02-16 20:59
COMPATIBILITY_README.html	12.47 KB	-rw-r--r--	2020-02-16 20:59
CONNECTION_CACHE_README.html	12.02 KB	-rw-r--r--	2020-02-16 20:59
CONTENT_INSPECTION_README.html	3.57 KB	-rw-r--r--	2020-02-16 20:59
DATABASE_README.html	20.07 KB	-rw-r--r--	2020-02-16 20:59
DB_README.html	8.32 KB	-rw-r--r--	2020-02-16 20:59
DEBUG_README.html	20.59 KB	-rw-r--r--	2020-02-16 20:59
DSN_README.html	5.14 KB	-rw-r--r--	2020-02-16 20:59
ETRN_README.html	13.83 KB	-rw-r--r--	2020-02-16 20:59
FILTER_README.html	38.25 KB	-rw-r--r--	2020-02-16 20:59
FORWARD_SECRECY_README.html	29.03 KB	-rw-r--r--	2020-02-16 20:59
INSTALL.html	58.1 KB	-rw-r--r--	2020-02-16 20:59
IPV6_README.html	14.29 KB	-rw-r--r--	2020-02-16 20:59
LDAP_README.html	23.62 KB	-rw-r--r--	2020-02-16 20:59
LINUX_README.html	2.71 KB	-rw-r--r--	2020-02-16 20:59
LMDB_README.html	14.61 KB	-rw-r--r--	2020-02-16 20:59
LOCAL_RECIPIENT_README.html	7.71 KB	-rw-r--r--	2020-02-16 20:59
MAILDROP_README.html	6.99 KB	-rw-r--r--	2020-02-16 20:59
MEMCACHE_README.html	2.85 KB	-rw-r--r--	2020-02-16 20:59
MILTER_README.html	33.84 KB	-rw-r--r--	2020-02-16 20:59
MULTI_INSTANCE_README.html	54.29 KB	-rw-r--r--	2020-02-16 20:59
MYSQL_README.html	6.54 KB	-rw-r--r--	2020-02-16 20:59
NFS_README.html	5.19 KB	-rw-r--r--	2020-02-16 20:59
OVERVIEW.html	33.49 KB	-rw-r--r--	2020-02-16 20:59
PACKAGE_README.html	5.49 KB	-rw-r--r--	2020-02-16 20:59
PCRE_README.html	3.97 KB	-rw-r--r--	2020-02-16 20:59
PGSQL_README.html	5.86 KB	-rw-r--r--	2020-02-16 20:59
POSTSCREEN_README.html	52.75 KB	-rw-r--r--	2020-02-16 20:59
QSHAPE_README.html	46.6 KB	-rw-r--r--	2020-02-16 20:59
RESTRICTION_CLASS_README.html	9.08 KB	-rw-r--r--	2020-02-16 20:59
SASL_README.html	69.85 KB	-rw-r--r--	2020-02-16 20:59
SCHEDULER_README.html	72.05 KB	-rw-r--r--	2020-02-16 20:59
SMTPD_ACCESS_README.html	21.38 KB	-rw-r--r--	2020-02-16 20:59
SMTPD_POLICY_README.html	32.2 KB	-rw-r--r--	2020-02-16 20:59
SMTPD_PROXY_README.html	16.09 KB	-rw-r--r--	2020-02-16 20:59
SMTPUTF8_README.html	13.81 KB	-rw-r--r--	2020-02-16 20:59
SOHO_README.html	16.35 KB	-rw-r--r--	2020-02-16 20:59
SQLITE_README.html	3.53 KB	-rw-r--r--	2020-02-16 20:59
STANDARD_CONFIGURATION_README.html	33.36 KB	-rw-r--r--	2020-02-16 20:59
STRESS_README.html	24.34 KB	-rw-r--r--	2020-02-16 20:59
TLS_LEGACY_README.html	64.9 KB	-rw-r--r--	2020-02-16 20:59
TLS_README.html	141.53 KB	-rw-r--r--	2020-02-16 20:59
TUNING_README.html	29.65 KB	-rw-r--r--	2020-02-16 20:59
UUCP_README.html	6.37 KB	-rw-r--r--	2020-02-16 20:59
VERP_README.html	9.36 KB	-rw-r--r--	2020-02-16 20:59
VIRTUAL_README.html	29.75 KB	-rw-r--r--	2020-02-16 20:59
XCLIENT_README.html	8.35 KB	-rw-r--r--	2020-02-16 20:59
XFORWARD_README.html	8.08 KB	-rw-r--r--	2020-02-16 20:59
access.5.html	23.14 KB	-rw-r--r--	2020-02-16 20:59
aliases.5.html	10.73 KB	-rw-r--r--	2020-02-16 20:59
anvil.8.html	10.36 KB	-rw-r--r--	2020-02-16 20:59
bounce.5.html	9.61 KB	-rw-r--r--	2020-02-16 20:59
bounce.8.html	9.51 KB	-rw-r--r--	2020-02-16 20:59
canonical.5.html	14.12 KB	-rw-r--r--	2020-02-16 20:59
cidr_table.5.html	4.65 KB	-rw-r--r--	2020-02-16 20:59
cleanup.8.html	27.79 KB	-rw-r--r--	2020-02-16 20:59
defer.8.html	9.51 KB	-rw-r--r--	2020-02-16 20:59
discard.8.html	5.99 KB	-rw-r--r--	2020-02-16 20:59
dnsblog.8.html	4.42 KB	-rw-r--r--	2020-02-16 20:59
error.8.html	6.65 KB	-rw-r--r--	2020-02-16 20:59
flush.8.html	8.43 KB	-rw-r--r--	2020-02-16 20:59
generic.5.html	11.6 KB	-rw-r--r--	2020-02-16 20:59
header_checks.5.html	25.89 KB	-rw-r--r--	2020-02-16 20:59
index.html	4.52 KB	-rw-r--r--	2020-02-16 20:59
ldap_table.5.html	36.07 KB	-rw-r--r--	2020-02-16 20:59
lmdb_table.5.html	5.41 KB	-rw-r--r--	2020-02-16 20:59
lmtp.8.html	50.41 KB	-rw-r--r--	2020-02-16 20:59
local.8.html	36.49 KB	-rw-r--r--	2020-02-16 20:59
mailq.1.html	23.52 KB	-rw-r--r--	2020-02-16 20:59
master.5.html	13.86 KB	-rw-r--r--	2020-02-16 20:59
master.8.html	10.41 KB	-rw-r--r--	2020-02-16 20:59
memcache_table.5.html	12.07 KB	-rw-r--r--	2020-02-16 20:59
mysql_table.5.html	16.72 KB	-rw-r--r--	2020-02-16 20:59
newaliases.1.html	23.52 KB	-rw-r--r--	2020-02-16 20:59
nisplus_table.5.html	3.51 KB	-rw-r--r--	2020-02-16 20:59
oqmgr.8.html	22.08 KB	-rw-r--r--	2020-02-16 20:59
pcre_table.5.html	9.94 KB	-rw-r--r--	2020-02-16 20:59
pgsql_table.5.html	16 KB	-rw-r--r--	2020-02-16 20:59
pickup.8.html	5.83 KB	-rw-r--r--	2020-02-16 20:59
pipe.8.html	24.79 KB	-rw-r--r--	2020-02-16 20:59
postalias.1.html	12.17 KB	-rw-r--r--	2020-02-16 20:59
postcat.1.html	3.91 KB	-rw-r--r--	2020-02-16 20:59
postconf.1.html	29.45 KB	-rw-r--r--	2020-02-16 20:59
postconf.5.html	715.88 KB	-rw-r--r--	2020-02-16 20:59
postdrop.1.html	5.83 KB	-rw-r--r--	2020-02-16 20:59
postfix-logo.jpg	3.58 KB	-rw-r--r--	2020-02-16 20:59
postfix-manuals.html	7.27 KB	-rw-r--r--	2020-02-16 20:59
postfix-power.png	5.26 KB	-rw-r--r--	2020-02-16 20:59
postfix-tls.1.html	14.53 KB	-rw-r--r--	2020-02-16 20:59
postfix-wrapper.5.html	15.48 KB	-rw-r--r--	2020-02-16 20:59
postfix.1.html	21.65 KB	-rw-r--r--	2020-02-16 20:59
postkick.1.html	3.7 KB	-rw-r--r--	2020-02-16 20:59
postlock.1.html	4.89 KB	-rw-r--r--	2020-02-16 20:59
postlog.1.html	3.9 KB	-rw-r--r--	2020-02-16 20:59
postmap.1.html	15.17 KB	-rw-r--r--	2020-02-16 20:59
postmulti.1.html	23.16 KB	-rw-r--r--	2020-02-16 20:59
postqueue.1.html	12.01 KB	-rw-r--r--	2020-02-16 20:59
postscreen.8.html	28.23 KB	-rw-r--r--	2020-02-16 20:59
postsuper.1.html	14.22 KB	-rw-r--r--	2020-02-16 20:59
posttls-finger.1.html	18.53 KB	-rw-r--r--	2020-02-16 20:59
proxymap.8.html	11.34 KB	-rw-r--r--	2020-02-16 20:59
qmgr.8.html	26.61 KB	-rw-r--r--	2020-02-16 20:59
qmqp-sink.1.html	2.36 KB	-rw-r--r--	2020-02-16 20:59
qmqp-source.1.html	3.88 KB	-rw-r--r--	2020-02-16 20:59
qmqpd.8.html	8.78 KB	-rw-r--r--	2020-02-16 20:59
qshape.1.html	7.33 KB	-rw-r--r--	2020-02-16 20:59
regexp_table.5.html	7.89 KB	-rw-r--r--	2020-02-16 20:59
relocated.5.html	7.96 KB	-rw-r--r--	2020-02-16 20:59
scache.8.html	7.5 KB	-rw-r--r--	2020-02-16 20:59
sendmail.1.html	23.52 KB	-rw-r--r--	2020-02-16 20:59
showq.8.html	5.55 KB	-rw-r--r--	2020-02-16 20:59
smtp-sink.1.html	13.2 KB	-rw-r--r--	2020-02-16 20:59
smtp-source.1.html	5.55 KB	-rw-r--r--	2020-02-16 20:59
smtp.8.html	50.41 KB	-rw-r--r--	2020-02-16 20:59
smtpd.8.html	79.32 KB	-rw-r--r--	2020-02-16 20:59
socketmap_table.5.html	4.36 KB	-rw-r--r--	2020-02-16 20:59
spawn.8.html	7.16 KB	-rw-r--r--	2020-02-16 20:59
sqlite_table.5.html	13.42 KB	-rw-r--r--	2020-02-16 20:59
tcp_table.5.html	4.31 KB	-rw-r--r--	2020-02-16 20:59
tlsmgr.8.html	9.85 KB	-rw-r--r--	2020-02-16 20:59
tlsproxy.8.html	14.63 KB	-rw-r--r--	2020-02-16 20:59
trace.8.html	9.51 KB	-rw-r--r--	2020-02-16 20:59
transport.5.html	14.87 KB	-rw-r--r--	2020-02-16 20:59
trivial-rewrite.8.html	19.13 KB	-rw-r--r--	2020-02-16 20:59
verify.8.html	12.06 KB	-rw-r--r--	2020-02-16 20:59
virtual.5.html	15.06 KB	-rw-r--r--	2020-02-16 20:59
virtual.8.html	16.9 KB	-rw-r--r--	2020-02-16 20:59

Rename

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"
        "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Postfix MySQL Howto</title>

</head>

<body>

<h1><img src="postfix-logo.jpg" width="203" height="98" ALT="">Postfix MySQL Howto</h1>

<hr>

<h2>Introduction</h2>

<p> The Postfix mysql map type allows you to hook up Postfix to a
MySQL database. This implementation allows for multiple mysql
databases: you can use one for a <a href="virtual.5.html">virtual(5)</a> table, one for an
<a href="access.5.html">access(5)</a> table, and one for an <a href="aliases.5.html">aliases(5)</a> table if you want.  You
can specify multiple servers for the same database, so that Postfix
can switch to a good database server if one goes bad.  </p>

<p> Busy mail servers using mysql maps will generate lots of
concurrent mysql clients, so the mysql server(s) should be run with
this fact in mind.  You can reduce the number of concurrent mysql
clients by using the Postfix <a href="proxymap.8.html">proxymap(8)</a> service. </p>

<h2>Building Postfix with MySQL support</h2>

<p> These instructions assume that you build Postfix from source
code as described in the <a href="INSTALL.html">INSTALL</a> document. Some modification may
be required if you build Postfix from a vendor-specific source
package.  </p>

<p> Note: to use mysql with Debian GNU/Linux's Postfix, all you
need is to install the postfix-mysql package and you're done.
There is no need to recompile Postfix. </p>

<p> The Postfix MySQL client utilizes the mysql client library,
which can be obtained from: </p>

<blockquote>
    <p> <a href="http://www.mysql.com/downloads/">http://www.mysql.com/downloads/</a> <br>
    <a href="http://sourceforge.net/projects/mysql/">http://sourceforge.net/projects/mysql/</a> </p>
</blockquote>

<p> In order to build Postfix with mysql map support, you will need to add
-DHAS_MYSQL and -I for the directory containing the mysql headers, and
the mysqlclient library (and libm) to <a href="MYSQL_README.html">AUXLIBS_MYSQL</a>, for example: </p>

<blockquote>
<pre>
make -f Makefile.init makefiles \
    'CCARGS=-DHAS_MYSQL -I/usr/local/mysql/include' \
    '<a href="MYSQL_README.html">AUXLIBS_MYSQL</a>=-L/usr/local/mysql/lib -lmysqlclient -lz -lm'
</pre>
</blockquote>

<p> Postfix versions before 3.0 use AUXLIBS instead of <a href="MYSQL_README.html">AUXLIBS_MYSQL</a>.
With Postfix 3.0 and later, the old AUXLIBS variable still supports
building a statically-loaded MySQL database client, but only the new
<a href="MYSQL_README.html">AUXLIBS_MYSQL</a> variable supports building a dynamically-loaded or 
statically-loaded MySQL database client.  </p>

<blockquote>
 
<p> Failure to use the <a href="MYSQL_README.html">AUXLIBS_MYSQL</a> variable will defeat the purpose
of dynamic database client loading. Every Postfix executable file
will have MYSQL database library dependencies. And that was exactly
what dynamic database client loading was meant to avoid. </p>
 
</blockquote>

<p> On Solaris, use this instead: </p>

<p> Then, just run 'make'. This requires libz, the compression
library.  Older mysql implementations build without libz. </p>

<h2>Using MySQL tables</h2>

<p> Once Postfix is built with mysql support, you can specify a
map type in <a href="postconf.5.html">main.cf</a> like this: </p>

<blockquote>
<pre>
<a href="postconf.5.html#alias_maps">alias_maps</a> = <a href="mysql_table.5.html">mysql</a>:/etc/postfix/mysql-aliases.cf
</pre>
</blockquote>

<p> The file /etc/postfix/mysql-aliases.cf specifies lots of
information telling Postfix how to reference the mysql database.
For a complete description, see the <a href="mysql_table.5.html">mysql_table(5)</a> manual page. </p>

<h2>Example: local aliases </h2>

<pre>
#
# mysql config file for <a href="local.8.html">local(8)</a> <a href="aliases.5.html">aliases(5)</a> lookups
#

# The user name and password to log into the mysql server.
user = someone
password = some_password

# The database name on the servers.
dbname = customer_database

# For Postfix 2.2 and later The SQL query template.
# See <a href="mysql_table.5.html">mysql_table(5)</a> for details.
query = SELECT forw_addr FROM mxaliases WHERE alias='%s' AND status='paid'

# For Postfix releases prior to 2.2. See <a href="mysql_table.5.html">mysql_table(5)</a> for details.
select_field = forw_addr
table = mxaliases
where_field = alias
# Don't forget the leading "AND"!
additional_conditions = AND status = 'paid'

# This is necessary to make UTF8 queries work for Postfix 2.11 .. 3.1,
# and is the default setting as of Postfix 3.2,
option_group = client
</pre>

<h2>Additional notes</h2>

<p> Postfix 3.2 and later read <b>[client]</b> option group settings
by default. To disable this, specify no <b>option_file</b> and
specify "<b>option_group =</b>" (i.e. an empty value).  </p>

<p> Postfix 3.1 and earlier don't read <b>[client]</b> option group
settings unless a non-empty <b>option_file</b> or <b>option_group</b>
value are specified. To enable this, specify, for example
"<b>option_group = client</b>".  </p>

<p> The MySQL configuration interface setup allows for multiple
mysql databases: you can use one for a virtual table, one for an
access table, and one for an aliases table if you want. </p>

<p> Since sites that have a need for multiple mail exchangers may
enjoy the convenience of using a networked mailer database, but do
not want to introduce a single point of failure to their system,
we've included the ability to have Postfix reference multiple hosts
for access to a single mysql map.  This will work if sites set up
mirrored mysql databases on two or more hosts.  Whenever queries
fail with an error at one host, the rest of the hosts will be tried
in random order.  If no mysql server hosts are reachable, then mail
will be deferred until at least one of those hosts is reachable.
</p>

<h2>Credits</h2>

<ul>

<li> The initial version was contributed by Scott Cotton and Joshua
Marcus, IC Group, Inc.</li>

<li> Liviu Daia revised the configuration interface and added the
<a href="postconf.5.html">main.cf</a> configuration feature.</li>

<li> Liviu Daia with further refinements from Jose Luis Tallon and
Victor Duchovni developed the common query, result_format, domain and
expansion_limit interface for LDAP, MySQL and PosgreSQL.</li>

</ul>

</body>

</html>