In fedora you can download the SRPMS as you know,
here you can find the configure option and medify them to suite you :~??
----- Original Message -----
From: "Alex Broens" <[EMAIL PROTECTED]>
To: "DBMail mailinglist" <dbmail@dbmail.org>
Sent: Monday, October 18, 2004 5:37 PM
Subject: Re: [Dbmail] DBmail - SASL smtp auth
Hmmm ...sasl was installed with Fedora.
Dunno how to find out if ist compiled with mysql support or not.
compile from sources? your mean remove the installed sasl and start from
scratch or?...
want ssh? :-)
sigh
Alex
On Mon, 2004-10-18 at 16:38, David Rebarchik wrote:
One thing I forgot to ask... Did you install sasl from sources or a
package.
If from sources you need to configure it with
./configure --enable-sql --with-mysql=/usr/include/mysql/ --enable-login
then recompile.
If from a package you need to find the auxprop package with mysql and
install
it. I just compiled it from sources as I couldn't find the needed
package
when I did it.
Dave
Quoting Alex Broens <[EMAIL PROTECTED]>:
> Thanks for your reply Dave!
>
> replaced my junk in sasl2/smtpd.conf with yours (changed mysql user &
> pw
> :-)
>
> added the line to main.cf
>
>
> and the /var/log/maillog output is:
>
> ----------------
> Oct 18 14:00:12 smtp postfix/smtpd[4786]: warning: SASL authentication
> problem: unable to open Berkeley db /etc/sasldb2: No such file or
> directory
> Oct 18 14:00:12 smtp last message repeated 3 times
> Oct 18 14:00:12 smtp postfix/smtpd[4786]: warning: SASL authentication
> failure: Password verification failed
> ---------------
>
> now why SASL is looking for a Berkely db is above me
>
> could it be my /etc/pam.d/smtp which is broken? (see way below)
>
> (I dream of walkthroughs, complete docs and compatible methods :-)))
>
> thanks for all
>
> Alex
>
>
> On Mon, 2004-10-18 at 13:21, David Rebarchik wrote:
> > the part after the @ is split off to become the realm. You need to
> > set up
> > saslauthd to use the realm and then add it back in when querying the
> database.
> >
> > I've got my setup to use the auxprop.
> > My sasl2/smtpd.conf is:
> > sasl_pwcheck_method: auxprop
> > sasl_auxprop_plugin: mysql
> > sasl_auto_transition: no
> > sasl_mech_list: PLAIN LOGIN, CRAM-MD5
> > sql_user: ****
> > sql_passwd:****
> > sql_hostnames: localhost
> > sql_database: dbmail
> > sql_statement: select passwd from users
> > where userid = IF('%r'='dbmail','%u','[EMAIL PROTECTED]')
> > (no return in the sql statement, added for line wrap in the e-mail)
> >
> > and in my main.cf for postfix is
> > smtpd_sasl_local_domain = dbmail
> > (and a few more lines that I you already have)
> >
> > Hope it helps....
> >
> > Dave
> >
> >
> > Quoting Alex Broens <[EMAIL PROTECTED]>:
> >
> > > Good Day,
> > >
> > > DBmail 2.0 / Fedora Core2 .
> > > Imap & Pop are working fine
> > >
> > > trying got get to get SASL to work for SMTP auth.
> > > (its a test box)
> > >
> > > userid is [EMAIL PROTECTED]
> > >
> > > Postfix main.cf
> > > ---------------
> > > local_recipient_maps = mysql:/etc/postfix/sql-recipients.cf
> > > #
> > > broken_sasl_auth_clients = yes
> > > smtpd_sasl_auth_enable = yes
> > > smtpd_sasl_security_options = noanonymous
> > > smtpd_sasl_local_domain =
> > > smtpd_recipient_restrictions =
> > > permit_sasl_authenticated,reject_unauth_destination
> > > check_recipient_access =
> > > permit_sasl_authenticated,check_relay_domains
> > > ---------------
> > >
> > >
> > >
> > > /etc/postfix/sql-recipients.cf
> > > ----------------
> > >
> > > user = <username>
> > > password = <password>
> > > hosts = <dbhost>
> > > dbname = <dbname>
> > > table = dbmail_users
> > > select_field = userid
> > > where_field = userid
> > > -------------------------------------------
> > >
> > > /etc/pam.d/smtp
> > > ---
> > >
> > > auth required pam_mysql.so user=dbmail passwd=dbmail host=localhost
> > > db=dbmail table=dbmail_users usercolumn=userid passwdcolumn=passwd
> > > crypt=0
> > >
> > > --------------------------------------------
> > > /var/log/messages:
> > >
> > >
> > > Oct 18 09:05:01 smtp saslauthd[2258]: pam_sm_authenticate called.
> > > Oct 18 09:05:01 smtp saslauthd[2258]: dbuser changed.
> > > Oct 18 09:05:01 smtp saslauthd[2258]: dbpasswd changed.
> > > Oct 18 09:05:01 smtp saslauthd[2258]: host changed.
> > > Oct 18 09:05:01 smtp saslauthd[2258]: database changed.
> > > Oct 18 09:05:01 smtp saslauthd[2258]: table changed.
> > > Oct 18 09:05:01 smtp saslauthd[2258]: usercolumn changed.
> > > Oct 18 09:05:01 smtp saslauthd[2258]: passwdcolumn changed.
> > > Oct 18 09:05:01 smtp saslauthd[2258]: crypt changed.
> > > Oct 18 09:05:01 smtp saslauthd[2258]: db_connect called.
> > > Oct 18 09:05:01 smtp saslauthd[2258]: returning 0 .
> > > Oct 18 09:05:01 smtp saslauthd[2258]: db_checkpasswd called.
> > > Oct 18 09:05:01 smtp saslauthd[2258]: pam_mysql: where clause =
> > > Oct 18 09:05:01 smtp saslauthd[2258]: SELECT passwd FROM
> > > dbmail_users
> > > WHERE userid='jd'
> > > Oct 18 09:05:01 smtp saslauthd[2258]: pam_mysql: select returned
> > > more
> > > than one resultOct 18 09:05:01 smtp saslauthd[2258]: returning 7
> > > after
> > > db_checkpasswd.
> > > Oct 18 09:05:01 smtp saslauthd[2258]: do_auth : auth
> > > failure:
> > > [user=jd] [service=smtp] [realm=] [mech=pam] [reason=PAM auth
> > > error]
> > >
> > > ----------------------------
> > >
> > > can someone give me a hint why [user=] is not seeing the
> > > @domain.tld?
> > > or is there a better way to implement smtp auth?
> > >
> > > happily driving me nuts!
> > >
> > > thanks
> > >
> > > Alex
> > >
> > >
> > >
> > > _______________________________________________
> > > Dbmail mailing list
> > > Dbmail@dbmail.org
> > > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> > >
> >
> >
> >
>
>
> _______________________________________________
> Dbmail mailing list
> Dbmail@dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
