Hi,

I got a strong (or stupid) problem with maildrop. When I try to deliver mails with maildrop I got always the following message:

vmail@chambertin:~$ maildrop -V -d te...@chambertin.fmx.ch < /tmp/test.mail maildrop: Unable to open filter file, errno=2. vmail@chambertin:~$

However I try to setup maildrop to use mysql to lookup the infos for the maildelivery. The goal is to use only virtual mailboxes, authentification is done on the mysql database. Each email adresse has his own folder but all files are owned by the user vmail (1004).

As I'm running a Debian Woody I had to recompile courier packages so maildrop work with mysql. some of my compilation options: --enable-maildropmysql \ --with-mysqlconfig=/etc/courier/maildropmysql.config \ --enable-maildrop-uid=1004 \ --enable-maildrop-gid=1004

I guess this is ok as maildrop show: chambertin:/etc/courier# maildrop -v maildrop 1.5.3 Copyright 1998-2003 Double Precision, Inc. GDBM extensions enabled. Maildir quota extension enabled. Virtual user database 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. chambertin:/etc/courier#

I was thinking that filter file was /etc/courier/maildroprc, this file exist is readable. Also /etc/courier/maildropmysql.config exit and is readable.

I was not able to found any solution on the web or in the list archieve. Has anybody an idea about that issue ? To what this error is realy related to ?

Thank you for your help ! Have a nice day, Marc

PS: I appologies for my bad english, but it's not my mother tong :-/

BTW: Here I compiled some infos about my setup to make the investigation more easy.

The list of my config files: chambertin:/etc/courier# ls -l total 40 -rw------- 1 vmail vmail 2728 Feb 25 15:52 authdaemonrc -rw------- 1 vmail vmail 11 Jan 17 15:00 authmodulelist -rw------- 1 vmail vmail 6493 Feb 25 15:57 authmysqlrc -rw------- 1 vmail vmail 11707 Feb 25 16:00 imapd -rw------- 1 vmail vmail 18 Jan 17 15:00 maildrop -rw------- 1 vmail vmail 506 Feb 27 10:23 maildropmysql.config -rw------- 1 vmail vmail 233 Feb 27 10:56 maildroprc chambertin:/etc/courier#

My maildroprc file: chambertin:/etc/courier# cat maildroprc if ( $SIZE < 26144 ) { exception { xfilter "/usr/bin/spamassassin" } }

if (/^X-Spam-Flag: *YES/) { exception { to "$HOME/$DEFAULT/.Spam/" } } else { exception { to "$HOME/$DEFAULT" } } chambertin:/etc/courier#

My maildropmysql.config file: chambertin:/etc/courier# cat maildropmysql.config hostname localhost port 3306 database mail dbuser vmail dbpw apassword dbtable postfix_users default_uidnumber 1004 default_gidnumber 1004 uid_field email uidnumber_field uid gidnumber_field gid maildir_field maildir homedirectory_field homedir quota_field quota # unused for now, but needs to be a valid field. mailstatus_field postfix where_clause AND postfix = 'y' chambertin:/etc/courier#

mysql> select * from postfix_users; +----+------------------------+-------+-------+------+------+------+--------------+---------------------------------+-------+--------+---------+ | id | email | clear | crypt | name | uid | gid | homedir | maildir | quota | access | postfix | +----+------------------------+-------+-------+------+------+------+--------------+---------------------------------+-------+--------+---------+ | 1 | te...@chambertin.fmx.ch | 1664 | | | 1004 | 1004 | /home/vmail/ | chambertin.fmx.ch/test/Maildir/ | | Y | Y | +----+------------------------+-------+-------+------+------+------+--------------+---------------------------------+-------+--------+---------+ 1 row in set (0.00 sec)

mysql>

--

#include <standard.disclaimer> Berthold Marc, Rolle, Switzerland

// Computers are only interesting when they go wrong, // otherwise it's just like watching television !!!