Using SNMP Extend (MySQL) with Percona MySQL 8 database - not working

When asking for help and support, please provide as much information as possible. This should include:

  • Steps to reproduce an issue.

Followed the steps here: https://docs.librenms.org/Extensions/Applications/#mysql to setup mysql monitoring. Installed php-mysql and php-cli on database server.

  • The output of ./validate.php

====================================

Component Version
LibreNMS 1.50.1
DB Schema 2019_02_10_220000_add_dates_to_fdb (132)
PHP 7.2.15-0ubuntu0.18.04.2
MySQL 10.1.38-MariaDB-0ubuntu0.18.04.1
RRDTool 1.7.0
SNMP NET-SNMP 5.7.3

====================================

[OK] Composer Version: 1.8.5
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct

I’ve downloaded the ttps://github.com/librenms/librenms-agent/raw/master/snmp/mysql and changed the permissions and setup my mysql.cnf file. However, it doesn’t appear to be working correctly and not sure if there is a log somewhere that I could tell? I noticed Percona has these: https://www.percona.com/downloads/percona-monitoring-plugins/LATEST/ but not sure if I need to install one of them?

This is the version of MySQL I am running: mysql --version
mysql Ver 8.0.13-4 for debian-linux-gnu on x86_64 (Percona Server (GPL), Release ‘4’, Revision ‘f0a32b8’)

Any help would be appreciated. I have a cluster that I’m wanting to use LibreNMS for and this might be a make or break decision if I can’t get this working.

Hi,

Can you exec the script manually? Does it return info?

snmp user needs to be able to run that script.

1 Like

Thank you! That helped solve the problem halfway.

When running the script manually I got this error:

ERROR: The server requested authentication method unknown to the client

A quick google search lead me to this site:

Which suggested I change the authentication type to mysql_native_password - which I then did follow the instructions and executed the script again which worked.

Cause was likely from the caching_sha2_password default.

However, Libre isn’t showing anything on the graphs yet.

This is the output from running the script.

a0:0
a1:0
a2:0
a3:0
a4:43
a5:799866
a6:0
a7:2
a8:0
a9:0
aa:8192
ab:6280
ac:1891
ad:0
ae:1718
af:173
ag:16876
ah:14231
ai:1989
aj:30289
ak:10950
al:0
am:0
an:18446744073709551613
ao:-1
ap:0
aq:0
ar:-1
as:0
at:0
au:0
av:0
aw:0
ax:86
ay:0
az:73
b0:3
b1:3924
b2:2
b3:39872
b4:0
b5:25
b6:0
b7:2
b8:770
b9:794
ba:4000
bb:10000
bc:4000
bd:0
be:191
bf:4
bg:0
bh:2
bi:2
bj:4
bk:2
bl:151
bm:9
bn:1448
bo:-1
bp:-1
bq:-1
br:-1
bs:0
bt:-1
bu:-1
bv:-1
bw:-1
bx:-1
by:-1
bz:-1
c0:-1
c1:-1
c2:14931
c3:3626
c4:3
c5:5250
c6:986
c7:0
c8:0
c9:0
ca:0
cb:0
cc:0
cd:1
ce:0
cf:95
cg:0
ch:3152
ci:0
cj:20
ck:214
cl:163
cm:56
cn:0
co:6
cp:12163505
cq:1802626
cr:16777216
cs:0
ct:416345822
cu:416345822
cv:-1
cw:32768
cx:0
cy:3615
cz:138822600
d0:0
d1:0
d2:0
d3:0
d4:0
d5:0
d6:0
d7:0
d8:0
d9:0
da:0
db:0
dc:0
dd:0
de:0
df:0
dg:1
dh:2
di:16210
dj:1
dk:0
dl:7232
dm:4096
dn:22230
do:19162
dp:16
dq:131
dr:42208
ds:0
dt:0
du:0
dv:3926
dw:13258
dx:0
dy:0
dz:34679
e0:0
e1:-1
e2:-1
e3:0
e4:1
e5:0
e6:2
e7:-1
e8:-1
e9:-1
ea:-1
eb:-1
ec:-1
ed:-1
ee:-1
ef:-1
eg:0
eh:1529856
ei:8388608
ej:0
ek:0
ol:-1
om:-1
on:-1
oo:-1
op:-1
oq:-1
or:-1
os:-1
ot:-1
ou:-1
ov:-1
ow:-1
ox:-1
oy:-1
oz:-1
pg:-1
ph:-1
pi:-1
pj:-1
pk:-1
pl:-1
pm:-1
pn:-1
po:-1
pp:-1
pq:-1
pr:-1
ps:-1
pt:-1
pu:-1
pv:-1
pw:-1
px:-1
py:-1
pz:-1
qg:-1
qh:-1
qi:-1
qj:-1
qk:-1
ql:-1
qm:-1
qn:-1
qo:1718
qp:144650

