Remote API fails after upgrade 3.1.15p2 -> 3.2.8p1

Hi Guys,

Im having some problems on remote api after upgrade ISPConfig Version: 3.1.15p2 to ISPConfig Version: 3.2.8p1.
This is my script soap to exec a create customer/mail_domain:

$soap_location = 'https://myserver/remote/index.php';
$soap_uri = 'https://myserver/remote/';

$client = new SoapClient(null, array('location' => $soap_location,
'uri' => $soap_uri,
'trace' => 1,
'stream_context'=> stream_context_create(array('ssl'=> array('verify_peer'=>false,'verify_peer_name'=>false))),
'exceptions' => 1));

try {
if ($session_id = $client->login($username, $password)) {

}
$params = array(
'company_name' => $data['domain_www'],
'contact_name' => $data['domain_contact'],
'country' => 'US',
'email' => $data['domain_contact_email'],
'default_mailserver' => 1,
'limit_maildomain' => 1,
'limit_mailbox' => 10,
'limit_mailalias' => 10,
'limit_mailaliasdomain' => 0,
'limit_mailforward' => 10,
'limit_mailcatchall' => 0,
'limit_mailrouting' => 0,
'limit_mailfilter' => -1,
'limit_fetchmail' => 0,
'limit_mailquota' => $data['quota'],
'limit_spamfilter_wblist' => -1,
'limit_spamfilter_user' => -1,
'limit_spamfilter_policy' => -1,
'default_webserver' => 0,
'limit_web_ip' => '',
'limit_web_domain' => 0,
'limit_web_quota' => 0,
'web_php_options' => 'no,fast-cgi,mod',
'limit_web_subdomain' => 0,
'limit_web_aliasdomain' => 0,
'limit_ftp_user' => 0,
'limit_shell_user' => 0,
'ssh_chroot' => 'no,jailkit,ssh-chroot',
'limit_webdav_user' => 0,
'default_dnsserver' => 0,
'limit_dns_zone' => 0,
'limit_dns_slave_zone' => 0,
'limit_dns_record' => 0,
'default_dbserver' => 0,
'limit_database' => 0,
'limit_cron' => 0,
'limit_cron_type' => 'url',
'limit_cron_frequency' => 5,
'limit_traffic_quota' => 0,
'username' => $data['domain_username'],
'password' => $data['domain_pass'],
'language' => 'en',
'usertheme' => 'default',
'template_additional' => '',
'created_at' => 0
);

$client_id = $client->client_add($session_id, 0, $params);
//Im receveing client_id correctly
$params = array(
'server_id' => 1,
'domain' => $data['domain_www'],
'active' => 'y'
);

$domain_id = $client->mail_domain_add($session_id, $client_id, $params);
//Im receiving domain_id correctly

$data = [$domain_id, $client_id];
return $data;
//returns $data correctly

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


So, every response looks fine and i can see the customer created correctly. The mail domain was created without a Customer defined.
There is no one CP user and i cant login at ISPConfig panel too.

I think something changed at API after this upgrade.
Please, anyone can help?

Regards.

 

Hi @Th0m
Thanks for your answer.
How to properly check this options with current documentation offline?

 

Hi Guys,

thanks for your replies.

Im back with more details.

With the ISPCONFIG upgrade i also performed the UPGRADE from Ubuntu 18 -> 20.
MYSQL has been updated from version 5.7 to 8 automatically.
Everthyng looks fine and all permissions are ok inside of MYSQL. (postfix/dovecot/roundcube) are both running and connecting without problems.

The problem specifically does not occur in the API but in the creation of the user when asked to create a new domain.
MYSQL 8 is supported by ISPCONFIG?
The problem was solved downgrading MYSQL to 5.7..

Is there something im missing?

 

Hi @Jesse Norell,

No.
The ISPCONFIG API returns with CLIENT ID and DOMAIN ID as expected without any error but when you check the domains list the client doesnt appear as owner of this domain.

The client field is empty and no cpuser was created for this domain.

With ISPCONFIG at DEBUG mode i cant see errors at log for this operation.

 

@Jesse Norell

Yes, the same parameters.
After downgrade to MYSQL 5.7 everything works again without problems.

 

hi @till

Before downgrade MYSQL I thought it might be related to the strict mode.
Tested with:

sql_mode=

at mysqld.cnf without successfull.
This was the first change after upgrade because without this parameter i cant login at ISPCONFIG.