postfix-2.9.20110501 SRC RPM With sqlite3 Support

Since postfix-2.9. 20100617, sqlite3 support feature was added. Now, in  postfix-2.9.20110501 rpm source, i’ve included sqlite3 feature after some tweaking on Simon J. Mudd’s postfix source. Adding sqlite3 support howto can be read officially from here:

http://www.postfix.org/SQLITE_README.html

Before getting any further, i must warn you that i’m not test sqlite feature yet, since i don’t use sqlite as sql storage backend. it was compiled againts sqlite library in my system. but not tested.

rpm source can be obtain here:

Instructions:

After download the source install the source

$ rpm -Uvh  postfix-2.9.20110501.src.rpm

Set some options you wish to enable (sqlite option shown as highlighted)

export POSTFIX_SMTPD_MULTILINE_GREETING=1
export POSTFIX_LDAP=1
export POSTFIX_MYSQL_REDHAT=1
export POSTFIX_PCRE=1
export POSTFIX_PGSQL=1
export POSTFIX_SQLITE=1
export POSTFIX_RBL_MAPS=1
export POSTFIX_SASL=2
export POSTFIX_TLS=1
export POSTFIX_VDA=1
export POSTFIX_DB=4
export POSTFIX_CDB=1

Create postfix.spec file

$ sh `rpm --eval '%{_sourcedir}'`/make-postfix.spec

Compile

$ cd `rpm --eval '%{_specdir}'`
$ rpmbuild -ba postfix.spec

Lookup table list

# postconf -m
btree
cdb
cidr
environ
hash
internal
ldap
mysql
nis
pcre
pgsql
proxy
regexp
sqlite
static
tcp
texthash
unix