> Rene Bartsch wrote: >>> Brian Evans - Postfix List wrote: >>> >>>> Rene Bartsch wrote: >>>> >>>> >>>>>> Rene Bartsch wrote: >>>>>> >>>>>> >>>>>> >>>>>>> Hi, >>>>>>> I'm running the combination of Postfix, Postfix-GLD (Greylisting) and >>>>>>> DBMail(MDA) as a >>>>>>> >>>>>>> >>>>>>> >>>>> stand-alone >>>>> >>>>> >>>>> >>>>>>> Internet host on a Ubuntu-9.04 system. The file 'sql-recipients.cf' >>>>>>> provides the MySQL >>>>>>> access >>>>>>> >>>>>>> >>>>>>> >>>>> information for the list of mail-aliases in DBMail and 'sql-domains.cf' >>>>> provides the list of >>>>> >> virtual domains extracted from the mail-aliases. >> >>>>> >>>>>> According to your config below, you are trying to use local as virtual. >>>>>> Don't do this. >>>>>> >>>>>> >>>>>> >>>>> According to http://www.dbmail.org/dokuwiki/doku.php/setup_postfix I >>>>> shall do this. >>>>> >>>>> >>>>> >>>>> >>>> This documentation tries to override the Address Classes that Postfix has >>>> defined in the >>>> >> ADDRESS_CLASS_README. >> >>>> No guarantees are given with unsupported configurations. >>>> >>>> >>>> >>>>> If I use virtual as you proposed, remote clients can send mail to >>>>> postfix, but postfix >>>>> doesn't >>>>> >> relay mail from local (loopback or private network) users to the internet. >> >>>>> (Message not sent. Server replied: >>>>> Action not performed: mailbox not available >>>>> 550 5.1.1 <postfix-users@postfix.org>: Recipient address rejected: >>>>> User unknown in virtual >>>>> mailbox table >>>>> >>>>> >>>>> >>>>> >>> In addition, why are you accepting mail locally as postfix.org? >>> >> >> I do NOT ACCEPT mail as "postfix.org". That error occurrs when I try to SEND >> MAIL to the >> internet >> (in this case to the postfix ML). >> >> With the following configuration I can receive mail from the internet with >> DBMAIL and send mail >> from local hosts to DBMAIL accounts, but I CANNOT SEND MAIL TO THE INTERNET >> getting the error: >> "550 5.1.1 $recipient: Recipient address rejected: User unknown in virtual >> mailbox table" >> >> ------------------------------------ snip >> ------------------------------------------------------- >> >> append_dot_mydomain = no >> biff = no >> config_directory = /etc/postfix >> mail_owner = postfix >> mynetworks = 127.0.0.0/8, 10.214.224.0/24, 10.214.234.0/24 >> myorigin = $mydomain >> readme_directory = no >> recipient_delimiter = + >> relay_domains = >> setgid_group = postdrop >> smtpd_banner = $myhostname ESMTP $mail_name (Ubuntu) >> virtual_mailbox_domains = mysql:/etc/postfix/sql-virtual_mailbox_domains.cf >> virtual_mailbox_maps >> = >> mysql:/etc/postfix/sql-virtual_mailbox_maps.cf virtual_transport = >> dbmail-lmtp:127.0.0.1:24 >> >> ------------------------------------ snap >> ------------------------------------------------------- >> >> When I disable the virtual* entries I can send mail fine, but cannot receive >> mail, of course. >> >> I used "postmap -q" to check the MySQL results: >> >> "mysql:/etc/postfix/sql-virtual_mailbox_domains.cf" returns a >> comma-separated list of the >> domains >> > > I hope you are not trying to list all domains with every query. > For virtual_(alias|mailbox)_domains or mydestination using a mysql map, > Postfix expect to give a domain to a query . > If *any* result is returned, the return value is ignored and the lookup > is considered a success. > > This can be where Postfix is confusing all domains to be relayed locally. > > An example: > query = SELECT 1 from domains where domain='%s'
You're my hero! ;) After changing the MySQL-query to return '1' or nothing in "mysql:/etc/postfix/sql-virtual_mailbox_domains.cf" it works like a charm! :) Is there any reason why Postfix accepts the results without a error message and behaves completely different? Best regards, Renne :)
