groups in /var/lib/mysql after mysql update

Hi,
as I observed, Virtualmin sets the group of directories and files under /var/lib/mysql/ (databases and tables) as virtual server group, like this:

[code:1]
ls -al /var/lib/mysql/
(…)
drws–S— 2 mysql user.com 28672 2009-04-20 00:05 user_com
(…)
[/code:1]

[code:1]
ls -al /var/lib/mysql/user_com
(…)
-rw-rw---- 1 mysql user.com 12808 2009-02-17 22:41 table.frm
-rw-rw---- 1 mysql user.com 2064 2009-04-02 18:46 table.MYD
-rw-rw---- 1 mysql user.com 2048 2009-04-03 02:55 table.MYI
(…)
[/code:1]

I imagine that for the purposes of include the space occupied by database (group quota).

Well, today I installed a security update of mysql-server-5.0 on Debian Etch and post-installation script has asigned all files and directories to the mysql group.

To restore the groups I did the following

cd /var/lib/mysql grep ^dbs /etc/webmin/mysql/* |awk -F'/etc/webmin/mysql/' {'print "chgrp -Rc " $2'} |awk -F'.acl:dbs=' {'print $1 " " $2'} |bash

I hope it is helpful to other users Virtualmin on Debian. And I would like to know if anyone has thought about another solution.

best regards,
Santi

Post edited by: nodo50, at: 2009/04/29 06:41<br><br>Post edited by: nodo50, at: 2009/04/29 06:42

Thanks for the tip Santi. That’s an unfortunate bug-like behavior in Debian’s MySQL package. Might be worth filing a bug in their tracker. It really shouldn’t be tweaking files that aren’t even part of the package, and user databases obviously aren’t part of the package.

There is a bug open since 2007 http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=436468

but no answer. I sent a response to the bug (for shake it), but has not appeared in the bugreport.

:frowning:

Thanks for digging that up. That’s disappointing that it’s been a problem for two years with no response.