Re: [Postfixadmin-devel] How to fix missing internal alias for a mailbox

[Christian B. <pos...@cb...>]

Hello,

Am Donnerstag, 17. Oktober 2013 schrieb Geoff Shang:
> I'm guessing this might be a bug.
> 
> We're running Postfixadmin 2.3.6.  Apparently, one of our users logged
> in and forwarded their mail to another address, then changed their
> mind and unforwarded it again.
> 
> Now in our Postfix log we see entries like this:
> 
> postfix/proxymap[10226]: warning: table
> "pgsql:/etc/postfix/sql/pgsql_virtual_alias_maps.cf": empty lookup
> result for: "<address>" -- ignored
> 
> I'm guessing that the internal alias was to avoid errors like this in
> the logs.
> 
> I believe we have Postfixadmin configured not to show these internal
> aliases for mailboxes, and I'd prefer to keep it that way as it'll
> probably just confuse people.
> 
> I'm prepared to go poking about in the Postgres CLI to fix this.
> 
> Is it just as simple as 'update alias set goto="<address>" where
> alias="<adress>";'?

Looks correct ;-)

To be sure you really do the correct thing, you can
    select alias, goto from alias where alias="address"
(the "goto" in your case should be an empty string, but in general it 
should of course contain one or more mail addresses ;-)

> I haven't tried reproducing the steps above to see if this reliably
> causes this situation.

I'd _guess_ that he (additionally to the steps you describe) had 
vacation enabled while removing the forwarding, and then later disabled 
vacation.

FYI: The code in SVN trunk makes sure this can't happen anymore ;-)


Regards,

Christian Boltz
-- 
BTW mission statement sounds a bit like at the beginning of this
century.  Why do we need such crap anyhow at all?  Since ages the main
motivation to use a SUSE based system is written down in /etc/motd :)
[Lars Müller in opensuse-factory]