LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 08-16-2009, 12:50 AM   #1
brenton.williams
LQ Newbie
 
Registered: Aug 2009
Posts: 4

Rep: Reputation: 0
POSTFIX - virtual domain and alias maps results in 'unknown user'


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.
 
Old 08-16-2009, 09:17 PM   #2
brenton.williams
LQ Newbie
 
Registered: Aug 2009
Posts: 4

Original Poster
Rep: Reputation: 0
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.
 
Old 08-19-2009, 12:32 AM   #3
brenton.williams
LQ Newbie
 
Registered: Aug 2009
Posts: 4

Original Poster
Rep: Reputation: 0
I gave up, redid the thing from scratch and it works.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Virtual Email Account for virtual domain in Postfix javed_dogar Linux - Server 7 10-17-2008 12:31 PM
POSTFIX with VIRTUAL DOMAIN jgph71 Linux - Software 3 10-14-2008 01:24 AM
qmail stats:Recipient address rejected: User unknown in virtual alias table/Giving up Niceman2005 Linux - Software 0 08-19-2007 08:13 PM
Postfix virtual domain eyt Linux - Newbie 0 02-23-2004 05:07 PM
Mysql - Postfix alias domain paulten Linux - Networking 0 11-03-2003 04:05 PM


All times are GMT -5. The time now is 05:30 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration