Hello All!
I use postfx 2.3.5 + dovecot (pop3/imap/lda/auth daemon for postfix) rc15.
root@post /etc/postfix# grep dovecot main.cf smtpd_sasl_type = dovecot virtual_transport = dovecot dovecot_destination_recipient_limit = 1
root@post /etc/dovecot# grep password_query dovecot-sql.conf password_query = SELECT mail as user, cryptp as password, CONCAT('/home/vmail/',homedir,'/',maildir,'/') as userdb_home, uid as userdb_uid, gid as userdb_gid, CONCAT('dirsize:/home/vmail/',homedir,'/',maildir,'/',':storage=',quota/1024) as userdb_quota, nice as userdb_nice, hosts as allow_nets FROM users WHERE mail = '%u' and access = 'Y' and %Ls = 'Y';
When I insert allow_nets (and it should be used without userdb_ prefix) into password_query I could not send any more letters. In logs next:
Dec 19 11:25:30 post dovecot: auth-worker(default): sql(mail@example.com): query: SELECT mail as user, cryptp as password, CONCAT('/home/vmail/',homedir,'/',maildir,'/' ) as userdb_home, uid as userdb_uid, gid as userdb_gid, CONCAT('dirsize:/home/vmail/',homedir,'/',maildir,'/',':storage=',quota/1024) as userdb_quota, nice as userdb_nice , hosts as allow_nets FROM users WHERE mail = 'mail@example.com' and access = 'Y' and smtp = 'Y'; Dec 19 11:25:30 post dovecot: auth-worker(default): passdb(mail@example.com): allow_nets check failed: Remote IP not known
As I understand, postfix does not transfer to dovecot auth daemon rip ( remote ip ). And it is looks like allow_nets it is impossible to use together with dovecot sasl auth in postfix.
Do we have any workaround on it?
A.
"Hic Jacet Ego"