I have had postfix/dbmail running multiple domains up and running for
months. I believe I have a dbmail config issue, I'm not sure.
I tried adding SASL recently and can't quite get it working from a mail
client, any client. I tried Kmail, Evolution and RoundCube WebMail.
When I try to authenticate from a mail client this is all I get in the auth
log,
Oct 6 14:15:55 cpe-22-22-222-222 postfix/smtpd[12547]: sql auxprop plugin
using mysql engine
It is very frustrating because I can successfully authenticate from telnet,
I get all this output in the auth log after a successful telnet
authentication,
Oct 5 18:41:35 cpe-22-22-222-222 postfix/smtpd[5861]: sql plugin Parse the
username po
Oct 5 18:41:35 cpe-22-22-222-222 postfix/smtpd[5861]: sql plugin try and
connect to a host
Oct 5 18:41:35 cpe-22-22-222-222 postfix/smtpd[5861]: sql plugin trying to
open db 'dbmail' on host 'localhost'
Oct 5 18:41:35 cpe-22-22-222-222 postfix/smtpd[5861]: sql plugin Parse the
username po
Oct 5 18:41:35 cpe-22-22-222-222 postfix/smtpd[5861]: sql plugin try and
connect to a host
Oct 5 18:41:35 cpe-22-22-222-222 postfix/smtpd[5861]: sql plugin trying to
open db 'dbmail' on host 'localhost'
Oct 5 18:41:35 cpe-22-22-222-222 postfix/smtpd[5861]: begin transaction
Oct 5 18:41:35 cpe-22-22-222-222 postfix/smtpd[5861]: sql plugin create
statement from userPassword po mail.MyHostOne.org
Oct 5 18:41:35 cpe-22-22-222-222 postfix/smtpd[5861]: sql plugin doing
query SELECT passwd FROM dbmail_users WHERE userid = 'po';
Oct 5 18:41:35 cpe-22-22-222-222 postfix/smtpd[5861]: sql plugin create
statement from cmusaslsecretPLAIN po mail.MyHostOne.org
Oct 5 18:41:35 cpe-22-22-222-222 postfix/smtpd[5861]: sql plugin doing
query SELECT passwd FROM dbmail_users WHERE userid = 'po';
Oct 5 18:41:35 cpe-22-22-222-222 postfix/smtpd[5861]: commit transaction
Can someone point me in the right direction to troubleshoot?
I tried following this, w/o success...
http://www.dbmail.org/dokuwiki/doku.php?id=smtp_auth:postfix
Postfix 2.2.3
dbmail 2.0.1
MySQL 5.0
Fedora 5
...all on the same box behind a firewall...
Thanks,
Jim