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. |