Motadata Prerequisites

##Database Monitor

Database supported by Motadata are:

  • Oracle

  • Microsoft SQL

  • MySQL

  • PostgreSQL

  • IBM DB2

##Prerequisites for Oracle Database Monitor

In the Oracle database (that you are trying to monitor), ensure that the username assigned to Motadata has the permission to access the Oracle database from the host where Motadata is running.

User Privilege: To create a new Oracle database monitor, you should have admin privileges.

Minimum User Privileges > user with CONNECT and SELECT_CATALOG_ROLE roles.

##Prerequisites for MySQL Database Monitor

In the MySQL database (that you are trying to monitor), ensure that the user name assigned to Motadata has the permission to access the MySQL database from the host where Motadata is running. Else, give a relevant user who has the privileges to do the same.

Minimum User Privileges: The user should have privileges to execute SELECT, SHOW DATABASES and REPLICATION commands in the MySQL server. Also, Minder machine should be allowed to access the MySQL database server.

For enabling the privileges, execute the below commands in the remote MySQL Server:

INSERT INTO user (Host, User) VALUES(’’,’’);
GRANT SELECT,SHOW DATABASES,REPLICATION CLIENT ON . TO
‘’@’’; FLUSH PRIVILEGES;

##Prerequisites for MSSQL Database Monitor

In the MSSQL database (that you are trying to monitor), ensure that the username assigned to Motadata has the permission to access the MSSQL database from the host where Motadata is running.

Note: Minimum User Privileges required creating a new monitor of MSSQL: User should be permitted to access MASTER database & MSDB database.

Roles: public + db_datareader should be selected for both MASTER and MSDB databases.

Database Accessed: Master

Permit in Database Role: db_datareader & requires VIEW SERVER STATE permission on the server.

##Prerequisites for PostgreSQL Database Monitor

In the MSSQL database (that you are trying to monitor), ensure that the username assigned to Motadata has the permission to access the MSSQL database from the host where Motadata is running.

Note: Motadata uses PostgreSQL subsystem sta򀀀s򀀀cs collector to monitor PostgreSQL server activity. By default statics collector is accessible.

Also in postgresql.conf file, the parameter “ LISTEN ADDRESS ” has to be ’ ∗ ‘.

##Prerequisites for DB2 Database Monitor

In the DB2 database (that you are trying to monitor), ensure that the username assigned to Motadata has the permission to access the DB2 database from the host where Motadata is running.

User Privileged: To create a new DB2 monitor user should be able to access SYSPROC procedures.

##Webserver Monitor

##Web Servers supported by Motadata Motadata

  • Apache HTTP Server

  • Microsoft IIS Server

  • Nginx Server

##Prerequisites Apache HTTP Server Monitor

To monitor Apache Web Server the Server status and the Extended‐status should be enabled to fetch additional informa򀀀on from Apache server.

Please enable mod_status on the HTTP server to get stats.

##Prerequisites Microsoft IIS Server Monitor

To monitor IIS server ensure that Motadata has permission to access Windows server where IIS is hosted. Make sure Windows host server type is specified to be discovered while running the network discovery and WMI credential profile is provided to make the connection.

##Prerequisites NGINX Server Monitor

To monitor Nginx Server the Server Status should be enabled.

##Prerequisites Application Server Monitor

The Application Servers supported by Motadata Minder is * JBoss * Tomcat * WebSphere * WebLogic * GlassFish * Jetty

##Prerequisites JBoss Server Monitor

Motadata uses JMX to monitor JBoss server. JMX should be enabled to retrieve the information from JBoss. If JBoss is hosted on Windows platform, then there are two ways you can configure JMX in JBoss.

##Prerequisites Tomcat Server Monitor

Motadata uses JMX to monitor Tomcat server. JMX should be enabled to retrieve the information from Tomcat.

##Prerequisites WebSphere Server Monitor

Motadata uses Performance Monitoring Infrastructure (PMI) to monitor WebSphere. PMI should be enabled to retrieve informa򀀀on from WebSphere server.

##Prerequisites WebLogic Server Monitor

To add support for WebLogic server, you need to copy the wlfullclient.jar from WebLogic installation. On your WebLogic host, navigate to the folder where the WebLogic server was installed. It is typically installed at Oracle/Middleware/wlserver_/server/lib.

##Prerequisites Glassfish Server Monitor

Motadata uses JMX to monitor Glassfish server. JMX should be enabled to retrieve the information from Glassfish.

##Network Switch, Routers & Firewall

Select correct SNMP version & Community name. Readonly community type will also work. Allow Motadata Server IP address in SNMP configuration on the device.

##Restrictions of Network Discovery

  1. Motadata cannot discover devices that cannot be pinged. If, for example, a firewall blocks echo requests, a device behind it cannot be discovered.

  2. If proper creden򀀀als are not provided then also minder will not be able to the discovery our device.

  3. A device has more than one IP address, it may show up more than once in the discovery results.