From: Michael C. Clark (me at michaelcclark dot com)
Date: Mon Sep 29 2003 - 05:44:46 EDT
Hi Danny,
You can most certainly authenticate using SASL against the mySQL
database. You are exactly correct that the Sendmail.conf file is the
key. The directives are quite similar to those for IMAP config, but
without the "sasl_"
My Sendmail.conf looks like this:
pwcheck_method:auxprop
auxprop_plugin:sql
sql_engine:mysql
sql_user:cyrus
sql_passwd:cyrus
sql_hostnames:127.0.0.1:3306
sql_database:cyrus
sql_statement:select userpassword from mail_users where username='%u'
and realm='%r'
sql_verbose:true
The 2.1.15 documention describes the directives available.
HTH,
Michael C. Clark
---- Original Message ----
From: danny at g2k dot es
To: cyrus-sasl at lists dot andrew dot cmu dot edu
Subject: RE: sendmail + mysql login
Date: Mon, 29 Sep 2003 11:52:30 +0200
>Hello List.
>
>I have cyrus-sasl-2.1.15 installed and my cyrus-imap-2_2b server is
>authenticating users against mysql server database, using mysql
>pluggin.
>
>/etc/imap.conf
>
>configdirectory: /var/imap
>partition-default: /var/spool/imap
>admins: cyrus cyrus at xxx dot com
>virtdomains: yes
>defaultdomain: localdomain
>sasl_pwcheck_method: auxprop
>sasl_auxprop_plugin: mysql
>sasl_mysql_user: eeee
>sasl_mysql_passwd: rrrr
>sasl_mysql_hostnames: micalet
>sasl_mysql_database: mail
>sasl_mysql_statement: select plaintext from accountuser where user =
>'%u'
>and r$
>sasl_mysql_verbose: false
>
>Then, right now i need smtp auth for authorized user into the same
>mysql
>database. Can i use mysql pluggin into Sendmail.conf file?. is
>saslauthd
>daemon neccesary to do this?.
>
>My sendmail ehlo response look like this:
>
>250-localhost.localdomain Hello micalet [127.0.0.1], pleased to meet
>you
>250-ENHANCEDSTATUSCODES
>250-PIPELINING
>250-8BITMIME
>250-SIZE
>250-DSN
>250-ETRN
>250-AUTH DIGEST-MD5 CRAM-MD5 PLAIN LOGIN
>250-DELIVERBY
>250 HELP
>
>Any Hints?
>
>Thank in advanced
>Danny
>
|
|
|