Thanks for advice. I found this in the Wiki, I guess it shouldn't be too difficult to translate to sendmail :) http://www.dbmail.org/dokuwiki/doku.php?id=smtp_auth&s=sql+plugin
Mikael -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Leonel Nunez Sent: den 29 september 2005 17:54 To: DBMail mailinglist Subject: Re: [Dbmail] SMTP Authentication - pam-mysql 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 _______________________________________________ Dbmail mailing list Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
