<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div style="FONT-SIZE: 12pt; COLOR: #000000; FONT-FAMILY: 'Calibri'">
<div>Dear List,</div>
<div> </div>
<div>We have configured a mail server on a Red Hat Enterprise
Linux Server release 6.1 (64 bit) using the following components
: -</div>
<div>1. Postfix</div>
<div>2. Courier-authlib</div>
<div>3. Courier-imap</div>
<div>4. MySQL</div>
<div>5. maqildrop</div>
<div>6. cyrus-sasl</div>
<div> </div>
<div>The login credentials of the users are being stored in the
MySQL database. The mailing system is working fine. Now, we want
to have SASL authentication in our mailing system. We want to do
SASL authentication with mysql. We are not very sure that the
support for mysql is already present in the Cyrus-sasl rpms or
not. We have installed the following rpms:-</div>
<div> </div>
<div>cyrus-sasl-2.1.23-8.el6.x86_64</div>
<div>cyrus-sasl-devel-2.1.23-8.el6.x86_64</div>
<div>cyrus-sasl-gssapi-2.1.23-8.el6.x86_64</div>
<div>cyrus-sasl-lib-2.1.23-8.el6.x86_64</div>
<div>cyrus-sasl-md5-2.1.23-8.el6.x86_64</div>
<div>cyrus-sasl-plain-2.1.23-8.el6.x86_64</div>
<div>cyrus-sasl-sql-2.1.23-8.el6.x86_64</div>
<div> </div>
<div>Is mysql support is there in the above rpm list or do we need
to compile the source with mysql support? </div>
<div>I have gone through the documents in the internet and done
the following changes :-</div>
<div>/etc/sasl2/smtpd.conf </div>
<div> </div>
<div>pwcheck_method: auxprop</div>
<div>auxprop_plugin: sql</div>
<div>sql_engine: mysql</div>
<div>mech_list: PLAIN LOGIN CRAM-MD5 DIGEST-MD5</div>
<div>sql_hostnames: localhost</div>
<div>sql_user: root</div>
<div>sql_passwd: mysql</div>
<div>sql_database: mail</div>
<div>sql_select: SELECT clear FROM postfix_users WHERE email =
'%u@%r'</div>
<div>sql_usessl: no</div>
<div style="FONT-SIZE: 12pt; COLOR: #000000; FONT-FAMILY:
'Calibri'"> </div>
<div style="FONT-SIZE: 12pt; COLOR: #000000; FONT-FAMILY:
'Calibri'">But we are not able to do SASL authentication with
MySQL. If anybody has any clue regarding this then kindly let us
know about it.</div>
<div style="FONT-SIZE: 12pt; COLOR: #000000; FONT-FAMILY:
'Calibri'"> </div>
<div style="FONT-SIZE: 12pt; COLOR: #000000; FONT-FAMILY:
'Calibri'">Thanks & Regards,</div>
<div style="FONT-SIZE: 12pt; COLOR: #000000; FONT-FAMILY:
'Calibri'">Jayanta Ghosh</div>
</div>
</body>
</html>