yeah, sure. here's my transport.cf:
user = [username]
password = [password]
dbname = climb
hosts = rockclimbing.com
table = postfix_transport
select_field = transport
where_field = domain
schema:
CREATE TABLE postfix_transport (
id int(7) NOT NULL auto_increment,
domain varchar(40) NOT NULL default '',
transport varchar(40) NOT NULL default '',
comment varchar(40) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
INSERT INTO postfix_transport VALUES (1,'rockclimbing.com','dbmail:','this
is kind of self evident...');
/etc/postfix/main.cf:
local_recipient_maps = mysql:/etc/postfix/mailboxes.cf
mydestination = mysql:/etc/postfix/transport.cf
transport_maps = mysql:/etc/postfix/transport.cf
mynetworks = 127.0.0.1, 216.240.150.150/29, mysql:/etc/postfix/pbsp.cf
queue_directory = /var/spool/postfix
command_directory = /usr/sbin
daemon_directory = /usr/libexec/postfix
mail_owner = postfix
unknown_local_recipient_reject_code = 550
smtpd_delay_reject = no
smtpd_helo_required = no
disable_vrfy_command = yes
smtpd_client_restrictions = reject_maps_rbl
sendmail_path = /usr/sbin/sendmail.postfix
newaliases_path = /usr/bin/newaliases.postfix
mailq_path = /usr/bin/mailq.postfix
setgid_group = postdrop
manpage_directory = /usr/share/man
sample_directory = /etc/postfix/samples
readme_directory = /etc/postfix/README_FILES
alias_maps = hash:/etc/postfix/aliases
fallback_transport = dbmail
content_filter = smtp-amavis:[127.0.0.1]:10024
max_use = 10
/etc/postfix/master.cf:
smtp inet n - y - - smtpd
pickup fifo n - y 60 1 pickup
cleanup unix n - y - 0 cleanup
qmgr fifo n - y 300 1 qmgr
rewrite unix - - y - - trivial-rewrite
bounce unix - - y - 0 bounce
defer unix - - y - 0 bounce
flush unix n - y 1000? 0
flus
h
proxymap unix - - y - - proxymap
smtp unix - - y - - smtp
relay unix - - y - - smtp
showq unix n - y - - showq
error unix - - y - - error
lmtp unix - - y - - lmtp
local unix - n n - - pipe
flags= user=dbmail:dbmail argv=/usr/bin/dbmail-smtp -d
${recipient}
virtual unix - n n - - virtual
dbmail unix - n n - - pipe
flags= user=dbmail:dbmail argv=/usr/bin/dbmail-smtp -d
${recipient}
smtp-amavis unix - - y - 2 lmtp -o
smtp_data_don
e_timeout=1200 -o disable_dns_lookups=yes
127.0.0.1:10025 inet n - y - - smtpd -o
content_filt
er= -o local_recipient_maps= -o relay_recipient_maps= -o
smtpd_restrict
ion_classes= -o smtpd_client_restrictions= -o smtpd_helo_restrictions=
-o smtpd_sender_restrictions= -o
smtpd_recipient_restrictions=permit_mynetwor
ks,reject -o mynetworks=127.0.0.0/8 -o strict_rfc821_envelopes=yes
I'll try and write a real howto sometime.... but right now I'm late for
work (Google! not a job I want to screw aroudn with!)... so that will have
to wait for later.
dbmail works great for us now that the bugs are (seemingly) all gone.
Quoth the one known as lou...
> In some email I received from [EMAIL PROTECTED] on Wed, 7 May 2003
> 18:50:00 -0400
> (EDT), wrote:
>
>> personally I would suggest amavisd + clamav + SpamAssassin -- the
>> documentation is clear and straightforward, the entire thing can be
>> integrated into a single startup script (along with your postfix and
>> dbmail processes), and the performance is amazing when you use a RAMdisk
>> for the scrubbing.
>>
>> I could maybe write up a HOWTO for Linux / Postfix / DBmail if you like.
>
> Hi there,
>
> Would you like to shed some more light with you transport settings for
> this configuration?
> Please.
>
>
> TIA
> -lou
>
--
Of course I'm crazy, but that doesn't mean I'm wrong.
