On 3/16/2014 12:24 PM, bluethu...@jokefire.com wrote: >> Apparently your virtual_mailbox_domains lookup isn't working. Test >> your lookup with: >> postmap -q example.com mysql:/etc/postfix/mysql_domains.cf >> >> Listed domains should return a result -- any non-empty result is >> considered valid. >> >> Nothing should be printed when testing unlisted domains. > > Hmm from this test it looks like I'm not pulling any info from mysql: > > [root@mail:/etc/postfix] #postmap -q example.com > mysql:/etc/postfix/mysql_domains.cf > [root@mail:/etc/postfix] #postmap -q example.com > mysql:/etc/postfix/mysql_mailbox.cf > [root@mail:/etc/postfix] #postmap -q example.com > mysql:/etc/postfix/mysql_alias.cf > [root@mail:/etc/postfix] #postmap -q example.com > mysql:/etc/postfix/mysql_transport.cf > > I actually tried testing all my mysql conf files this way and no > info was returned from any of them! > > And I do have postfix-mysql installed. > > [root@mail:/etc/postfix] #dpkg -l | grep postfix > ii postfix > 2.10.2-1 amd64 High-performance mail > transport agent > ii postfix-mysql > 2.10.2-1 amd64 MySQL map support for > Postfix > > I'm wondering if there is some flaw in my config that is preventing > postfix from reading from the db? I'd really appreciate any advice > you might have n getting postfix to interface with mysql. > > Thanks > Tim
Sorry, I don't use sql and am unable to provide help beyond knowing what response postfix expects. Maybe someone else can help with your sql queries. Start a new thread asking about this specific problem. -- Noel Jones