postfix build does not have documented support of sqlite

Odd
according to postfix:
"SQLite support was added with Postfix version 2.8.

    * Implementation by Axel Steiner
    * Documentation by Jesus Garcia Crespo
"

I am running postfix 2.7.0. So it is not supposed to have sqlite support even though the fedora howto was using some postfix 2.6 version

The howto you reference includes adding third party patches which we don't support.

It seems that 2.8.2 does not have sqlite built either.

root@postfix:/etc/ufw/applications.d# May 1 10:35:46 postfix postfix/proxymap[10146]: fatal: dict_open: unsupported dictionary type: sqlite: Is the postfix-sqlite package installed?
May 1 10:35:47 postfix postfix/smtpd[10031]: warning: private/proxymap socket: service dict_proxy_open: Success
May 1 10:35:47 postfix postfix/master[9848]: warning: process /usr/lib/postfix/proxymap pid 10146 exit status 1
May 1 10:35:47 postfix postfix/master[9848]: warning: /usr/lib/postfix/proxymap: bad command startup -- throttling

root@postfix:/etc/ufw/applications.d# postconf -d | grep mail_version
mail_version = 2.8.2
milter_macro_v = $mail_name $mail_version

I have been spending time attempting to build postfix from ubuntu source deb with sqlite built in with no success

Path 1
apt-get build-dep postfix
apt-get source postfix
cd postfix-2.8.2
dpkg-buildpackage

However I can not seem to influence what it is built with. I can not apply the following instructions:
    make -f Makefile.init makefiles \
         'CCARGS=-DHAS_SQLITE -I/usr/local/include' \
         'AUXLIBS=-L/usr/local/lib -lsqlite3 -lpthread'
make

The result is a legit postfix, but no indication from the output indicates that it took the sqlite changes.

Using the source code to build according to postfix instructions fails as well:
make tidy
make -f Makefile.init makefiles
make

../../lib/libutil.a: undefined reference to `dict_pcre_open'
../../lib/libutil.a: undefined reference to `dict_tcp_open'
collect2: ld returned 1 exit status
make: *** [master] Error 1
make: *** [update] Error 1

and this is without sqlite configured.

I have exhausted myself trying to build a ubuntu postfix 2.8.2 with sqlite.

I'll try to have a look at this, but it may be a bit before I get time.

That is fine, I finally found out that I could get things configured using the rules file. This built the dict_sqlite.so needed by postfix.

Seems like what is missing is a postfix-sqlite package. If I get to it I'll put in a patch to generate the postfix-sqlite package.

@mikepower, I tried editing the rules, modifying CCARGS and AUXLIBS as described in your previous comment, but without avail. dict_sqlite.so is still not included in the deb. Would you mind to share your rules file?

This bug was fixed in the package postfix - 2.8.7-1~build1

---------------
postfix (2.8.7-1~build1) precise; urgency=low

  * upload for precise

postfix (2.8.7-1) unstable; urgency=low

  [Wietse Venema]

  * New Upstream Version

  [LaMont Jones]

  * ack NMU
  * add debian/copyright file for lintian
  * Add SMTPS entry to ufw profile. LP: #859658
  * Add sqlite map support. LP: #774500 Closes: #651208
  * Fix linux 3.0 + multiarch FTBFS, based on patch from Loïc Minier.
    Closes: #643020
 -- LaMont Jones <email address hidden> Thu, 19 Jan 2012 12:23:50 -0700