List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:July 21 2003 5:39am
Subject:Re: quotas
View as plain text  
In the last episode (Jul 21), Paul Chvostek said:
> On Sun, Jul 20, 2003 at 11:43:20PM -0500, Dan Nelson wrote:
> > > For example user1 has a web space in /home/hostings/user1 and his
> > > database in /home/hostings/user1/data and user2 will have his web
> > > space in /home/hostings/user2 and database in
> > > /home/hostings/user2/data
> > 
> > Create symlinks from the mysql data dir to each user's directory:
> > 
> > /var/db/mysql/user1 -> /home/hostings/user1/data
> > /var/db/mysql/user2 -> /home/hostings/user2/data
> > 
> > etc.  Then any table the user creates in their database will end up
> > in their data dir.
> That'll put the files in the right directories, but if the quotas are
> based on file ownership, it won't limit the users' database size,
> since mysql wants the tables and indices to be owned by the 'mysql'
> user.

You may be able to use group quotas instead; newly-created files should
inherit the group ownership from the directory thay're in. 
Unfortunately, users can chgrp files they own to any group they're a
member of, so they can "cheat" by chgrp'ing large files in their web
directory to groups like "mysql", or "users".  If they are not members
of any group other than their own, this will work.

	Dan Nelson
quotasLaCraze21 Jul
  • Re: quotasDan Nelson21 Jul
    • Re: quotasPaul Chvostek21 Jul
      • Re: quotasDan Nelson21 Jul
        • Re: quotasPaul Chvostek23 Jul
  • Re: quotasYves Goergen21 Jul