Possible Glitch ! Can't Delete the Device

Help
1

I have two devices somehow added as below

libre-device
libre-device1021×234 6.15 KB

I tried to edit/overwrite/maintenance mode. But there is no way i can delete them. After deleting confirmation it says ‘no such host’ . But the devices remains in the system. How to delete these ?

2

same issue here, @jasim_alam did you get the issue resolved ?

3

Only way to delete these is via SQL DELETE FROM `devices` WHERE `device_id`=999999999; (where 999999999 is the device_id in the url)

I still haven’t figure out what is adding these…

1 Like
4

can you walk me step by step ?

5

You have to enter mysql cli:

mysql -u librenms -p librenms
That will ask you for a password, you can look it at .env or config.php

Then run the query murrant said with the correct device_id.

6

THANKS ! worked :slight_smile:

7

@murrant I think this happened to me in the past and was part of a failed test.

1 Like
8

to find device_id in database, just do like this :
MariaDB [librenms]> SELECT device_id, hostname, sysName, ip FROM devices;

9

Thanks. it works.