Linux - GeneralThis Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
I configured Qmail with vpopmail to use mysql auth and storage of
domain/user data. Everything works fine (creating domains/users, pop3 auth
etc.) except for one big detail. - All users/domains are stored in one table
(in mysql). This is not what I want. I configured vpopmail
with --enable-many-domains=y so one table would be created for each domain.
But it ain't working. Anyone know what could be causing this?
The mysql user that vpopmail use has been granted following permissions on
the mysql db: select, insert, update, delete, create, drop
vpopmail directory = /home/vpopmail
uid = 1009
gid = 105
ip alias = OFF --enable-ip-alias-domains=n (default)
address extentions = OFF --enable-qmail-ext=n (default)
rebuild tcpserver file = YES --enable-rebuild-tcpserver-file=y (default)
roaming users = OFF --enable-roaming-users=n (default)
user quota = 10485760 -enable-hardquota=10485760
domain quotas = OFF --enable-domainquotas=n (default)
auth module = mysql --enable-mysql=y
mysql replication = OFF --enable-mysql-replication=n (default)
table optimization = many domains --enable-many-domains=y (default)
system passwords = OFF --enable-passwd=n (default)
file locking = ON --enable-file-locking=y (default)
file sync = OFF --enable-file-sync=n disable vdelivermail fsync
make seekable = ON --enable-make-seekable=y (default)
auth logging = ON --enable-auth-logging=y (default)
mysql logging = ON --enable-mysql-logging=y
clear passwd = ON --enable-clear-passwd=y (default)
users big dir = ON --enable-users-big-dir=y (default)
valias processing = ON --enable-valias=y
mysql limits = OFF --enable-mysql-limits=n (default)
pop syslog = show failure attempts with clear text password
auth inc = -I/usr/local/mysql/include/mysql
auth lib = -L/usr/local/mysql/lib/mysql -lmysqlclient -lz