Soap Issue - Creating DNS Record

Discussion in 'Installation/Configuration' started by laz99, Mar 2, 2023.

  1. laz99

    laz99 New Member

    Hi, I can successfully create a DNS SOA using the API.
    However when I try to create an A record for that zone I get the below error.

    I am using the pre-build file from the remoting_client\examples folder (dns_ds_add.php)

    Code:
    <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Body><SOAP-ENV:Fault><faultcode>database_error</faultcode><faultstring>Incorrect integer value: '' for column `dbispconfig`.`dns_rr`.`sys_userid` at row 1 INSERT INTO `dns_rr` (`server_id`, `zone`, `name`, `type`, `data`, `ttl`, `active`, `stamp`, `serial`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`) VALUES ('1', '10', 'test.uk', 'a', '192.168.1.88', '3600', 'y', '2023-03-01 16:59:49', '1', '', '', 'riud', 'riud', '')</faultstring></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope>
    SOAP Error: Incorrect integer value: '' for column `dbispconfig`.`dns_rr`.`sys_userid` at row 1 INSERT INTO `dns_rr` (`server_id`, `zone`, `name`, `type`, `data`, `ttl`, `active`, `stamp`, `serial`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`) VALUES ('1', '10', 'test.uk', 'a', '192.168.1.88', '3600', 'y', '2023-03-01 16:59:49', '1', '', '', 'riud', 'riud', '')
    My Parameters:

    Code:
            //* Set the function parameters.
            $client_id = 1;
            $params = array(
                    'server_id' => 1,
                    'zone' => '10',
                    'name' => 'test.uk.',
                    'type' => 'a',
                    'data' => '192.168.1.88',
                    'aux' => '0',
                    'ttl' => '3600',
                    'active' => 'y',
                    'stamp' => '2023-03-01 16:59:49',
                    'serial' => '1',
            );
    
    The error seems to point to sys_userid not being specified. I have tried adding this field to the parameters with the value of 0 but the error persists.

    Any Ideas to point me in the right direction would be much appreciated?
    Kindest Regards
    Colin
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Do not specify sys_userid. The issue is that there seems to be no client with client_id = 1 on your system.
     
    laz99 likes this.
  3. laz99

    laz99 New Member

    Ah, of course, how blind. Changed to 0 . Now working, thank you!
     

Share This Page