Hi @murrant ,
Thanks for your quickly response!
I had already done this optimization after installation, I did the review and everything is fine!
I changed the PHP child and enabled tuning in the MySQL settings, the system started working again and responding better, but it started to show errors in the icon and deformation of the pop-up graph and the global settings page is blank, I saw the logs and I have the errors below;
root@librenms:~# tail -f /var/log/php8.3-fpm.log
[01-Apr-2025 10:47:06] NOTICE: Terminating ...
[01-Apr-2025 10:47:06] NOTICE: exiting, bye-bye!
[01-Apr-2025 10:47:06] NOTICE: fpm is running, pid 2181613
[01-Apr-2025 10:47:06] NOTICE: ready to handle connections
[01-Apr-2025 10:47:06] NOTICE: systemd monitor interval set to 10000ms
[01-Apr-2025 10:47:35] NOTICE: Terminating ...
[01-Apr-2025 10:47:35] NOTICE: exiting, bye-bye!
[01-Apr-2025 10:47:35] NOTICE: fpm is running, pid 2198156
[01-Apr-2025 10:47:35] NOTICE: ready to handle connections
[01-Apr-2025 10:47:35] NOTICE: systemd monitor interval set to 10000ms
^C
root@librenms:~# tail -f /var/log/mysql/error.log
2025-03-31 18:37:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2025-03-31 18:37:26 0 [Note] Server socket created on IP: '127.0.0.1'.
2025-03-31 18:37:26 0 [Note] /usr/sbin/mariadbd: ready for connections.
Version: '10.11.11-MariaDB-0ubuntu0.24.04.2-log' socket: '/run/mysqld/mysqld.sock' port: 3306 Ubuntu 24.04
2025-03-31 18:37:41 0 [Note] InnoDB: Buffer pool(s) load completed at 250331 18:37:41
2025-04-01 0:48:02 69844 [Warning] Aborted connection 69844 to db: 'librenms' user: 'librenms' host: 'localhost' (Got an error reading communication packets)
2025-04-01 6:48:02 139067 [Warning] Aborted connection 139067 to db: 'librenms' user: 'librenms' host: 'localhost' (Got an error reading communication packets)
2025-04-01 10:47:06 189280 [Warning] Aborted connection 189280 to db: 'librenms' user: 'librenms' host: 'localhost' (Got an error reading communication packets)
2025-04-01 10:47:35 189476 [Warning] Aborted connection 189476 to db: 'librenms' user: 'librenms' host: 'localhost' (Got an error reading communication packets)
2025-04-01 10:47:39 189472 [Warning] Aborted connection 189472 to db: 'librenms' user: 'librenms' host: 'localhost' (Got an error writing communication packets)
^C
root@librenms:~# tail -f /var/log/php8.3-fpm.log
[01-Apr-2025 10:47:06] NOTICE: Terminating ...
[01-Apr-2025 10:47:06] NOTICE: exiting, bye-bye!
[01-Apr-2025 10:47:06] NOTICE: fpm is running, pid 2181613
[01-Apr-2025 10:47:06] NOTICE: ready to handle connections
[01-Apr-2025 10:47:06] NOTICE: systemd monitor interval set to 10000ms
[01-Apr-2025 10:47:35] NOTICE: Terminating ...
[01-Apr-2025 10:47:35] NOTICE: exiting, bye-bye!
[01-Apr-2025 10:47:35] NOTICE: fpm is running, pid 2198156
[01-Apr-2025 10:47:35] NOTICE: ready to handle connections
[01-Apr-2025 10:47:35] NOTICE: systemd monitor interval set to 10000ms
^C
root@librenms:~# tail -f /var/log/nginx/error.log
2025/04/01 10:47:35 [crit] 1486#1486: *3928 connect() to unix:/run/php-fpm-librenms.sock failed (2: No such file or directory) while connecting to upstream, client: 10.6.6.22, server: librenms.domain.com, request: "GET /graph.php?id=75895&type=port_errors&legend=no&absolute_size=0&width=150&height=21&from=-1d HTTP/2.0", upstream: "fastcgi://unix:/run/php-fpm-librenms.sock:", host: "librenms.domain.com", referrer: "https://librenms.domain.com/"
2025/04/01 10:47:35 [crit] 1486#1486: *3928 connect() to unix:/run/php-fpm-librenms.sock failed (2: No such file or directory) while connecting to upstream, client: 10.6.6.22, server: librenms.domain.com, request: "GET /graph.php?device=105&from=1743414455&to=1743500855&width=150&height=21&type=device_bits&legend=no&absolute=0 HTTP/2.0", upstream: "fastcgi://unix:/run/php-fpm-librenms.sock:", host: "librenms.domain.com", referrer: "https://librenms.domain.com/"
2025/04/01 10:47:35 [crit] 1486#1486: *3928 connect() to unix:/run/php-fpm-librenms.sock failed (2: No such file or directory) while connecting to upstream, client: 10.6.6.22, server: librenms.domain.com, request: "GET /graph.php?device=106&from=1743414455&to=1743500855&width=150&height=21&type=device_bits&legend=no&absolute=0 HTTP/2.0", upstream: "fastcgi://unix:/run/php-fpm-librenms.sock:", host: "librenms.domain.com", referrer: "https://librenms.domain.com/"
2025/04/01 10:47:35 [crit] 1486#1486: *3928 connect() to unix:/run/php-fpm-librenms.sock failed (2: No such file or directory) while connecting to upstream, client: 10.6.6.22, server: librenms.domain.com, request: "GET /graph.php?device=265&from=1743414455&to=1743500855&width=150&height=21&type=device_bits&legend=no&absolute=0 HTTP/2.0", upstream: "fastcgi://unix:/run/php-fpm-librenms.sock:", host: "librenms.domain.com", referrer: "https://librenms.domain.com/"
2025/04/01 10:47:35 [crit] 1486#1486: *3928 connect() to unix:/run/php-fpm-librenms.sock failed (2: No such file or directory) while connecting to upstream, client: 10.6.6.22, server: librenms.domain.com, request: "GET /graph.php?device=225&from=1743414455&to=1743500855&width=150&height=21&type=device_bits&legend=no&absolute=0 HTTP/2.0", upstream: "fastcgi://unix:/run/php-fpm-librenms.sock:", host: "librenms.domain.com", referrer: "https://librenms.domain.com/"
2025/04/01 10:47:35 [crit] 1486#1486: *3928 connect() to unix:/run/php-fpm-librenms.sock failed (2: No such file or directory) while connecting to upstream, client: 10.6.6.22, server: librenms.domain.com, request: "GET /graph.php?device=190&from=1743414455&to=1743500855&width=150&height=21&type=device_bits&legend=no&absolute=0 HTTP/2.0", upstream: "fastcgi://unix:/run/php-fpm-librenms.sock:", host: "librenms.domain.com", referrer: "https://librenms.domain.com/"
2025/04/01 10:50:28 [alert] 1486#1486: *4282 pread() read only 5602 of 5716 from "/opt/librenms/html/plugins/Weathermap/output/edge1.png" while sending response to client, client: 10.6.6.41, server: librenms.domain.com, request: "GET /plugins/Weathermap/output/edge1.png?1405796415 HTTP/2.0", host: "librenms.domain.com", referrer: "https://librenms.domain.com/overview"
server {
listen 80;
listen 443 ssl http2;
server_name librenms.domain.com;
root /opt/librenms/html;
index index.php;
ssl_certificate /home/administrator/certificate/wildcard.pem;
ssl_certificate_key /home/administrator/certificate/wildcard_key.key;
charset utf-8;
gzip on;
gzip_types text/css application/javascript text/javascript application/x-javascript image/svg+xml text/plain text/xsd text/xsl text/xml image/x-icon;
location / {
try_files $uri $uri/ /index.php?$query_string;
}
location ~ [^/]\.php(/|$) {
fastcgi_pass unix:/run/php-fpm-librenms.sock;
fastcgi_split_path_info ^(.+\.php)(/.+)$;
include fastcgi.conf;
}
location ~ /\.(?!well-known).* {
deny all;
}
}
librenms@librenms:~$ ./validate.php
===========================================
Component | Version
--------- | -------
LibreNMS | 25.3.0-78-g2edcaaed9 (2025-04-01T07:11:59+01:00)
DB Schema | 2025_03_19_205700_fix_ospfv3_ports_table (331)
PHP | 8.3.6
Python | 3.12.3
Database | MariaDB 10.11.11-MariaDB-0ubuntu0.24.04.2-log
RRDTool | 1.7.2
SNMP | 5.9.4.pre2
===========================================
[OK] Composer Version: 2.8.6
[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] rrdtool version ok
[OK] Connected to rrdcached
