No graphs after upgrade debian 8

Help
1

Hi. When i upgrade my debian 8 to 9, librenms stops showing graph’s.

./validate.php
PHP Fatal error: Uncaught Error: Call to undefined function mysqli_query() in /opt/librenms/includes/dbFacile.php:109
Stack trace:
#0 /opt/librenms/includes/dbFacile.php(370): dbQuery(‘SELECT version …’, Array)
#1 /opt/librenms/includes/dbFacile.php(395): dbFetchRow(‘SELECT version …’, Array, false)
#2 /opt/librenms/includes/functions.php(2318): dbFetchCell(‘SELECT version …’)
#3 /opt/librenms/includes/common.php(1126): get_db_schema()
#4 /opt/librenms/validate.php(49): version_info()
#5 [internal function]: {closure}()
#6 {main}
thrown in /opt/librenms/includes/dbFacile.php on line 109

Where can be problem ?

2

Possibly this?

3

Ok , i solve mysqli problem , now poller works fine but i don’t see any graphs. Permission’s are ok.

4

post validate.php output again

5

./validate.php

====================================

Component Version
LibreNMS 1.31.03
DB Schema 205
PHP 7.0.19-1
MySQL 10.1.26-MariaDB-0+deb9u1
RRDTool 1.6.0
SNMP NET-SNMP 5.7.3

====================================

[OK] Database connection successful
[OK] Database schema correct
[WARN] Your local git branch is not master, this will prevent automatic updates.
[FAIL] Discovery has not completed in the last 24 hours, check the cron job
[WARN] Some devices have not been polled in the last 5 minutes.
You may have performance issues. Check your poll log and see: http://docs.librenms.org/Support/Performance/

6

Anyone ? this is weard…

7

??? No one know’s where is the issue ? Smokeping draw’s graphs without problem. Only libre have this issue.

8

What do the graphs look like?

9

They are empty , in legend all are -nan.

libre
libre1171×504 54.5 KB

10

Bartek_Tabak,

When you click on one of those graphs and then click on “show RRD command” what do you see?

11

I reckon poller isn’t running.

Try and run ./poller-wrapper.py 16 manually and see what happens.

12

INFO: worker Thread-10 finished device 38 in 1 seconds
INFO: worker Thread-4 finished device 273 in 1 seconds
INFO: worker Thread-2 finished device 266 in 1 seconds
INFO: worker Thread-16 finished device 145 in 1 seconds
INFO: worker Thread-8 finished device 183 in 1 seconds
INFO: worker Thread-9 finished device 143 in 1 seconds
INFO: worker Thread-3 finished device 182 in 1 seconds
INFO: worker Thread-12 finished device 37 in 2 seconds
INFO: worker Thread-6 finished device 11 in 12 seconds
INFO: poller-wrapper polled 294 devices in 397 seconds with 16 workers
WARNING: the process took more than 5 minutes to finish, you need faster hardware or more threads
INFO: in sequential style polling the elapsed time would have been: 6075 seconds
WARNING: Consider setting a minimum of 22 threads. (This does not constitute professional advice!)

In rrd command i see some error: RRDTool Output
1377x339
ERROR: Unable to connect to rrdcached: Permission denied

13

after you ran the poller anything show?

Also are you running RRDcached?

14

Yes, i use rrdcached and there is some permission error’s but i dont know why

RRDTool Output 1377x339
ERROR: Unable to connect to rrdcached: Permission denied

15

chmod 755 /var/run/rrdcached

16

Still dont show grapch.

17

I would go back through the install guide for rrdcached setup as you have something wrong.