通过php脚本创建cpanel数据库 [英] Create cpanel database through php script
问题描述
我正在尝试使用cpanel / whm和postwwwacct php脚本自动安装某些自定义软件,这需要将文件复制到用户public_html文件夹中,然后编辑配置并设置eh文件权限。到目前为止一切顺利,没有问题。当尝试创建数据库时,我遇到了一些问题。
Im trying to automate the installation of some custom software using cpanel/whm and postwwwacct php script.This requires files to be copied to the users public_html folder then edit the config and set eh file permissions. So far so good, no issues. When trying to create the database im running into some problems.
$db_create= $opts['user']. '_lol';
$db_host="immersion-networks.com";
include("xmlapi.php");
$xmlapi = new xmlapi($db_host);
$xmlapi->password_auth("".$opts['user']."","".$opts['pass']."");
$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($opts['user'], "Mysql", "adddb", array($db_create));
//create user
$usr = $xmlapi->api1_query($opts['user'], "Mysql", "adduser", array($db_create, $opts['pass']));
//add user
$addusr = $xmlapi->api1_query($opts['user'], "Mysql", "adduserdb", array($db_create,$db_create, 'all'));
其余的代码可以正常运行,但是没有创建数据库,用户也没有。
有什么想法吗?
Rest of the code runs ok but the db isnt being created nor are the users. Any ideas?
推荐答案
require("xmlapi.php"); // this can be downlaoded from https://github.com/CpanelInc/xmlapi-php/blob/master/xmlapi.php
$xmlapi = new xmlapi("your cpanel domain");
$xmlapi->set_port( 2083 );
$xmlapi->password_auth($opts['user'],$opts['pass']);
$xmlapi->set_debug(0);//output actions in the error log 1 for true and 0 false
$cpaneluser=$opts['user'];
$databasename="something";
$databaseuser="else";
$databasepass=$opts['pass'];
//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'));
上面的代码对我有用!
需要确保您使用的是cpanel用户/密码而不是root用户,并且还要使用端口2083
The above code worked for me! Need to make sure that you are using a cpanel user/pass not root and also that you are using port 2083
这篇关于通过php脚本创建cpanel数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!