Retrieving Database Server Parameters
Use get operation to retrieve parameters of the database server specified by ID. You can retrieve preferences of multiple database servers in a single operation.
Request Packet Structure
A request XML packet retrieving a database server info includes the get operation node:
The get node has the following graphical representation:
- The filter node is required. It specifies the filtering rule. Data type: none.
- The id node is optional. Specifies the database server ID. Data type: integer.
Note: If the filter node is left blank (<filter/>), the operation will return info on all database servers.
Remarks
A single operation can retrieve the data of multiple database servers. Add as many different id parameters as the number of database servers info on which you want to retrieve.
Response Packet Structure
The get node of the output XML packet is structured as follows:
- The result node is required. It wraps the response retrieved from the server. Data type: extension of DatabaseServerResultType (
database_output.xsd
). - The status node is required. It specifies the execution status of the get operation. Data type: string. Allowed values: ok | error.
- The errcode node is optional. Is returns the error code if the get operation fails. Data type: integer.
- The errtext node is optional. It returns the error message if the get operation fails. Data type: string.
- The id node is optional. It returns the ID of the database server. Data type: integer.
- The data node is optional. Data type: databaseServerDescription (
plesk_db.xsd
) If the get operation succeeded it returns the following data:- The host node is optional. Specifies the IP address or name of the database server. Data type: string.
- The port node is optional. It specifies the port of the database server. Data type: string.
- The type node is required. It returns the type of the database server. Data type: string.
- The admin node is required. It specifies the login name of administrator of the database server. Data type: integer.
- The password node is optional. It specifies the password of the administrator of the database server. Data type: integer.
- The status node is required. It specifies the status of connection to the database server. Data type: string. Allowed values: NO_ERROR | CONNECTION_FAILED | LOGIN_FAILED | PERMISSION_DENIED | OTHER_ERROR | CREDENTIALS_NOT_SET
- The db_num node is required. It specifies the number of databases managed by the database server. Data type: integer.
- The default node is optional. It specifies a default database server. Data type: none.
- The local node is optional. It specifies a local database server. Data type: none.
Samples
Retrieving a single database server
This packet retrieves the database server specified by ID 7
Response:
If the database server was not found, the result is as follows:
Retrieving multiple database servers
This request packet retrieves info on the database servers specified by ID 2 and ID 92.
Response: