LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Fedora (https://www.linuxquestions.org/questions/fedora-35/)
-   -   saslauthd problems with mysql (https://www.linuxquestions.org/questions/fedora-35/saslauthd-problems-with-mysql-531715/)

mmoor 02-23-2007 11:42 AM

saslauthd problems with mysql
 
Feb 23 17:40:07 sol postfix/smtpd[3183]: TLS connection established from x-x-x-x.ch[x.x.x.x]: TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)
Feb 23 17:40:07 sol postfix/smtpd[3183]: warning: SASL authentication failure: empty secret
Feb 23 17:40:07 sol postfix/smtpd[3183]: warning: xxx.ch[x.x.x.x]: SASL CRAM-MD5 authentication failed
Feb 23 17:40:07 sol postfix/master[2976]: warning: process /usr/libexec/postfix/smtpd pid 3183 killed by signal 11
Feb 23 17:40:07 sol postfix/master[2976]: warning: /usr/libexec/postfix/smtpd: bad command startup -- throttling

/usr/lib/sasl2/smptd.conf (same as in /etc/postfix/sasl)
pwcheck_method: auxprop
auxprop_plugin: sql
mech_list: plain login plain-md5 cram-md5 digest-md5
log-level: 7
sql_engine: mysql
sql_hostnames: localhost
sql_database: xxx
sql_user: xxxx
sql_passwd: xxxxx
sql_select: select passwort from postfix where email='%u@%r'
-----------------------

/etc/pam.d/smptd.conf
#%PAM-1.0
auth sufficient pam_mysql.so user=xxx passwd=xxx host=localhost db=xxx table=postfix usercolumn=email passwdcolumn=passwort crypt=1
account required pam_mysql.so user=xxx passwd=xxx host=localhost db=xxx table=postfix usercolumn=email passwdcolumn=passwort crypt=1

if I have that in i get the above errors. The password is in plain text insite the mysql. But even if i change the email or leave it empty in mysql, i get the same error, i dont think it even uses mysql.
If I take the smptd.conf away from the lib/sasl2/ then it works again.. But I even can delete the mysql table it still works. and if i put the damn smptd.conf in, then i get that worthless stupid error.

Messages log
Auxprop plugin error, missing mech..

I tryed to recompile that stupid saslauthd with -enable mysql. but still dont work. No matter what im doing it just uses tath stupid berkley db /etc/sasldb2..

Any hint are warmly welcomed.


All times are GMT -5. The time now is 12:34 PM.