Gecko [ www.finalhopeacademy.com ]

Name	Size	Permission
AAAREADME	2.99 KB	-rw-r--r--
ADDRESS_CLASS_README	9.33 KB	-rw-r--r--
ADDRESS_REWRITING_README	42.72 KB	-rw-r--r--
ADDRESS_VERIFICATION_README	23.28 KB	-rw-r--r--
BACKSCATTER_README	12.5 KB	-rw-r--r--
BASIC_CONFIGURATION_README	20.99 KB	-rw-r--r--
BUILTIN_FILTER_README	16.36 KB	-rw-r--r--
CDB_README	3.26 KB	-rw-r--r--
COMPATIBILITY_README	12.05 KB	-rw-r--r--
CONNECTION_CACHE_README	9.23 KB	-rw-r--r--
CONTENT_INSPECTION_README	3.29 KB	-rw-r--r--
DATABASE_README	17.04 KB	-rw-r--r--
DB_README	7.58 KB	-rw-r--r--
DEBUG_README	18.09 KB	-rw-r--r--
DSN_README	4.33 KB	-rw-r--r--
ETRN_README	11.4 KB	-rw-r--r--
FILTER_README	28.61 KB	-rw-r--r--
FORWARD_SECRECY_README	28.84 KB	-rw-r--r--
INSTALL	63.8 KB	-rw-r--r--
IPV6_README	11.79 KB	-rw-r--r--
LDAP_README	21 KB	-rw-r--r--
LINUX_README	2.32 KB	-rw-r--r--
LMDB_README	4.9 KB	-rw-r--r--
LOCAL_RECIPIENT_README	5.65 KB	-rw-r--r--
MAILDROP_README	5.23 KB	-rw-r--r--
MEMCACHE_README	2.27 KB	-rw-r--r--
MILTER_README	41.04 KB	-rw-r--r--
MULTI_INSTANCE_README	42.58 KB	-rw-r--r--
MYSQL_README	5.55 KB	-rw-r--r--
NFS_README	4.73 KB	-rw-r--r--
OVERVIEW	20.31 KB	-rw-r--r--
PACKAGE_README	5.79 KB	-rw-r--r--
PCRE_README	3.25 KB	-rw-r--r--
PGSQL_README	4.98 KB	-rw-r--r--
POSTSCREEN_README	39.46 KB	-rw-r--r--
QSHAPE_README	36.63 KB	-rw-r--r--
RELEASE_NOTES	8.38 KB	-rw-r--r--
RESTRICTION_CLASS_README	7 KB	-rw-r--r--
SASL_README	64.71 KB	-rw-r--r--
SCHEDULER_README	65.39 KB	-rw-r--r--
SMTPD_ACCESS_README	20.66 KB	-rw-r--r--
SMTPD_POLICY_README	27.19 KB	-rw-r--r--
SMTPD_PROXY_README	11.9 KB	-rw-r--r--
SOHO_README	13 KB	-rw-r--r--
SQLITE_README	2.75 KB	-rw-r--r--
STANDARD_CONFIGURATION_README	26.56 KB	-rw-r--r--
STRESS_README	20.67 KB	-rw-r--r--
TLS_LEGACY_README	51.47 KB	-rw-r--r--
TLS_README	125.7 KB	-rw-r--r--
TUNING_README	24.3 KB	-rw-r--r--
ULTRIX_README	1.96 KB	-rw-r--r--
UUCP_README	5.14 KB	-rw-r--r--
VERP_README	7.35 KB	-rw-r--r--
VIRTUAL_README	23.52 KB	-rw-r--r--
XCLIENT_README	10.03 KB	-rw-r--r--
XFORWARD_README	8.57 KB	-rw-r--r--

Code Editor : MYSQL_README

PPoossttffiixx MMyySSQQLL HHoowwttoo

-------------------------------------------------------------------------------

IInnttrroodduuccttiioonn

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
virtual(5) table, one for an access(5) table, and one for an aliases(5) 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.

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 proxymap(8)
service.

BBuuiillddiinngg PPoossttffiixx wwiitthh MMyySSQQLL ssuuppppoorrtt

These instructions assume that you build Postfix from source code as described
in the INSTALL document. Some modification may be required if you build Postfix
from a vendor-specific source package.

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.

The Postfix MySQL client utilizes the mysql client library, which can be
obtained from:

http://www.mysql.com/downloads/
    http://sourceforge.net/projects/mysql/

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 AUXLIBS_MYSQL, for example:

make -f Makefile.init makefiles \
        'CCARGS=-DHAS_MYSQL -I/usr/local/mysql/include' \
        'AUXLIBS_MYSQL=-L/usr/local/mysql/lib -lmysqlclient -lz -lm'

Postfix versions before 3.0 use AUXLIBS instead of AUXLIBS_MYSQL. With Postfix
3.0 and later, the old AUXLIBS variable still supports building a statically-
loaded MySQL database client, but only the new AUXLIBS_MYSQL variable supports
building a dynamically-loaded or statically-loaded MySQL database client.

Failure to use the AUXLIBS_MYSQL 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.

On Solaris, use this instead:

make -f Makefile.init makefiles \
        'CCARGS=-DHAS_MYSQL -I/usr/local/mysql/include' \
        'AUXLIBS_MYSQL=-L/usr/local/mysql/lib -R/usr/local/mysql/lib \
            -lmysqlclient -lz -lm'

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

UUssiinngg MMyySSQQLL ttaabblleess

Once Postfix is built with mysql support, you can specify a map type in main.cf
like this:

alias_maps = mysql:/etc/postfix/mysql-aliases.cf

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 mysql_table(5) manual page.

EExxaammppllee:: llooccaall aalliiaasseess

#
# mysql config file for local(8) aliases(5) 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 mysql_table(5) for details.
query = SELECT forw_addr FROM mxaliases WHERE alias='%s' AND status='paid'

# For Postfix releases prior to 2.2. See mysql_table(5) 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

AAddddiittiioonnaall nnootteess

Postfix 3.2 and later read [[cclliieenntt]] option group settings by default. To
disable this, specify no ooppttiioonn__ffiillee and specify "ooppttiioonn__ggrroouupp ==" (i.e. an
empty value).

Postfix 3.1 and earlier don't read [[cclliieenntt]] option group settings unless a non-
empty ooppttiioonn__ffiillee or ooppttiioonn__ggrroouupp value are specified. To enable this, specify,
for example "ooppttiioonn__ggrroouupp == cclliieenntt".

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.

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.

CCrreeddiittss

* The initial version was contributed by Scott Cotton and Joshua Marcus, IC
    Group, Inc.
  * Liviu Daia revised the configuration interface and added the main.cf
    configuration feature.
  * 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.

${this.title}

Code Editor : MYSQL_README