MySQL snmpd extension not working on LibreNMS itself

Hi,

I got a really weird problem.

I had extended the snmpd.conf on several hosts to monitor the MySQL instances.
Graphs show up like expected except on the LibreNMS host itself.

Credentials for the script located in “/etc/snmpd/” are settled in a file called “mysql.cnf”.
When I run the script as user librenms values are pulled from MySQL

bash-4.2$ cd /etc/snmp/
bash-4.2$ ./mysql
a0:0
a1:0
a2:0
a3:0
...
...
...
eh:24474624
ei:134217728
ej:0
ek:0
bash-4.2$

But graphs on the UI are not populated.

./poller.php -h 1 shows following about the applications:

#### Load poller module applications ####
 apache: UUUUUUUUUU...U......
 memcached(): ..................
 mysql: UUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU
 ntp-client: U....
: .
 rrdcached: .UUUU..U.

Any idea what’s going on here?

HI @Jarod2801,

As always, ./validate.php your install.

Then, if everything is ok, run ./poller.php -d -h 1 -m applications and check the output or pastebin if you dont find any problem.

1 Like

Shame on me having forgot the validate.php

====================================
Component | Version
--------- | -------
LibreNMS  | 1.42.01-78-g6d62026
DB Schema | 260
PHP       | 7.0.31
MySQL     | 5.5.60-MariaDB
RRDTool   | 1.4.8
SNMP      | NET-SNMP 5.7.2
====================================

[OK]    Composer Version: 1.7.2
[OK]    Dependencies up-to-date.
[OK]    Database connection successful
[OK]    Database schema correct
[FAIL]  Missing PHP extension: mysqlnd
        [FIX] Please install mysqlnd
[FAIL]  The poller (xyz-librenms) has not completed within the last 5 minutes, check the cron job.

I replace php70w-mysql with php70w-mysqlnd.

Now validate.php shows no errors any more.
I will have a look on the graphs later as I have to leave now.

Thanks a lot!!!

Works!
Thank you for your help.