postwwwact script

madpato · Dec 8, 2011

Hello

I am following this guide for the creation of a db (and its user) for cpanel accounts:

Frequently Asked Scripts: "How do I automate XYZ after creating an account?" - cPanel Integration

I am not a programmer im just trying to do this to make my life at work easier when it comes to create a new account, I havent tested it yet because i want to sort out the fact that it uses the same password for the db and the cpanel account, so ive inserted a little password generator script inside that file (the bold part), this is what i have:

#!/usr/bin/php
# Scripts hook to create database and db virtuser; pair the two
<?php
//set error handling so any warnings are logged
ini_set('error_log','/usr/local/cpanel/logs/error_log');
ini_set('display_errors',0);

//include basic xmlapi client class
include('/home/cpanelcustom/xmlapi.php')

/**
* extend the basic xmlapi class
* add the method for getting args
*/
Class cpScriptsXmlApi extends XMLAPI
{
}

public $cliargs = array();

/**
* Simple method to store args into an array
*
*@params array $argv shell array to be parsed
*@return array
*/
public function argv2array ($argv) {
$opts = array();
$argv0 = array_shift($argv);

while(count($argv)) {
$key = array_shift($argv);
$value = array_shift($argv);
$opts[$key] = $value;
}
return $opts;
}
/**
* constructor
*
*@param array $scriptargs cli $argv that will be parsed
*@param string $host
*@param string $user
*@param string $password
*@return cpScriptsXmlApi
*/
public function __construct($scriptargs = array(), $host = null, $user = null, $password = null)
{
parent::__construct($host,$user,$password);
$this->cliargs = $this->argv2array($scriptargs);
return $this;
}
/**
* Create a database
*/
public function createUserDb(){}

/**
* Create a db virtuser
*/
public function createDbVirtuser(){}

/**
* Assign db privs
*/
public function assignUserPrivs(){}

/**
* Creating some different password
*/

function createRandomPassword() {

$chars = "abcdefghijkmnopqrstuvwxyz023456789";
srand((double)microtime()*1000000);
$i = 0;
$pass = '' ;

while ($i <= 7) {
$num = rand() % 33;
$tmp = substr($chars, $num, 1);
$pass = $pass . $tmp;
$i++;
}

return $pass;

}
$password = createRandomPassword();

/**
* Create a database
*
*@param string $user cpanel user to create db as
*@param string $dbname name for database
*/
public function createUserDb($user,$dbname){
$args = array($dbname);
return $this->api1_query($user,'Mysql','adddb',$args);
}
/**
* Create a db virtuser
*
*@param string $user cpanel user to create virtuser as
*@param string $virtusername name for db virtuser
*@param string $password password for new db virtuser
*/
public function createDbVirtuser($user,$virtusername,$password){
$args = array($virtusername,$password);
return $this->api1_query($user,'Mysql','adduser',$args);
}

/**
* Assign user privs
*
*@param string $user cpanel user to work on behalf of
*@param string $dbname name of database
*@param string $virtusername receiver of privs
*@param array $privs array of privileges to assign.
*/
public function assignUserPrivs($user,$dbname,$virtusername,$privs = array()){
$privs = (empty($privs))? array('all'): $privs; //not the best, you can change the default if you wish
$priv_str = implode(',',$privs);
$args = array($dbname, $virtusername, $priv_str);
return $this->api1_query($user,'Mysql','adduserdb',$args);
}

//create xmlapi object and set it's params
$xmlapi = new cpScriptsXmlApi($argv,'127.0.0.1');

//root auth hash
$hash = file_get_contents('/root/.accesshash');
$xmlapi->set_user('root');
$xmlapi->set_hash($hash);
$xmlapi->set_port('2087');

$dbtoattach = ((int)$prefixing)? $xmlapi->cliargs['user'].'_'.$dbname : $dbname;
$usertoattach = ((int)$prefixing)? $xmlapi->cliargs['user'].'_'.$virtusername : $virusername;
$xmlapi->assignUserPrivs($xmlapi->cliargs['user'], $dbtoattach, $usertoattach, $privs);

$xmlapi->createUserDb($xmlapi->cliargs['user'], $dbname);
$xmlapi->createDbVirtuser($xmlapi->cliargs['user'],$virtusername, $xmlapi->cliargs['pass']); //setting passwd same is not wise, but is done per commission request
$xmlapi->assignUserPrivs($xmlapi->cliargs['user'], $dbprefix.'_'.$dbname, $dbprefix.'_'.$virtusername, $privs);
Click to expand...

What i want to know is if this line:

$xmlapi->createDbVirtuser($xmlapi->cliargs['user'],$virtusername, $xmlapi->cliargs['pass']);
Click to expand...

If i put the variable $password (of the mentioned function) instead of ['pass'] it should work?

Any help and advice is appreciated. Thank you

cPanelDavidG · Dec 9, 2011

You would want to replace $xmlapi->cliargs['pass'] not just ['pass'] - the stuff between the brackets is a command line interfae (CLI) parameter. Since $password is a variable rather than a command line parameter, you would replace the entirety of that "variable."

To recap, a CLI parameter is something like this:

myscript.php user=bob pass=~sup3rsecur3!!

Everything after the .php is a parameter. In this case, the parameters are named user and pass respectively.

madpato · Dec 26, 2011

Im so sorry for my late reply. I will give it a try thank you.

Forums

The Community Forums

Interact with an entire community of cPanel & WHM users!

postwwwact script

madpato Active Member

cPanelDavidG Technical Product Specialist

madpato Active Member

Authentication to 3rd party plugins through scripting

Python Script not running on cPanel

cPanel ftp backup bash script

rDNS setup script?

Configuring reverse proxy for python script

Share This Page

Useful Searches

The Community Forums

Interact with an entire community of cPanel & WHM users!

postwwwact script

madpato Active Member

cPanelDavidG Technical Product Specialist

madpato Active Member

Authentication to 3rd party plugins through scripting

Python Script not running on cPanel

cPanel ftp backup bash script

rDNS setup script?

Configuring reverse proxy for python script

Share This Page