postfix - sasl - mysql

This is a discussion on postfix - sasl - mysql within the alt.comp.mail.postfix forums, part of the Mail Servers and Related category; I use Redhat 9 and I want to use postfix + sasl2 auth for smtpd server. I installed postfix with sasl2 ...


Go Back   Usenet Forums > Mail Servers and Related > alt.comp.mail.postfix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 01-19-2004
=?iso-8859-1?q?Melqu=EDades?=
 
Posts: n/a
Default postfix - sasl - mysql

I use Redhat 9 and I want to use postfix + sasl2 auth for smtpd server. I
installed postfix with sasl2 support, and compiled sasl2 with mysql
support. The problem occur when I try to send a mail. I receive this error:

Jan 19 14:24:29 stan postfix/smtpd[5943]: warning: SASL authentication problem: unable to open Berkeley db /etc/sasldb2: No such file or directory
Jan 19 14:24:29 stan postfix/smtpd[5943]: warning: SASL authentication problem: unable to open Berkeley db /etc/sasldb2: No such file or directory
Jan 19 14:24:29 stan postfix/smtpd[5943]: warning: SASL authentication failure: no secret in database
Jan 19 14:24:29 stan postfix/smtpd[5943]: warning: [172.26.0.233]: SASL CRAM-MD5 authentication failed
Jan 19 14:24:30 stan postfix/smtpd[5943]: warning: SASL authentication problem: unable to open Berkeley db /etc/sasldb2: No such file or directory
Jan 19 14:24:30 stan postfix/smtpd[5943]: warning: SASL authentication problem: unable to open Berkeley db /etc/sasldb2: No such file or directory
Jan 19 14:24:30 stan postfix/smtpd[5943]: warning: SASL authentication problem: unknown password verifier
Jan 19 14:24:30 stan postfix/smtpd[5943]: warning: SASL authentication failure: Password verification failed
Jan 19 14:24:30 stan postfix/smtpd[5943]: warning: [172.26.0.233]: SASL PLAIN authentication failed
Jan 19 14:24:31 stan postfix/smtpd[5943]: warning: SASL authentication problem: unable to open Berkeley db /etc/sasldb2: No such file or directory
Jan 19 14:24:31 stan postfix/smtpd[5943]: warning: SASL authentication problem: unable to open Berkeley db /etc/sasldb2: No such file or directory
Jan 19 14:24:31 stan postfix/smtpd[5943]: warning: SASL authentication problem: unknown password verifier

I don't know why smtpd try to access to /etc/sasldb2 file. I want to
access to mysql database :(

My /usr/lib/sasl2/smtpd.conf is:
mysql_user: mail
mysql_passwd: cipriano
mysql_hostnames: localhost
mysql_database: mail
mysql_statement: select clear from users where id='%u' and domain='%r'
pwcheck_method: mysql
mysql_uidcol: id
mysql_pwdcol: clear

Too I have tried with this:
mysql_user: mail
mysql_passwd: cipriano
mysql_hostnames: localhost
mysql_database: mail
mysql_statement: select clear from users where id='%u' and domain='%r'
pwcheck_method: auxprop

Can you help me? thanks
Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:13 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0