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, 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.

 

[…]

 

Can somebody help?

 

Mit freundlichen Grüßen

Tobias Wissen

 

 


observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium