When I click on ports I get: Whoops, looks like something went wrong. Check your librenms.log.
validate shows:
Component | Version |
---|---|
LibreNMS | 24.7.0-21-ge45dd59f7 (2024-07-26T08:26:04-05:00) |
DB Schema | 2024_07_19_120719_update_ports_stack_table (296) |
PHP | 8.1.27 |
Python | 3.9.2 |
Database | MariaDB 10.5.23-MariaDB-0+deb11u1 |
RRDTool | 1.7.2 |
SNMP | 5.9 |
=========================================== |
[OK] Composer Version: 2.7.7
[OK] Dependencies up-to-date.
[OK] Database connection successful
[WARN] Your database schema has extra migrations (2024_07_19_120719_update_ports_stack_table). If you just switched to the stable release from the daily release, your database is in between releases and this will be resolved with the next release.
[OK] SQL Server meets minimum requirements
[OK] lower_case_table_names is enabled
[OK] MySQL engine is optimal
[OK] MySQL and PHP time match
[OK] Active pollers found
[OK] Dispatcher Service not detected
[OK] Locks are functional
[OK] Python poller wrapper is polling
[OK] Redis is unavailable
[OK] rrd_dir is writable
[OK] rrdtool version ok
Error in log:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘port_id_high’ in ‘where clause’ (Connection: mysql, SQL: select * from ports_stack
where device_id
= 166 and (port_id_high
= 15577 or port_id_low
= 15577)) {“userId”:2,“exception”:“[object] (Illuminate\Database\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘port_id_high’ in ‘where clause’ (Connection: mysql, SQL: select * from ports_stack
where device_id
= 166 and (port_id_high
= 15577 or port_id_low
= 15577)) at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘port_id_high’ in ‘where clause’ at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:423)”}
When asking for help and support, please provide as much information as possible. This should include:
- Steps to reproduce an issue.
- The output of
./validate.php
If it’s an issue with the WebUI then please consider including a screenshot and the browser version you are using.
If you are having troubles with discovery/polling include the pastebin output of:
./discovery.php -h HOSTNAME -d | ./pbin.sh
./poller.php -h HOSTNAME -r -f -d | ./pbin.sh
If you need to post any text longer than a few lines, please use a pastebin service such as https://p.libren.ms using non-expiring pastes.