Hi,
On 15-jul-04, at 8:13, Ross Gohlke wrote:
from DBMail INSTALL.postfix:
To use MySQL or PostgreSQL with Postfix, first install the
postfix-mysql or postfix-pgsql packages (they're in Debian, probably
also in other distros).
My setup:
Mac OS 10.2
Postfix 2.1.4 (from source)
PostgreSQL 7.4.1 (from source)
I'm not aware of a postfix-pgsql source package. Here's what I did for
Postfix:
Download source, untar postfix-2.1.4
Download pgsql patch into postfix-2.1.4 <http://mat.cc/postfix/>
patch -p1 < postfix-pg.postfix-2.0.0.2.patch
make makefiles CCARGS='-traditional-cpp -DHAS-PGSQL -DUSE_SASL_AUTH
-DHAS_PCRE -I/Library/Frameworks/SASL2.framework/Headers
-I/usr/local/include/sasl -I/usr/local/pgsql/include' AUXLIBS='-lpq
-ldb -lpcre -lcrypto -lsasl2 -L/usr/local/lib -L/usr/local/lib/sasl2
-L/usr/local/pgsql/lib -L/usr/lib/sasl2' (this was gleaned from lots
of READMEs and google results)
make
sudo make install
The wonder is, everything actually worked.
Per DBMail INSTALL, I added this to /etc/postfix/main.cf:
local_recipient_maps = pgsql:/etc/postfix/sql-recipients.cf
Here's my mail.log file:
Jul 14 23:07:47 boomhaus postfix/smtpd[11496]: fatal: unsupported
dictionary type: pgsql
Jul 14 23:07:48 boomhaus postfix/master[9889]: warning: process
/usr/libexec/postfix/smtpd pid 11496 exit status 1
Jul 14 23:07:48 boomhaus postfix/master[9889]: warning:
/usr/libexec/postfix/smtpd: bad command startup -- throttling
Not only did postfix's original PGSQL README not mention anything
about the patch (leading me to believe it may no longer be necessary),
the patch seems pretty outdated. I tried several different compile
options without the patch first.
QUESTION #1
How important is having pgsql support compiled into postfix, from a
DBMail perspective?
PgSQL/MySQl support in postfix is optional and needed only for
recipient-checking on incoming mail.
This enables postfix to bounce mail for unknown users instead of just
blindly piping all incoming mail to dbmail-{smtp | lmtp}.
QUESTION #2
Any ideas what I'm doing wrong?
I don't think you need a (third party) patch in order to obtain
PgSQL-support in postfix:
http://www.postfix.org/PGSQL_README.html
Try recompiling postfix as described here.
kind regards,
Leander
