I am trying to setup maildrop with mysql authentication for virtual
mailboxes. When I run maildrop from command line I get
[vmail@mail2 vmail]$ /usr/local/courier/bin/maildrop -d otheruser
maildrop: signal 0x0B
tail -f /var/log/mysqld.log
040918 8:16:56 59 Connect otheruser@localhost on
59 Init DB Access denied for user:
'otheruser@localhost' to database ELF'
59 Quit
Why is maildrop trying to connect to a database named "ELF'"??
Why is it trying to connect as user otheruser?
It appears that maildrop is not reading
/usr/local/courier/etc/maildropmysql.config
I compiled maildrop 1.7.0.20040907 as
$export CPPFLAGS="-I/usr/local/mysql/include"
$export LDFLAGS="-L/usr/local/mysql/lib"
$./configure \
--prefix=/usr/local/courier \
--enable-maildirquota \
--enable-maildropmysql \
--with-mysqlconfig=/usr/local/courier/etc/maildropmysql.config \
--enable-maildrop-uid=1001 \
--enable-maildrop-gid=1001 \
--with-trashquota
$make
#make install
Below is /usr/local/courier/etc/maildropmysql.config
hostname 127.0.0.1
socket /tmp/mysql.sock
database postfix
dbuser postfix
dbpw ********
dbtable mailbox
default_uidnumber 1001
default_gidnumber 1001
uid_field username
uidnumber_field 1001
gidnumber_field 1001
maildir_field maildir
#homedirectory_field homedir
quota_field quota
#mailstatus_field postfix
where_clause AND active = '1'
[root@mail2 root]# ls -al /usr/local/courier/etc/maildropmysql.config
-r-------- 1 vmail vmail 348 Sep 16 22:02
/usr/local/courier/etc/maildropmysql.config
TIA,
Malaney