Lou,
Is dbmail-lmtpd running? Is it listening on 127.0.0.1:24?
telnet localhost 24
should give you something like
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
220 mail DBMail LMTP service ready to rock
Until you fix these, there's no point in testing postfix.
The query you mention is only relevant for a postfix table lookup. It's
not generated by lmtpd.
On 08/01/2010 02:54 AM, Lou Picciano wrote:
> DBMailers -
>
> Am trying again to manage a working configuration of
> Postfix-DBMAIL-PostgreSQL.
> Can someone help us diagnose this?
>
> Sending a test mail from an 'external domain' to our test server, Postix
> is reporting:
>
> deliver_request_final: send: "connect to localhost[127.0.0.1]:24:
> Connection refused" -1
> (this would appear to be referring to the dbmail-lmtpd, no?)
>
> In fact, I do see the dbmail query in PostgresQL:
>
> SELECT DISTINCT 1 FROM dbmail_aliases WHERE SUBSTRING(alias FROM
> POSITION('@' in alias)+1) = 'oneofourdomains.com';
>
> and, yes, I have verified that the database user can connect with the
> uname/password specified in /etc/dbmail.conf
>
> Can someone help? Lou
>
>
>
> _______________________________________________
> DBmail mailing list
> [email protected]
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail