MySQL

MySQL

Install prereqs

The MySQL script requires PHP-CLI and the PHP MySQL extension, so please verify those are installed.

apt-get install php-cli php-mysql

yum install php-cli php-mysql

Create the cache directory

Create the cache directory, '/var/cache/librenms/' and make sure that it is owned by the user running the SNMP daemon.

mkdir -p /var/cache/librenms/

MySQL User

Refer to the Percona Documentation for details on how to create a MySQL user with privileges to read the required monitoring data from MySQL / MariaDB.

MySQL script

Unlike most other scripts, the MySQL script requires a configuration file mysql.cnf in the same directory as the extend or agent script with following content:

<?php
$mysql_user = 'root';
$mysql_pass = 'toor';
$mysql_host = 'localhost';
$mysql_port = 3306;

Note that depending on your MySQL installation (chrooted install for example), use 127.0.0.1 instead of localhost. localhost makes a MySQL connection via the mysql socket, while 127.0.0.1 make a standard IP connection to mysql.

Note also if you get a mysql error Uncaught TypeError: mysqli_num_rows(): Argument #1, this is because you are using a newer mysql version which doesnt support UNBLOCKING for slave statuses, so you need to also include the line $chk_options['slave'] = false; into mysql.cnf to skip checking slave statuses