SMTP auth question - Printable Version

SMTP auth question - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: System Setup & Installation (/forum-32.html)
+--- Thread: SMTP auth question (/thread-2535.html)

SMTP auth question - robmorin - 02-23-2008 07:21 AM

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 Smile

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

RE: SMTP auth question - joximu - 02-23-2008 07:33 AM

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.

RE: SMTP auth question - robmorin - 02-23-2008 07:38 AM

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..... Smile

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.

RE: SMTP auth question - rbtux - 02-23-2008 09:08 AM

this does not work for subdomains or aliasdomains...

RE: SMTP auth question - robmorin - 02-25-2008 12:45 AM

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...

RE: SMTP auth question - dennyv - 07-24-2008 01:48 AM

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