Re: Maildrop

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_at_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_at_freebsd.org mailing list
>http://lists.freebsd.org/mailman/listinfo/freebsd-current
>To unsubscribe, send any mail to "freebsd-current-unsubscribe_at_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