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