Re: [webmin-l] Virtualmin DB creation user group perms on database files

[Jamie C. <jca...@we...>]

On 25/Nov/2006 10:14 Leah Kubik wrote ..
> On Thursday 23 November 2006 18:21, Jamie Cameron wrote:
> > On 23/Nov/2006 13:46 Leah Kubik wrote ..
> > Currently, Virtualmin attempts to sum up the size of a domain's databases
> > and include that in the quota usage display on the Edit Virtual Server
> > page. However, because the files under /var/lib/mysql/$dbname are not
> > owned by the virtual server's group, they don't actually count towards the
> > enforced quota..
> 
> Ah, I wasn't sure if that was happening or not, so that is good to know,
> despite not being part of the enforced quota.
> 
> > Have you ever tested to see if mysql still runs when its database files
> > have a different group owner? If it still works fine, I would consider
> > having Virtualmin do this automatically. Of course, it would need to
> > set the group-inheritance bit on the DB directory too, to make sure any new
> > table files have the right ownership.
> 
> So far, I haven't seen any problems running the DB's w/different GID's
> than  mysql, which we started doing manually just for now.

Cool, I will definately look into having Virtualmin set the group owner
automatically for new databases in future.

Have you ever checked to see how MySQL behaves when adding rows to a table
goes over quota, or when creating new table does? Hopefully it returns a 
useful error to the user, and doesn't simply crash ..

 - Jamie