google provide many documentation for differents shemas for mysql table nb : 'google est ton ami'
Le vendredi 9 octobre 2009 20:42, Rene Bartsch a écrit : > > 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 :)
