With the sql library installed, to use postgresql you just have to change:

sql_engine: mysql

to
sql_engine: pgsql


----- Original Message ----- From: "Jorge Bastos" <[EMAIL PROTECTED]>
To: "DBMail mailinglist" <[email protected]>
Sent: Friday, August 31, 2007 11:54 AM
Subject: Re: [Dbmail] SASL with saslauth rimap


You're doing it wrong
to use auxprop you don't need to put nothing in /etc/pamd./smtp

you need just to put in smtpd.conf (u have to see where it lives in your system, in debian it's in /etc/postfix/sasl/smtpd.conf)


for that file i have (i don't use realm):

#log_level: 7
pwcheck_method: auxprop
auxprop_plugin: sql
mech_list: plain login cram-md5 digest-md5
sql_engine: mysql
sql_hostnames: 127.0.0.1
sql_user: user
sql_passwd: pwd
sql_database: postfix
sql_select: select password from smtp_auth_users where username='%u' and status='true'
# @%r



On Freitag, 31. August 2007 Paul J Stevens wrote:
that's the sql based authentication module in dbmail. It's what you
already use if you're not using LDAP.

OK, I've tried it in /etc/pam.d/smtp, but I don't know with mech I
should enter:
saslauthd -a auxprop
is not working, although I installed all cyrus-sasl packages:
# rpm -qa|grep cyrus
cyrus-sasl-2.1.22-28
cyrus-sasl-ldap-auxprop-2.1.22-27
cyrus-sasl-saslauthd-2.1.22-27
cyrus-sasl-crammd5-2.1.22-28
cyrus-sasl-otp-2.1.22-28
cyrus-sasl-digestmd5-2.1.22-28
cyrus-sasl-plain-2.1.22-28
cyrus-sasl-devel-2.1.22-28
cyrus-sasl-gssapi-2.1.22-28
cyrus-sasl-sqlauxprop-2.1.22-27

How to do it? It's openSUSE 10.2, if that's important...

mfg zmi
--
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0676/846 914 666                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: EA39 8918 EDFF 0A68 ACFB  11B7 BA2D 060F 1C6F E6B0
// Keyserver: www.keyserver.net                   Key-ID: 1C6FE6B0


----- Original Message ----- From: "Michael Monnerie" <[EMAIL PROTECTED]>
To: "DBMail mailinglist" <[email protected]>
Sent: Friday, August 31, 2007 11:24 AM
Subject: Re: [Dbmail] SASL with saslauth rimap


_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail


_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail

_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Reply via email to