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:
[EMAIL PROTECTED] jason]$ echo "123"|maildrop-mysql -d [EMAIL PROTECTED]
Invalid user specified.
the maildrop-mysql binary is suid root (it drops perms to the recipient
when run with the -d option).
[EMAIL PROTECTED] 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
--
TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug
TriLUG Organizational FAQ : http://trilug.org/faq/
TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
TriLUG PGP Keyring : http://trilug.org/~chrish/trilug.asc
