SMTP auth question

Threaded Mode | Linear Mode

SMTP auth question

Author Message

robmorin
Junior Member

Posts: 177
Group: Registered
Joined: Apr 2007
Status: Offline
Reputation: 0

Post: #1

SMTP auth question

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

02-23-2008 07:21 AM

joximu
Moderator

Posts: 3,534
Group: Moderators
Joined: Jan 2007
Status: Offline
Reputation: 47

Post: #2

RE: SMTP auth question

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.

2008-03-16 ispCP RC4 released!!!

02-23-2008 07:33 AM

robmorin
Junior Member

Posts: 177
Group: Registered
Joined: Apr 2007
Status: Offline
Reputation: 0

Post: #3

RE: SMTP auth question

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:

02-23-2008 07:38 AM

rbtux
Member

Posts: 1,200
Group: Registered
Joined: Feb 2007
Status: Away
Reputation: 22

Post: #4

RE: SMTP auth question

this does not work for subdomains or aliasdomains...

OS: Debian Lenny
ispCP Version: Trunk r1033
Activated: AWStats dynamic, Dovecot, Avelsieve, Selective Greylisting, Bogus MX Filter,
No Webtools, Roundcube, Some own modifications

02-23-2008 09:08 AM

robmorin
Junior Member

Posts: 177
Group: Registered
Joined: Apr 2007
Status: Offline
Reputation: 0

Post: #5

RE: SMTP auth question

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

02-25-2008 12:45 AM

dennyv

Posts: 1
Group: Registered
Joined: Oct 2007
Status: Offline
Reputation: 0

Post: #6

RE: SMTP auth question

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

07-24-2008 01:48 AM

« Next Oldest | Next Newest »

View a Printable Version
Send this Thread to a Friend
Subscribe to this Thread | Add Thread to Favorites