Mikael Henriksson wrote:
Hi all,
I have a problem that's probably more related to pam-mysql than to dbmail,
but I just
wanted to check wether you have seen it before.
I've managed to get sendmail to authenticate to the dbmail datbase via
pam-mysql, so
I know that the configuration is (probably) correct.
I've set up our users to login to dbmail with their full e-mail address
<user.name>@<domain.com> (I've edited the logs below). And it doesn't work
until I
removed the "@" sign and changed the username in the database to just
<user.name>.
It seems that pam-mysql somehow interpret the "@" for realm, see the log
extact below.
When I don't write "@<domain.com>" the [realm=] is empty.
Has anyone set up pam-mysql and uses full e-mail adresses as the userid?
Thanks
Mikael
/var/log/messages:
Sep 29 20:42:12 rhes4 saslauthd[28024]: do_auth : auth failure:
[user=<user.name>] [service=smtp] [realm=<domain.com>] [mech=pam]
[reason=PAM auth error]
Sep 29 20:42:12 rhes4 sendmail[28429]: Password verification failed
Sep 29 20:42:12 rhes4 saslauthd[28025]: do_auth : auth failure:
[user=<user.name>] [service=smtp] [realm=<domain.com>] [mech=pam]
[reason=PAM auth error]
/var/log/secure:
Sep 29 20:41:32 rhes4 saslauthd[28023]: pam_mysql - SELECT passwd FROM
dbmail_users WHERE userid = '<user.name>'
Sep 29 20:41:32 rhes4 saslauthd[28023]: pam_mysql - SELECT returned no
result.
Sep 29 20:41:32 rhes4 saslauthd[28023]: pam_mysql - pam_mysql_check_passwd()
returning 1.
Sep 29 20:41:32 rhes4 saslauthd[28023]: pam_mysql - pam_sm_authenticate()
returning 10.
Sep 29 20:41:32 rhes4 saslauthd[28023]: pam_mysql - pam_mysql_release_ctx()
called.
Sep 29 20:41:32 rhes4 saslauthd[28023]: pam_mysql - pam_mysql_destroy_ctx()
called.
Sep 29 20:41:32 rhes4 saslauthd[28023]: pam_mysql - pam_mysql_close_db()
called.
My versions:
RedHat Enterprise 4
pam-mysql 0.6.2
mysql 4.1.10
dbmail 2.0.7
sendmail 8.13.1
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
You can use saslauthd with sqlplugin
with the sqlplugin you can use que select the fields and conditions
for authenticate to your database
leonel
