remote api problems

Hello,

i have some problems with softacolous
So im debugging the remote api.
I used the examples from
https://git.ispconfig.org/ispconfig/ispconfig3/tree/master/remoting_client

But when adding a sql user the demoscript gives a error

Code:

database_error
Incorrect integer value: '' for column `ispconfigdb`.`web_database_user`.`sys_userid` at row 1
INSERT INTO `web_database_user` (`server_id`, `database_user`, `database_user_prefix`, `database_password`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`)
VALUES ('7', 'db_name2', '', '*1950D0F514CDFCA9037093847748A608B091D4BE', '', '', 'riud', 'riud', '')

SOAP Error: Incorrect integer value: '' for column `ispconfigdb`.`web_database_user`.`sys_userid` at row 1
INSERT INTO `web_database_user` (`server_id`, `database_user`, `database_user_prefix`, `database_password`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`)
VALUES ('7', 'db_name2', '', '*1950D0F514CDFCA9037093847748A608B091D4BE', '', '', 'riud', 'riud', '')

the used code is:

Code:

require 'soap_config.php';


$client = new SoapClient(null, array('location' => $soap_location,
                'uri'      => $soap_uri,
                'trace' => 1,
                'exceptions' => 1));


try {
        if($session_id = $client->login($username, $password)) {
                echo 'Logged successfull. Session ID:'.$session_id.'<br />';
        }

        //* Set the function parameters.
        $client_id = 1;
        $params = array(
                'server_id' => 7,
                'database_user' => 'db_name2',
                'database_password' => 'db_name2'
        );

        $database_user_id = $client->sites_database_user_add($session_id, $client_id, $params);

        echo "Database ID: ".$database_user_id."<br>";

        if($client->logout($session_id)) {
                echo 'Logged out.<br />';
        }


} catch (SoapFault $e) {
        echo $client->__getLastResponse();
        die('SOAP Error: '.$e->getMessage());
}

so i treid:

Code:

$params = array(
                'server_id' => 7,
                'database_user' => 'db_name2',
                'database_password' => 'db_name2',
                'sys_userid' =>  '1'
        );

but again a error and sys_userid is still empty.
So looks like sys_userid is somehow filterd?

Any idees?

 

So somewhere there is a check that checks the id?
Why is in the example then no sys_userid set.
In the DBtable the default = 0

 

Ik mean in the github example is not working. So what would be the correct code

 

Oke thanx.
Ik knie that they asked, IT worked in the past in a onder server, after migration IT stopped.
They blame ispconfig.
In in the middle trying tot make IT work for me.

Thanks for the answer