Child pages
  • WHM API 1 Functions - remote_mysql_read_profile

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

Description

Excerpt

This function displays the details of a specified remote MySQL® profile.

Panel
bgColor#F2F2F2
borderStylenone

Examples 


Panel
bgColor#FFFFFF
borderStylenone
Expand
titleJSON API
Code Block
languagexml
https://hostname.example.com:2087/cpsess##########/json-api/remote_mysql_read_profile?api.version=1&name=MyProfile
Expand
titleXML API
Code Block
languagexml
https://hostname.example.com:2087/cpsess##########/xml-api/remote_mysql_read_profile?api.version=1&name=MyProfile
Expand
titleCommand Line
Code Block
languagebash
whmapi1 remote_mysql_read_profile name=MyProfile

Include Page
LIB:_WHMAPI1CLINote
LIB:_WHMAPI1CLINote

Expand
titleOutput (JSON)
Code Block
languagetext
linenumberstrue
{
  "data": {
    "profile_details": {
      "mysql_port": "3306",
      "setup_via": "1",
      "mysql_pass": "1234luggage",
      "active": 0,
      "mysql_user": "username",
      "mysql_host": "192.168.0.1"
    },
    "profile_name": "MyProfile"
  },
  "metadata": {
    "version": 1,
    "reason": "OK",
    "result": 1,
    "command": "remote_mysql_read_profile"
  }
}
Expand
titleOutput (XML)
Code Block
languagetext
linenumberstrue
<result>
    <data>
        <profile_details>
            <mysql_port>3306</mysql_port>
            <setup_via>1</setup_via>
            <mysql_pass>1234luggage</mysql_pass>
            <active>0</active>
            <mysql_user>username</mysql_user>
            <mysql_host>192.168.0.1</mysql_host>
        </profile_details>
        <profile_name>MyProfile</profile_name>
    </data>
    <metadata>
        <version>1</version>
        <reason>OK</reason>
        <result>1</result>
        <command>remote_mysql_read_profile</command>
    </metadata>
</result>

Include Page
LIB:_WHMAPIShellNote
LIB:_WHMAPIShellNote

Parameters

ParameterTypeDescriptionPossible valuesExample
namestring

Required

The profile's name.

A valid string.MyProfile

Returns

Return

TypeDescriptionPossible valuesExample
profile_detailshashA hash of the profile's data.This hash includes the name, mysql_host, mysql_user, mysql_pass, mysql_port, setup_via, and active returns. 

mysql_host

string

The MySQL server's IP address or hostname.

The function returns this value in the profile_details hash.

A valid IP address or hostname.192.168.0.1

mysql_user

string

The MySQL server's username.

The function returns this value in the profile_details hash.

A valid string.username

mysql_pass

string

The MySQL server's password.

The function returns this value in the profile_details hash.

A valid string.12345luggage

mysql_port

integer

The MySQL server's port.

The function returns this value in the profile_details hash.

A valid positive integer.3306

setup_via

string

A description of the profile data.

The function returns this value in the profile_details hash.

A valid string with a maximum length of 255 characters.Main terminal

active

Boolean

Whether the system uses this profile to access the MySQL server.

The function returns this value in the profile_details hash.

  • 1 — Active.
  • 0 — Not active.
0
profile_namestringThe profile's name.A valid string.MyProfile