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

You may also want to read these posts:

• postfix-2.8.2 postfix-2.8.3 src rpm (sqlite3 support)
• Centos 5 Compile Postfix With Tcp Table Support
• postfix-2.8.0.src.rpm
• postfix-2.8-20110105 rpm source
• postfix-2.8.0-RC3, postfix-2.9.20110118 rpm source
• Compile Postfix 2.7.0 from simon j. mudd git repository
• Compiling Postfix-2.7.0 As RPM Package
• Postfix TLS Support On Fedora 12
• Postfix Bind Sender Domain To Dedicated Outgoing IP Address
• postfix 2.8-20100213 postscreen