Hello,

this is my situation, one qmail+vpopmail(MySQL)+dovecot server that works like an MX record and provide access on mailbox via POP3 or IMAP.

Another server with postfix and SASL for SMTP-Auth only, with SASL that query the vpopmail DB for user authentication.

My intention is to set a query into SASL for use the same flags for SMTP-Auth that read vpopmail and qmail.

Now the SASL query is very simple:

$ cat /etc/postfix/sasl/smtpd.conf
pwcheck_method: auxprop
auxprop_plugin: sql
mech_list: PLAIN LOGIN
#password_format: crypt
sql_engine: mysql
sql_hostnames: 10.0.0.1
sql_user: postfix
sql_passwd: pippo
sql_database: vpopmail
sql_select: SELECT pw_clear_passwd FROM vpopmail WHERE pw_name='%u' and pw_domain='%r' and smtppostfix = '1'

the only condition is the column "smtppostfix" that I must set manually.

There is the way to change the SELECT query in order to check the original vpopmail flags? So i can manage SMTP users authentication from vpopmail command line and reflect this configuration into a postfix server :-)

I have read this discussion:

http://www.mail-archive.com/vchkpw@inter7.com/msg17260.html

but I have not found a solution :-(

Thanks
--
Alessio Cecchi is:
@ ILS -> http://www.linux.it/~alessice/
on LinkedIn -> http://www.linkedin.com/in/alessice
Assistenza Sistemi GNU/Linux -> http://www.cecchi.biz/
@ PLUG -> ex-Presidente, adesso senatore a vita, http://www.prato.linux.it
@ LOLUG -> Socio http://www.lolug.net

!DSPAM:4acb4e5f32711494420535!

Reply via email to