7 messages in net.sourceforge.lists.courier-usersRe: [courier-users] SASL2 problem - o...
FromSent OnAttachments
tekn...@wp.plSep 28, 2006 11:26 am 
Johnny LamSep 28, 2006 12:35 pm 
Ryan ParleeOct 10, 2006 11:11 pm 
Gordon MessmerOct 11, 2006 12:07 am 
Ryan ParleeOct 11, 2006 9:18 am 
Gordon MessmerOct 11, 2006 9:30 am 
Sam VarshavchikOct 11, 2006 3:19 pm 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: [courier-users] SASL2 problem - other solutionActions...
From:Johnny Lam (jl@pkgsrc.org)
Date:Sep 28, 2006 12:35:33 pm
List:net.sourceforge.lists.courier-users

I hate to point out the obvious here, but you might want to ask this question on either a Cyrus SASL mailing list or a Postfix mailing list. This mailing list is for Courier, which has nothing to do with either Cyrus SASL nor Postfix.

Cheers,

-- Johnny Lam <jl@pkgsrc.org>

tekn@wp.pl wrote:

Hello

I fight with SASL2 authentication using mysql for postfix. I tried other
solution:

-bash-2.05b# cat /usr/local/lib/sasl2/smtpd.conf # smtpd.conf #pwcheck_method: saslauthd auxprop pwcheck_method: auxprop auxprop_plugin: sql mech_list: plain login

sql_engine: mysql sql_hostnames: localhost sql_user: vmailuser sql_passwd: password123 sql_database: mail sql_select: select clear from postfix_users where email='%u@%r' and
smtpaccess='Y'; log_level: 9

in postfix main.cf: smtpd_sender_restrictions = check_sender_access
mysql:/usr/local/etc/postfix/mysql-sender.cf

-bash-2.05b# cat /usr/local/etc/postfix/mysql-sender.cf user = vmailuser password = password123 dbname = mail query = SELECT maildir FROM postfix_users where email='%s' and postfix = 'y' hosts = 127.0.0.1

mysql test: mysql> SELECT maildir FROM postfix_users where email='use@server.com' and
postfix = 'y'; +-----------------------------+ | maildir | +-----------------------------+ | server.com/user1/Maildir/ | +-----------------------------+ 1 row in set (0.00 sec)

When i try to send mail from use@server.com to other user i receive:

Sep 28 20:04:52 server postfix/smtpd[33789]: warning: unknown smtpd restriction:
"server.com/user1/Maildir/" Sep 28 20:04:52 server postfix/smtpd[33789]: NOQUEUE: reject: RCPT from
xxxx[my_ip]: 451 4.3.5 Server configuration error; from=<use@server.com>
to=<me@home.address.com> proto=ESMTP helo=<darkstar>

Debug logs show: Sep 28 20:18:27 server postfix/smtpd[33892]: sql plugin trying to open db 'mail'
on host 'localhost' Sep 28 20:18:27 server postfix/smtpd[33892]: begin transaction Sep 28 20:18:27 server postfix/smtpd[33892]: sql plugin create statement from
userPassword user1 server.com Sep 28 20:18:27 server postfix/smtpd[33892]: sql plugin doing query select clear
from postfix_users where email='use@server.com' and smtpaccess='Y';; Sep 28 20:18:27 server postfix/smtpd[33892]: sql plugin create statement from
cmusaslsecretPLAIN user1 server.com Sep 28 20:18:27 server postfix/smtpd[33892]: sql plugin doing query select clear
from postfix_users where email='use@server.com' and smtpaccess='Y';; Sep 28 20:18:27 server postfix/smtpd[33892]: commit transaction Sep 28 20:18:27 server postfix/smtpd[33892]: sql plugin Parse the username
use@server.com Sep 28 20:18:27 server postfix/smtpd[33892]: sql plugin try and connect to a
host Sep 28 20:18:27 server postfix/smtpd[33892]: sql plugin trying to open db 'mail'
on host 'localhost' Sep 28 20:18:27 server postfix/smtpd[33892]: sql plugin Parse the username
use@server.com Sep 28 20:18:27 server postfix/smtpd[33892]: sql plugin try and connect to a
host Sep 28 20:18:27 server postfix/smtpd[33892]: sql plugin trying to open db 'mail'
on host 'localhost'

Why ? What's wrong ? COuld anybody help ?

Thanx

_______________________________________________ courier-users mailing list cour@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users