From: Markus Edholm (sitemasterfro.se)
Date: Wed Jan 02 2008 - 13:07:36 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Wietse Venema wrote:
> Markus Edholm:
> [ Charset ISO-8859-1 unsupported, converting... ]
>> Hi List
>>
>> I?m feeling quite puzzled
>>
>> I have an "ordinary" mailserver that I now extended with an mysql table for
>> virtual mail forwarding.
>>
>> but I dont understand following error from mail.log:
>>
>> Jan 1 15:52:23 postfix postfix/trivial-rewrite[22495]: warning: do not list
>> domain orebro.example.net in BOTH virtual_mailbox_domains and relay_domains
> ...
>> relay_domains = example.net
>> virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql_virtual_domains_maps.cf
>
> What is the output of:
>
> $ postmap -q orebro.example.net \
> mysql:/etc/postfix/mysql_virtual_domains_maps.cf || echo not found
>
> The output should be: "not found".
>
> Wietse

Hi!

No

#!/bin/bash
postmap -q orebro.example.net mysql:/etc/postfix/mysql_virtual_domains_maps.cf \
|| echo not found

output:
Örebro lokalavdelning

So it replys with description field from mysql

(I take as you wanted me to run it as bash script)
from prompt I got:

/etc/postfix# $ postmap -q orebro.example.net \
mysql:/etc/postfix/mysql_virtual_domains_maps.cf || echo not found
-bash: $: command not found
not found

Hmm, My file:
/etc/postfix# cat mysql_virtual_domains_maps.cf
user = postfixadmin
password = xxxxxxx
hosts = localhost
dbname = postfix
query = SELECT description FROM domain WHERE domain='%s' AND active = '1'

I have used several different "howtos" maby I made some misstake and using wrong
files?

/Markus

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]