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.


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 =
------------------------------------------------------------------------------
_______________________________________________
Dspam-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspam-user

Reply via email to