Ok. Something is something.

Now you need to make sure the snmpd user is able to exec that script.

From librenms server, try
snmpwalk -v2c -c public localhost NET-SNMP-EXTEND-MIB::nsExtendOutput2Table

Changing public with your community and localhost with the server that host the script.

MIB search path: /home/administrator/.snmp/mibs:/usr/share/snmp/mibs:/usr/share/snmp/mibs/iana:/usr/share/snmp/mibs/ietf:/usr/share/mibs/site:/usr/share/snmp/mibs:/usr/share/mibs/iana:/usr/share/mibs/ietf:/usr/share/mibs/netsnmp
Cannot find module (SNMP-FRAMEWORK-MIB): At line 9 in /usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt
Cannot find module (SNMPv2-SMI): At line 8 in /usr/share/snmp/mibs/NET-SNMP-MIB.txt
Did not find ‘enterprises’ in module #-1 (/usr/share/snmp/mibs/NET-SNMP-MIB.txt)
Unlinked OID in NET-SNMP-MIB: netSnmp ::= { enterprises 8072 }
Undefined identifier: enterprises near line 10 of /usr/share/snmp/mibs/NET-SNMP-MIB.txt
Cannot find module (SNMPv2-TC): At line 21 in /usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt
Did not find ‘SnmpAdminString’ in module #-1 (/usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt)
Did not find ‘netSnmpObjects’ in module NET-SNMP-MIB (/usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt)
Did not find ‘netSnmpModuleIDs’ in module NET-SNMP-MIB (/usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt)
Did not find ‘netSnmpNotifications’ in module NET-SNMP-MIB (/usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt)
Did not find ‘netSnmpGroups’ in module NET-SNMP-MIB (/usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt)
Did not find ‘DisplayString’ in module #-1 (/usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt)
Did not find ‘RowStatus’ in module #-1 (/usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt)
Did not find ‘TruthValue’ in module #-1 (/usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt)
Unlinked OID in NET-SNMP-AGENT-MIB: nsAgentNotifyGroup ::= { netSnmpGroups 9 }
Undefined identifier: netSnmpGroups near line 545 of /usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt
Unlinked OID in NET-SNMP-AGENT-MIB: nsTransactionGroup ::= { netSnmpGroups 8 }
Undefined identifier: netSnmpGroups near line 536 of /usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt
Unlinked OID in NET-SNMP-AGENT-MIB: nsConfigGroups ::= { netSnmpGroups 7 }
Undefined identifier: netSnmpGroups near line 515 of /usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt
Unlinked OID in NET-SNMP-AGENT-MIB: nsCacheGroup ::= { netSnmpGroups 4 }
Undefined identifier: netSnmpGroups near line 505 of /usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt
Unlinked OID in NET-SNMP-AGENT-MIB: nsModuleGroup ::= { netSnmpGroups 2 }
Undefined identifier: netSnmpGroups near line 495 of /usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt
Unlinked OID in NET-SNMP-AGENT-MIB: netSnmpAgentMIB ::= { netSnmpModuleIDs 2 }
Undefined identifier: netSnmpModuleIDs near line 24 of /usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt
Unlinked OID in NET-SNMP-AGENT-MIB: nsTransactions ::= { netSnmpObjects 8 }
Undefined identifier: netSnmpObjects near line 55 of /usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt
Unlinked OID in NET-SNMP-AGENT-MIB: nsConfiguration ::= { netSnmpObjects 7 }
Undefined identifier: netSnmpObjects near line 54 of /usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt
Unlinked OID in NET-SNMP-AGENT-MIB: nsErrorHistory ::= { netSnmpObjects 6 }
Undefined identifier: netSnmpObjects near line 53 of /usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt
Unlinked OID in NET-SNMP-AGENT-MIB: nsCache ::= { netSnmpObjects 5 }
Undefined identifier: netSnmpObjects near line 52 of /usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt
Unlinked OID in NET-SNMP-AGENT-MIB: nsDLMod ::= { netSnmpObjects 4 }
Undefined identifier: netSnmpObjects near line 51 of /usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt
Unlinked OID in NET-SNMP-AGENT-MIB: nsExtensions ::= { netSnmpObjects 3 }
Undefined identifier: netSnmpObjects near line 50 of /usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt
Unlinked OID in NET-SNMP-AGENT-MIB: nsMibRegistry ::= { netSnmpObjects 2 }
Undefined identifier: netSnmpObjects near line 49 of /usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt
Unlinked OID in NET-SNMP-AGENT-MIB: nsVersion ::= { netSnmpObjects 1 }
Undefined identifier: netSnmpObjects near line 48 of /usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt
Unlinked OID in NET-SNMP-AGENT-MIB: nsNotifyRestart ::= { netSnmpNotifications 3 }
Undefined identifier: netSnmpNotifications near line 482 of /usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt
Unlinked OID in NET-SNMP-AGENT-MIB: nsNotifyShutdown ::= { netSnmpNotifications 2 }
Undefined identifier: netSnmpNotifications near line 476 of /usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt
Unlinked OID in NET-SNMP-AGENT-MIB: nsNotifyStart ::= { netSnmpNotifications 1 }
Undefined identifier: netSnmpNotifications near line 470 of /usr/share/snmp/mibs/NET-SNMP-AGENT-MIB.txt
Did not find ‘nsExtensions’ in module NET-SNMP-AGENT-MIB (/usr/share/snmp/mibs/NET-SNMP-EXTEND-MIB.txt)
Did not find ‘DisplayString’ in module #-1 (/usr/share/snmp/mibs/NET-SNMP-EXTEND-MIB.txt)
Did not find ‘RowStatus’ in module #-1 (/usr/share/snmp/mibs/NET-SNMP-EXTEND-MIB.txt)
Did not find ‘StorageType’ in module #-1 (/usr/share/snmp/mibs/NET-SNMP-EXTEND-MIB.txt)
Unlinked OID in NET-SNMP-EXTEND-MIB: nsExtendGroups ::= { nsExtensions 3 }
Undefined identifier: nsExtensions near line 39 of /usr/share/snmp/mibs/NET-SNMP-EXTEND-MIB.txt
Unlinked OID in NET-SNMP-EXTEND-MIB: nsExtendObjects ::= { nsExtensions 2 }
Undefined identifier: nsExtensions near line 38 of /usr/share/snmp/mibs/NET-SNMP-EXTEND-MIB.txt
Unlinked OID in NET-SNMP-EXTEND-MIB: netSnmpExtendMIB ::= { nsExtensions 1 }
Undefined identifier: nsExtensions near line 19 of /usr/share/snmp/mibs/NET-SNMP-EXTEND-MIB.txt
NET-SNMP-EXTEND-MIB::nsExtendOutput2Table: Unknown Object Identifier

