From owner-freebsd-current@FreeBSD.ORG Mon Jan 17 18:05:08 2005 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id DD60216A4CF for ; Mon, 17 Jan 2005 18:05:07 +0000 (GMT) Received: from makeworld.com (makeworld.com [198.92.228.38]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6631943D2F for ; Mon, 17 Jan 2005 18:05:06 +0000 (GMT) (envelope-from racerx@makeworld.com) Received: from localhost (localhost.com [127.0.0.1]) by makeworld.com (Postfix) with ESMTP id D102D6130; Mon, 17 Jan 2005 12:04:57 -0600 (CST) Received: from makeworld.com ([127.0.0.1]) by localhost (makeworld.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 55485-08; Mon, 17 Jan 2005 12:04:47 -0600 (CST) Received: from [127.0.0.1] (unknown [63.117.97.221]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by makeworld.com (Postfix) with ESMTP id 41B2D60EA; Mon, 17 Jan 2005 12:04:39 -0600 (CST) Message-ID: <41EBFE33.4090703@makeworld.com> Date: Mon, 17 Jan 2005 12:04:35 -0600 From: Chris User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Adolfo B. Ferreira" References: <1105984508.950.7.camel@notebook> In-Reply-To: <1105984508.950.7.camel@notebook> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by ClamAV 0.75.1/amavisd-new-2.2.1 (20041222) at makeworld.com - Isn't it ironic cc: current@freebsd.org Subject: Re: Maildrop X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 17 Jan 2005 18:05:08 -0000 Adolfo B. Ferreira wrote: >Hello Folks, > >Could some one help me with maildrop? > >I'm using FreeBSD 5.3 with all updated from CVS. >I'm trying to use maildrop with MYSQL and QUOTA but maildrop is not >connecting in MySQL. >I installed maildrop with >cd /usr/ports/mail/maildrop >make deinstall distclean WITH_MAILDIRQUOTA=yes WITH_TRASHQUOTA=yes >WITH_MYSQL=yes install clean >then i typed rehash and maildrop -v >maildrop 1.6.3 Copyright 1998-2003 Double Precision, Inc. >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. > >When I try to run maildrop with echo "test" | maildrop -V 5 -d >adolfo@anderung.com.br I got: >Invalid user specified. >but when I try with echo "test" | maildrop -V 5 -d root >maildrop: Changing to /root >Message start at 0 bytes, envelope sender=root >/usr/local/etc/maildrop/maildroprc(1): Opening >logfile /var/log/maildrop.log >maildrop: Attempting .mailfilter >maildrop: Delivering to /var/mail/root >maildrop: Appending to /var/mail/root. >maildrop: Delivery complete. > >So what I could understand is that maildrop is delivering only for users >from /etc/passwd. >My maildropmysql.config is located >in /usr/locall/etc/maildrop/maildropmysql.config and I set it in >Makefile of maildrop port. >anderung# cat maildropmysql.config >hostname localhost >port 3306 >socket /tmp/mysql.sock >database postfix >dbuser DBUSER >dbpw DBPASSWD >dbtable mailbox >uid_field username >uidnumber_field uid >gidnumber_field gid >maildir_field maildir >homedirectory_field home >quota_field quota >mailstatus_field active >where_clause AND active = '1' > >I have the user in the mailbox mysql table and the dbuser and dbpasswd >is correct. > >What am I doing wrong with maildrop? > >Thanks for all, > > >Adolfo Bravo Ferreira >Admninistrador de Redes / Analista de Segurança / Desenvolvedor >Grupo Ferreira Limitada >Telefone: 11 50628877 >_______________________________________________ >freebsd-current@freebsd.org mailing list >http://lists.freebsd.org/mailman/listinfo/freebsd-current >To unsubscribe, send any mail to "freebsd-current-unsubscribe@freebsd.org" > > > > You might have better luck asking in Questions or even Ports - I thought CURRENT (in this case) was for FBSD 6.0 and not 5.3 -- Best regards, Chris PGP Fingerprint = D976 2575 D0B4 E4B0 45CC AA09 0F93 FF80 C01B C363