No graphs for MySQL Application

[Sparky]

I have multiple MySQL servers, on some them graphs are empty with “nan” values.

• On some of these LibreNMS Poller won’t find the MySQL App
• On others, Poller finds it and shows the values for it but the graphs are still empty “nan”

In all of the cases if I do a manual snmpwalk for the OID of the mysql php script I see the values.

librenms$ ./snmpwalk.sh mysql.server.tld .1.3.6.1.4.1.8072.1.3.2.3.1.2.5.109.121.115.113.108
.1.3.6.1.4.1.8072.1.3.2.3.1.2.5.109.121.115.113.108 = STRING: a0:0
a1:0
a2:0
a3:0
a4:0
a5:22811
a6:0
a7:9
a8:0
a9:0
aa:39321600
ab:38854894
ac:462944
ad:0
ae:1046
af:462002
ag:479038
ah:1814804
...

I also tried the dirty patch, which worked on one of the servers. And I’ve also tried running snmpd with a lower NICE (-5) but didn’t help.

Any other ideas what should I try?

[pjchilds]

@Sparky

dirty patch

I have this same problem it is sort of doing my head in

I added this to line 160
$val = $val % ( 124999999999 + 1 );
and after a few polls it seems to be working again … I’ll keep and eye on it and if that is the ‘go’ perhaps I’ll submit a PR

[Sparky]

I noticed in /var/log/snmpd.log the following messages are repeated often, it looks this happens when LibreNMS connects to the server.

send response: Failure in sendto
    -- NET-SNMP-EXTEND-MIB::nsExtendOutputFull."zfs"
    -- NET-SNMP-EXTEND-MIB::nsExtendOutputFull."mysql"
    -- NET-SNMP-EXTEND-MIB::nsExtendOutNumLines."zfs"
    -- NET-SNMP-EXTEND-MIB::nsExtendOutNumLines."mysql"
    -- NET-SNMP-EXTEND-MIB::nsExtendResult."zfs"
    -- NET-SNMP-EXTEND-MIB::nsExtendResult."mysql"
    -- NET-SNMP-EXTEND-MIB::nsExtendOutLine."zfs".1
    -- NET-SNMP-EXTEND-MIB::nsExtendOutLine."mysql".1
    -- NET-SNMP-EXTEND-MIB::nsExtendOutLine."mysql".2
    -- NET-SNMP-EXTEND-MIB::nsExtendOutLine."mysql".3

If I do a manual snmpwalk I see no error messages.