Hello Everybody
I am a new user to librenms. After a successfull installation on a Ubuntu VM, i have now a little Issue with caching some data from PeeringDB.
If i try following:
_localadmin@nms:/opt/librenms# php ./daily.php -f peeringdb
No cached PeeringDB data found, sleeping for 26 seconds
SQL 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 ')' at line 1 (SQL: DELETE FROM `pdb_ix` WHERE `pdb_ix_id` NOT IN ()) (SQL: DELETE FROM `pdb_ix` WHERE `pdb_ix_id` NOT IN ())
/opt/librenms/includes/functions.php:2403
/opt/librenms/daily.php:288
SQL 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 ')' at line 1 (SQL: DELETE FROM `pdb_ix` WHERE `pdb_ix_id` NOT IN ()) (SQL: DELETE FROM `pdb_ix` WHERE `pdb_ix_id` NOT IN ())
/opt/librenms/includes/functions.php:2403
/opt/librenms/daily.php:288
SQL 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 ')' at line 1 (SQL: DELETE FROM `pdb_ix` WHERE `pdb_ix_id` NOT IN ()) (SQL: DELETE FROM `pdb_ix` WHERE `pdb_ix_id` NOT IN ())
/opt/librenms/includes/functions.php:2403
/opt/librenms/daily.php:288
SQL 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 ')' at line 1 (SQL: DELETE FROM `pdb_ix` WHERE `pdb_ix_id` NOT IN ()) (SQL: DELETE FROM `pdb_ix` WHERE `pdb_ix_id` NOT IN ())
/opt/librenms/includes/functions.php:2403
/opt/librenms/daily.php:288
SQL 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 ')' at line 1 (SQL: DELETE FROM `pdb_ix` WHERE `pdb_ix_id` NOT IN ()) (SQL: DELETE FROM `pdb_ix` WHERE `pdb_ix_id` NOT IN ())
/opt/librenms/includes/functions.php:2403
/opt/librenms/daily.php:288
SQL 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 ')' at line 1 (SQL: DELETE FROM `pdb_ix` WHERE `pdb_ix_id` NOT IN ()) (SQL: DELETE FROM `pdb_ix` WHERE `pdb_ix_id` NOT IN ())
/opt/librenms/includes/functions.php:2403
/opt/librenms/daily.php:288
localadmin@nms:/opt/librenms#_
I have installed following Package versions:
_PHP: 7.0+35ubuntu6.1_
_Apache2: 2.4.18-2ubuntu3.9_
_MariaDB: 5.7.23-0ubuntu0.16.04.1_
If Anyone know something it would be nice to fix this.
Have a nice evening