Can't configure remote poller

[stormonts]

Yes, we are using spine and on-demand is enabled.

performance.png (69.66 KiB) Viewed 1658 times

spine.png (61.55 KiB) Viewed 1658 times

[Piratos]

I have it working. Looks very good.

I have both On-demand RRD Updating and RRDtool Proxy Server disabled. Currently testing with localhost and one Cisco router (I have no idea why Cacti is sharing the localhost data).

[stormonts]

You have on demand updating disabled? That is strange as that is not what any of the documentation says.

[Piratos]

I had problems with On-demand RRD Updating enabled.

[stormonts]

What do your spine.conf files look like on your main Cacti server and the remote poller?

[Piratos]

Both spine.conf look like you would expect:

Code: Select all

DB_Host		localhost
DB_Database	cacti
DB_User		cactiuser
DB_Pass		local_PW
DB_Port		3306

RDB_Host		remote_IP
RDB_Database	cacti
RDB_User		cactiuser
RDB_Pass		remote_PW
RDB_Port		3306

But I did have to add extra rules to the firewall (I updated from CatiEZ 0.7).

I also I had to uncomment "bind-address=127.0.0.1" in /etc/my.cnf.d/server.cnf and add remote user login to MySQL:

Code: Select all

mysql> GRANT ALL ON cacti.* TO cactiuser@{remoteIP} IDENTIFIED BY '{local_PW}';
mysql> flush privileges;

to be able to remotely log in to MySQL .

[stormonts]

So your main server looks like below and the remote server has the same conifg (with the only exception being the remote IP is different)?

DB_Host localhost
DB_Database cacti
DB_User cactiuser
DB_Pass local_PW
DB_Port 3306

RDB_Host remote_IP
RDB_Database cacti
RDB_User cactiuser
RDB_Pass remote_PW
RDB_Port 3306

[Piratos]

Dear stormonts,

I made a small guide here:

http://forums.cacti.net/viewtopic.php?f=6&t=57506

[stormonts]

I think I finally got this working (somewhat), but it wasn't quite as expected and I am still having some issues.

Before we messed with remote polling, our main Cacti server we have "On Demand RRD Updating" enabled, as well as SPine ( 6 concurrent poller processes, 25 threads per process, 10 script servers), and polling would finish at around 30 seconds. We have more devices that we want to add, like some switches, that we know are slow to poll so we wanted to setup a remote poller to poll servers/devices at that location. The remote poller (it doesn't have nearly the horespower as the main server) was setup at a different location connected via a dedicated 1 gig connection with a latency of 2.5 ms between them.

I know that the remote polling is configured as the following tests all pass:
From the remote poller to the main poller

Code: Select all

mysql -u cactiuser --password={Main poller PW} -h {Main poller IP}

Works fine.

From the main poller to the remote poller

Code: Select all

shell> mysql -u cactiuser --password={Remote Poller PW} -h {Remote Poller IP}

Works fine.

Log into the GUI, go to Data Collectors, click on the Remote Data Collector (it has no name initially). Did the following:

Code: Select all

Change the name
Set the web site hostname to the FQDN of the remote poller
Set the hostname to the IP of the remote poller
Set the Remote Database Name to the correct name (cacti1x-btp)
Set the Remote Database User to cactiuser
Set the Remote Database Password to the {Remote Poller PW}
Click Save
Click Test Connection button
See "Connection Successful" message.

When I make a change on either the remote or main poller settings, the change then shows up at the other location, so they are definitely talking.

When I select the remote Data Collector and click "Enable", no more data is charted in the graphs. At this point, I haven't even assigned any devices to the remote poller, they are still associated with the original main poller but the graphs just stop logging data. If I turn off On Demand RRD Updating, then I start getting sporadic data graphed, but then both pollers (main and remote) start to overrun the 1 minute polling interval that we have setup.

I know the various posts I have read said that having on demand updating is suggested, that gives me absolutely no graphs. But disabling it ends up giving me holes. Is it a permission thing with Boost and the rra directory? Any other ideas?