[TriLUG] maildrop w/ sql headache

Jason Tower jason at cerient.net
Tue Dec 7 02:13:47 EST 2004


anyone have maildrop working with mysql lookups?  i'm trying to get it 
set up but no matter what i try i get a "Invalid user specified" error:

[jason at mail jason]$ echo "123"|maildrop-mysql -d user at test.dom.ain
Invalid user specified.

the maildrop-mysql binary is suid root (it drops perms to the recipient 
when run with the -d option).

[jason at mail jason]$ maildrop-mysql -v
maildrop 1.6.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.

----------------------------------------------------------------

master.cf:

maildrop  unix  -       n       n       -       -       pipe
  flags=R user=vmail argv=/usr/bin/maildrop-mysql -d ${recipient}

----------------------------------------------------------------

/etc/maildrop/maildrop-mysql.config:

hostname        127.0.0.1
port            3306
socket          /var/lib/mysql/mysql.sock
database        vmail
dbuser          vmail
dbpw            <secret>
dbtable         passwd
default_uidnumber       500
default_gidnumber       500
uid_field               id
uidnumber_field         uid
gidnumber_field         gid
maildir_field           maildir
homedirectory_field     home
quota_field             quota
mailstatus_field        en

----------------------------------------------------------------

mysql> describe passwd;
+---------+--------------+------+-----+---------+-------+
| Field   | Type         | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| id      | varchar(255) |      | PRI |         |       |
| crypt   | varchar(64)  |      |     |         |       |
| uid     | int(4)       |      |     | 0       |       |
| gid     | int(4)       |      |     | 0       |       |
| home    | varchar(255) |      |     |         |       |
| maildir | varchar(255) |      |     |         |       |
| gecos   | varchar(128) | YES  |     | NULL    |       |
| en      | int(1)       |      |     | 1       |       |
| quota   | varchar(32)  | YES  |     | NULL    |       |
+---------+--------------+------+-----+---------+-------+


jason



More information about the TriLUG mailing list