One of you mentioned having postfix check against the dbmail interface to
see if email addresses were valid. I like the idea. Does someone have an
example of that kind of setup. Currently I'm using straight postfix with
dbmail. there is support for mysql compiled into postfix. I was just
getting ready to install spamassassin, clamav and amavisd to handle all of
that, but the base system is working perfectly with pop beford smtp (very
fast, too.)
Currently I'm setting up users so that they log in with their email
addresses. so the dbmail-adduser command looks something like:
dbmail-adduser a [EMAIL PROTECTED] secret 0 0 [EMAIL PROTECTED]
[EMAIL PROTECTED]
Will things work properly with that kind of setup. That setup allows me
to unique logins for each domain hosted on the server.
Thanks in advance,
Curtis
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
On Wed, 14 Jul 2004, 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?
QUESTION #2
Any ideas what I'm doing wrong?
Thanks,
ross
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
