postfix / mysql configuration
 

Hi all--

I really need help.

I have postfix 2.0.13 installed on Mandrake 9.2 ...

We decided to go to virtual mailboxes via mysql,
so I downloaded the postfix source and rebuilt.

So far, so good...

But previously, postfix was configured for mbox style mailboxes.
We are also using courier-imap, so need maildir boxes.

I have made, checked, and re-checked all the correct changes in
main.cf and master.cf ... and postfix seems to be talking to mysql.

But no matter what I do, my mail is still delivered to my old mbox file!

I've checked the errors and info logs.

I've checked config parameters with postconf.

Does anybody have any ideas!

-Thomas

Re: postfix / mysql configuration
 

What do your conf files look like?
Were there any?

There are several howtos - which did you use? if any?
http://www.postfix.org/addon.html

postfix / mysql config (not mbox!)
 

Thanks David ... here is that info ...

# cat main.cf | grep -v '^\s*$' | grep -v '^#'
command_directory = /usr/sbin
daemon_directory = /usr/lib/postfix
myhostname = zearth.zearth.com
mydomain = zearth.com
myorigin = $myhostname
mydestination = $mydomain, $myhostname, $transport_maps
unknown_local_recipient_reject_code = 450
alias_maps = hash:/etc/postfix/aliases
alias_database = hash:/etc/postfix/aliases
mailbox_command = /usr/bin/procmail -Y -a $DOMAIN
smtpd_banner = $myhostname ESMTP $mail_name ($mail_version) (Mandrake Linux)
debug_peer_level = 1
debug_peer_list = zearth.zearth.com
debugger_command =
PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
xxgdb $daemon_directory/$process_name $process_id & sleep 5
delay_warning_time = 4
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 = /usr/share/doc/postfix-2.0.13/samples
readme_directory = /usr/share/doc/postfix-2.0.13/README_FILES
virtual_transport = virtual
virtual_mailbox_base= /
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_mailbox_limit = 51200000
virtual_minimum_uid = 500
virtual_uid_maps = static:74
virtual_gid_maps = static:74
mail_spool_directory = /var/spool/mail/virtual/

# cat master.cf | grep -v '^\s*$' | grep -v '^#'
smtp inet n - n - - smtpd
pickup fifo n - y 60 1 pickup
cleanup unix n - y - 0 cleanup
qmgr fifo n - n 300 1 nqmgr
rewrite unix - - n - - trivial-rewrite
bounce unix - - y - 0 bounce
defer unix - - y - 0 bounce
flush unix n - y 1000? 0 flush
proxymap unix - - n - - proxymap
smtp unix - - y - - smtp
relay unix - - y - - smtp
showq unix n - y - - showq
error unix - - y - - error
local unix - n n - - local
virtual unix - n n - - virtual
lmtp unix - - y - - lmtp
maildrop unix - n n - - pipe
flags=DRhu user=vmail argv=/usr/local/bin/maildrop -d ${recipient}
old-cyrus unix - n n - - pipe
flags=R user=cyrus argv=/cyrus/bin/deliver -e -m ${extension} ${user}
cyrus unix - n n - - pipe
user=cyrus argv=/usr/lib/cyrus-imapd/deliver -e -r ${sender} -m ${extension} $
{user}
uucp unix - n n - - pipe
flags=Fqhu user=uucp argv=uux -r -n -z -a$sender - $nexthop!rmail ($recipient)
ifmail unix - n n - - pipe
flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop ($recipient)
bsmtp unix - n n - - pipe
flags=Fq. user=foo argv=/usr/local/sbin/bsmtp -f $sender $nexthop $recipient


Logs: no warnings, no errors, nothing much in info but connects and disconnects.


Thanks again! -Thomas

This howto seems very good:
http://kirb.insanegenius.net/postfix.html

Have you got the maildir values set in the mysql database?

Re: postfix / mysql configuration
 

Hi all-

FOUND THE CULPRIT!

just commented this line out of main.cf and all is well

mailbox_command = /usr/bin/procmail -Y -a $DOMAIN

don't need a mail box delivery command if you use postfix
to do the delivery...

and the -Y option on procmail defines mbox style delivery...

for postfix to do the deliver, you do need

home_mailbox = Maildir/

Hope this helps someone else!

-Thomas :)