-------- Original-Nachricht -------- > Datum: Wed, 22 Jul 2009 01:03:28 -0400 > Von: Roman Gelfand <[email protected]> > An: Julien Valroff <[email protected]> > CC: [email protected] > Betreff: [Dspam-user] dspam + postfix + mysql
> H Julien, > > I decided to work with debian lenny. I have installed all the necessary > components dspam deployment. I have configured and successfully setup > standalone postfix to work as gateway, ie route messages to my internal > server. Then I reconfigured this postfix server to work with mysql and > dspam. > > When rereceiveing an external mail, I get the message: > > Jul 22 00:15:58 mail postfix/smtpd[2430]: warning: connect to mysql server > unix:/tmp/mysqld.sock: Can't connect to local MySQL server through socket > '/tmp/mysqld.sock' (2) > However, when I enter the following command it workds > > mysql -u abc -pdef --socket=/tmp/mysqld.sock > > I can not figure out what is going on. Any help is appreciated. > - Does the socket have any special permission not allowing Postfix to access it? - Do you run Postfix in chroot and /tmp/mysqld.sock is not available in the chroot? > > Thanks in advance > > > Here is my main.cf > > local_recipient_maps = > local_transport = error:local mail delivery is disabled > myhostname = mail.abc.com > mynetworks = 127.0.0.0/8 192.168.3.0/24 192.168.1.0/24 > dspam_destination_recipient_limit = 1 > parent_domain_matches_subdomains = > debug_peer_list, > smtpd_access_maps > smtpd_recipient_restrictions = > permit_mynetworks, > reject_unauth_destination, > check_recipient_access pcre:/etc/postfix/dspam_check_aliases, > check_sender_access pcre:/etc/postfix/dspam_check_aliases > smtpd_client_restrictions = > check_client_access pcre:/etc/postfix/dspam_filter_access > nested_header_checks= > transport_maps = hash:/etc/postfix/transport > #relay_recipient_maps = hash:/etc/postfix/relay_recipients > # virtual_alias_maps = hash:/etc/postfix/virtual > virtual_transport = lmtp:unix:/tmp/dspam.sock > virtual_mailbox_domains = masmid.com flexpertpoly.com > virtual_mailbox_maps = mysql:/etc/postfix/vmailbox.cf > > Here is my vmailbox.cf > > user = abc > password = def > dbname = libdspam7drvmysql > query = SELECT username FROM dspam_virtual_uids WHERE username='%s' > table = dspam_virtual_uids > hosts = unix:/tmp/mysqld.sock > select_field = username > where_field = username > additiona_conditions = -- Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3 - sicherer, schneller und einfacher! http://portal.gmx.net/de/go/atbrowser ------------------------------------------------------------------------------ _______________________________________________ Dspam-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspam-user