Yeah, sorry.

snmpwalk -v2c -c public localhost -M /opt/librenms/mibs -m ALL NET-SNMP-EXTEND-MIB::nsExtendOutput2Table

This looks better…

NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.1 = STRING: a0:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.2 = STRING: a1:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.3 = STRING: a2:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.4 = STRING: a3:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.5 = STRING: a4:22
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.6 = STRING: a5:800989
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.7 = STRING: a6:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.8 = STRING: a7:2
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.9 = STRING: a8:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.10 = STRING: a9:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.11 = STRING: aa:8192
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.12 = STRING: ab:6278
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.13 = STRING: ac:1893
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.14 = STRING: ad:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.15 = STRING: ae:1718
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.16 = STRING: af:175
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.17 = STRING: ag:19222
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.18 = STRING: ah:16148
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.19 = STRING: ai:1989
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.20 = STRING: aj:34448
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.21 = STRING: ak:12419
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.22 = STRING: al:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.23 = STRING: am:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.24 = STRING: an:18446744073709551613
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.25 = STRING: ao:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.26 = STRING: ap:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.27 = STRING: aq:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.28 = STRING: ar:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.29 = STRING: as:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.30 = STRING: at:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.31 = STRING: au:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.32 = STRING: av:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.33 = STRING: aw:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.34 = STRING: ax:108
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.35 = STRING: ay:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.36 = STRING: az:91
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.37 = STRING: b0:3
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.38 = STRING: b1:4418
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.39 = STRING: b2:2
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.40 = STRING: b3:41837
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.41 = STRING: b4:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.42 = STRING: b5:81
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.43 = STRING: b6:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.44 = STRING: b7:2
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.45 = STRING: b8:787
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.46 = STRING: b9:811
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.47 = STRING: ba:4000
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.48 = STRING: bb:10000
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.49 = STRING: bc:4000
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.50 = STRING: bd:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.51 = STRING: be:191
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.52 = STRING: bf:4
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.53 = STRING: bg:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.54 = STRING: bh:2
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.55 = STRING: bi:2
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.56 = STRING: bj:4
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.57 = STRING: bk:2
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.58 = STRING: bl:151
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.59 = STRING: bm:9
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.60 = STRING: bn:1650
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.61 = STRING: bo:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.62 = STRING: bp:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.63 = STRING: bq:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.64 = STRING: br:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.65 = STRING: bs:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.66 = STRING: bt:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.67 = STRING: bu:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.68 = STRING: bv:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.69 = STRING: bw:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.70 = STRING: bx:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.71 = STRING: by:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.72 = STRING: bz:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.73 = STRING: c0:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.74 = STRING: c1:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.75 = STRING: c2:17209
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.76 = STRING: c3:4122
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.77 = STRING: c4:3
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.78 = STRING: c5:5921
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.79 = STRING: c6:1121
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.80 = STRING: c7:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.81 = STRING: c8:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.82 = STRING: c9:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.83 = STRING: ca:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.84 = STRING: cb:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.85 = STRING: cc:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.86 = STRING: cd:1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.87 = STRING: ce:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.88 = STRING: cf:101
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.89 = STRING: cg:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.90 = STRING: ch:3687
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.91 = STRING: ci:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.92 = STRING: cj:22
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.93 = STRING: ck:218
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.94 = STRING: cl:174
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.95 = STRING: cm:140
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.96 = STRING: cn:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.97 = STRING: co:6
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.98 = STRING: cp:14894652
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.99 = STRING: cq:2046254
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.100 = STRING: cr:16777216
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.101 = STRING: cs:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.102 = STRING: ct:416639686
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.103 = STRING: cu:416639686
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.104 = STRING: cv:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.105 = STRING: cw:32768
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.106 = STRING: cx:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.107 = STRING: cy:4109
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.108 = STRING: cz:139130384
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.109 = STRING: d0:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.110 = STRING: d1:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.111 = STRING: d2:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.112 = STRING: d3:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.113 = STRING: d4:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.114 = STRING: d5:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.115 = STRING: d6:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.116 = STRING: d7:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.117 = STRING: d8:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.118 = STRING: d9:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.119 = STRING: da:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.120 = STRING: db:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.121 = STRING: dc:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.122 = STRING: dd:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.123 = STRING: de:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.124 = STRING: df:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.125 = STRING: dg:1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.126 = STRING: dh:2
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.127 = STRING: di:18006
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.128 = STRING: dj:1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.129 = STRING: dk:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.130 = STRING: dl:8220
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.131 = STRING: dm:4628
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.132 = STRING: dn:23571
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.133 = STRING: do:19176
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.134 = STRING: dp:16
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.135 = STRING: dq:131
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.136 = STRING: dr:105368
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.137 = STRING: ds:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.138 = STRING: dt:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.139 = STRING: du:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.140 = STRING: dv:4420
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.141 = STRING: dw:43918
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.142 = STRING: dx:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.143 = STRING: dy:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.144 = STRING: dz:34679
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.145 = STRING: e0:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.146 = STRING: e1:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.147 = STRING: e2:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.148 = STRING: e3:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.149 = STRING: e4:1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.150 = STRING: e5:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.151 = STRING: e6:2
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.152 = STRING: e7:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.153 = STRING: e8:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.154 = STRING: e9:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.155 = STRING: ea:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.156 = STRING: eb:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.157 = STRING: ec:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.158 = STRING: ed:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.159 = STRING: ee:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.160 = STRING: ef:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.161 = STRING: eg:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.162 = STRING: eh:1529856
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.163 = STRING: ei:8388608
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.164 = STRING: ej:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.165 = STRING: ek:0
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.166 = STRING: ol:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.167 = STRING: om:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.168 = STRING: on:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.169 = STRING: oo:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.170 = STRING: op:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.171 = STRING: oq:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.172 = STRING: or:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.173 = STRING: os:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.174 = STRING: ot:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.175 = STRING: ou:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.176 = STRING: ov:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.177 = STRING: ow:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.178 = STRING: ox:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.179 = STRING: oy:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.180 = STRING: oz:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.181 = STRING: pg:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.182 = STRING: ph:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.183 = STRING: pi:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.184 = STRING: pj:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.185 = STRING: pk:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.186 = STRING: pl:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.187 = STRING: pm:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.188 = STRING: pn:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.189 = STRING: po:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.190 = STRING: pp:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.191 = STRING: pq:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.192 = STRING: pr:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.193 = STRING: ps:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.194 = STRING: pt:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.195 = STRING: pu:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.196 = STRING: pv:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.197 = STRING: pw:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.198 = STRING: px:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.199 = STRING: py:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.200 = STRING: pz:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.201 = STRING: qg:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.202 = STRING: qh:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.203 = STRING: qi:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.204 = STRING: qj:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.205 = STRING: qk:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.206 = STRING: ql:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.207 = STRING: qm:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.208 = STRING: qn:-1
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.209 = STRING: qo:1718
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“mysql”.210 = STRING: qp:156405
NET-SNMP-EXTEND-MIB::nsExtendOutLine.“osupdate”.1 = STRING: 60

