setting up webhosting with php/mysql

[babil]

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

PS: As someone suggested in another forum, a possible solution is to connect php to a perl demon and the execute then system related actions. ( php should not execute scripts as root due to security reasons). Any good link to start reading about this or maybe another idea?

[herve]

Yes it should work. If you have a script (shell script) that do everything you want, the next thing
to do is just a daemon (in PERL on anything else) which listen on local IP only
(127.0.0.1), on a specific port (let's say 1234). Then your PHP script use some
fsockopen() function call and send the parameters needed (username, etc.) with fwrite().

Another direction might be :

• the PHP script simply create a text file in a specific directory with all the parameters inside
  (username, ...)

• you have a daemon running in background, regularly checking this directory for
  new files, and when found one, process it.

[babil]

Hi, thanks for your help. I somehow figured it out.

A user registers with a php script. His data is stored in a "users_pending" DB.
With a bash script I export the DB.

#! /bin/bash 
/opt/lampp/bin/mysqldump -u xxxx -pxxxxxxx
users_pending --tab=/home/edmundo/sqldump

Then a perl script creates the user DB, his rights, and some more functionality that I'm going to add.

#! /usr/bin/perl 
 open (DUMP,"users.txt"); 
while ($line = <DUMP>)  

{    

  chop($line);    

  ($u_id,$username,$password,$email,$active)=split (/\t/,$line);          

  open (MYSQLPIPE, "| /opt/lampp/bin/mysql -u xxx -pxxxxxxx");    

    {         print MYSQLPIPE ("CREATE DATABASE `$u_id`;");      

               print MYSQLPIPE ("GRANT SELECT,INSERT,UPDATE ON `$u_id`.* TO '$username'\@'%' IDENTIFIED BY PASSWORD '*$password';");    

               print MYSQLPIPE ("flush privileges;");       

       }       close(MYSQLPIPE);    

    if(eof)     

     {      close(DUMP);     

      }   

} 

I plan to run these scripts as CRON jobs every hour.
There is still a lot to be done but this was a good start.

Thanks for the tips

Cheers
Vassilis