<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>
<DIV><SPAN class=851260608-21042004><FONT face=Arial
size=2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>I have tried for 3
days now to integrate SASL/PostFix/MySQL but I can't make
it.</FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>What I have done
:</FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>- Compile Postfix
with the SALS and MySQL support :</FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>make -f
Makefile.init makefiles 'CCARGS=-DHAS_MYSQL -I/home/cyril/mysql/include
-DUSE_SASL_AUTH -I/usr/local/include/sasl' </FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial
size=2> 'AUXLIBS=-L/home/cyril/mysql/lib -lmysqlclient -lz -lm
-L/usr/local/lib/sasl2 -lsasl2'<BR></FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>- Compile SALS with
the MySQL support :</FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>env
CPPFLAGS="-I/usr/include/mysql" LDFLAGS="-L/usr/lib/mysql
-R/usr/lib/mysql"<BR>./configure --enable-sql
--with-mysql=/usr/lib/mysql<BR></DIV></FONT></SPAN>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>- Create the
smtpd.conf:</FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>sasl_pwcheck_method:
auxprop<BR>sasl_auxprop_plugin: mysql<BR>mech_list: PLAIN LOGIN CRAM-MD5
DIGEST-MD5 NTLM<BR>mysql_user: postfix<BR>mysql_passwd:
password</FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>mysql_hostnames:
localhost<BR>mysql_database: users<BR>mysql_statement: SELECT crypt FROM users
WHERE address = '%u'<BR>mysql_verbose: yes<BR></DIV></FONT></SPAN>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>- Change my
main.cf to :</FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>#Authentification
SASL</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial
size=2>smtpd_sasl_auth_enable = yes<BR>smtpd_sasl2_auth_enable =
yes<BR>broken_sasl_auth_clients = yes<BR>smtpd_sasl_local_domain
=<BR>smtpd_sasl_security_options = noanonymous<BR>smtpd_recipient_restrictions =
permit_sasl_authenticated, permit_mynetworks,
reject_unauth_destination<BR></FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>What I am sure of is
:</FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>- MySQL and POSTFIX
integration is working as I can check the email through pop3/imap (I am using
courier-imap package)</FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>- Postfix can send
message out</FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>Few questions
:</FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>1/ When I
compile sasl, I got an error saying that :</FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>checking for
mysql_select_db in -lmysqlclient... (cached) no<BR>configure: WARNING: MySQL
library mysqlclient does not work</FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>I can't figure out
why I got this warning. I used the same library than for Mysql</DIV>
<DIV><BR></DIV></FONT></SPAN>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>2/ I got nothing in
maillog. how can I know if SASL is using Mysql ? even how can I know if Postfix
is using SASL ?</FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>Few more details
:</FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>1/ Redhat
9</FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial><FONT size=2>2/ Postfix
version 2.0.19<SPAN class=163192408-21042004><FONT
color=#0000ff> </FONT></SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial><FONT size=2>3/ SASL SASL2
2.1.18<SPAN class=163192408-21042004><FONT
color=#0000ff> </FONT></SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial><FONT size=2><SPAN
class=163192408-21042004><FONT color=#0000ff>4/ My password are encrypted
in my Database</FONT> </SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial size=2>Thanks for your
answers..I am getting crazy down here with that.</FONT></SPAN></DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851260608-21042004><FONT face=Arial
size=2>Cyril</FONT></SPAN></DIV></FONT></DIV></FONT></DIV></BODY></HTML>