Thanks for your reply, I know that smtp auth is far better from pop-before-smtp but I have to replace a qpopper daemon and not ask any change from client site (they are thousands ...) So I must do the kind of setting I described. If you have any suggestion... thanks again Bye te0x

----- Original Message ----- From: "Matteo Garofano" <m.garofano@internetware.it> To: <dovecot@dovecot.org> Sent: Monday, November 28, 2005 12:40 PM Subject: Pop-before-smtp and MySQL?

Hi, I found that dovecot have many nice features. Now I write because I'm tring to setup the dovecot server, I would substitute a qpopper daemon (patched for mysql authentication) The problem I find is to set up the pop-before-smtp using sql (mysq) as written in http://wiki.dovecot.org/moin.cgi/PopBSMTPAndDovecot (Waiting for post_login ;-) I would use the script popbsmtp.sh and not a perl pig. (I'm using qpopper patched to store the relay IP in mysql and it works) I set .my.cnf in /root What happen is that the $3 don't contain the IP that should be written to the DB. Is there something I miss ? I tried to modify the dovecot.conf file like this mail_executable = /usr/local/libexec/dovecot/popbsmtp.sh /usr/local/libexec/dovecot/pop3 %r "%r" and it write to the db the litteral value %r and not the ip, otherwise it write nothing. the connection with mysql works and any other operation on it works. this should be the last step for my setting.

Have you any hint?

Thanks in advance and best regards

Matteo Garofano