Recently upgrades from Ubuntu 16.04 to 18.04 and in the process the required version of PHP.
ubuntu@ip-172-31-4-35:/opt/librenms$ sudo /opt/librenms/validate.php
| Component | Version |
|---|---|
| LibreNMS | 1.49-115-g4e4ceffc0 |
| DB Schema | 2019_02_10_220000_add_dates_to_fdb (132) |
| PHP | 7.2.15-1+ubuntu18.10.1+deb.sury.org+1 |
| MySQL | 10.1.38-MariaDB-0ubuntu0.18.04.1 |
| RRDTool | 1.7.0 |
| SNMP | NET-SNMP 5.7.3 |
====================================
[OK] Composer Version: 1.8.4
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
ubuntu@ip-172-31-4-35:/opt/librenms$
Devices are being polled and alerts working correctly however all graphs red.
[2019-03-31 13:50:17] production.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘) LIMIT 1’ at line 1 (SQL: SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=19 AND (devices.sysName = “3D Safety Systems Pty Ltd” = ) LIMIT 1) (SQL: SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=19 AND (devices.sysName = “3D Safety Systems Pty Ltd” = ) LIMIT 1)#0 /opt/librenms/includes/device-groups.inc.php(237): dbFetchCell(‘SELECT DISTINCT…’, Array)
#1 /opt/librenms/includes/device-groups.inc.php(300): QueryGroupsFromDevice(19)
#2 /opt/librenms/includes/polling/functions.inc.php(346): UpdateGroupsForDevice(19)
#3 /opt/librenms/poller.php(157): poll_device(Array, false)
#4 {main}
[2019-03-31 13:50:17] production.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘= “Vadacom Service Team <service.*vadacom.co.nz>”) LIMIT 1’ at line 1 (SQL: SELECT DISTINCT(syslog.device_id) FROM syslog WHERE syslog.device_id=19 AND (syslog. = “Vadacom Service Team <service.*vadacom.co.nz>”) LIMIT 1) (SQL: SELECT DISTINCT(syslog.device_id) FROM syslog WHERE syslog.device_id=19 AND (syslog. = “Vadacom Service Team <service.*vadacom.co.nz>”) LIMIT 1)#0 /opt/librenms/includes/device-groups.inc.php(237): dbFetchCell(‘SELECT DISTINCT…’, Array)
#1 /opt/librenms/includes/device-groups.inc.php(300): QueryGroupsFromDevice(19)
#2 /opt/librenms/includes/polling/functions.inc.php(346): UpdateGroupsForDevice(19)
#3 /opt/librenms/poller.php(157): poll_device(Array, false)
#4 {main}
/opt/librenms/poller.php 19 2019-03-31 13:50:17 - 1 devices polled in 3.126 secs
Unsure if I have either not selected the correct database - I do have all my devices showing but unsure if this data is collected from elsewhere.