LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices

Reply
 
Search this Thread
Old 02-05-2004, 03:32 PM   #1
theetderks
LQ Newbie
 
Registered: Feb 2002
Posts: 22

Rep: Reputation: 15
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
 
Old 02-05-2004, 03:48 PM   #2
david_ross
Moderator
 
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

Rep: Reputation: 64
Re: postfix / mysql configuration

Quote:
Originally posted by theetderks
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!

What do your conf files look like?
Quote:
Originally posted by theetderks
I've checked the errors and info logs.
Were there any?

There are several howtos - which did you use? if any?
http://www.postfix.org/addon.html
 
Old 02-05-2004, 07:34 PM   #3
theetderks
LQ Newbie
 
Registered: Feb 2002
Posts: 22

Original Poster
Rep: Reputation: 15
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
 
Old 02-06-2004, 02:07 PM   #4
david_ross
Moderator
 
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

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

Have you got the maildir values set in the mysql database?
 
Old 02-09-2004, 12:21 PM   #5
theetderks
LQ Newbie
 
Registered: Feb 2002
Posts: 22

Original Poster
Rep: Reputation: 15
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Postfix configuration help. mdpolaris Linux - Software 7 10-06-2006 02:31 AM
postfix configuration jkmartha Linux - Newbie 1 04-22-2005 02:29 AM
Postfix configuration jriis Linux - Software 3 12-19-2003 09:21 AM
PostFix Configuration triki Linux - Software 4 12-14-2003 01:08 PM
postfix configuration argh2005 Linux - Networking 0 08-30-2003 10:35 PM


All times are GMT -5. The time now is 11:47 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration