LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
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.

Notices

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

Rep: Reputation: 0
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
 
  


Reply


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:27 AM.

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