Remote Poller is not showing in Main Poller

[ponnuchelvam]

Hi Team, I installed main poller and remote poller. Remote poller is not showing in main poller under data collectors. But we able to see main poller in remote poller page under data collector. Please help to resolve the issue. I am very new on open source tools. Also, i am able do full sync from Main poller. I dont know where i am doing mistake. Also , Main poller status always "unknown\down". I have attached screentshot here. Please help.

Note: I am not install spine sofar. I dont feel that is not make this issue.


Thanks and Regards
Ponnuchelvam.V

[netniV]

Make sure that the cron for the main poller is setup and running. Check the cacti logs (CLOG tab) to make sure that you are seeing no errors and completion of polling cycles. Try updating the logging level to show more info if you are unsure.

[ponnuchelvam]

Hi Netniv,

I have cron like below on main poller.

> cat /etc/cron.d/cacti


*/5 * * * * cacti /usr/bin/php /usr/share/cacti/poller.php > /dev/null 2>&1



Thanks and Regards
Ponnuchelvam.V
Mobile: (91) 8015031151

[ponnuchelvam]

Hi Netniv,

After having the below cron config.. Main cacti data collector status is showing as " Running". But i couldn't view the remote poller entry in Main cacti server. Please help to resolve this.

> cat /etc/cron.d/cacti


*/5 * * * * cacti /usr/bin/php /usr/share/cacti/poller.php > /dev/null 2>&1


I have the below config in remote poller under > cat /etc/cacti/db.php

[root@cactisechub ~]# cat /etc/cacti/db.php
<?php
/*
+-------------------------------------------------------------------------+
| Copyright (C) 2004-2018 The Cacti Group |
| |
| This program is free software; you can redistribute it and/or |
| modify it under the terms of the GNU General Public License |
| as published by the Free Software Foundation; either version 2 |
| of the License, or (at your option) any later version. |
| |
| This program is distributed in the hope that it will be useful, |
| but WITHOUT ANY WARRANTY; without even the implied warranty of |
| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
| GNU General Public License for more details. |
+-------------------------------------------------------------------------+
| Cacti: The Complete RRDtool-based Graphing Solution |
+-------------------------------------------------------------------------+
| This code is designed, written, and maintained by the Cacti Group. See |
| about.php and/or the AUTHORS file for specific developer information. |
+-------------------------------------------------------------------------+
| http://www.cacti.net/ |
+-------------------------------------------------------------------------+
*/

/* make sure these values reflect your actual database/host/user/password */

$database_type = 'mysql';
$database_default = 'cactisec';
$database_hostname = 'localhost';
$database_username = 'cacti';
$database_password = 'cacti';
$database_port = '3306';
$database_ssl = false;

/* when the cacti server is a remote poller, then these entries point to
* the main cacti server. otherwise, these variables have no use.
* and must remain commented out. */

$rdatabase_type = 'mysql';
$rdatabase_default = 'cacti';
$rdatabase_hostname = 'main cacti ip';
$rdatabase_username = 'cacti';
$rdatabase_password = 'cacti';
$rdatabase_port = '3306';
$rdatabase_ssl = false;

/* the poller_id of this system. set to '1' for the main cacti
* web server. otherwise, you this value should be the poller_id
* for the remote poller. */

$poller_id = 3;

/* set the $url_path to point to the default URL of your cacti
* install ex: if your cacti install as at
* http://serverip/cacti/ this would be set to /cacti/.
*/

$url_path = '/cacti/';

/* default session name - session name must contain alpha characters */

$cacti_session_name = 'Cacti';

/* save sessions to a database for load balancing */

$cacti_db_session = false;

/* optional parameters to define scripts and resource paths. these
* variables become important when using remote poller installs
* when the scripts and resource files are not in the main cacti
* web server path. */

//$scripts_path = '/var/www/html/cacti/scripts';
//$resource_path = '/var/www/html/cacti/resource/';
[root@cactisechub ~]#

[netniV]

Do you have a cron setup on the remote poller?

[ponnuchelvam]

Hi netniv,

Yes. I have the cron on remote poller. the below config i have.

[root@cactisechub ~]# cat /etc/cron.d/cacti
*/5 * * * * cacti /usr/bin/php /usr/share/cacti/poller.php > /dev/null 2>&1

Thanks and Regards
Ponnuchelvam.V
(+91) 8015031151

[ponnuchelvam]

Hi Netniv, the below hosts file config have on both main and remote cacti servers.

Cacti main server:
[root@cactimainhub ~]# cat /etc/hosts
198.x.x.22 cactimainhub
198.x.x.24 cactisechub
#127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
#::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

Cacti remote server:
[root@cactisechub ~]# cat /etc/hosts
198.x.x.24 cactisechub
198.x.x.22 cactimainhub
#127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
#::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

[netniV]

Can you use mysql at the command line and ensure you can connect to the remote server and vise versa?

[ponnuchelvam]

Hi Netniv,
Yes. i can reach mysql vise versa.

FROM MAIN CACTI to Remote CACTI MYSQL:

[root@cactimainhub ~]# telnet 198.19.x.24 3306
Trying 198.19.x.24...
Connected to 198.19.x.24.
Escape character is '^]'.
Y
5.5.5-10.1.36-MariaDB`x[>aPL?▒R=zn9pI[o;vcmysql_native_passwordConnection closed by foreign host.
[root@cactimainhub ~]#

FROM Remote CACTI to Main CACTI MYSQL:

[root@cactisechub ~]# telnet 198.19.x.22 3306
Trying 198.19.x.22...
Connected to 198.19.x.22.
Escape character is '^]'.
Y
5.5.5-10.1.36-MariaDB▒~wY9Oc$?▒:.s|7:]D}k"amysql_native_passwordConnection closed by foreign host.
[root@cactisechub ~]#

[netniV]

Sorry, I was expecting you to use the mysql commandline tool rather than purely connecting to the port. At least we know the port is open both ways.

Make sure both servers can use both sets of credentials by connecting then doing a simple SQL command like "select * from version;"

[ponnuchelvam]

Hi Netniv, I am able to connect vice versa through command line.

FROM MAIN CACTI to Remote CACTI MYSQL:

[root@cactimainhub ~]# mysql -u "cacti" -h "198.19.x.24" -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 33
Server version: 10.1.36-MariaDB MariaDB Server

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)]> use cactisec;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [cactisec]>

FROM Remote CACTI to Main CACTI MYSQL:

[root@cactisechub ~]# mysql -u "cacti" -h "198.19.x.22" -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 170
Server version: 10.1.36-MariaDB MariaDB Server

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)]> use cacti;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [cacti]>

[ponnuchelvam]

Hi Netniv,

One thing i want to tell . I have two different database name for both Main and remote cacti. Is it make issues?.

Database name in Main Cacti is "cacti"
Database name in Remote Cacti is "cactisec"

Thanks and Regards
Ponnuchelvam.V
(+91) 8015031151

[netniV]

As long as you have them set properly, no. You could use the same server with different connection details (eg, db name and user) or separate servers. As long as they aren't sharing the same database (that is the big no no).

[netniV]

Do you have any errors in <cacti>/log/cacti.log on the remote poller?

[ponnuchelvam]

Hi Netniv, that's like only i did. if you check my update. you can find the request what i did. I tested mysql connection and i tried to connect remote cacti database from main cacti. Even i dont use same db name. so, it making connection vise versa and able to access db also.

Thanks and Regards
Ponnuchelvam.V
(91) 8015031151