Yes, you certainly needs to chown the files to the specific user id's for filesystem quota to count the files in the user's quota.
This will solve your quota needs, although I see many potential problems: - The mysql daemon needs to have access to the files. An easy solution is to chgrp mysql the files (they should already be) and then change the permissions so the group has access to them (chmod g+rwx). You could also use access control list if your system supports it. - We don't want the users to access the database files directly If a user owns a file, he can change permissions on it, modify it, delete it, etc.. The mysql daemon will not like that and it can cause all sorts of unexpected problems I guess. So the first thing to do is to NOT put the files in the user's home directory with the symlink hack. This has no advantage and the users will certainly mess with them if you do so. A complete solution might be to only chown the files, not their directory. If the user has no access to the directory, he cannot modify its files even though they are owned by him. - Database files are created at various times You cannot only have a script set the permissions correctly when the database is created and then forget about it. As the tables will be created, new files will appear and they need to be chown'ed / chmod'ed. A cron job might come in handy here. - innodb tables are different This should work with myISAM tables, but innodb stores the data in one big file shared between databases if I am not mistaken. So you need to prevent your users from using innoDB. May be other table type will have a similar problem and you might not be able to prevent users from using them. May be someone more experienced with the different table types available can enlighten us here. I never tried such a setup but I will have to soon. Any quirks I missed? Cedric Le December 11, 2002 12:06 am, Steven Adams a écrit : > Well hows it spoes to work with disk qoutas if u dont chown it to the user > id?? > > /Steve > ----- Original Message ----- > From: "Dean Harding" <[EMAIL PROTECTED]> > To: "'Steven Adams'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Wednesday, December 11, 2002 7:32 AM > Subject: RE: Quota Support > > > Why would you need to chown it? Your user's won't need to touch the > > file at all, so it should be happy being owned by mysql... > > > > I don't know, maybe it won't work... I'm not much of a Unix person - > > I've never touched unix since I left university :) > > > > Dean. > > > > > -----Original Message----- > > > From: Steven Adams [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, 10 December 2002 7:42 pm > > > To: [EMAIL PROTECTED] > > > Subject: Re: Quota Support > > > > > > > > > So do u mean like this > > > > > > user home dir = /home/web/users/xxx > > > > > > then u symlink /home/web/users/xxx/mysql/database1 > > > > /usr/local/mysql/lib/database1 > > > > > > chown -R xxx.xxx /home/web/users/xxx/mysql/database1 > > > > > > Wouldent mysql get permissions errors like that? > > > > > > /Steve > > > ----- Original Message ----- > > > > > > > From: "Dean Harding" <[EMAIL PROTECTED]> > > > > To: "'Steven Adams'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > > > Sent: Monday, December 09, 2002 7:01 PM > > > > Subject: RE: Quota Support > > > > > > > > > You can place the actual database files inside your user's home > > > > > directory, and sym-link to them from the MySQL's data folder. > > > > That > > > > > way > > > > > > > > they will contribute to the user's whole quota and you don't end > > > > up > > > > > with > > > > > > > > one quota for DB and another for everything else. > > > > > > > > > > The drawback, of course, is that you have to limit it to one user > > > > per > > > > > > > database (but each user could have more than one database). > > > > > > > > > > Dean Harding. > > > > > > > > > > > -----Original Message----- > > > > > > From: Steven Adams [mailto:[EMAIL PROTECTED]] > > > > > > Sent: Monday, 9 December 2002 4:07 pm > > > > > > To: [EMAIL PROTECTED] > > > > > > Subject: Quota Support > > > > > > > > > > > > Hey, > > > > > > I was wondering if its possible to implant a quota > > > > system > > > > > > > where i > > > > > > > > > > > can give a user just say access to 2 databases which is allowed > > > > to > > > > > > > grow to > > > > > > > > > > > 30Mb bewteen the two of them.. > > > > > > > > > > > > What i would really like is if its possible to make mysql use > > > > the > > > > > disk > > > > > > > > > quota > > > > > > limits.. So i can give the uses say 50MB WebSpace on my server > > > > which > > > > > > > will > > > > > > > > > > > iclude his mysql db > > > > > > > > > > > > Thanks > > > > > > /Steve > > > > -------------------------------------------------------------------- > > > > > - > > > > > > > > > Before posting, please check: > > > > > > http://www.mysql.com/manual.php (the manual) > > > > > > http://lists.mysql.com/ (the list archive) > > > > > > > > > > > > To request this thread, e-mail > > > > <[EMAIL PROTECTED]> > > > > > > > > To unsubscribe, e-mail <mysql-unsubscribe- > > > > > > [EMAIL PROTECTED]> > > > > > > Trouble unsubscribing? Try: > > > > > > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > Before posting, please check: > > > http://www.mysql.com/manual.php (the manual) > > > http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail <mysql-unsubscribe- > > > [EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
