Hi everyone,
I’ve recently installed LibreNMS on both Ubuntu 22.04 and 24.04, but I’m encountering some unusual errors.
- Error in Polling Ports Module: I receive an error message, “Error polling ports module. Check log file for more details.” Upon checking the log file, I found this SQL error: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\x96 glob…’ for column
librenms
I’m unsure which settings to adjust to resolve this. I followed the LibreNMS documentation closely, so any insights into configuration tweaks would be appreciated.
- Blank Graphs for Certain Ports: Some ports display blank graphs in the performance section, although the real-time section shows data accurately. This issue doesn’t occur with every port; only certain ones on the same equipment are affected, so I can’t identify a clear pattern.
If anyone has encountered these issues or has ideas on how to troubleshoot, I’d appreciate your help!
librenms@x86-librenms-2:~$ ./validate.php
| Component | Version |
|---|---|
| LibreNMS | 24.9.1-104-gabefe902d (2024-10-31T05:29:09+08:00) |
| DB Schema | 2024_10_12_210114_custom_map_legend_colours (304) |
| PHP | 8.3.6 |
| Python | 3.12.3 |
| Database | MariaDB 10.11.8-MariaDB-0ubuntu0.24.04.1 |
| RRDTool | 1.7.2 |
| SNMP | 5.9.4.pre2 |
| =========================================== |
[OK] Composer Version: 2.8.2
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database connection successful
[OK] Database Schema is current
[OK] SQL Server meets minimum requirements
[OK] lower_case_table_names is enabled
[OK] MySQL engine is optimal
[OK] Database and column collations are correct
[OK] Database schema correct
[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