[OK] Composer Version: 2.7.9
[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] rrd_dir is writable
[OK] rrdtool version ok
I have the same issue. It happens right after the midnight daily update.
librenms@librenms:~$ ./validate.php
===========================================
Component | Version
--------- | -------
LibreNMS | 24.8.0-61-gf1e7a218f (2024-09-09T23:48:07+07:00)
DB Schema | 2021_02_09_122930_migrate_to_utf8mb4 (299)
PHP | 8.1.2-1ubuntu2.18
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.9
[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
The poller-wrapper.py give error the following. However poller.py still run successfully.
librenms@librenms:~$ ./poller-wrapper.py 2
2024-09-10 08:40:53,612 :: CRITICAL :: ERROR: Could not connect to MySQL database! (1045, "Access denied for user 'librenms'@'localhost' (using password: NO)")
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 633, in connect
self._request_authentication()
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 907, in _request_authentication
auth_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: (1045, "Access denied for user 'librenms'@'localhost' (using password: NO)")
Mine has just done it too! (No active python wrapper pollers found)
librenms@librenms:~$ ./validate.php
===========================================
Component | Version
--------- | -------
LibreNMS | 24.8.0-61-gf1e7a218f (2024-09-09T17:48:07+01:00)
DB Schema | 2024_08_27_182000_ports_statistics_table_rev_length (299)
PHP | 8.1.2-1ubuntu2.18
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] rrd_dir is writable
[OK] rrdtool version ok
and poller_wrapper.log
2024-09-10 00:11:22,701 :: INFO :: poller-wrapper checked 9 devices in 79 seconds with 9 workers with 0 errors
2024-09-10 00:15:03,271 :: INFO :: starting the poller check at 2024-09-10 00:15:03 with 9 threads for 9 devices
2024-09-10 00:15:06,512 :: INFO :: worker Thread-11 (poll_worker) finished device 2 in 3 seconds
2024-09-10 00:15:09,072 :: INFO :: worker Thread-16 (poll_worker) finished device 1 in 5 seconds
2024-09-10 00:15:11,776 :: INFO :: worker Thread-15 (poll_worker) finished device 6 in 8 seconds
2024-09-10 00:15:16,933 :: INFO :: worker Thread-13 (poll_worker) finished device 10 in 13 seconds
2024-09-10 00:15:20,406 :: INFO :: worker Thread-8 (poll_worker) finished device 4 in 17 seconds
2024-09-10 00:15:22,663 :: INFO :: worker Thread-7 (poll_worker) finished device 5 in 19 seconds
2024-09-10 00:15:40,405 :: INFO :: worker Thread-4 (poll_worker) finished device 9 in 37 seconds
2024-09-10 00:15:53,011 :: INFO :: worker Thread-3 (poll_worker) finished device 7 in 49 seconds
2024-09-10 00:16:22,746 :: INFO :: worker Thread-2 (poll_worker) finished device 3 in 79 seconds
2024-09-10 00:16:22,747 :: INFO :: poller-wrapper checked 9 devices in 79 seconds with 9 workers with 0 errors
2024-09-10 00:20:03,027 :: CRITICAL :: ERROR: Could not connect to MySQL database! (1045, "Access denied for user 'librenms'@'localhost' (using password: NO)")
2024-09-10 00:25:02,866 :: CRITICAL :: ERROR: Could not connect to MySQL database! (1045, "Access denied for user 'librenms'@'localhost' (using password: NO)")
2024-09-10 00:30:03,691 :: CRITICAL :: ERROR: Could not connect to MySQL database! (1045, "Access denied for user 'librenms'@'localhost' (using password: NO)")
2024-09-10 00:35:02,915 :: CRITICAL :: ERROR: Could not connect to MySQL database! (1045, "Access denied for user 'librenms'@'localhost' (using password: NO)")
2024-09-10 00:40:03,007 :: CRITICAL :: ERROR: Could not connect to MySQL database! (1045, "Access denied for user 'librenms'@'localhost' (using password: NO)")
librenms@monitor2:~$ ./validate.php
===========================================
Component | Version
--------- | -------
LibreNMS | 24.8.0-61-gf1e7a218f (2024-09-09T16:48:07+00:00)
DB Schema | 2024_08_27_182000_ports_statistics_table_rev_length (299)
PHP | 8.2.14
Python | 3.9.2
Database | MariaDB 10.5.23-MariaDB-0+deb11u1
RRDTool | 1.7.2
SNMP | 5.9
===========================================
[OK] Composer Version: 2.7.9
[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] rrd_dir is writable
[OK] rrdtool version ok
manually running the poller reveals this:
STANDARD OUTPUT:
2024-09-10 02:09:13,208 :: CRITICAL :: ERROR: Could not connect to MySQL database! (1045, "Access denied
for user 'librenms'@'localhost' (using password: NO)")
UPDATE - I changed my db password in /opt/librenms/.env to one without symbols, then update the password in MySQL:
ALTER USER 'librenms'@'localhost' IDENTIFIED BY 'new_secure_password';
FLUSH PRIVILEGES;
Now php /opt/librenms/poller.php -h all -d works, but the /opt/librenms/poller-wrapper.py 16 still says:
librenms@librenms:~$ /opt/librenms/poller-wrapper.py 16
2024-09-10 03:23:37,358 :: CRITICAL :: ERROR: Could not connect to MySQL database! (1045, "Access denied for user 'librenms'@'localhost' (using password: NO)")
2024-09-10 09:45:02,637 :: CRITICAL :: ERROR: Could not connect to MySQL database! (1045, "Access denied for user 'librenms'@'localhost' (using password: NO)
[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] rrd_dir is writable
[OK] rrdtool version ok
/opt/librenms/poller-wrapper.py 16
2024-09-10 08:54:34,532 :: CRITICAL :: ERROR: Could not connect to MySQL database! (1045, “Access denied for user ‘librenms’@‘localhost’ (using password: NO)”)
Traceback (most recent call last):
File “/opt/librenms/poller-wrapper.py”, line 64, in
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/init.py”, line 94, in Connect
return Connection(*args, **kwargs)
File “/usr/lib/python3/dist-packages/pymysql/connections.py”, line 325, in init
self.connect()
File “/usr/lib/python3/dist-packages/pymysql/connections.py”, line 599, in connect
self._request_authentication()
File “/usr/lib/python3/dist-packages/pymysql/connections.py”, line 861, in _request_authentication
auth_packet = self._read_packet()
File “/usr/lib/python3/dist-packages/pymysql/connections.py”, line 684, in _read_packet
packet.check_error()
File “/usr/lib/python3/dist-packages/pymysql/protocol.py”, line 220, in check_error
err.raise_mysql_exception(self._data)
File “/usr/lib/python3/dist-packages/pymysql/err.py”, line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1045, “Access denied for user ‘librenms’@‘localhost’ (using password: NO)”)
$config[‘db_pass’] has been deprecated, therefore will not work in some environments.
Our poller resumed upon adding password=“YOUR_DB_PASSWORD” (replace the empty space) in def init function within /usr/lib/python3/dist-packages/pymysql/connections.py file.
this works for me, thanks.
my environments:
|Version |24.8.0-61-gf1e7a218f
|Web Server |nginx/1.22.1|
|PHP |8.1.14|
|Python |3.9.17|
|Database |MariaDB 10.5.16-MariaDB|
|Laravel |10.48.18|
|RRDtool |1.7.2|
ran daily.sh . Current version is now 24.8.0-62-g77fa7573c
however, still the same issue. Is this the correct version to be on? anything else to be done?
