Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SQL OUTPUT resulting in 0# for Voltage values under device Overview
- mysql> select * from sensors where sensor_type='netonixPoeStatus' and sensor_oid LIKE '.1.3.6.1.4%' and device_id=275 limit 10;
- +-----------+----------------+--------------+-----------+-------------+---------------------------------------+--------------+------------------+--------------+----------------+-------------------+----------------+--------------+-------------------+------------------+-----------------------+--------------+---------------+------------------+---------------------------+---------------------+-------------+-----------+
- | sensor_id | sensor_deleted | sensor_class | device_id | poller_type | sensor_oid | sensor_index | sensor_type | sensor_descr | sensor_divisor | sensor_multiplier | sensor_current | sensor_limit | sensor_limit_warn | sensor_limit_low | sensor_limit_low_warn | sensor_alert | sensor_custom | entPhysicalIndex | entPhysicalIndex_measured | lastupdate | sensor_prev | user_func |
- +-----------+----------------+--------------+-----------+-------------+---------------------------------------+--------------+------------------+--------------+----------------+-------------------+----------------+--------------+-------------------+------------------+-----------------------+--------------+---------------+------------------+---------------------------+---------------------+-------------+-----------+
- | 4590 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.1 | 1 | netonixPoeStatus | Port 1 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 15:02:31 | 0 | |
- | 4591 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.2 | 2 | netonixPoeStatus | Port 2 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 15:02:31 | 0 | |
- | 4592 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.3 | 3 | netonixPoeStatus | Port 3 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 15:02:31 | 0 | |
- | 4593 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.4 | 4 | netonixPoeStatus | Port 4 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 15:02:31 | 0 | |
- | 4594 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.5 | 5 | netonixPoeStatus | Port 5 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 15:02:31 | 0 | |
- | 4595 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.6 | 6 | netonixPoeStatus | Port 6 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 15:02:31 | 0 | |
- | 4596 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.7 | 7 | netonixPoeStatus | Port 7 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 15:02:31 | 0 | |
- | 4597 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.8 | 8 | netonixPoeStatus | Port 8 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 15:02:31 | 0 | |
- | 4598 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.9 | 9 | netonixPoeStatus | Port 9 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 15:02:31 | 0 | |
- | 4599 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.10 | 10 | netonixPoeStatus | Port 10 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 15:02:31 | 0 | |
- +-----------+----------------+--------------+-----------+-------------+---------------------------------------+--------------+------------------+--------------+----------------+-------------------+----------------+--------------+-------------------+------------------+-----------------------+--------------+---------------+------------------+---------------------------+---------------------+-------------+-----------+
- ##################
- Followed SQL update;
- https://github.com/librenms/librenms/issues/4487
- Things were working for about an hour before reverting - some Devices were showing 24# and 48# for some Ports , but not all.
- ##################
- mysql> select * from sensors where sensor_type='netonixPoeStatus' and sensor_oid LIKE '.1.3.6.1.4%' and device_id=275 limit 10;
- +-----------+----------------+--------------+-----------+-------------+---------------------------------------+--------------+------------------+--------------+----------------+-------------------+----------------+--------------+-------------------+------------------+-----------------------+--------------+---------------+------------------+---------------------------+---------------------+-------------+-----------+
- | sensor_id | sensor_deleted | sensor_class | device_id | poller_type | sensor_oid | sensor_index | sensor_type | sensor_descr | sensor_divisor | sensor_multiplier | sensor_current | sensor_limit | sensor_limit_warn | sensor_limit_low | sensor_limit_low_warn | sensor_alert | sensor_custom | entPhysicalIndex | entPhysicalIndex_measured | lastupdate | sensor_prev | user_func |
- +-----------+----------------+--------------+-----------+-------------+---------------------------------------+--------------+------------------+--------------+----------------+-------------------+----------------+--------------+-------------------+------------------+-----------------------+--------------+---------------+------------------+---------------------------+---------------------+-------------+-----------+
- | 4590 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.1 | 1 | netonixPoeStatus | Port 1 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 14:57:46 | 48 | |
- | 4591 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.2 | 2 | netonixPoeStatus | Port 2 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 14:57:46 | 24 | |
- | 4592 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.3 | 3 | netonixPoeStatus | Port 3 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 14:57:46 | 48 | |
- | 4593 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.4 | 4 | netonixPoeStatus | Port 4 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 14:57:46 | 1 | |
- | 4594 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.5 | 5 | netonixPoeStatus | Port 5 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 14:57:46 | 2 | |
- | 4595 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.6 | 6 | netonixPoeStatus | Port 6 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 14:57:46 | 1 | |
- | 4596 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.7 | 7 | netonixPoeStatus | Port 7 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 14:57:46 | 1 | |
- | 4597 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.8 | 8 | netonixPoeStatus | Port 8 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 14:57:46 | 1 | |
- | 4598 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.9 | 9 | netonixPoeStatus | Port 9 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 14:57:46 | 1 | |
- | 4599 | 0 | state | 275 | snmp | .1.3.6.1.4.1.3.6.1.4.1.46242.5.1.2.10 | 10 | netonixPoeStatus | Port 10 PoE | 1 | 1 | 0 | NULL | NULL | NULL | NULL | 1 | No | | | 2017-07-12 14:57:46 | 1 | |
- +-----------+----------------+--------------+-----------+-------------+---------------------------------------+--------------+------------------+--------------+----------------+-------------------+----------------+--------------+-------------------+------------------+-----------------------+--------------+---------------+------------------+---------------------------+---------------------+-------------+-----------+
- 10 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement