LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - General (https://www.linuxquestions.org/questions/linux-general-1/)
-   -   mysql doesnt create a table for each domain (https://www.linuxquestions.org/questions/linux-general-1/mysql-doesnt-create-a-table-for-each-domain-77948/)

PurpleMotion 08-01-2003 03:16 AM

mysql doesnt create a table for each domain
 
Hi.

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

Configure options used:
./configure --enable-roaming-users=n --enable-logging=p --enable-defaultquo
ta=10485760 --enable-ip-alias-domains=n --enable-passwd=n --enable-clear-pas
swd=y --enable-domain-quotas=y --enable-mysql=y --enable-incdir=/usr/local/m
ysql/include/mysql --enable-libdir=/usr/local/mysql/lib/mysql --enable-many-
domains=y --enable-auth-logging=y --enable-mysql-logging=y --enable-valias=y
--enable-mysql-limits=n

vpopmail 5.3.23
Current settings
---------------------------------------

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
(default)
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
--enable-logging=p
auth inc = -I/usr/local/mysql/include/mysql
auth lib = -L/usr/local/mysql/lib/mysql -lmysqlclient -lz

Any tips would be appreciated.
Thanks


All times are GMT -5. The time now is 11:13 PM.