|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: Postfix, Sasl and MySQL
jheath
unixremedies.com
Date: Mon Feb 02 2004 - 13:05:01 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> All,
>
> I am trying to get postfix authenticating thru sasl/mysql by using the
following howto:
>
> http://high5.net/howto/
>
> I have been able to get courrier to authenticate just fine. However, I
cannot seem to get smtp auth to work. The only "error" I recieve is:
>
> Feb 1 17:04:22 server postfix/smtpd[29926]: connect from
> client[10.0.0.2] Feb 1 17:04:37 server postfix/smtpd[29926]: lost
connection after AUTH from client[10.0.0.2]
> Feb 1 17:04:37 server postfix/smtpd[29926]: disconnect from
> client[10.0.0.2]
>
> I have been wrestling with this for over a week. Any help would be
greatly appreciated.
>
> Running Mandrake 9.2 with the following rpms.
> libpostfix1-2.0.16.20031231-0.13mdk
> postfix-2.0.16.20031231-0.13mdk
> postfix-mysql-2.0.16.20031231-0.13mdk
>
> libsasl2-2.1.15-5mdk
> libsasl2-plug-login-2.1.15-5mdk
> libsasl2-plug-plain-2.1.15-5mdk
> cyrus-sasl-2.1.15-5mdk
> libsasl2-plug-mysql-2.1.15-5mdk (made this from the src rpm)
>
>
> Thanks,
> Justin
Just got it working!!!!
Anyone who is interested here is what I had to do.
Add the following smtpd.conf
pwcheck_method: auxprop
auxprop_plugin: mysql
mysql_user: username
mysql_passwd: password
mysql_host: localhost
mysql_database: postfix
mysql_statement: select password from mailbox where username='%u
%r'
Secondly, I had the password crypted. I cahnged this to clear text and it
works great. For those who followed this howto this means you need to
change the following flag in /etc/courier/authmysqlrc:
MYSQL_CLEAR_PWFIELD password
I noticed afterward some of you were doing sasl auth with mysql via pam. I
didnt see anyone post thier pam smtp config file. Someone mind posting
your pam config as well as your smtpd.conf? This should allow me to get
this working crypted instead of plain text.
Thanks,
Justin
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]