Edit profile

Page History

Versions Compared

Old Version 1

changes.mady.by.user user-eb51a

Saved on Mar 05, 2025

compared with

New Version 2

changes.mady.by.user user-eb51a

Saved on Mar 05, 2025

Key

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

...

You can use either of the HTTP methods GET and POST.

The Parameters

The parameters that you will need to pass are:

_object: This basically addresses the logical object in Monyog that you want to direct your request to.The only acceptable value is MONyogAPI.
_action: This specifies the part of the object specified above that you want to direct your request to. The acceptable values are:
- Alerts
- DataCollection
- Sniffer
- LongRunningQueries
- LockedQueries
- LongRunningQueryAction
- AddServer
- EditServer
- RemoveServer
_value: The operation that you want to perform for the action specified in the _action field. Acceptable values include for:
- Alerts, DataCollection, Sniffer, LongRunningQueries, LockedQueries: enable and disable
- LongRunningQueryAction: notify, kill and notifyandkill
_user: It may be Monyog user, LDAP user or LDAP Group user. In case, no user is supplied, admin account is used by default.
_password: The password for the specified _user.
_server: Name or data directory number of the servers separated by a comma(‘,’) for which the operation to be performed.
_tags: Name of the tag separated by a comma(‘,’) for which the operation to be performed for all the servers under the specified tag.

API's for server management

To manage servers in Monyog via API, the following parameters need to be passed:

...

In summary, the various URLs that you can use with curl:

Change LDAP bind user password:

Code Block

theme	Confluence

$ curl "127.0.0.1:5555/?_object=MONyogAPI&_action=changeldapbindpassword&_user=<sqldm user name>&_password=<sqldm user password>&_currentpassword=<current ldap user password>&_newpassword=<new ldap user password>"

Change user password:

Code Block

theme	Confluence

$ curl "127.0.0.1:5555/?_object=MONyogAPI&_action=changepassword&_user=<sqldm username>&_password=<currentpassword>&_newpassword=<newpassword>"

Starts data collection for <server name>

Code Block

theme	Confluence

$ curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=DataCollection
       &_value=enable&_user=admin&_password=Password&_server=Production001"

Starts data collection for <multiples servers>

Code Block

theme	Confluence

$ curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=DataCollection
       &_value=enable&_user=admin&_password=Password&_server=Production001,Test"

Stops data collection for <server name>(Slave Of Production)

Code Block

theme	Confluence

$ curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=DataCollection
       &_value=disable&_user=admin&_password=Password&_server=Slave+Of+Production"

Starts data collection for <tag>

Code Block

theme	Confluence

$ curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=DataCollection
       &_value=enable&_user=admin&_password=Password&_tag=Production"

Stops data collection for <tag>

Code Block

theme	Confluence

$ curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=DataCollection
       &_value=disable&_user=admin&_password=Password&_tag=Production"

Stops data collection globally for all the servers (Maintenance)

Code Block

theme	Confluence

$ curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=datacollection&_value=enable&_user=admin&_password="

Enables alerts for <server name>

Code Block

theme	Confluence

$ curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=Alerts
       &_value=enable&_user=admin&_password=Password&_server=Production001"

Disables alerts for <server name>

Code Block

theme	Confluence

$ curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=Alerts
       &_value=disable&_user=admin&_password=Password&_server=Production001"

Enables alerts for <tag>

Code Block

theme	Confluence

$ curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=Alerts
       &_value=enable&_user=admin&_password=Password&_tag=Production"

Disables alerts for <tag>

Code Block

theme	Confluence

$ curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=Alerts
       &_value=disable&_user=admin&_password=Password&_tag=Production"

Disables alerts globally for all the servers(Maintenance)

Code Block

theme	Confluence

$ curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=Alerts&_value=disable&_user=admin&_password="

Enables alerts globally for all the servers(Maintenance)

Code Block

theme	Confluence

$ curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=Alerts&_value=enable&_user=admin&_password="

Enables Sniffer for <server name>

Code Block

theme	Confluence

$ curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=sniffer
       &_value=enable&_server=Production001"

Disables Sniffer for <server name>

Code Block

theme	Confluence

$ curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=sniffer
       &_value=disable&_server=Production001"

Add Server

Code Block

theme	Confluence

$ curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=addserver
       &_mysqluser=msandbox&_mysqlhost=127.0.0.1&_mysqlport=3306&_tags=Production
       &_server=Test&_mysqlpassword=msandbox&_connectontype=direct
       &_user=admin&_password=Password"

