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

[Leah K. <le...@fr...>]

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.

Leah
-- 
Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511
Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada
F9B6 FEFE 080B 8299 D7EA  1270 005C EC73 47C9 B7A6