darookee
Apprentice
Joined: 02 Jan 2003
Posts: 162
Location: Long Beach, CA.
|
 Posted: Tue Nov 06, 2007 11:25 pm Post subject: Exim+cyrus-sasl+mysql problem |
 |
|
Hi there!
I have exim with the "sasl" USE-flag and cyrus-sasl installed.
My authenticators look like this:
| Code: |
sasl_cram_md5:
driver = cyrus_sasl
public_name = CRAM-MD5
server_set_id = $1
sasl_plain:
driver = cyrus_sasl
public_name = PLAIN
server_set_id = $1
|
and my /etc/sasl2/smtpd.conf looks like this:
| Code: |
pwcheck_method: auxprop
auxprop_plugin: sql
mech_list: PLAIN LOGIN
password_format: crypt
sql_engine: mysql
sql_user: email
sql_passwd: password
sql_hostnames: localhost
sql_database: server
sql_select: SELECT passwd FROM dbmail_users WHERE userid = '%u'
sql_verbose: no
|
When I try to authenticate the logs show this messages
| Code: |
Nov 7 00:12:10 sevenup exim[31548]: 2007-11-07 00:12:10 Start queue run: pid=31548
Nov 7 00:12:10 sevenup exim[31548]: 2007-11-07 00:12:10 End queue run: pid=31548
Nov 7 00:12:27 sevenup exim[31561]: sql_select option missing
Nov 7 00:12:27 sevenup exim[31561]: auxpropfunc error no mechanism available
Nov 7 00:12:27 sevenup exim[31561]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql
Nov 7 00:12:27 sevenup exim[31561]: [1\2] 2007-11-07 00:12:27 sasl_cram_md5 authenticator (CRAM-MD5):
Nov 7 00:12:27 sevenup exim[31561]: [2/2] Cyrus SASL permanent failure: user not found
Nov 7 00:12:27 sevenup exim[31561]: 2007-11-07 00:12:27 sasl_cram_md5 authenticator failed for ([192.168.0.192]) [89.182.13.169]: 535 Incorrect authentication data
Nov 7 00:12:27 sevenup exim[31561]: 2007-11-07 00:12:27 sasl_cram_md5 authenticator failed for ([192.168.0.192]) [89.182.13.169]: 535 Incorrect authentication data
Nov 7 00:12:27 sevenup exim[31561]: sql_select option missing
Nov 7 00:12:27 sevenup exim[31561]: auxpropfunc error no mechanism available
Nov 7 00:12:27 sevenup exim[31561]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql
Nov 7 00:12:27 sevenup exim[31561]: [1\2] 2007-11-07 00:12:27 sasl_plain authenticator (PLAIN):
Nov 7 00:12:27 sevenup exim[31561]: [2/2] Cyrus SASL permanent failure: user not found
Nov 7 00:12:27 sevenup exim[31561]: 2007-11-07 00:12:27 sasl_plain authenticator failed for ([192.168.0.192]) [89.182.13.169]: 535 Incorrect authentication data
Nov 7 00:12:27 sevenup exim[31561]: 2007-11-07 00:12:27 sasl_plain authenticator failed for ([192.168.0.192]) [89.182.13.169]: 535 Incorrect authentication data
|
Can someone tell me what I'm doing wrong? I read this (https://forums.gentoo.org/viewtopic-t-312591.html?sid=a10e9fa09ef6aba6646e39c3c1e98812) howto and tried to use the "Just SASL" and the pam_mysql methods, but it won't work for me :(
Thanks in advance
darookee |
|
Networking & Security
