what ever here is the postfix part of my config just incase you need it
apt-get install postfix-pgsql (for postfix PostgreSQL support)
/etc/postfix/main.cf (edit and add below lines or replace existing)
relay_domains = pgsql:/etc/postfix/pgsql-relay_domains.cf
transport_maps = pgsql:/etc/postfix/pgsql-transports.cf
whitelist_policy = check_client_access
pgsql:/etc/postfix/pgsql-global_lists.cf, check_sender_access
pgsql:/etc/postfix/pgsql-global_lists.cf
/etc/postfix/pgsql-global_lists.cf (new file)
user = baruwa
password = verysecretpw
dbname = baruwa query = SELECT CONCAT('PERMIT') FROM lists WHERE
from_address='%s' AND list_type=1 UNION SELECT CONCAT('REJECT') FROM lists
WHERE from_address='%s' AND list_type=2; hosts = 127.0.0.1
/etc/postfix/pgsql-relay_domains.cf (new file)
user = baruwa
password = verysecretpw
dbname = baruwa
query = SELECT name FROM maildomains WHERE name='%s' AND status='TRUE' AND
delivery_mode=1; hosts = 127.0.0.1
/etc/postfix/pgsql-transports.cf (new file)
user = baruwa
password = verysecretpw
dbname = baruwa
query = SELECT CONCAT('smtp:[', destinations.address, ']:', port) FROM
destinations, maildomains WHERE maildomains.name = '%s' AND
destinations.enabled='TRUE' AND maildomains.id = destinations.domain_id;
hosts = 127.0.0.1
--
View this message in context:
http://baruwa-users-list.963389.n3.nabble.com/Preview-Error-Failed-coercing-to-Unicode-need-string-or-buffer-NoneType-found-tp4026916p4027623.html
Sent from the Baruwa users list mailing list archive at Nabble.com.
_______________________________________________
http://pledgie.com/campaigns/12056
