Errors in DB.log / No RRD Graphs more
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
Why do you have a user observium and a user obs? Which is the one that's running your poller?
Tom
On 10/18/2019 12:20 PM, Wissen, Tobias (EDV) via observium 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.
[…]
Can somebody help?
Mit freundlichen Grüßen
Tobias Wissen
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Good morning, sir,
thanks for the feedback.
If I now install on a new server with the installer script, is there any way to take over the data from the current server? And is there already a manual for this? So far I haven't had many points of contact with Linux.
Mit freundlichen Grüßen
Tobias Wissen
Von: observium observium-bounces@observium.org Im Auftrag von Tom Laermans via observium Gesendet: Samstag, 19. Oktober 2019 19:49 An: Wissen, Tobias (EDV) via observium observium@observium.org Cc: Tom Laermans tom.laermans@powersource.cx Betreff: Re: [Observium] Errors in DB.log / No RRD Graphs more
Why do you have a user observium and a user obs? Which is the one that's running your poller?
Tom
On 10/18/2019 12:20 PM, Wissen, Tobias (EDV) via observium 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@01D588B9.444668D0]
[cid:image002.png@01D588B9.444668D0] [...] [cid:image003.png@01D588B9.444668D0]
Can somebody help?
Mit freundlichen Grüßen
Tobias Wissen
_______________________________________________
observium mailing list
observium@observium.orgmailto:observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
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
participants (3)
-
Adam Armstrong -
Tom Laermans -
Wissen, Tobias (EDV)