Next step.

Have you enabled applications module for that device?

Device -> Edit -> Modules

Enable and wait. You can rediscover device to make it appear quickly, but wait at least from 2 to 4 poll cycles (10 to 20min if using default polling interval)

No luck. Even removed and re-added the server.

Try, as librenms user, ./poller.php -d -h YOURDEVICE -m applications and check the output

Not sure completely what to look for - but here you go:

LibreNMS Poller
SQL[select migration from migrations order by id desc limit 1 [] 0.31ms]

SQL[select count(*) as aggregate from migrations limit 1 [] 0.2ms]

SQL[SELECT version() [] 0.2ms]

===================================
Version info:
Commit SHA: f37e28a5f2f7a1bc90de534ff951afc89531c24d
Commit Date: 1555120070
DB Schema: 2019_02_10_220000_add_dates_to_fdb (132)
PHP: 7.2.15-0ubuntu0.18.04.2
MySQL: 10.1.38-MariaDB-0ubuntu0.18.04.1
RRDTool: 1.7.0
SNMP: NET-SNMP 5.7.3
==================================DEBUG!
Updating os_def.cache…
Done
Override poller modules: applications
Starting polling run:

SQL[SELECT * FROM devices WHERE disabled = 0 AND hostname = ‘mysql.example.net’ ORDER BY device_id ASC [] 0.9ms]

