A default database server manages all databases of the corresponding type. Only one default database server for each type of databases is available in Plesk. Use the get-default operation to retrieve a default database server.
A request XML packet retrieving a default database server info includes the get-default operation node:
<packet>
<db_server>
<get-default>
...
</get-default>
</db_server>
</packet>
The get-default node has the following graphical representation:
The type node is required. It specified the default database of which type to retrieve. Data type: string. Allowed values: mysql | postgresql | mssql.
Note: If the filter node is left blank (<filter/>), the operation will return default database servers for all types of databases.
A single packet can retrieve the data of multiple default database servers. Add as many different type parameters as the number of default database servers info on which you want to retrieve.
<db_server>
<get-default>
...
</get-default>
...
<get-default>
...
</get-default>
</db_server>
The get-default node of the output XML packet is structured as follows:
database_output.xsd
).This request packet retrieves default Microsoft SQL database server info.
<packet>
<db_server>
<get-default>
<filter>
<type>mssql</type>
</filter>
</get-default>
</db_server>
</packet>
Response:
<packet>
<db_server>
<get-default>
<result>
<status>ok</status>
<type>mssql</type>
</result>
</get-default>
</db_server>
</packet>
If an unsupported type was specified in the request packet, the response from the server looks as follows:
<packet>
<db_server>
<get-default>
<result>
<status>error</status>
<errcode>14006</errcode>
<errtext>unsupported database type</errtext>
<type>mssql</type>
</result>
</get-default>
</db_server>
</packet>
This packet retrieves default MySQL and PostgreSQL database servers info.
<packet>
<db_server>
<get-default>
<filter>
<type>mysql</type>
<type>postgresql</type>
</filter>
</get-default>
</db_server>
</packet>
Response:
<packet>
<db_server>
<get-default>
<result>
<status>ok</status>
<type>mysql</type>
</result>
<result>
<status>ok</status>
<type>postgresql</type>
</result>
</get-default>
</db_server>
</packet>