Hello,
i need your help, i have search since a long time ago but i stay stuck on this issue.
I monitor my Meraki ap from the SAS cloud controller
i would like to check if my AP ar Online or Offline, for do that i have write the yaml discovery like this :
//////////
state:
data:
-
oid: devstatus
value: devStatus
num_oid: ‘.1.3.6.1.4.1.29671.1.1.4.1.3.{{ $index }}’
descr: “{{ $devName }}”
index: “devstatus.{{ $index }}”
group: Meraki
states:
- { value: 0, generic: 2, graph: 1, descr: Offline }
- { value: 1, generic: 0, graph: 1, descr: Online }
//////////
the dicovery output for the status is :
devStatus.‘8.y!..’ = 0
devStatus.‘8.y"…’ = 0
devStatus.‘8.y"…’ = 0
devStatus.‘8.y#…’ = 1
devStatus.‘8.y#,.’ = 1
you can see :
https://p.libren.ms/view/a0a30366
so, it’s ok for the discovery but this character are really strange (for exemple : ‘8.y#,.’)
when the polling start all the AP devices appear KO
you can show my output (sorry for the output, problem with ./poller.php -h xxx -r -f -d | ./pbin.sh
####################################################################
LibreNMS Poller
SQL[select migration from migrations order by id desc limit 1 [] 0.4ms]
SQL[select count(*) as aggregate from migrations limit 1 [] 0.45ms]
SQL[select version() [] 0.32ms]
===================================
Version info:
Commit SHA: a71ea964b6498cda4e140551858d377301e6a670
Commit Date: 1650640185
DB Schema: 2022_04_08_085504_isis_adjacencies_table_add_index (236)
PHP: 7.3.20
MySQL: 10.3.28-MariaDB
RRDTool: 1.7.0
SNMP: 5.8
==================================DEBUG!
Updating os_def.cache
Starting polling run:
SQL[SELECT * FROM devices WHERE disabled = 0 AND device_id = 257 ORDER BY device_id ASC [] 0.69ms]
SQL[select * from devices where device_id = ? limit 1 [257] 1.31ms]
SQL[select * from devices_attribs where devices_attribs.device_id = ? and devices_attribs.device_id is not null [257] 0.42ms]
Attempting to initialize OS: cloud-controller
OS initialized as Generic
Hostname: snmp.meraki.com
Device ID: 257
OS: cloud-controller
Assigned IP: 209.206.58.188
[FPING] ‘/usr/sbin/fping’ ‘-e’ ‘-q’ ‘-c’ ‘3’ ‘-p’ ‘500’ ‘-t’ ‘500’ ‘-O’ ‘0’ ‘209.206.58.188’
response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 15.6/16/16.7
SNMP[’/usr/bin/snmpget’ ‘-M’ ‘/opt/librenms/mibs:/opt/librenms/mibs/meraki’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-OQXUte’ ‘-t’ ‘5’ ‘udp:HOSTNAME:16100’ ‘SNMPv2-MIB::sysObjectID.0’]
SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.29671.1
SQL[insert into device_perf (min, max, avg, xmt, rcv, loss, device_id, timestamp) values (?, ?, ?, ?, ?, ?, ?, ?) [15.6,16.7,16,3,3,0,257,“2022-04-27 14:17:10”] 3.99ms]
SQL[update devices set last_ping_timetaken = ? where device_id = ? [16,257] 7.04ms]
SQL[select * from device_outages where device_outages.device_id = ? and device_outages.device_id is not null and up_again is null order by going_down desc limit 1 [257] 0.48ms]
Modules status: Global+
OS
Device
Load poller module core
SNMP[’/usr/bin/snmpget’ ‘-M’ ‘/opt/librenms/mibs:/opt/librenms/mibs/meraki’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-OQXUte’ ‘-On’ ‘-t’ ‘5’ ‘udp:HOSTNAME:16100’ ‘SNMPv2-MIB::sysDescr.0’ ‘SNMPv2-MIB::sysObjectID.0’ ‘SNMPv2-MIB::sysUpTime.0’ ‘SNMPv2-MIB::sysName.0’]
...0 = Cisco Meraki Cloud Controller
...0 = ..4.1.29671.1
...0 = 1012423000
..*.0 = dashboard.meraki.com
SNMP[’/usr/bin/snmpget’ ‘-M’ ‘/opt/librenms/mibs:/opt/librenms/mibs/meraki’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-OQXUte’ ‘-t’ ‘5’ ‘udp:HOSTNAME:16100’ ‘SNMP-FRAMEWORK-MIB::snmpEngineTime.0’ ‘HOST-RESOURCES-MIB::hrSystemUptime.0’]
SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = No Such Object available on this agent at this OID
HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Object available on this agent at this OID
Uptime seconds: 10124230
Uptime: 117 days 4 hours 17 minutes 10 seconds
SQL[update devices set uptime = ? where device_id = ? [10124230,257] 3.14ms]
Runtime for poller module ‘core’: 0.1039 seconds with 70456 bytes
SNMP: [2/0.10s] MySQL: [1/0.03s]
Unload poller module core
Modules status: Global-
OS
Device
Module [ unix-agent ] disabled globally.
Modules status: Global+
OS
Device-
Module [ os ] disabled on host.
Modules status: Global+
OS
Device+
Load poller module availability
SQL[SELECT duration FROM availability WHERE device_id = ? [257] 0.45ms]
Availability:
SQL[SELECT * FROM availability WHERE device_id = ? [257] 0.34ms]
SQL[select * from device_outages where device_id = ? and up_again >= ? order by going_down asc [257,1650975430] 0.31ms]
SQL[UPDATE availability set availability_perc=? WHERE availability_id = ? [100,881] 0.21ms]
1 day : 100%
SQL[select * from device_outages where device_id = ? and up_again >= ? order by going_down asc [257,1650457030] 0.3ms]
SQL[UPDATE availability set availability_perc=? WHERE availability_id = ? [100,882] 0.17ms]
7 days : 100%
SQL[select * from device_outages where device_id = ? and up_again >= ? order by going_down asc [257,1648469830] 0.26ms]
SQL[UPDATE availability set availability_perc=? WHERE availability_id = ? [66.763,883] 0.21ms]
30 days : 66.763%
SQL[select * from device_outages where device_id = ? and up_again >= ? order by going_down asc [257,1619525830] 0.24ms]
SQL[UPDATE availability set availability_perc=? WHERE availability_id = ? [97.268,884] 0.18ms]
365 days : 97.268%
Runtime for poller module ‘availability’: 0.0057 seconds with 13344 bytes
SNMP: [0/0.00s] MySQL: [10/0.03s]
Unload poller module availability
Modules status: Global+
OS
Device-
Module [ ipmi ] disabled on host.
Modules status: Global+
OS
Device+
Load poller module sensors
SQL[SELECT sensor_class FROM sensors WHERE device_id = ? GROUP BY sensor_class [257] 0.68ms]
SNMP[’/usr/bin/snmpget’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-OUQnte’ ‘-M’ ‘/opt/librenms/mibs:/opt/librenms/mibs/meraki’ ‘-t’ ‘5’ ‘udp:HOSTNAME:16100’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’‘h:./.j’’’’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’‘h:./.m’’’’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’‘h:./.o’’’’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’‘h:./.q’’’’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’‘h:./.s’’’’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’‘h:./.t’’’’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’‘h:./.|’’’’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’‘h:.T’ ‘I’’’’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’‘h:.T’]
Exitcode: 1
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:./.j’: Unknown Object Identifier
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:./.m’: Unknown Object Identifier
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:./.o’: Unknown Object Identifier
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:./.q’: Unknown Object Identifier
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:./.s’: Unknown Object Identifier
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:./.t’: Unknown Object Identifier
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:./.|’: Unknown Object Identifier
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:.T: Unknown Object Identifier
I’: Unknown Object Identifier (Sub-id not found: (top) → I’)
.1.3.6.1.4.1.29671.1.1.4.1.3.'h:.T: Unknown Object Identifier
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:./.j’: Unknown Object Identifier
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:./.m’: Unknown Object Identifier
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:./.o’: Unknown Object Identifier
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:./.q’: Unknown Object Identifier
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:./.s’: Unknown Object Identifier
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:./.t’: Unknown Object Identifier
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:./.|’: Unknown Object Identifier
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:.T: Unknown Object Identifier
I’: Unknown Object Identifier (Sub-id not found: (top) → I’)
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:.T: Unknown Object Identifier
SNMP[’/usr/bin/snmpget’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-OUQnte’ ‘-M’ ‘/opt/librenms/mibs:/opt/librenms/mibs/meraki’ ‘-t’ ‘5’ ‘udp:HOSTNAME:16100’ ‘J’’’’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’‘h:.T’ ‘N’’’’]
Exitcode: 1
J’: Unknown Object Identifier (Sub-id not found: (top) → J’)
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:.T: Unknown Object Identifier
N’: Unknown Object Identifier (Sub-id not found: (top) → N’)
J’: Unknown Object Identifier (Sub-id not found: (top) → J’)
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:.T: Unknown Object Identifier
N’: Unknown Object Identifier (Sub-id not found: (top) → N’)
SNMP[’/usr/bin/snmpget’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-OUQnte’ ‘-M’ ‘/opt/librenms/mibs:/opt/librenms/mibs/meraki’ ‘-t’ ‘5’ ‘udp:HOSTNAME:16100’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’‘h:.T’ ‘h’’’’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’‘h:.T’ ‘r’’’’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’‘h:.T’ ‘s’’’’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’‘h:.T’ ‘v’’’’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’‘h:.T’ ‘.’’’’]
Exitcode: 1
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:.T: Unknown Object Identifier
h’: Unknown Object Identifier (Sub-id not found: (top) → h’)
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:.T: Unknown Object Identifier
r’: Unknown Object Identifier (Sub-id not found: (top) → r’)
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:.T: Unknown Object Identifier
s’: Unknown Object Identifier (Sub-id not found: (top) → s’)
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:.T: Unknown Object Identifier
v’: Unknown Object Identifier (Sub-id not found: (top) → v’)
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:.T: Unknown Object Identifier
.’: Unknown Object Identifier (Sub-id not found: (top) → ')
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:.T: Unknown Object Identifier
h’: Unknown Object Identifier (Sub-id not found: (top) → h’)
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:.T: Unknown Object Identifier
r’: Unknown Object Identifier (Sub-id not found: (top) → r’)
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:.T: Unknown Object Identifier
s’: Unknown Object Identifier (Sub-id not found: (top) → s’)
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:.T: Unknown Object Identifier
v’: Unknown Object Identifier (Sub-id not found: (top) → v’)
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:.T: Unknown Object Identifier
.’: Unknown Object Identifier (Sub-id not found: (top) → ‘)
SNMP[’/usr/bin/snmpget’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-OUQnte’ ‘-M’ ‘/opt/librenms/mibs:/opt/librenms/mibs/meraki’ ‘-t’ ‘5’ ‘udp:HOSTNAME:16100’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’‘h:…’’’’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’‘h:…’’’.’’’’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’’…[’’’’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’’…’’’’ ‘.1.3.6.1.4.1.29671.1.1.4.1.3.’’’…2’’’’]
Exitcode: 1
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:…’: Unknown Object Identifier
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:…’.’: Unknown Object Identifier
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:…’: Unknown Object Identifier
.1.3.6.1.4.1.29671.1.1.4.1.3.‘h:…’.’: Unknown Object Identifier
Checking (snmp) state MS-01…
SQL[SELECT state_value
FROM state_translations LEFT JOIN sensors_to_state_indexes
ON state_translations.state_index_id = sensors_to_state_indexes.state_index_id
WHERE sensors_to_state_indexes.sensor_id = ?
AND state_translations.state_descr LIKE ? [27128,""] 0.65ms]
State value of is
Checking (snmp) state MS-02…
SQL[SELECT state_value
FROM state_translations LEFT JOIN sensors_to_state_indexes
ON state_translations.state_index_id = sensors_to_state_indexes.state_index_id
WHERE sensors_to_state_indexes.sensor_id = ?
AND state_translations.state_descr LIKE ? [27129,""] 0.29ms]
State value of is
Checking (snmp) state BAT88-SU-5-SS-2…
SQL[SELECT state_value
FROM state_translations LEFT JOIN sensors_to_state_indexes
ON state_translations.state_index_id = sensors_to_state_indexes.state_index_id
WHERE sensors_to_state_indexes.sensor_id = ?
AND state_translations.state_descr LIKE ? [27130,""] 0.26ms]
State value of is
Checking (snmp) state BAT88-SU-5-SS-1…
SQL[SELECT state_value
FROM state_translations LEFT JOIN sensors_to_state_indexes
ON state_translations.state_index_id = sensors_to_state_indexes.state_index_id
WHERE sensors_to_state_indexes.sensor_id = ?
AND state_translations.state_descr LIKE ? [27131,""] 0.24ms]
State value of is
Checking (snmp) state RBX88-SU51-2…
SQL[SELECT state_value
FROM state_translations LEFT JOIN sensors_to_state_indexes
ON state_translations.state_index_id = sensors_to_state_indexes.state_index_id
WHERE sensors_to_state_indexes.sensor_id = ?
AND state_translations.state_descr LIKE ? [27132,""] 0.24ms]
State value of is
Checking (snmp) state RBX75-SU35…
SQL[SELECT state_value
FROM state_translations LEFT JOIN sensors_to_state_indexes
ON state_translations.state_index_id = sensors_to_state_indexes.state_index_id
WHERE sensors_to_state_indexes.sensor_id = ?
AND state_translations.state_descr LIKE ? [27133,""] 0.24ms]
State value of is
Checking (snmp) state RBX88-SU52-2…
SQL[SELECT state_value
FROM state_translations LEFT JOIN sensors_to_state_indexes
ON state_translations.state_index_id = sensors_to_state_indexes.state_index_id
WHERE sensors_to_state_indexes.sensor_id = ?
AND state_translations.state_descr LIKE ? [27134,""] 0.25ms]
State value of is
Checking (snmp) state SLF-RBX-BAT13-02-AP01…
SQL[SELECT state_value
FROM state_translations LEFT JOIN sensors_to_state_indexes
ON state_translations.state_index_id = sensors_to_state_indexes.state_index_id
WHERE sensors_to_state_indexes.sensor_id = ?
AND state_translations.state_descr LIKE ? [27135,""] 0.24ms]
State value of is
Checking (snmp) state SLF-RBX-BAT88-05-AP01…
SQL[SELECT state_value
FROM state_translations LEFT JOIN sensors_to_state_indexes
ON state_translations.state_index_id = sensors_to_state_indexes.state_index_id
WHERE sensors_to_state_indexes.sensor_id = ?
AND state_translations.state_descr LIKE ? [27136,""] 0.26ms]
State value of is
Checking (snmp) state SLF-RBX-AB-01-AP05…
SQL[SELECT state_value
FROM state_translations LEFT JOIN sensors_to_state_indexes
ON state_translations.state_index_id = sensors_to_state_indexes.state_index_id
WHERE sensors_to_state_indexes.sensor_id = ?
AND state_translations.state_descr LIKE ? [27176,""] 0.24ms]
State value of is
Checking (snmp) state SLF-RBX-BAT88-04-AP02…
SQL[SELECT state_value
FROM state_translations LEFT JOIN sensors_to_state_indexes
ON state_translations.state_index_id = sensors_to_state_indexes.state_index_id
WHERE sensors_to_state_indexes.sensor_id = ?
AND state_translations.state_descr LIKE ? [27177,""] 0.22ms]
State value of is
Checking (snmp) state SLF-BOR-02-AP04…
SQL[SELECT state_value
FROM state_translations LEFT JOIN sensors_to_state_indexes
ON state_translations.state_index_id = sensors_to_state_indexes.state_index_id
WHERE sensors_to_state_indexes.sensor_id = ?
AND state_translations.state_descr LIKE ? [27178,""] 0.22ms]
State value of is
Checking (snmp) state SLF-RBX-AB-01-AP02…
SQL[SELECT state_value
FROM state_translations LEFT JOIN sensors_to_state_indexes
ON state_translations.state_index_id = sensors_to_state_indexes.state_index_id
WHERE sensors_to_state_indexes.sensor_id = ?
AND state_translations.state_descr LIKE ? [27179,""] 0.22ms]
State value of is
Checking (snmp) state SLF-RBX-BAT88-02-AP02…
SQL[SELECT state_value
FROM state_translations LEFT JOIN sensors_to_state_indexes
ON state_translations.state_index_id = sensors_to_state_indexes.state_index_id
WHERE sensors_to_state_indexes.sensor_id = ?
AND state_translations.state_descr LIKE ? [27180,""] 0.23ms]
State value of is
Checking (snmp) state SLF-RBX-BAT88-04-AP03…
SQL[SELECT state_value
FROM state_translations LEFT JOIN sensors_to_state_indexes
ON state_translations.state_index_id = sensors_to_state_indexes.state_index_id
WHERE sensors_to_state_indexes.sensor_id = ?
AND state_translations.state_descr LIKE ? [27181,""] 0.23ms]
State value of is
Checking (snmp) state SLF-RBX-BAT88-RCH-AP02…
SQL[SELECT state_value
FROM state_translations LEFT JOIN sensors_to_state_indexes
ON state_translations.state_index_id = sensors_to_state_indexes.state_index_id
WHERE sensors_to_state_indexes.sensor_id = ?
AND state_translations.state_descr LIKE ? [27182,""] 0.23ms]
State value of is
Checking (snmp) state SLF-RBX-BAT88-01-AP02…
SQL[SELECT state_value
FROM state_translations LEFT JOIN sensors_to_state_indexes
ON state_translations.state_index_id = sensors_to_state_indexes.state_index_id
WHERE sensors_to_state_indexes.sensor_id = ?
AND state_translations.state_descr LIKE ? [27183,""] 0.25ms]
State value of is
Checking (snmp) state SLF-RBX-AB-01-AP03…
SQL[SELECT state_value
FROM state_translations LEFT JOIN sensors_to_state_indexes
ON state_translations.state_index_id = sensors_to_state_indexes.state_index_id
WHERE sensors_to_state_indexes.sensor_id = ?
AND state_translations.state_descr LIKE ? [27190,""] 0.24ms]
State value of is
Checking (snmp) state SLF-RBX-BAT88-04-AP01…
SQL[SELECT state_value
FROM state_translations LEFT JOIN sensors_to_state_indexes
ON state_translations.state_index_id = sensors_to_state_indexes.state_index_id
WHERE sensors_to_state_indexes.sensor_id = ?
AND state_translations.state_descr LIKE ? [27191,""] 0.25ms]
State value of is
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
0 #
Runtime for poller module ‘sensors’: 0.5935 seconds with 624 bytes
SNMP: [14/0.56s] MySQL: [67/0.19s]
Unload poller module sensors
Groups Added:
Groups Removed:
End Device Groups, runtime: 0.0244s
Start Alerts
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 = ? [257] 0.63ms]
SQL[select * from locations where locations.id = ? limit 1 [77] 0.34ms]
SQL[select exists(select * from alert_schedule where (start <= ? and end >= ? and (recurring = ? or (recurring = ? and ((time(start) < time(end) and time(start) <= ? and time(end) > ?) or (time(start) > time(end) and (time(end) <= ? or time(start) > ?))) and (recurring_day like ? or recurring_day is null)))) and (exists (select * from devices inner join alert_schedulables on devices.device_id = alert_schedulables.alert_schedulable_id where alert_schedule.schedule_id = alert_schedulables.schedule_id and alert_schedulables.alert_schedulable_type = ? and alert_schedulables.alert_schedulable_id = ?) or exists (select * from device_groups inner join alert_schedulables on device_groups.id = alert_schedulables.alert_schedulable_id where alert_schedule.schedule_id = alert_schedulables.schedule_id and alert_schedulables.alert_schedulable_type = ? and alert_schedulables.alert_schedulable_id in (?, ?)) or exists (select * from locations inner join alert_schedulables on locations.id = alert_schedulables.alert_schedulable_id where alert_schedule.schedule_id = alert_schedulables.schedule_id and alert_schedulables.alert_schedulable_type = ? and alert_schedulables.alert_schedulable_id = ?))) as exists [“2022-04-27T12:17:11.391347Z”,“2022-04-27T12:17:11.391347Z”,0,1,“12:17:11”,“12:17:11”,“12:17:11”,“12:17:11”,"%",“device”,257,“device_group”,14,37,“location”,77] 0.89ms]
SQL[select * from devices where devices.device_id = ? limit 1 [257] 0.38ms]
Disable alerting is set, Clearing active alerts and skipping alert rules check
SQL[UPDATE alerts set state=?,alerted=?,open=? WHERE device_id = ? [0,0,0,257] 0.27ms]
End Alerts
./poller.php 257 2022-04-27 14:17:11 - 1 devices polled in 2.246 secs
SNMP [18/0.86s]: Snmpget[18/0.86s]
SQL [121/0.62s]: Select[109/0.43s] Delete[3/0.01s] Insert[1/0.04s] Update[8/0.15s]
#############################################################################
the output of a manual snmpwalk is ok : snmpwalk -v2c -t 10 -c xxxx -Ob -M +. -m +MERAKI-CLOUD-CONTROLLER-MIB snmp.meraki.com:16100 .1
iso.3.6.1.4.1.29671.1.1.4.1.3.104.58.30.47.4.218 = INTEGER: 1
iso.3.6.1.4.1.29671.1.1.4.1.3.104.58.30.47.4.221 = INTEGER: 1
iso.3.6.1.4.1.29671.1.1.4.1.3.104.58.30.47.4.223 = INTEGER: 1
iso.3.6.1.4.1.29671.1.1.4.1.3.104.58.30.47.4.230 = INTEGER: 1
iso.3.6.1.4.1.29671.1.1.4.1.3.104.58.30.47.5.33 = INTEGER: 1
i think (but no sure" i need to add “.1” in the snmpget like this : snmp.meraki.com:16100 .1
can you please help me, i’m really stucked
many thank’s per advance