virtual + sql + remote_aliases bug?

From: Brian Kruger (no email)
Date: Mon Apr 01 2002 - 16:24:50 EST


Greetings. I'm having a problem in Postfix 1.1.7 where when I put in
a catch-all on a domain, it processes the catch-all first instead of
the other aliases. Operating system is FreeBSD 4.5.

I realize topics of this might have been in the archives previously,
but I could not find anything relavent to what I am finding an answer
for. I have also read manpages and believe I'm following correcty.

I am using postgres as my database instead of MySQL. Everything
works fine otherwise. I am presently using a view for
remote_aliases, since I'm wanting to track aliases to an account for
a future web front end.

In the database view, I'm reverse sorting so when queried, the catch
alls show up last, thinking that it might be finding them first, but
sorting, not sorting, it doesn't matter.

Another unfortunate side effect is that if I have a virtual account
created, it is also getting ignored and heading right for the catch
all.

In the examples, despite the domains being named similiar (.com
and .net respectively) they are completely separate boxen.

Here's my config info:

virtual_gid_maps = pgsql:/etc/postfix/ids.cf
virtual_mailbox_base = /home/user
virtual_mailbox_limit = 51200000
virtual_mailbox_lock = fcntl
virtual_mailbox_maps = pgsql:/etc/postfix/aliases.cf
virtual_maps = pgsql:/etc/postfix/remote_aliases.cf,
hash:/etc/postfix/virtual
virtual_minimum_uid = 100
virtual_uid_maps = pgsql:/etc/postfix/ids.cf
transport_maps = pgsql:/etc/postfix/transport.cf
local_transport = virtual

my ids.cf, transport.cf, and aliases.cf are correct, when not using a
catchall, they function just fine..

the hash:/etc/postfix/virtual is just an empty file for right now
with an empty map to go with it.

select * from aliases where id=1100;

  id | alias | maildir
------+----------------------------+-----------------------------
 1100 | | monsterous.net/bek/

select * from remote_aliases where rcpt = '';

        alias | rcpt
---------------------+--------------------
  |
 @monsterous.net |

bash-2.05a$ mail <<--(NOTE: This is a virt user
above, therefore it should deliver there, right?)

Subject: Test
12345
.
EOT

Apr 1 14:03:24 gossamer postfix/pickup[67524]: 721C125105: uid=1000
from=<bek>
Apr 1 14:03:24 gossamer postfix/cleanup[67616]: 721C125105: message-
id=<>
Apr 1 14:03:24 gossamer postfix/qmgr[65940]: 721C125105:
from=<>, size=293, nrcpt=1 (queue active)
Apr 1 14:03:24 gossamer postfix/smtp[67619]: 721C125105:
to=<>, relay=mail.monsterous.com[209.223.97.1],
delay=0, status=sent (250 Ok: queued as 5154B1712A)

One thing that might be pointed out is that uid in the log says 1000
where the table says 1100. I have a local user named 'bek' for me to
administer, but I'm not doing any local delivery for mail on the
system whatsoever, so this shouldn't affect it.

Flat files on monsterous.com for virtual using postmap seem to work
just fine. Any information that could be provided to help me fix
this is much appreciated! If responses could be mailed directly to
 since I don't read the groups that often, that
would be apperciated as well.

Thanks in advance.

-Brian

-- 
-----------------------------------------------------------------
Brian Kruger
"You're either part of the problem or part of the solution."
                                                -Eldridge Cleaver
-----------------------------------------------------------------
-
To unsubscribe, send mail to  with content
(not subject): unsubscribe postfix-users







Hosted Email Solutions

Invaluement Anti-Spam DNSBLs



Powered By FreeBSD   Powered By FreeBSD