SQL[SELECT * FROM devices_attribs WHERE device_id = ? [25] 0.19ms]

Hostname: mysql.example.net
Device ID: 25
OS: linux (unix)

[FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 mysql.example.net
array (
‘xmt’ => ‘3’,
‘rcv’ => ‘3’,
‘loss’ => ‘0’,
‘min’ => ‘0.58’,
‘max’ => ‘0.75’,
‘avg’ => ‘0.65’,
‘exitcode’ => 0,
)
SQL[INSERT IGNORE INTO device_perf (xmt,rcv,loss,min,max,avg,device_id,timestamp,debug) VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) {“xmt”:“3”,“rcv”:“3”,“loss”:“0”,“min”:“0.58”,“max”:“0.75”,“avg”:“0.65”,“device_id”:25,“debug”:"[]"} 3.67ms]

SNMP Check response code: 0
Modules status: Global+
OS
Device

Load poller module core

SNMP[’/usr/bin/snmpget’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-OQnUt’ ‘-m’ ‘SNMPv2-MIB’ ‘-M’ ‘/opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell’ ‘udp:HOSTNAME:161’ ‘sysUpTime.0’ ‘sysLocation.0’ ‘sysContact.0’ ‘sysName.0’ ‘sysObjectID.0’ ‘sysDescr.0’]
...0 = 2761490
...0 = Location
...0 = Name
...0 = mysql
...0 = ..4.1.8
...0 = Linux mysql 4.15.0-46-generic #49-Ubuntu SMP Wed Feb 6 09:33:07 UTC 2019 x86_64

