Poller Server unable to connect to DB

Help
1 
Hey all

i am setting up distributed polling for the first time and i am running into an issue on the poller server. Server 1 has the webUI, memcached, rrdcached and DB all installed on it because originally we were only using a one server setup.

Now with installing distributed polling i have built out a poller server to handle that load, but librenms cannot connect to the database on server 1, but if i run

mysql -h 10.78.240.110 -u librenmsuser -p from the poller server which is 10.78.240.111 i cam able to connect just fine. so i am not sure exactly where i have messed up at.

my config.php on the poller server has the same information on it as the master server just without localhost.

Database config

$config[‘db_host’] = ‘10.78.240.110’;
$config[‘db_port’] = ‘3306’;
$config[‘db_user’] = ‘librenmsuser’;
$config[‘db_pass’] = ‘xxxxxxxxxxxxx’;
$config[‘db_name’] = ‘librenmsdb’;
$config[‘db_socket’] = ‘’;

Do any of you have any ideas why i can manually connect to the mariadb from the poller server, but librenms fails to connect to it?

Thank you for any help you are able to provide.

2

What about your .env file?

Also, ./validate.php

3

well now i feel like an idiot. lol i completely forgot about the .env file.

i had copied the librenms install from the master server to the poller server and so the .env was still pointed at localhost.

i changed it to the master IP and it works now.

Thank you for pointing me in the right direction.