Go Job Hunting at the LQ Job Marketplace
Go Back > Forums > Linux Forums > Linux - General
User Name
Linux - General This 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.


  Search this Thread
Old 08-01-2003, 04:16 AM   #1
LQ Newbie
Registered: Jun 2003
Distribution: Slackware & Gentoo
Posts: 15

Rep: Reputation: 0
mysql doesnt create a table for each domain


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

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

Any tips would be appreciated.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
how to create ip rule table? yenonn Linux - Networking 6 07-26-2005 12:57 AM
CREATE TABLE problems in MySQL mosdef Linux - Software 0 03-10-2004 11:18 AM
MySQL non-realtime table-by-table mirroring Passive Linux - Software 1 01-20-2004 01:11 PM
How to import MS ACCESS Table including OLE filed into the MySQL Table ? myunicom Linux - General 1 11-28-2003 12:30 PM
new domain doesnt work yet? GraemeK Linux - Networking 3 08-25-2003 01:44 PM

All times are GMT -5. The time now is 04:20 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration