Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


  Search this Thread
Old 02-11-2007, 02:03 PM   #1
LQ Newbie
Registered: Aug 2006
Posts: 6

Rep: Reputation: 0
cyrus-sasl mysql problem

I'm running Fedora. I'm trying to get cyrus-sasl to authenticate through mysql for imap. If I set it to sasl_pwcheck_method: saslauthd it works fine. When I change it, below is what happens and my setup.

Here's my tail /var/log/maillog

Feb 9 15:53:18 localhost imap[2643]: badlogin: [] plaintext maxyourstats0001 SASL(-13): user not found: checkpass failed

I get that after running

imtest -a maxyourstats0001 localhost

and getting

S: L01 NO Login failed: authentication failure
Authentication failed. generic failure
Security strength factor: 0

Here's some setup info:

mysql> select * from accountuser;
| username | password | prefix | domain_name |
| maxyourstats0001 | testpw | maxyourstats | |

tls_cert_file: /etc/pki/cyrus-imapd/cyrus-imapd.pem
tls_key_file: /etc/pki/cyrus-imapd/cyrus-imapd.pem
tls_ca_file: /etc/pki/tls/certs/ca-bundle.crt
postmaster: postmaster
configdirectory: /var/lib/imap
partition-default: /var/spool/imap
# admins: cyrus # no admins!
allowanonymouslogin: no
allowplaintext: yes
#sasl_mech_list: PLAIN
autocreatequota: 10000
reject8bit: no
quotawarn: 90
timeout: 30
poptimeout: 10
dracinterval: 0
drachost: localhost
sievedir: /usr/sieve
sendmail: /usr/sbin/sendmail
sieve_maxscriptsize: 32
sieve_maxscripts: 5
#unixhierarchysep: yes
sasl_pwcheck_method: auxprop
sasl_auxprop_plugin: sql
sql_engine: mysql
sasl_auto_transition: no
sasl_sql_hostnames: localhost
sasl_sql_user: user //changed for post
sasl_sql_password: password //changed for post
sasl_sql_database: mail
sasl_sql_statement: select password from accountuser where username = '%u'
sasl_sql_verbose: true
sasl_mech_list: login plain

I set mysql to log, and when I login with the mysql client and run queries they show up in the log, so logging works. However when I run the imtest command and try to authenticate imap, nothing ever appears in the mysqld.log, so it's like cyrus-imapd isn't even trying to talk to mysql.

Any suggestions? Need any other config files?
Old 02-11-2007, 06:07 PM   #2
LQ Newbie
Registered: Aug 2006
Posts: 6

Original Poster
Rep: Reputation: 0
For anyone interested I solved my problem. I used saslauthd and set it to use PAM_MYSQL which works fine.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
i have a problem with cyrus-sasl-2.1.22, help me please! bss Linux - Server 4 12-20-2006 04:11 AM
Sendmail Cyrus SASL authentication problem demith Linux - Software 0 11-15-2006 02:19 AM
cyrus-sasl authentication problem nobu Red Hat 1 11-01-2005 06:54 PM
Cyrus SASL help littlebill Red Hat 0 10-02-2004 08:43 PM
rebuilding cyrus-sasl src.rpm w/mysql support fails willwrk4u Red Hat 1 04-17-2004 02:34 PM > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 09:53 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration