From owner-freebsd-ports@FreeBSD.ORG Mon Jan 17 18:28:53 2005 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id E2F5916A4CE for ; Mon, 17 Jan 2005 18:28:53 +0000 (GMT) Received: from smtp-out.hotpop.com (smtp-out.hotpop.com [38.113.3.61]) by mx1.FreeBSD.org (Postfix) with ESMTP id 66B2543D5D for ; Mon, 17 Jan 2005 18:28:53 +0000 (GMT) (envelope-from bitchat@hotpop.com) Received: from hotpop.com (kubrick.hotpop.com [38.113.3.103]) by smtp-out.hotpop.com (Postfix) with SMTP id 33007D003B0 for ; Mon, 17 Jan 2005 18:28:48 +0000 (UTC) Received: from [10.1.1.7] (c90618ac.virtua.com.br [201.6.24.172]) by smtp-2.hotpop.com (Postfix) with ESMTP id 34F88CFF1A1 for ; Mon, 17 Jan 2005 18:28:46 +0000 (UTC) From: "Adolfo B. Ferreira" To: ports@freebsd.org Date: Mon, 17 Jan 2005 16:24:31 -0200 Message-Id: <1105986271.950.14.camel@notebook> Mime-Version: 1.0 X-Mailer: Evolution 2.0.3 X-HotPOP: ----------------------------------------------- Sent By HotPOP.com FREE Email Get your FREE POP email at www.HotPOP.com ----------------------------------------------- Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Content-Filtered-By: Mailman/MimeDel 2.1.1 Subject: Maildrop X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 17 Jan 2005 18:28:54 -0000 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