Hi,
I need a help, my server stop polling with error;
Devices unpolled
It appears as though you have some devices that haven't completed polling within the last 15 minutes, you may want to check that out :)
Any idea to solve it please!
Thanks
librenms@ubuntu:~$ ./validate.php
===========================================
Component | Version
--------- | -------
LibreNMS | 24.8.0-28-gcdc360dcd (2024-08-28T20:35:20+01:00)
DB Schema | 2024_08_27_182000_ports_statistics_table_rev_length (299)
PHP | 8.2.22
Python | 3.10.12
Database | MariaDB 10.6.18-MariaDB-0ubuntu0.22.04.1
RRDTool | 1.7.2
SNMP | 5.9.1
===========================================
[OK] Composer Version: 2.7.8
[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
[FAIL] Poller is not running. No poller has run within the last 300 seconds.
[OK] Dispatcher Service not detected
[OK] Locks are functional
[FAIL] No active python wrapper pollers found
[OK] Redis is unavailable
[OK] rrdtool version ok
[OK] Connected to rrdcached
librenms@ubuntu:~$ /opt/librenms/poller-wrapper.py 4
2024-08-30 12:16:02,155 :: CRITICAL :: ERROR: Could not connect to MySQL database! (1130, "127.0.0.1' is not allowed to connect to this MariaDB server")
Traceback (most recent call last):
File "/opt/librenms/poller-wrapper.py", line 64, in <module>
wrapper.wrapper(
File "/opt/librenms/LibreNMS/wrapper.py", line 468, in wrapper
db_connection = LibreNMS.DB(sconfig)
File "/opt/librenms/LibreNMS/__init__.py", line 220, in __init__
self.connect()
File "/opt/librenms/LibreNMS/__init__.py", line 269, in connect
conn = MySQLdb.connect(**args)
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 353, in __init__
self.connect()
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 632, in connect
self._get_server_information()
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1055, in _get_server_information
packet = self._read_packet()
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/lib/python3/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1130, "127.0.0.1' is not allowed to connect to this MariaDB server")
I can connect to db normally!
root@ubuntu:~# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 8951
Server version: 10.6.18-MariaDB-0ubuntu0.22.04.1 Ubuntu 22.04
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| librenms |
| mysql |
| performance_schema |
| sys |
+--------------------+
5 rows in set (0.000 sec)
MariaDB [(none)]>