Hi,
We tried to configure new poller in our envieonment, however DB connection is failing when we tried to connect to the main server database.
Below error occurred when we ran the validate.php on distributed poller.
===========================================
| Component | Version |
|---|---|
| LibreNMS | 23.6.0-12-gafe0a25d3 (2023-06-26T11:25:42-04:00) |
| DB Schema | No Schema (0) |
| PHP | 8.1.2-1ubuntu2.11 |
| Python | 3.10.6 |
| Database | MariaDB 10.6.12-MariaDB-0ubuntu0.22.04.1 |
| RRDTool | 1.7.2 |
| SNMP | 5.9.1 |
| =========================================== |
[OK] Composer Version: 2.5.8
[OK] Dependencies up-to-date.
In Connection.php line 793:
SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user ‘librenms’@‘’ f
or table librenmsdb.devices (Connection: mysql, SQL: select exists(select * from devices) as exists)
In Connection.php line 414:
SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user ‘librenms’@’ f
or table librenmsdb.devices
Also after these configuration we are getting “Undefined constant “‘distributed_poller’”” error on main server.
Could you please help me to resolve this issue.
SQLDB port is open in firewall.
Below is the output for validate.pho on main server.
In config.php line 31:
Undefined constant “‘distributed_poller’”
===========================================
| Component | Version |
|---|---|
| LibreNMS | 23.5.0-11-g3ac0129fa (2023-06-07T01:22:36-04:00) |
| DB Schema | Not Connected (0) |
| PHP | 8.1.2-1ubuntu2.11 |
| Python | 3.10.6 |
| Database | Not Connected |
| RRDTool | 1.7.2 |
| SNMP | 5.9.1 |
| =========================================== |
[OK] Composer Version: 2.5.8
[OK] Dependencies up-to-date.
.env file also updated with correct db details…