Hello,
I have been installed this package before:
[EMAIL PROTECTED] ~]# rpm -q cyrus-sasl-sql  
cyrus-sasl-sql-2.1.22-4
also I change my smtpd.conf as you mentioned , but I'm still getting this
message in my maillog :

Nov 16 08:52:14 prmail postfix/smtpd[3616]: connect from
unknown[192.168.18.214]
Nov 16 08:52:14 prmail pop3d: LOGIN, [EMAIL PROTECTED],
ip=[::ffff:192.168.18.214], port=[47762]
Nov 16 08:52:15 prmail pop3d: LOGOUT, [EMAIL PROTECTED],
ip=[::ffff:192.168.18.214], port=[47762], top=0, retr=0, rcvd=18, sent=38,
time=1
Nov 16 08:52:15 prmail postfix/smtpd[3616]: warning: SASL authentication
problem: unable to open Berkeley db /etc/sasldb2: No such file or directory
Nov 16 08:52:15 prmail postfix/smtpd[3616]: warning: SASL authentication
problem: unable to open Berkeley db /etc/sasldb2: No such file or directory
Nov 16 08:52:15 prmail postfix/smtpd[3616]: warning:
unknown[192.168.18.214]: SASL LOGIN authentication failed: authentication
failure
Nov 16 08:52:15 prmail postfix/smtpd[3616]: disconnect from
unknown[192.168.18.214]

And here is my /var/log/messages last lines: 

Nov 16 08:52:14 prmail postfix/smtpd[3616]: sql_select option missing
Nov 16 08:52:14 prmail postfix/smtpd[3616]: auxpropfunc error no mechanism
available 
Nov 16 08:52:14 prmail postfix/smtpd[3616]: _sasl_plugin_load failed on
sasl_auxprop_plug_init for plugin: sql 
Nov 16 08:52:14 prmail postfix/smtpd[3616]: connect from
unknown[192.168.18.214]
Nov 16 08:52:14 prmail pop3d: LOGIN, [EMAIL PROTECTED],
ip=[::ffff:192.168.18.214], port=[47762]
Nov 16 08:52:15 prmail pop3d: LOGOUT, [EMAIL PROTECTED],
ip=[::ffff:192.168.18.214], port=[47762], top=0, retr=0, rcvd=18, sent=38,
time=1
Nov 16 08:52:15 prmail postfix/smtpd[3616]: warning: SASL authentication
problem: unable to open Berkeley db /etc/sasldb2: No such file or directory
Nov 16 08:52:15 prmail postfix/smtpd[3616]: warning: SASL authentication
problem: unable to open Berkeley db /etc/sasldb2: No such file or directory
Nov 16 08:52:15 prmail postfix/smtpd[3616]: warning:
unknown[192.168.18.214]: SASL LOGIN authentication failed: authentication
failure
Nov 16 08:52:15 prmail postfix/smtpd[3616]: disconnect from
unknown[192.168.18.214]

I think there is problem with sasl , because it seems sasl want to use
/etc/sasldb2 instead of mysql !
Any idea ?
Thanks .

-----Original Message-----
From: Алексей Доморадов [mailto:[EMAIL PROTECTED] 
Sent: Saturday, November 15, 2008 19:36
To: Nasser Heidari
Cc: postfix-users@postfix.org
Subject: Re[2]: smtp authentication failure

> Hi again.
> Thanks for your answer, 
> I don't run postfix in a jail.
> 
> [EMAIL PROTECTED] postfix]# grep smtpd master.cf
> smtp      inet  n       -       n       -       -       smtpd
> 587      inet  n       -       n       -       -       smtpd
> #submission inet n       -       n       -       -       smtpd
> #  -o smtpd_enforce_tls=yes
> #  -o smtpd_sasl_auth_enable=yes
> #  -o smtpd_client_restrictions=permit_sasl_authenticated,reject
> smtps     inet  n       -       n       -       -       smtpd
>   -o smtpd_tls_wrappermode=yes
>   -o smtpd_sasl_auth_enable=yes
>   -o smtpd_client_restrictions=permit_sasl_authenticated,reject
> 
> Also I don't want to use sasldb for my authentication; my user information
> is in mysql database.
If you store user information in mysql, you also need to install
cyrus-sasl-sql package

# yum install cyrus-sasl-sql

And use following smtpd.conf

pwcheck_method: auxprop
mech_list: PLAIN LOGIN CRAM-MD5
auxprop_plugin: sql
sql_engine: mysql
sql_hostnames: localhost
sql_user: postfix
sql_passwd: postfix
sql_database: postfix
sql_select: select password from mailbox where username = '[EMAIL PROTECTED]' 
and
active='1'
log_level: 3

Use postfixadmin to manage your users in mysql

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to