The dB.log errors are unimportant.
It looks like you've changed the owner of your RRD directory to a user called "obs", which doesn't match the user of the rest of the installation.
This is almost certainly the cause of the poller no longer writing to the rrd files.
Adam.
Sent from BlueMail
On 18 Oct 2019, 11:20, at 11:20, "Wissen, Tobias (EDV) via observium" observium@observium.org wrote:
Hi there,
i gor several errors in the db.log
obs@observium:/opt/observium/logs$ tail db.log [2019/10/18 12:16:24 +0200] poller.php(3286): Failed dbQuery (#1146 - Table 'observium.lsp' doesn't exist), Query: SELECT * FROM `lsp` WHERE `device_id` = '7' [2019/10/18 12:16:24 +0200] poller.php(3255): Failed dbQuery (#1146 - Table 'observium.lsp' doesn't exist), Query: SELECT * FROM `lsp` WHERE `device_id` = '18' [2019/10/18 12:16:24 +0200] poller.php(3344): Failed dbQuery (#1146 - Table 'observium.lsp' doesn't exist), Query: SELECT * FROM `lsp` WHERE `device_id` = '6' [2019/10/18 12:16:24 +0200] poller.php(3080): Failed dbQuery (#1146 - Table 'observium.lsp' doesn't exist), Query: SELECT * FROM `lsp` WHERE `device_id` = '10' [2019/10/18 12:16:25 +0200] poller.php(3151): Failed dbQuery (#1146 - Table 'observium.lsp' doesn't exist), Query: SELECT * FROM `lsp` WHERE `device_id` = '13' [2019/10/18 12:16:25 +0200] poller.php(3254): Failed dbQuery (#1146 - Table 'observium.lsp' doesn't exist), Query: SELECT * FROM `lsp` WHERE `device_id` = '17' [2019/10/18 12:16:25 +0200] poller.php(3158): Failed dbQuery (#1146 - Table 'observium.lsp' doesn't exist), Query: SELECT * FROM `lsp` WHERE `device_id` = '12' [2019/10/18 12:16:25 +0200] poller.php(3193): Failed dbQuery (#1146 - Table 'observium.lsp' doesn't exist), Query: SELECT * FROM `lsp` WHERE `device_id` = '11' [2019/10/18 12:16:25 +0200] poller.php(3253): Failed dbQuery (#1146 - Table 'observium.lsp' doesn't exist), Query: SELECT * FROM `lsp` WHERE `device_id` = '14' [2019/10/18 12:16:27 +0200] poller.php(3109): Failed dbQuery (#1146 - Table 'observium.lsp' doesn't exist), Query: SELECT * FROM `lsp` WHERE `device_id` = '15'
AND:
I got no RRD Graphs no longer. [cid:image001.png@01D585AE.6878F960]
[cid:image002.png@01D585AE.6878F960] [...] [cid:image003.png@01D585AE.6878F960]
Can somebody help?
Mit freundlichen Grüßen
Tobias Wissen
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium