8 messages in net.sourceforge.lists.courier-maildropRe: Re: [maildropl] Maildrop + postfi...
FromSent OnAttachments
Andrei GologanOct 9, 2002 8:01 am 
Andrei GologanOct 10, 2002 12:33 am 
Andrei GologanOct 10, 2002 2:19 am 
Jens LauterbachOct 10, 2002 2:29 am 
Andrei GologanOct 10, 2002 3:18 am 
Andrei GologanOct 11, 2002 2:59 am 
Rodolfo GonzalezOct 11, 2002 11:23 am 
Andrei GologanOct 12, 2002 3:35 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: Re: [maildropl] Maildrop + postfix + mysql = help !!Actions...
From:Andrei Gologan (agol@gmx.mis.de)
Date:Oct 10, 2002 2:19:42 am
List:net.sourceforge.lists.courier-maildrop

Well I think I pinpointed the problem as beeing maildrop:

from the command line:

[root@ns] maildrop -d and@xxxxx.net maildrop: Invalid user specified.

sql says:

323 Connect postfix@localhost on 323 Init DB maildb 323 Query SELECT id, uid, gid, home, maildir, quota, -- FROM users WHERE id = "and@xxxxx.net" 323 Quit

seems ok !

in maildropmysql.config i have:

default_uidnumber 1000 default_gidnumber 1000 uid_field id uidnumber_field uid gidnumber_field gid maildir_field maildir homedirectory_field home quota_field quota mailstatus_field where_clause ""

in the database i have:

id = and@xxxxx.net uid = 1001 gid = 1001 home= / maildir= /home/virtual/testing/andrei/Maildir quota =

/home/virtual/testing has permissions root.mail

andrei/maildir has permissions 1001.1001

I also tried other combinations of home and Maildir ...

maildroprc reads:

import SENDER DEFAULT=$HOME/Maildir/¡¡

maildrop is setuid. -r-sr-sr-x 1 root mail 163684 Okt 9 13:52 /usr/bin/maildrop

I am out of ideas , i have read the mailing lists but i think I am missig it ....

Thanks for any help !!!!

andrei

----- Original Message ----- From: "ppop123" <wang@ppop.org> To: "Andrei Gologan" <agol@gmx.mis.de> Sent: Thursday, October 10, 2002 9:59 AM Subject: Re: Re: [maildropl] Maildrop + postfix + mysql = help !!

Andrei Gologan,ÄúºÃ£¡

¡¡¡¡chmod +s /usr/bin/maildrop

======= 2002-10-10 09:32:00 ÄúÔÚÀ´ÐÅÖÐдµÀ£º=======

I did it exactly as you said, but nothing, so I thought it is because of the transport maps (in mysqldb), there it says for my domain virtual: , I changed that to maildrop: and I am a little fruther. first it complained about no such user vmail, ok i created one with uid:gid 1000:1000, than maildrop reads the maildropmysql.config - but:

Oct 10 09:12:39 ns maildrop[27474]: Cannot set my user or group id. Oct 10 09:12:39 ns postfix/pipe[27473]: 987303C011F: to=<and@xxxxxxxx.net>, relay=maildrop, delay=0, status=deferred (temporary failure. Command output: /usr/bin/maildrop: Cannot set my user or group id. )

ok we do not have system accounts for the users and we dont want to have system accounts, we want users only in the database, what am I missing ?

Thank you !! Andrei

----- Original Message ----- From: "ppop123" <wang@ppop.org> To: "Andrei Gologan" <agol@gmx.mis.de> Sent: Thursday, October 10, 2002 12:00 AM Subject: Re: [maildropl] Maildrop + postfix + mysql = help !!

Andrei Gologan,ÄúºÃ£¡

maildrop -v maildrop 1.4.0 Copyright 1998-2002 Double Precision, Inc. GDBM extensions enabled. Maildir quota extension enabled. Virtual user database via MySQL extension enabled. This program is distributed under the terms of the GNU General Public License. See COPYING for additional information.

/etc/postfix/master.cf maildrop unix - n n - - pipe flags=Ru user=vmail argv=/usr/bin/maildrop -d $user

/etc/postfix/main.cf transport_maps=mysql:/etc/postfix/transport.cf virtual_mailbox_maps=mysql:/etc/postfix/mysql_virt.cf virtual_uid_maps=mysql:/etc/postfix/uids.cf virtual_gid_maps=mysql:/etc/postfix/gids.cf virtual_mailbox_base=/ virtual_maps =mysql:/etc/postfix/virtual.cf local_transport=maildrop

cat maildroprc import SENDER DEFAULT=$HOME/Maildir/¡¡¡¡

