SMTP auth question

[robmorin]

Hello all..

I currently have SMTP auth working against my radius database via saslauth.... however i would like to auth against pop3 or the ispcp mail users table.....

Has anyone done this? here is my current smtpd.conf file from /etc/postfix/sasl

how would i use an sql statement to get the username and password out of ispcp, like i use below for radius as the radius one si simple

Thanks...


pwcheck_method: saslauthd auxprop
auxprop_plugin: sql
mech_list: sql plain login
sql_engine: mysql
sql_hostnames: xx.xx.xx.153
sql_user: radiusd
sql_passwd: somepasswd
sql_database: radius
sql_select: select value from data where name ='%u@%r' and attribute='clear-password'
sql_verbose: yes
log_level: 5

[joximu]

Hi

1) please wait until we have made this more easy (it's very complicated to find the right password to a given mail address in ispcp).

2) I think the configuration might be like the one for dovecot - see the wiki/howto about the switch to dovecot.

[robmorin]

No problem now my buddy came up with this sql statement, and it works!

pwcheck_method: saslauthd auxprop
auxprop_plugin: sql
mech_list: sql plain login
sql_engine: mysql
sql_hostnames: xx.xx.xx.153
sql_user: ispcp
sql_passwd: passwd
sql_database: ispcp
sql_select: select mail_pass from mail_users as a,domain as b where b.domain_name='%r' and (mail_acc='%u' and a.domain_id=b.domain_id);
sql_verbose: yes
log_level: 5

Works just fine.....

I hope someone else can use it!

Rob..

joximu Wrote:Hi

1) please wait until we have made this more easy (it's very complicated to find the right password to a given mail address in ispcp).

2) I think the configuration might be like the one for dovecot - see the wiki/howto about the switch to dovecot.

[rbtux]

this does not work for subdomains or aliasdomains...

[robmorin]

OK, i will keep this in mind, but i do not have users of alias or sub domains that would use smtp auth....

Have a great day

Rob..

rbtux Wrote:this does not work for subdomains or aliasdomains...

[dennyv]

Hi all!

Why don't you use the rimap mechanism?

/etc/default/saslauthd

Code:

MECHANISMS="rimap"

# Additional options for this mechanism. (default: none)
# See the saslauthd man page for information about mech-specific options.
MECH_OPTIONS="127.0.0.1"

# How many saslauthd processes should we run? (default: 5)
# A value of 0 will fork a new process for each connection.
THREADS=5

# Other options (default: -c)
# See the saslauthd man page for information about these options.
#
# Example for postfix users: "-c -m /var/spool/postfix/var/run/saslauthd"
# Note: See /usr/share/doc/sasl2-bin/README.Debian
OPTIONS="-c -m /var/spool/postfix/var/run/saslauthd -r"

/etc/postfix/sasl/smtpd.conf

Code:

pwcheck_method: saslauthd
              mech_list: plain login cram-md5 digest-md5

This should works with both subdomains and alias domain... so it's working for me without, but if the IMAP works correctly saslauthd should do the same!

thanks, bye
Daniele