Response Samples

Retrieving info on a single database server

This request packet retrieves info on the MySQL local database server.

<packet version="1.5.2.0">

<db_server>

 <get-local>

   <filter>

      <type>mysql</type>

   </filter>

 </get-local>

</db_server>

</packet>

A positive response from the server can look as follows:

<packet version="1.5.2.0">

<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 version="1.5.2.0">

<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>

Retrieving info on multiple database servers

This request packet retrieves info on all local database servers.

<packet version="1.5.2.0">

<db_server>

 <get-local>

   <filter/>

 </get-local>

</db_server>

</packet>

A possible response from the server can look as follows:

<packet version="1.5.2.0">

<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>