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'} |bashI 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.
--
Check out the forum guidelines!
There is a bug open since 2007 <a href='http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=436468' target='_blank'>http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=436468</a>
but no answer. I sent a response to the bug (for shake it), but has not appeared in the bugreport.
:-(
Thanks for digging that up. That's disappointing that it's been a problem for two years with no response.
--
Check out the forum guidelines!