cat maildropmysql.config hostname localhost #port 3306 socket /tmp/mysql.sock database maildb dbuser courier dbpw admin dbtable passwd

timeout 5

default_uidnumber 1000 default_gidnumber 1000 uid_field name uidnumber_field uid gidnumber_field gid maildir_field maildir homedirectory_field home quota_field quota mailstatus_field where_clause ""

mail wangyan

cat /var/log/maillog

Oct 10 08:57:53 mx3 postfix/pickup[9340]: F2FDBFA17: uid=0 from=<root> Oct 10 08:57:54 mx3 postfix/cleanup[9450]: F2FDBFA17: message-id=<20021010005753.F2FDBFA17@mx3.xxxxxxxx> Oct 10 08:57:54 mx3 postfix/qmgr[778]: F2FDBFA17: from=root@xxxxxxx, size=281, nrcpt=1 (queue active) Oct 10 08:57:54 mx3 postfix/pipe[9452]: F2FDBFA17: to=<wangyan@xxxxxc>, relay=maildrop, delay=1, status=sent (mx3.qq.com.cn)

-rw------- 1 postfix postfix 302 Oct 10 08:57 1034211474.9453_0.mx3,S=302 [root@mx3 new]# cat 1034211474.9453_0.mx3,S\=302 Return-Path: root@xxxxxxx Received: by mx3.xxxxxxxx(Postfix, from userid 0) id F2FDBFA17; Thu, 10 Oct 2002 08:57:53 +0800 (CST) To: wangyan@xxxxxx Subject: test Message-Id: 20021010005753.F2FDBFA17@xxxxxxx Date: Thu, 10 Oct 2002 08:57:53 +0800 (CST) From: root@xxxxxxxx (root)

test

======= 2002-10-09 17:00:00 ÄúÔÚÀ´ÐÅÖÐдµÀ£º=======

Hi

we have a system running now with: postfix + mysql + courier-imap on a redhat 7.3. It uses mysql as user database with postfixes internal delivery to the Maildirs. works fine!

now we need quota support so we have to use maildrop dor delivery as far as I understand. Compiled, installed:

maildrop -v shows:

maildrop 1.4.0 Copyright 1998-2002 Double Precision, Inc. GDBM extensions enabled. Enabled Berkeley DB instead of GDBM extensions. Maildir quota extension enabled. Virtual user database extension enabled. Virtual user database via LDAP extension enabled. Virtual user database via MySQL extension enabled.

in main.cf of postfix i had:

transport_maps=mysql:/etc/postfix/transport.cf virtual_mailbox_maps=mysql:/etc/postfix/mysql_virt.cf virtual_uid_maps=mysql:/etc/postfix/uids.cf virtual_gid_maps=mysql:/etc/postfix/gids.cf virtual_mailbox_base=/ virtual_maps =mysql:/etc/postfix/virtual.cf

for maildrop i comented out all the lines and added:

mailbox_command = /usr/bin/maildrop

in master.cf i have : maildrop unix - n n - - pipe flags=R user=postfix argv=/usr/bin/maildrop -V9 -d ${user}

ok the mail gets piped to maildrop but maildrop does not read the /etc/maildropmysql.config as it should , instead it tries to deliver based on /etc/passwd. if there is the user it delivers to that users /home/user/Maildir FILE !!!! if the user isnt there it says:

Oct 9 16:38:16 ns postfix/local[24322]: C36503C0118: to=<use@xxxxxxxx.net>, relay=local, delay=1, status=bounced (unknown user: "user1") and: Oct 9 16:38:16 ns maildrop[24324]: Invalid home directory permissions - world writable.

bunt only when there is no system user as user1.

but it should read maildropmysql.config and deliver to use@xxxxxxxx.net Maildir folders as dose the postfix´s delivery agent. it should try to deliver virtual not local .... i guess but i am not sure ..... why does it not read the maildropmysql.config ?

mysql logs are empty ... no query gets there ...

I feel that I am close, but i am out of documentation, i tried a lot of stuff, but nothing works .... Iread the mailling list tried what it says there but nothing works ...

Any help or hints would be greatly apreciated !!

Thank you Andrei

_______________________________________________ Courier-maildrop mailing list Cour@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/courier-maildrop

= = = = = = = = = = = = = = = = = = = =

Ö Àñ£¡

ppop123 wang@ppop.org 2002-10-10

_______________________________________________ Courier-maildrop mailing list Cour@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/courier-maildrop .

= = = = = = = = = = = = = = = = = = = =

Ö Àñ£¡

ppop123 wang@ppop.org 2002-10-10