Rest api Create Database "Error"

Community Support
1

/ Server credentials
$hst_hostname = ‘server.hestiacp.com’;
$hst_port = ‘8083’;
$hst_username = ‘admin’;
$hst_password = ‘p4ssw0rd’;
$hst_returncode = ‘yes’;
$hst_command = ‘v-add-database’;

// New Database
$username = ‘demo’;
$db_name = ‘wordpress’;
$db_user = ‘wordpress’;
$db_pass = ‘wpbl0gp4s’;

// Prepare POST query
$postvars = array(
‘user’ => $hst_username,
‘password’ => $hst_password,
‘returncode’ => $hst_returncode,
‘cmd’ => $hst_command,
‘arg1’ => $username,
‘arg2’ => $db_name,
‘arg3’ => $db_user,
‘arg4’ => $db_pass
);

// Send POST query via cURL
$postdata = http_build_query($postvars);
$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, ‘https://’ . $hst_hostname . ‘:’ . $hst_port . ‘/api/’);
curl_setopt($curl, CURLOPT_RETURNTRANSFER,true);
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);
curl_setopt($curl, CURLOPT_POST, true);
curl_setopt($curl, CURLOPT_POSTFIELDS, $postdata);
$answer = curl_exec($curl);

// Check result
if($answer === 0) {
echo “Database has been successfuly created\n”;
} else {
echo "Query returned error code: " .$answer. “\n”;
}

Query returned error code: in white

2

Is the API enabled in the settings and have added your server ip to the allowed ip list?

3

the api is enabled… because this code works,

<?php $hostname = 'server.yourdomain.tld'; $port = '8083'; $hstadmin = 'admin'; $hstadminpw = 'AdMin_pWd'; $username = $_POST['username']; $password = $_POST['password']; $postvars = array( 'user' => $hstadmin, 'password' => $hstadminpw, 'returncode' => 'no', 'cmd' => 'v-check-user-password', 'arg1' => $username, 'arg2' => $password, ); // Send POST query via cURL $postdata = http_build_query($postvars); $curl = curl_init(); curl_setopt($curl, CURLOPT_HEADER, false); curl_setopt($curl, CURLOPT_URL, 'https://' . $hostname . ':' . $port . '/api/'); curl_setopt($curl, CURLOPT_RETURNTRANSFER,true); curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false); curl_setopt($curl, CURLOPT_POST, true); curl_setopt($curl, CURLOPT_POSTFIELDS, $postdata); $answer = curl_exec($curl); //var_dump($answer); // Check result if($answer == 'OK') { echo "OK: User can login\n"; } else { echo "Error: Username or password is incorrect\n"; }
4

First please use the code tags it makes the code way more readable.

secondly check /var/log/hestia/error.log or /var/log/auth.log for any thing strange