Hello, > > Rocco Scappatura a écrit : > > > [snip] > > > Why the message is not delivered immediately to the virtual mailbox > > after > > > vacation filter? > > > > > > > because the domain is not listed as a virtual mailbox domain > > At first glance, I shoud say as above too, but I swear that the query > is exactly the one I have reported. > > > >>> # postmap -q t...@receiver.tld > > >>> proxy:mysql:/etc/postfix/mysql-virtual-domain.cf > > >>> receiver.tld > > >> virtual_mailbox_domains is looked up with the domain name as the > > key, > > >> not the email address. Show the output from the right command. > > > > > > # postmap -q domain.tld proxy:mysql:/etc/postfix/mysql-virtual- > > domain.cf > > > # > > > > > > :-( > > > > > > But: > > > > > > # cat /etc/postfix/mysql-virtual-domain.cf > > > . > > > . > > > query = select domain from domain where domain = '%d' and active = > 1 > > > > > > return me correctly: > > > > > > +----------------+ > > > | domain | > > > +----------------+ > > > | domain.tld | > > > +----------------+ > > > > > > mmmhhh!?!?!? > > > > you'll need to make sure you run the right sql queries when testing > and > > that your .cf has the right hosts, user, ... etc. > > Also the db configuration parameter in postfix configuration files are > correct..
Not completely.. Infact, I have read carefully mysql_table man and I see that the right query is: query = select domain from domain where domain = '%s' and active = 1 because postfix evidently passes the domain part of the recipient for lookup.. while I erroneously thought the the entire recipient was looked up.. I'm sorry, rocsca