SNMP[’/usr/bin/snmpget’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-OQnUst’ ‘-m’ ‘HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB’ ‘-M’ ‘/opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell’ ‘udp:HOSTNAME:161’ ‘snmpEngineTime.0’ ‘hrSystemUptime.0’]
snmpEngineTime.0 = 27615
hrSystemUptime.0 = 8394800

Uptime seconds: 83948
RRD[update mysql.example.net/uptime.rrd N:83948 --daemon unix:/var/run/rrdcached.sock]
Uptime: 23 hours 19 minutes 8 seconds
SQL[select * from locations where (location = ?) limit 1 [“Location”] 0.32ms]

Runtime for poller module ‘core’: 0.0235 seconds with 76592 bytes
SNMP: [2/0.02s] MySQL: [0/0.00s] RRD: [1/0.00s]

Unload poller module core

RRD[update mysql.example.net/poller-perf-core.rrd N:0.023543119430542 --daemon unix:/var/run/rrdcached.sock]
Modules status: Global+
OS
Device

Load poller module applications

SQL[SELECT * FROM applications WHERE device_id = ? [25] 0.41ms]

SNMP[’/usr/bin/snmpget’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-Ovq’ ‘-M’ ‘/opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell’ ‘udp:HOSTNAME:161’ ‘.1.3.6.1.4.1.8072.1.3.2.3.1.2.5.109.121.115.113.108’]
“a0:0
a1:0
a2:0
a3:0
a4:3
a5:803329
a6:0
a7:2
a8:0
a9:0
aa:8192
ab:6272
ac:1899
ad:0
ae:1718
af:181
ag:24067
ah:20147
ai:1989
aj:43100
ak:15536
al:0
am:0
an:18446744073709551614
ao:-1
ap:0
aq:0
ar:-1
as:0
at:0
au:0
av:0
aw:0
ax:131
ay:0
az:111
b0:3
b1:5448
b2:2
b3:46028
b4:0
b5:195
b6:0
b7:2
b8:794
b9:818
ba:4000
bb:10000
bc:4000
bd:0
be:191
bf:4
bg:0
bh:2
bi:2
bj:4
bk:2
bl:151
bm:9
bn:2179
bo:-1
bp:-1
bq:-1
br:-1
bs:0
bt:-1
bu:-1
bv:-1
bw:-1
bx:-1
by:-1
bz:-1
c0:-1
c1:-1
c2:22473
c3:5157
c4:3
c5:7412
c6:1401
c7:0
c8:0
c9:0
ca:0
cb:0
cc:0
cd:1
ce:0
cf:116
cg:0
ch:4888
ci:0
cj:27
ck:228
cl:198
cm:311
cn:0
co:6
cp:20595401
cq:2596541
cr:16777216
cs:0
ct:417261486
cu:417261486
cv:-1
cw:32768
cx:0
cy:5139
cz:139772672
d0:0
d1:0
d2:0
d3:0
d4:0
d5:0
d6:0
d7:0
d8:0
d9:0
da:0
db:0
dc:0
dd:0
de:0
df:0
dg:1
dh:2
di:21842
dj:1
dk:0
dl:10280
dm:5829
dn:26463
do:19211
dp:16
dq:131
dr:234216
ds:0
dt:0
du:0
dv:5450
dw:106333
dx:0
dy:0
dz:34679
e0:0
e1:-1
e2:-1
e3:0
e4:1
e5:0
e6:2
e7:-1
e8:-1
e9:-1
ea:-1
eb:-1
ec:-1
ed:-1
ee:-1
ef:-1
eg:0
eh:1529856
ei:8388608
ej:0
ek:0
ol:-1
om:-1
on:-1
oo:-1
op:-1
oq:-1
or:-1
os:-1
ot:-1
ou:-1
ov:-1
ow:-1
ox:-1
oy:-1
oz:-1
pg:-1
ph:-1
pi:-1
pj:-1
pk:-1
pl:-1
pm:-1
pn:-1
po:-1
pp:-1
pq:-1
pr:-1
ps:-1
pt:-1
pu:-1
pv:-1
pw:-1
px:-1
py:-1
pz:-1
qg:-1
qh:-1
qi:-1
qj:-1
qk:-1
ql:-1
qm:-1
qn:-1
qo:1718
qp:180881”

