Re: webhosting with php/mysql and disk quota

Yes, however, a few of those require root permissions which gets tricky as you DO NOT want to run internet accessable php scripts as root, in which case you're hosed. What I do it run a perl daemon as root that php then connects to as a client and requests actions, and the daemon will only accept connections from localhost. The perl daemon actually does all the root actions. There's several ways to do this, some more secure than others.. But in a word, yes it's possible, but you'll need to give it some thought. -Micah On Monday 27 February 2006 1:01 pm, vassilis wrote: > Hello all, > is it possible to do the following thing with php/mysql? > > 1. user registers > 2. upon clicking the "submit" button a php script creates a mysql DB > with a unique name ( So far so good, till there I have no prob) > 3. the specific user gets SELCT INSERT UPDATE rights for his database only. > 4. Mysql quota is set to 10MB > 5. user directory with write permission only by the specific user gets > created > under the www directory. > 6. Syncronization of Disk quota and mysql quota e.g. 9MB pictures in the > user directory, > means 1MB left for mysql or the oposite 9MB mysql data, 1mb free in the > user directory. > > This whole thing must run on its own without someone to create the accounts > > thanks in advance > Vassilis > > -- > Using Opera's revolutionary e-mail client: > http://www.opera.com/mail/