List:Internals« Previous MessageNext Message »
From:Sasha Pachev Date:February 5 2002 3:59am
Subject:Re: Jailed MySQL for hosting customers
View as plain text  
On Monday 04 February 2002 07:29 pm, David Phillips wrote:
> This would be a very powerful feature, but I don't know how difficult it
> would be to implement it. ?Can anyone who has worked with the MySQL codebase
> comment on this? ?Is there a point to working on it for the 3.23 branch? ?I
> would really like to have this feature, but I don't know the direction to
> take with this.

I must admit I was very curious to read your message when I saw the word 
"jailed" in the subject, and misread it as "Jailed for MySQL hosting" :-)

Seriously speaking, the feature your are proposing will be useful as I 
imagine many hosting companies will be benefited by it. However, there are 
some practical implementation issues - MySQL is a threaded server, and it 
will be difficult, if not impossible, to make a thread to setuid() to the 
user without wreaking havoc for everyone else. You could, of course, simply 
create databases as symlinks to the user directory, but everything there 
would have to be owned by MySQL server user.

-- 
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
   __  ___     ___ ____  __ 
  /  |/  /_ __/ __/ __ \/ /   Sasha Pachev <sasha@stripped>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Provo, Utah, USA
       <___/                  
Thread
Jailed MySQL for hosting customersDavid Phillips5 Feb
  • Re: Jailed MySQL for hosting customersSasha Pachev5 Feb
  • Re: Jailed MySQL for hosting customersDavid Phillips5 Feb
    • Re: Jailed MySQL for hosting customersSasha Pachev5 Feb
  • Re: Jailed MySQL for hosting customersAlexander Keremidarski5 Feb
    • Re: Jailed MySQL for hosting customersMichael Widenius10 Feb
  • Re: Jailed MySQL for hosting customersDavid Phillips5 Feb
    • Re: Jailed MySQL for hosting customersPaul DuBois5 Feb
    • Re: Jailed MySQL for hosting customersMichael Widenius10 Feb
  • Re: Jailed MySQL for hosting customersJeremy Zawodny6 Feb
  • Re: Jailed MySQL for hosting customersDavid Phillips6 Feb
    • Re: Jailed MySQL for hosting customersJeremy Zawodny6 Feb
    • Re: Jailed MySQL for hosting customersMichael Widenius10 Feb