More on this, since it seems like things are closer. As soon as I enable the remote poller (cacti-btp-01), that poller runs and processes devices assigned to it, but the main poller (util-st-01) goes to unknown/down and stops processing devices. I have tried various combinations of RBD and DB configs (none seem to make any difference). Below are the current settings:
config.php on the remote poller (cacti-btp-01):
Code: Select all
$database_type = 'mysql';
$database_default = 'cacti1x_btp';
$database_hostname = 'localhost';
$database_username = 'cactiuser';
$database_password = 'password';
$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 = 'cacti1x';
$rdatabase_hostname = 'util-st-01';
$rdatabase_username = 'cactiuser';
$rdatabase_password = 'password';
$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 = 2;
spine.conf on the remote poller (cacti-btp-01):
Code: Select all
DB_Host localhost
DB_Database cacti1x_btp
DB_User cactiuser
DB_Pass password
DB_Port 3306
RDB_Host localhost
RDB_Database cacti1x_btp
RDB_User cactiuser
RDB_Pass password
RDB_Port 3306
config.php on the main poller (util-st-01):
Code: Select all
$database_type = 'mysql';
$database_default = 'cacti1x';
$database_hostname = 'localhost';
$database_username = 'cactiuser';
$database_password = 'password';
$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 = 'localhost';
#$rdatabase_username = 'cactiuser';
#$rdatabase_password = 'cactiuser';
#$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 = 1;
spine.conf on the main cacti poller (util-st-01):
Code: Select all
DB_Host localhost
DB_Database cacti1x
DB_User cactiuser
DB_Pass password
DB_Port 3306
RDB_Host cacti-btp-01
RDB_Database cacti1x_btp
RDB_User cactiuser
RDB_Pass password
RDB_Port 3306
I have verified that I can successfully connect to the mysql server on each poller remotely using the command "mysql -u cactiuser -p -h cacti-btp-01" (or mysql -u cactiuser -p -h util-st-01) and I can.
SQL users on the remote poller (cacti-btp-01):
Code: Select all
mysql> select user,host from mysql.user;
+-----------+------------+
| user | host |
+-----------+------------+
| cactiuser | localhost |
| mysql.sys | localhost |
| root | localhost |
| cactiuser | util-st-01 |
+-----------+------------+
4 rows in set (0.00 sec)
Grants on the remote poller (cacti-btp-01):
Code: Select all
mysql> show grants for 'cactiuser'@'util-st-01';
+---------------------------------------------------------------------+
| Grants for cactiuser@util-st-01 |
+---------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'cactiuser'@'util-st-01' |
| GRANT ALL PRIVILEGES ON `cacti1x_btp`.* TO 'cactiuser'@'util-st-01' |
+---------------------------------------------------------------------+
2 rows in set (0.00 sec)
SQL users on the main poller (util-st-01):
Code: Select all
mysql> select user,host from mysql.user;
+-----------+-----------------------+
| user | host |
+-----------+-----------------------+
| root | 127.0.0.1 |
| cactiuser | cacti-btp-01 |
| | localhost |
| cactiuser | localhost |
| mysql.sys | localhost |
| root | localhost |
| | util-st-01 |
| root | util-st-01 |
+-----------+-----------------------+
8 rows in set (0.00 sec)
Grants on the main poller (util-st-01):
[code]
mysql> show grants for 'cactiuser'@'cacti-btp-01';
+-------------------------------------------------------------------+
| Grants for cactiuser@cacti-btp-01 |
+-------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'cactiuser'@'cacti-btp-01' |
| GRANT ALL PRIVILEGES ON `cacti1x`.* TO 'cactiuser'@'cacti-btp-01' |
+-------------------------------------------------------------------+
2 rows in set (0.00 sec)
