Requirements

The requirements for doing that this monitoring works properly are the following:
•To install the Pandora FMS agent.
•To install Perl
•To have one MySQL database installed in the machine where it is going to monitor, with connection to this database.
•To specify the name, user, password and host of the MySQL database.
•It is necessary that the user whith which the Pandora FMS agent is executed, that is, the user that will execute the plugin, will have access to the following MySQL resources:
   ◦ MySQL homedir Directory( directory with the MySQL , usually /var/lib/mysql).
   ◦MySQL log file (usually /var/lib/mysql/mysql.log).
   ◦Access and writting permissions to a directory for temporary files.

Documentation the Area that requires the monitoring should report.
For the right MySQL monitoring, it should be necessary that the Technical Area sends some specific
information that will be included in the configuration files. These information is the following:
• User, password, host with access to the MySQL database. This user should have permission to read all the tables from which he want to extract information. This user should have pemissions to read all the tables from which he want to extract information.
•Log files and MySQL base directory.
•If you want to monitor some item that does not come defined “by default”, then it will be necessary that you provide that SQL code to do this monitoring, and also an exit data example, specifying if it is numeric, kind string, etc).