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
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.
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.
this does not work for subdomains or aliasdomains...
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...
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