mysqlRRD[update mysql.example.net/app-mysql-24.rrd N:16777216:417261486:417261486:228:27:0:198:1989:43100:15536:20147:2:3:46028:5448:1718:181:24067:195:0:8192:1899:6272:0:4000:2:794:818:0:131:111:U:U:151:4:0:191:2:2179:803329:0:0:0:0:U:U:U:U:U:0:311:6:0:0:0:0:0:1.844674407371E+19:0:0:0:0:1:0:116:0:4888:0:2596541:20595401:1401:3:0:0:0:0:7412:5157:0 --daemon unix:/var/run/rrdcached.sock]
RRD[update mysql.example.net/app-mysql-24-status.rrd N:0:0:0:0:0:0:0:0:0:0:0:0:0:0:1:2 --daemon unix:/var/run/rrdcached.sock]
SQL[UPDATE applications set app_state=?,app_status=?,timestamp=NOW() WHERE app_id = ? [“OK”,"",24] 3.32ms]

SQL[SELECT * FROM application_metrics WHERE app_id=? [24] 0.47ms]

: …SQL[UPDATE application_metrics set value=?,value_prev=? WHERE app_id=? && metric=? [195,193,24,“TLIe”] 9.72ms]

U…SQL[UPDATE application_metrics set value=?,value_prev=? WHERE app_id=? && metric=? [2179,2178,24,“Cs”] 10.67ms]

U…SQL[UPDATE application_metrics set value=?,value_prev=? WHERE app_id=? && metric=? [311,308,24,“CTMPTs”] 10.24ms]

U…SQL[UPDATE application_metrics set value=?,value_prev=? WHERE app_id=? && metric=? [4888,4883,24,“SSn”] 10.04ms]

U.SQL[UPDATE application_metrics set value=?,value_prev=? WHERE app_id=? && metric=? [2596541,2596186,24,“BRd”] 10.18ms]

USQL[UPDATE application_metrics set value=?,value_prev=? WHERE app_id=? && metric=? [20595401,20550013,24,“BSt”] 10.19ms]

U…
SNMP[’/usr/bin/snmpget’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-Oqv’ ‘-m’ ‘NET-SNMP-EXTEND-MIB’ ‘-M’ ‘/opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell’ ‘udp:HOSTNAME:161’ ‘.1.3.6.1.4.1.8072.1.3.2.4.1.2.8.111.115.117.112.100.97.116.101.1’]
60

RRD[update mysql.example.net/app-os-updates-25.rrd N:60 --daemon unix:/var/run/rrdcached.sock]
SQL[UPDATE applications set app_state=?,app_status=?,timestamp=NOW() WHERE app_id = ? [“OK”,“60”,25] 3.11ms]

SQL[SELECT * FROM application_metrics WHERE app_id=? [25] 0.36ms]

: .

Runtime for poller module ‘applications’: 1.4800 seconds with 72392 bytes
SNMP: [2/1.41s] MySQL: [11/0.07s] RRD: [4/0.00s]

Unload poller module applications

RRD[update mysql.example.net/poller-perf-applications.rrd N:1.4799568653107 --daemon unix:/var/run/rrdcached.sock]

Start Device Groups

SQL[SELECT * FROM device_groups ORDER BY name [] 0.17ms]

SQL[SELECT device_group_id FROM device_group_device WHERE device_id=? [25] 0.15ms]

Groups Added:
Groups Removed:

End Device Groups

RRD[update mysql.example.net/ping-perf.rrd N:0.65 --daemon unix:/var/run/rrdcached.sock]
RRD[update mysql.example.net/poller-perf.rrd N:2.527 --daemon unix:/var/run/rrdcached.sock]
SQL[UPDATE devices set uptime=?,last_ping=NOW(),last_ping_timetaken=? WHERE device_id = ? [83948,“0.65”,25] 8.8ms]

