Howdy,

I've setup postfix using mysql tables and all works except for sending to an alias. The mysql logs show that postfix is only looking at the mailbox table for where to deliver the mail for the alias. However it is not looking in the virtual alias maps table. There are no complaints from postfix on startup to indicate that there is anything wrong, and if I send to a virtual domain listed as a relay on the server it does look up the virtual alias table... even though the domain is not hosted on the server....

So the question I have is where to look next? The mysql log shows the expected lookups from postfix EXCEPT for the virtual alias map queries.... why would it not be checking the table?

Since it is not looking up the virtual alias it bounces the addresses back to sender complaining that the user doesn't exist...

It does deliver to a virtal mailbox, however again it never checks the vitual alias table.... so it only delivers since there's a mailbox for it rather than needing an alias...

Appreciate any assistance possible.

Incase it helps the mysql log shows the following: (note - sending the bounce to brenton@anotherdomain.com.au works fine....)


# This I'm guessing is looking for an alias setting on the domain - there is none.
# So as expected it returns nothing:

54 Connect postfixadmin@localhost on postfix
54 Query SELECT target_domain FROM alias_domain WHERE alias_domain='localdomain.com.au'


# This returns the domain as expected to set the transport as virtual:

55 Connect postfixadmin@localhost on postfix
55 Query SELECT domain FROM domain where domain='localdomain.com.au' AND backupmx = '0' and active = '1' and transport = 'virtual'



# These queries return nothing:

56 Connect postfixadmin@localhost on postfix
56 Query SELECT domain FROM domain WHERE domain='localdomain.com.au' and transport = 'relay' and backupmx = '1'
56 Query SELECT domain FROM domain WHERE domain='.com.au' and transport = 'relay' and backupmx = '1'
56 Query SELECT domain FROM domain WHERE domain='.au' and transport = 'relay' and backupmx = '1'




# Now for some reason we look directly at the mailbox table and not the virtual_alias tables:


57 Connect postfixadmin@localhost on postfix
57 Query SELECT maildir FROM mailbox WHERE username='brenton2@localdomain.com.au'
57 Query SELECT maildir FROM mailbox WHERE username='@localdomain.com.au'


# Here Postfix bounces the message just fine:

58 Connect postfixadmin@localhost on postfix
58 Query SELECT goto FROM alias WHERE address='brenton@anotherdomain.com.au'
58 Query SELECT goto FROM alias WHERE address='brenton'
58 Query SELECT goto FROM alias WHERE address='@anotherdomain.com.au'


54 Query SELECT target_domain FROM alias_domain WHERE alias_domain='anotherdomain.com.au'
55 Query SELECT domain FROM domain where domain='anotherdomain.com.au' AND backupmx = '0' and active = '1' and transport = 'virtual'
56 Query SELECT domain FROM domain WHERE domain='anotherdomain.com.au' and transport = 'relay' and backupmx = '1'


Any clues are greatly appreciated.

I gave up, redid the thing from scratch and it works.