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--

Name

Size

Permission

Action

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 : SQLITE_README

PPoossttffiixx SSQQLLiittee HHoowwttoo

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

IInnttrroodduuccttiioonn

The Postfix sqlite map type allows you to hook up Postfix to a SQLite database.
This implementation allows for multiple sqlite 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.

BBuuiillddiinngg PPoossttffiixx wwiitthh SSQQLLiittee ssuuppppoorrtt

The Postfix SQLite client utilizes the sqlite3 library, which can be obtained
from:

http://www.sqlite.org/

In order to build Postfix with sqlite map support, you will need to add to
CCARGS the flags -DHAS_SQLITE and -I with the directory containing the sqlite
header files, and you will need to add to AUXLIBS the directory and name of the
sqlite3 library, plus the name of the standard POSIX thread library (pthread).
For example:

make -f Makefile.init makefiles \
         'CCARGS=-DHAS_SQLITE -I/usr/local/include' \
         'AUXLIBS_SQLITE=-L/usr/local/lib -lsqlite3 -lpthread'

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

Failure to use the AUXLIBS_SQLITE variable will defeat the purpose of
    dynamic database client loading. Every Postfix executable file will have
    SQLITE database library dependencies. And that was exactly what dynamic
    database client loading was meant to avoid.

Then, just run 'make'.

UUssiinngg SSQQLLiittee ttaabblleess

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

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

The file /etc/postfix/sqlite-aliases.cf specifies lots of information telling
Postfix how to reference the sqlite database. For a complete description, see
the sqlite_table(5) manual page.

EExxaammppllee:: llooccaall aalliiaasseess

#
# sqlite config file for local(8) aliases(5) lookups
#

# Path to database
dbpath = /some/path/to/sqlite_database

# See sqlite_table(5) for details.
query = SELECT forw_addr FROM mxaliases WHERE alias='%s' AND status='paid'

AAddddiittiioonnaall nnootteess

The SQLite configuration interface setup allows for multiple sqlite databases:
you can use one for a virtual table, one for an access table, and one for an
aliases table if you want.

CCrreeddiittss

SQLite support was added with Postfix version 2.8.

* Implementation by Axel Steiner
  * Documentation by Jesus Garcia Crespo

${this.title}

Code Editor : SQLITE_README