Updating mysql.example.net

Polled in 2.527 seconds

Start Alerts

SQL[select * from devices where devices.device_id = ? limit 1 [25] 0.43ms]

SQL[select device_groups.*, device_group_device.device_id as pivot_device_id, device_group_device.device_group_id as pivot_device_group_id from device_groups inner join device_group_device on device_groups.id = device_group_device.device_group_id where device_group_device.device_id = ? [25] 0.22ms]

SQL[select exists(select * from alert_schedule inner join alert_schedulables on alert_schedule.schedule_id = alert_schedulables.schedule_id where ((recurring = ? and start <= NOW() and end >= NOW()) or (recurring = ? and (start_recurring_dt <= date_format(NOW(), ‘–%d’) and (end_recurring_dt >= date_format(NOW(), ‘–%d’) or end_recurring_dt is null or end_recurring_dt = ? or end_recurring_dt = ?)) and start_recurring_hr <= date_format(NOW(), ‘%H:%i:%s’) and end_recurring_hr >= date_format(NOW(), ‘%H:%i:%s’) and (recurring_day like CONCAT(’%’, date_format(NOW(), ‘’), ‘%’) or recurring_day is null or recurring_day = ?))) and ((alert_schedulable_type = ? and alert_schedulable_id = ?) or (alert_schedulable_type = ? and 0 = 1))) as exists [0,1,“0000-00-00”,"","",“device”,25,“device_group”] 0.6ms]

SQL[SELECT DISTINCT a.* FROM alert_rules a
LEFT JOIN alert_device_map d ON a.id=d.rule_id
LEFT JOIN alert_group_map g ON a.id=g.rule_id
LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id
WHERE a.disabled = 0 AND ((d.device_id IS NULL AND g.group_id IS NULL) OR d.device_id=? OR dg.device_id=?) [25,25] 0.26ms]

Rule #7 (Sensor over limit - Check Device Health Settings):
SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current > sensors.sensor_limit AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [25] 0.55ms]

SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [7,25] 0.17ms]

Status: NOCHG
Rule #8 (Sensor under limit - Check Device Health Settings):
SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current < sensors.sensor_limit_low AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [25] 0.5ms]

SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [8,25] 0.17ms]

Status: NOCHG

End Alerts

SQL[INSERT IGNORE INTO perf_times (type,doing,start,duration,devices,poller) VALUES (:type,:doing,:start,:duration,:devices,:poller) {“type”:“poll”,“doing”:“mysql.example.net”,“start”:1556214645.960983,“duration”:“2.699”,“devices”:1,“poller”:“nms”} 2.5ms]

./poller.php mysql.example.net 2019-04-26 00:50:48 - 1 devices polled in 2.699 secs
SNMP [5/1.44s]: Get[5/1.44s] Getnext[0/0.00s] Walk[0/0.00s]
MySQL [20/0.09s]: Cell[3/0.00s] Row[-3/-0.00s] Rows[8/0.00s] Column[1/0.00s] Update[9/0.08s] Insert[2/0.01s] Delete[0/0.00s]
RRD [8/0.00s]: Update[8/0.00s] Create [0/0.00s] Other[0/0.00s]

I dont have much time, but an overall view looks like it is correct and the mysql graphs should be there

mysqlRRD[update mysql.example.net/app-mysql-24.rrd N:16777216:417261486:417261486:228:27:0:198:1989:43100:15536:20147:2:3:46028:5448:1718:181:24067:195:0:8192:1899:6272:0:4000:2:794:818:0:131:111:U:U:151:4:0:191:2:2179:803329:0:0:0:0:U:U:U:U:U:0:311:6:0:0:0:0:0:1.844674407371E+19:0:0:0:0:1:0:116:0:4888:0:2596541:20595401:1401:3:0:0:0:0:7412:5157:0 --daemon unix:/var/run/rrdcached.sock] RRD[update mysql.example.net/app-mysql-24-status.rrd N:0:0:0:0:0:0:0:0:0:0:0:0:0:0:1:2 --daemon unix:/var/run/rrdcached.sock]

So just over 2 hours ago, I started seeing graphs. The server isn’t currently heavily used but it will go into production next week. Not sure why it took 10 hours to start generating graphs. Bizarre. Thanks again for your help.