incorrect setting in /etc/pam.d/smtp causes smtp auth to fail

[Susanoo]

On Ubuntu 8.04.2 using 2.6.24-19-server and ALL updates as of April 28th 2009, the text file /etc/pam.d/smtp has an incorrect setting causing authentication of smtp to fail. The contents of the file are below

auth required pam_mysql.so user=ehcp passwd=<password> host=<yourmysqlhost> db=ehcp table=emailusers usercolumn=mailusername passwdcolumn=password crypt=1
account sufficient pam_mysql.so user=ehcp passwd=<password> host=<yourmysqlhost> db=ehcp table=emailusers usercolumn=mailusername passwdcolumn=password crypt=1

The setting "usercolumn=mailusername" is incorrect as this is not where the email users are stored. This should be changed to "email" without quotes. after the change both lines should have "usercolumn=email"

[ehcpdeveloper (ehcpdeveloper)]

i noticed this one just now,
i will check and post the status..

[ehcpdeveloper (ehcpdeveloper)]

I agree that, this should be usercolumn=email , and i change this in ehcp and upcoming version of 0.29.10
This does not affect normal pop, imap, webmail operation, only smtp authentication, i think.

this bug is not specific to 0.29.10 (which I fix now), buth all versions of ehcp, prior to 0.29.10.

Thank you for reporting this.. I hope it is fixed now..

[Susanoo (emonahan)]

Indeed, it ONLY affects smtp auth.

bvidinli_ehcp wrote:
> I agree that, this should be usercolumn=email , and i change this in ehcp and upcoming version of 0.29.10
> This does not affect normal pop, imap, webmail operation, only smtp authentication, i think.
>
> this bug is not specific to 0.29.10 (which I fix now), buth all versions
> of ehcp, prior to 0.29.10.
>
> Thank you for reporting this.. I hope it is fixed now..
>

[ehcpdeveloper (ehcpdeveloper)]

Do you have any idea about errors below, on /var/log/auth.log :

Aug 12 01:09:45 ehcp postfix/smtpd[15781]: sql_select option missing
Aug 12 01:09:45 ehcp postfix/smtpd[15781]: auxpropfunc error no
mechanism available
Aug 12 01:09:45 ehcp postfix/smtpd[15781]: _sasl_plugin_load failed on
sasl_auxprop_plug_init for plugin: sql

???

[Susanoo (emonahan)]

no i don't off the top of my head, i have the same errors though, i
haven't had the time to look at it.

It doesn't seem to be related to actual connections or logins, like a
file or something is missing or its looking in the wrong directory...

Does it do it everyday for you too?

bvidinli_ehcp wrote:
> Do you have any idea about errors below, on /var/log/auth.log :
>
> Aug 12 01:09:45 ehcp postfix/smtpd[15781]: sql_select option missing
> Aug 12 01:09:45 ehcp postfix/smtpd[15781]: auxpropfunc error no
> mechanism available
> Aug 12 01:09:45 ehcp postfix/smtpd[15781]: _sasl_plugin_load failed on
> sasl_auxprop_plug_init for plugin: sql
>
>
> ???
>
> ** Changed in: ehcp
> Status: New => Fix Released
>