I'm sure there is a way to make what you want to work easier then the method I
used. So hopefully there will be someone with a little more experience that
will contribute to this question.
Dave
Quoting Alex Broens <[EMAIL PROTECTED]>:
> 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
>
