Use the get-local operation to retrieve info on local database servers of the specified type. You can retrieve preferences of multiple local database servers in a single packet.
A request XML packet retrieving a local database server info includes the get-local operation node:
<packet version="1.4.2.0">
<db_server>
<get-local>
...
</get-local>
</db_server>
</packet>
The get-local node has the following graphical representation:
Note: If the filter node is left blank (<filter/>), the operation will return info on all local database servers.
A single operation can retrieve the data of multiple database servers. Add as many different type parameters as the number of local database servers info on which you want to retrieve.
<db_server>
<get-local>
...
</get-local>
...
<get-local>
...
</get-local>
</db_server>
database_output.xsd
).This request packet retrieves info on the MySQL local database server.
<packet>
<db_server>
<get-local>
<filter>
<type>mysql</type>
</filter>
</get-local>
</db_server>
</packet>
Response:
<packet>
<db_server>
<get-local>
<result>
<status>ok</status>
<type>mysql</type>
<id>1</id>
</result>
</get-local>
</db_server>
</packet>
If the type of database server was invalid, the response from the server looks as follows:
<packet>
<db_server>
<get-local>
<result>
<status>error</status>
<errcode>14007</errcode>
<errtext>Unsupported database type</errtext>
<type>NewSQL</type>
</result>
</get-local>
</db_server>
</packet>
This request packet retrieves info on all local database servers.
<packet>
<db_server>
<get-local>
<filter/>
</get-local>
</db_server>
</packet>
Response:
<packet>
<db_server>
<get-local>
<result>
<status>ok</status>
<type>mysql</type>
<id>1</id>
</result>
<result>
<status>ok</status>
<type>postgresql</type>
<id>2</id>
</result>
</get-local>
</db_server>
</packet>