[NTLUG:Discuss] cyrus-sasl and mysql

[Jack Snodgrass]

On Wed, 12 Mar 2003 08:37:29 -0800, joseph beasley wrote:

> As usual, the redhat source rpms won't compile with the mysql option.
> Complains about unpackaged files.  I followed the cyrus-postfix-mysql
> howto, which uses pam_mysql.  
> 
> question???  
> 
> Does your config support encrypted passwords in the mysql database.  My
> config only does plain text passwords in the database.


don't know off the top of my head. I use plain text
passwords. In order to do some of the SMTPAUTH sasl mechs
you have to use plain text passwords. 

I am 100% sure that you can either 
1). specify some sort of crypt function on the select 
statement you pass to cyrus-sasl 
or 
2). add mysql crypt support to the cyrus-sasl soruce. 

I've done #2 in the past... not sure about #1. 

jack


> 
> 
> --- Jack Snodgrass <jack+ntlug at mylinuxguy.net> wrote:
>> On Mon, 2003-03-10 at 08:35, joseph beasley wrote:
>> > Just finished setting up squirrel mail and cyrus imap.  Docs
>> referred
>> > to using msyql as a backend for sasl authentication.  I can't find
>> any
>> > info on this.  Any pointers to info on cyrus-sasl-mysql?
>> 
>> here is the sasl options in my /etc/imapd.conf file. 
>> sasl_pwcheck_method: auxprop
>> sasl_auto_transition: yes
>> sasl_mysql_user: userid
>> sasl_mysql_passwd: password
>> sasl_mysql_hostnames: servername
>> sasl_mysql_database: dbname
>> sasl_mysql_statement: select pswd from users where szName = '%u';
>> 
>> 
>> Let me know if you need anything else. 
>> 
>> jack