• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Issue GetDatabases Rest API Fatal Error

safemoon

Basic Pleskian
Server operating system version
Ubuntu 24.04.2 LTS
Plesk version and microupdate number
Plesk Obsidian 18.0.68 Update #2 Web Host Edition
Hi All,

Recently the API call to the /databases endpoint is not working properly without a "domain" parameter.
It used to work without any issues before.

Having the ability to find if a database name already exists in the server is very beneficial as it allows you to create databases/domains etc remotely without conflicts.
Is there any other way to check if a string of database name already exists in the system?

URL: <serverurl>:8443/api/v2/databases
Response:
JSON:
{
    "code": 0,
    "message": "PleskX\\Api\\Operator\\Database::getAll(): Argument #1 ($field) must be of type string, null given, called in /opt/psa/admin/plib/modules/rest-api/v2/library/SDK/pm_Database.php on line 47"
}

From my understanding it's a Fatal error on Plesk's API Files as the empty/non existent "domain" parameter is not handled properly.
@IgorG
 
Also the endpoint /dbusers does NOT work without a string query "dbId"
It used to work fine previously. It seems like a lot has changed in the API in the last few weeks, particularly in the databases from what I can see.

However, this is not good because now we have to make a lot more API calls and nested for loops just to check if a database user or a database exists before creating a new one.
 
Back
Top