Cpanel API Database Creation with out root access

Question

So I'm trying to create a database/user with out root access. It's either not possible - or i've done something wrong.

Suggestions? Missing a Step?

Here is my code as of now:

include("xmlapi.php");   
$xmlapi = new xmlapi($db_host);    
$xmlapi->password_auth("".$cpaneluser."","".$cpanelpass."");    
$xmlapi->set_debug(1);//output actions in the error log 1 for true and 0 false  
$xmlapi->set_output('array');//set this for browser output  
//create database    
$createdb = $xmlapi->api1_query($cpaneluser, "Mysql", "adddb", array($databasename));   
//create user 
$usr = $xmlapi->api1_query($cpaneluser, "Mysql", "adduser", array($databaseuser, $databasepass));   
 //add user 
$addusr = $xmlapi->api1_query($cpaneluser, "Mysql", "adduserdb", array("".$cpaneluser."_".$databasename."", "".$cpaneluser."_".$databaseuser."", 'all'));

Doing a print_r of any of the calls just tells me Array ( [data] => Array ( [result] => 0 [reason] => Access denied )

bstpierre · Accepted Answer · 2011-05-11 20:05:23Z

3

Actually the solution here is to do this:

$xmlapi->set_port( 2083 );

You don't need to disable SSL through WHM, that's not ideal.

edited May 11, 2011 at 20:05

bstpierre

31.5k16 gold badges74 silver badges105 bronze badges

answered May 11, 2011 at 16:22

Dave Goodchild

312 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ed Charkow Over a year ago

Your absolutely correct. Figured that out a few days later - but thanks for pointing it out.

Charles · Accepted Answer · 2011-04-10 05:00:45Z

0

So I'm trying to create a database/user with out root access

Unless the user you are logging in with has permission to create new databases or users, then you will not be able to accomplish this.

This is true whether we're talking about the CPanel API or MySQL itself.

answered Apr 10, 2011 at 5:00

Charles

51.5k13 gold badges107 silver badges146 bronze badges

4 Comments

Ed Charkow Over a year ago

The user I'm logging in with can log into cpanel and create a database and a user. He just doesn't have root access. Is there a different permission required?

Charles Over a year ago

Can the user perform any actions over the API? Maybe API use itself is a permission?

Ed Charkow Over a year ago

There was a setting in whm only allowing ssl connections. Turned it off and worked fine.

Charles Over a year ago

The joy of useless error messages! Please post your solution as a new answer to this question and mark it accepted, so this question shows as having been fixed.

Ed Charkow · Accepted Answer · 2011-04-11 00:45:04Z

0

There was a setting in whm only allowing ssl connections. Turned it off and worked fine.

answered Apr 11, 2011 at 0:45

Ed Charkow

616 bronze badges

Collectives™ on Stack Overflow

Cpanel API Database Creation with out root access

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related