Inventory overview empty

Help
1

Hi all,

I cannot get my inventory overview to populate. Within individual devices inventory is fine (workstations show cpu, memory etc.). But the overview (https://librenms_url.org/inventory) is empty.

I tried looking in the browser console, but there is no helpful error there. Any suggestions?

./validate output:

#### Configuration Ok
#### Database Ok
#### Dependencies Ok
#### Disk Ok
#### Distributedpoller Ok
#### Mail Ok
#### Php Ok
#### Poller Ok
#### Programs Ok
#### Python Failure
FAIL: Python3 module issue found: 'Required packages: ['PyMySQL!=1.0.0', 'python-dotenv', 'redis>=4.0', 'setuptools', 'psutil>=5.9.6', 'command_runner>=1.3.0'] Package not found: The 'command_runner>=1.3.0' distribution was not found and is required by the application '
Fix:
pip3 install -r /opt/librenms/requirements.txt
#### Rrd Ok
#### Rrdcheck Ok
#### Scheduler Ok
#### System Ok
#### Updates Ok
#### User Failure
FAIL: We have found some files that are owned by a different user than 'librenms', this will stop you updating automatically and / or rrd files being updated causing graphs to fail.

Fix:

sudo chown -R librenms:librenms /opt/librenms sudo setfacl -d -m g::rwx /opt/librenms/rrd /opt/librenms/logs /opt/librenms/bootstrap/cache/ /opt/librenms/storage/ sudo chmod -R ug=rwX /opt/librenms/rrd /opt/librenms/logs /opt/librenms/bootstrap/cache/ /opt/librenms/storage/

* Files
* /opt/librenms/rrd/smokeping/appliance/device.rrd
* /opt/librenms/rrd/smokeping/__sortercache/data.lnmsFPing-0.storable
* /opt/librenms/rrd/smokeping/__sortercache/data.lnmsFPing-1.storable

#### Webserver Failure

WARN: base_url could be more specific
2

Hello,
Check developer console for errors then check database inventory entries. Some vendors accept non ascii garbage in serials etc which can lead to broken inventory.

3

Hi,

  • Console: 0 errors
  • Database: see below. This is normal, right?
  • Api: see below database. This is weird, right? How can API/webpage be empty but database not?
  • Api: in the api docs I read about entPhysical, not sure what it means. This database table is empty.
MariaDB [librenms]> select * from processors where device_id='11';
+--------------+------------------+---------------+-----------+--------------------------------+-----------------+----------------+-----------------+-----------------+---------------------+---------------------+
| processor_id | entPhysicalIndex | hrDeviceIndex | device_id | processor_oid                  | processor_index | processor_type | processor_usage | processor_descr | processor_precision | processor_perc_warn |
+--------------+------------------+---------------+-----------+--------------------------------+-----------------+----------------+-----------------+-----------------+---------------------+---------------------+
|           15 |                0 |        196608 |        11 | .1.3.6.1.2.1.25.3.3.1.2.196608 | 196608          | hr             |               8 | Processor       |                   1 |                  75 |
|           16 |                0 |        196609 |        11 | .1.3.6.1.2.1.25.3.3.1.2.196609 | 196609          | hr             |               4 | Processor       |                   1 |                  75 |
+--------------+------------------+---------------+-----------+--------------------------------+-----------------+----------------+-----------------+-----------------+---------------------+---------------------+
2 rows in set (0,004 sec)

`curl -H 'X-Auth-Token: .....' http://servername/api/v0/inventory/11/all
{
    "status": "ok",
    "inventory": [],
    "count": 0
}

MariaDB [librenms]> select * from entPhysical;
Empty set (0,001 sec)
4

Did some more digging, the only relevant issue I could find is someone having a mariadb config error. entPhysical is one of the few db table names with an uppercase letter. But the config is correct.

lower_case_table_names=0

Which function is responsible for populating the Inventory table? I couldn’t find it in the codebase.