postfix+mysql+courier-imap+amavisd-new and maildrop it's doesn't work

Hi

I used debian sarge and I have postfix+mysql+spamassassin,amavisd-new,clamav...

I try running maildrop + mysql but it's not working
How are compiled maildrop with mysql, from source?

Anyone writes yours configurations about maildropmysql and mai.cf,master.cf?

Regards,
osanet

 

That's a good error message...
What exactly is not working? Any error messages in the logs?

 

Hi sorry I forgot past my error

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

And yous see , maildrop have support for mysql, now I run a little test

maildrop -V 10 -d [email protected] < test.txt
maildrop: Invalid user specified.
[email protected] in a mysql mail..
Why maildrop don't see mysql e-mail user?

Regards,
osanet

 

What's in your maildrop configuration file?

 

Hi
My config /etc/maildropmysql.conf

hostname 127.0.0.1
port 3306
database db_name
dbuser db_user
dbpw db_password
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

 

Is this information correct?
Can you connect to MySQL with

Code:

mysql -u db_user -p

?

 

no the really base name is a postfix_virt and username is a sarge
and I can connect to Mysql with this username the base and passwd is the same which postfix configurations used and postfix working ok
maildrop still not working

 

And you use this username and password in your maildrop configuration? Is the database name correct?
What's the output of

Code:

netstat -tap

?

 

Look

Postfix is working, users can get and send mails without any problmes.

maildrop -V 9 -d [email protected]
maildrop: Invalid user specified.

osanet

 

And does [email protected] exist in the mailbox table in the database postfix_virt?
What's the output of

Code:

mysql -u sarge -p
USE postfix_virt;
SELECT * FROM mailbox;
quit;

?

 

select * from mailbox where username='[email protected]'
-> ;
+------------------+------------------------------------+--------+-----------+-------------------+---------+-------------+---------------------+---------------------+--------+
| username | password | name | transport | maildir | quota | domain | created | modified | active |
+------------------+------------------------------------+--------+-----------+-------------------+---------+-------------+---------------------+---------------------+--------+
| [email protected] | $1$37b37de6$NyV1Hy/Y2jEb3SOd./UMF0 | | virtual | [email protected]/ | 1024000 | make.one.pl | 2005-03-08 19:10:34 | 2006-06-05 11:00:57 | 1 |
+------------------+------------------------------------+--------

An you see , user exist
I have OS - debian sarge, what distribution you used to write this howto
http://howtoforge.net/postfix_mailfilter ?

 

I didn't write it, someone else did, based on my tutorial: http://www.howtoforge.com/virtual_postfix_mysql_quota_courier
For that tutorial I used Debian Sarge.