Hi

Now I have postfix+mysql+courier-imap+amavisd-new+spamassassin
and I want add a maildrop with mysql but it's no working

this is a maildropmysql config:

cat /etc/maildropmysql.conf
hostname 127.0.0.1
port 3306
database postfix_virt
dbuser sarge
dbpw mypassword
dbtable mailbox
default_uidnumber 107
default_gidnumber 1003
uid_field username
homedirectory_field concat('/var/vmail/',maildir)
homedirectory_base /var/vmail/
maildir_field maildir
quota_field concat(quota,'S')
mailstatus_field active
gid_field 1003
When I try running test a maildrop I get this error
maildrop -V 10 -d user@make.one.pl < test.txt
maildrop: Invalid user specified.
maildrop -v
maildrop 1.5.3 Copyright 1998-2003 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
select * from mailbox where username='test@make.one.pl'
-> ;
+------------------+------------------------------------+--------+-----------+-------------------+---------+-------------+---------------------+---------------------+--------+
| username | password | name | transport | maildir | quota | domain | created | modified | active |
+------------------+------------------------------------+--------+-----------+-------------------+---------+-------------+---------------------+---------------------+--------+
| test@make.one.pl | $1$37b37de6$NyV1Hy/Y2jEb3SOd./UMF0 | | virtual | test@make.one.pl/ | 1024000 | make.one.pl | 2005-03-08 19:10:34 | 2006-06-05 11:00:57 | 1 |
+------------------+------------------------------------+--------
You see maildrop is compiled with mysql support , user exist in mysql mailbox but maildrop still no working

Anyone have any ideas, why it's no working?

Regards,

ufocek