Add Server with SSH Tunnel

Code Block

theme	Confluence

$ curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=addserver
       &_mysqluser=msandbox&_mysqlhost=127.0.0.1&_mysqlport=3306
       &_tags=Production&_server=Test&_mysqlpassword=msandbox
       &_connectiontype=ssh&_sshhost=192.168.1.86&_sshuser=username
       &_sshpassword=sshpassword&_sshport=22&_user=admin&_password=Password"

Edit Server

Code Block

theme	Confluence

$ curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=editserver
       &_mysqluser=msandbox&_mysqlhost=127.0.0.1&_mysqlport=3306
       &_tags=Production&_server=Test&_mysqlpassword=msandbox
       &_connectontype=direct&_user=admin&_password=Password"

Delete Server

Code Block

theme	Confluence

$ curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=removeserver&_server=Test"

Delete all the servers under <tag>

Code Block

theme	Confluence

curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=removeserver&_tag=Production"

Delete multiple servers

Code Block

theme	Confluence

curl "http://192.168.1.1:5555/?_object=MONyogAPI&_action=removeserver&_server=Server1,Server2"

Return Codes

Assuming that the connection to SQL DM for MySQL was successful, it returns a text message. The message is in the JSON format:

...

Note
Since version 5.21 we have deprecated the API calls to `_object=ConnectionMgr`. Instead use `_object=MONyogAPI`.

Applications

The Monyog API is very flexible and can be accessed from other programming languages including scripting languages such as Perl, VBScript, etc. Here is a very generic Perl script that accepts the required parameters from the command line and executes the specified action:

Code Block

theme	Confluence

#! /usr/bin/perl
use LWP 5.64;
# USAGE: MONyog.pl <hostname>:<port> <user> <password> <connection_name/ID> <action> <value>
# $ARGV[0] = hostname:port of server running Monyog
# $ARGV[1] = Monyog user
# $ARGV[2] = Monyog password
# $ARGV[3] = connection name
# $ARGV[4] = action
# $ARGV[5] = value
my $numArgs = $#ARGV + 1;
if($numArgs < 5) {
   die 'USAGE: MONyog.pl <hostname>:<port> <user> <password> <connection_name/ID> <action>';
}

my $browser = LWP::UserAgent->new;

# The request URL
my $url = URI->new('http://' . $ARGV[0] . '/');

# The form data pairs:
$url->query_form(
   '_object' => 'MONyogAPI',
   '_action' => $ARGV[4],
   '_user' => $ARGV[1]
   '_password' => $ARGV[2],
   '_server' => $ARGV[3],
   '_value' => $ARGV[5]
);

# The response object
$response = $browser->post($url);

if (!$response->is_success) {# Error connecting to MONyog
   die $response->status_line . "\n";
} else { 

   # Successfully connected to MONyog; print MONyog's response
   print $response->content . "\n";

}

Scroll pdf ignore

Newtabfooter
alias IDERA
url http://www.idera.com
|
Newtabfooter
alias Products
url https://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
alias Purchase
url https://www.idera.com/buynow/onlinestore
|
Newtabfooter
alias Support
url https://idera.secure.force.com/
|
Newtabfooter
alias Community
url http://community.idera.com
|
Newtabfooter
alias Resources
url http://www.idera.com/resourcecentral
|
Newtabfooter
alias About Us
url http://www.idera.com/about/aboutus
|
Newtabfooter
alias Legal
url https://www.idera.com/legal/termsofuse

Content

Space Tools

Versions Compared

Old Version 1

New Version 2

Key

The Parameters

API's for server management

Change LDAP bind user password:

Change user password:

Starts data collection for <server name>

Starts data collection for <multiples servers>

Stops data collection for <server name>(Slave Of Production)

Starts data collection for <tag>

Stops data collection for <tag>

Stops data collection globally for all the servers (Maintenance)

Enables alerts for <server name>

Disables alerts for <server name>

Enables alerts for <tag>

Disables alerts for <tag>

Disables alerts globally for all the servers(Maintenance)

Enables alerts globally for all the servers(Maintenance)

Enables Sniffer for <server name>

Disables Sniffer for <server name>

Add Server

Add Server with SSH Tunnel

Edit Server

Delete Server

Delete all the servers under <tag>

Delete multiple servers

Return Codes

Applications