No tables where found or selected for conversion in installtion of RDC.

[mpahlevanzadeh]

I installed a Main Collector and it's okey and has graph from. According to new scenario, we are forced to install a Remote Data collectors according to cacti documention:
1. extract cacti in RDC host.
2. change variables of database.
3. import sql file.
4. open new tab and visit host of RDC of cacti.

After some next click, system generate the following log.


LOG =========================

Installing Cacti Server v1.2.23

Your Cacti Server is now installing

Refresh in ProgressLast updated: 17:15:48

0 %

2023-01-23 17:15:48 - INSTALL: always: Background was already started at 2023-01-23 10:25:31.438100, this attempt at 2023-01-23 13:45:48.205700 was skipped
2023-01-23 17:15:48 - INSTALL: Checking arguments
2023-01-23 17:15:48 - INSTALL: always: Spawning background process: /usr/bin/php '/opt/cacti/install/background.php' 1674481548.2057
2023-01-23 16:50:46 - INSTALL: always: Background was already started at 2023-01-23 10:25:31.438100, this attempt at 2023-01-23 13:20:45.723900 was skipped
2023-01-23 16:50:46 - INSTALL: Checking arguments
2023-01-23 16:50:46 - INSTALL: always: Spawning background process: /usr/bin/php '/opt/cacti/install/background.php' 1674480045.7239
2023-01-23 16:25:43 - INSTALL: always: Background was already started at 2023-01-23 10:25:31.438100, this attempt at 2023-01-23 12:55:43.470600 was skipped
2023-01-23 16:25:43 - INSTALL: Checking arguments
2023-01-23 16:25:43 - INSTALL: always: Spawning background process: /usr/bin/php '/opt/cacti/install/background.php' 1674478543.4706
2023-01-23 16:00:42 - INSTALL: always: Background was already started at 2023-01-23 10:25:31.438100, this attempt at 2023-01-23 12:30:42.273300 was skipped
2023-01-23 16:00:42 - INSTALL: Checking arguments
2023-01-23 16:00:42 - INSTALL: always: Spawning background process: /usr/bin/php '/opt/cacti/install/background.php' 1674477042.2733
2023-01-23 15:35:40 - INSTALL: always: Background was already started at 2023-01-23 10:25:31.438100, this attempt at 2023-01-23 12:05:40.383400 was skipped
2023-01-23 15:35:40 - INSTALL: Checking arguments
2023-01-23 15:35:40 - INSTALL: always: Spawning background process: /usr/bin/php '/opt/cacti/install/background.php' 1674475540.3834
2023-01-23 15:10:38 - INSTALL: always: Background was already started at 2023-01-23 10:25:31.438100, this attempt at 2023-01-23 11:40:37.992200 was skipped
2023-01-23 15:10:38 - INSTALL: Checking arguments
2023-01-23 15:10:38 - INSTALL: always: Spawning background process: /usr/bin/php '/opt/cacti/install/background.php' 1674474037.9922
2023-01-23 14:45:36 - INSTALL: always: Background was already started at 2023-01-23 10:25:31.438100, this attempt at 2023-01-23 11:15:35.824300 was skipped
2023-01-23 14:45:36 - INSTALL: Checking arguments
2023-01-23 14:45:36 - INSTALL: always: Spawning background process: /usr/bin/php '/opt/cacti/install/background.php' 1674472535.8243
2023-01-23 14:20:34 - INSTALL: always: Background was already started at 2023-01-23 10:25:31.438100, this attempt at 2023-01-23 10:50:34.163200 was skipped
2023-01-23 14:20:34 - INSTALL: Checking arguments
2023-01-23 14:20:34 - INSTALL: always: Spawning background process: /usr/bin/php '/opt/cacti/install/background.php' 1674471034.1632
2023-01-23 13:55:34 - INSTALL: always: Background was already started at 2023-01-23 10:25:31.438100, this attempt at 2023-01-23 10:25:33.586800 was skipped
2023-01-23 13:55:34 - INSTALL: Checking arguments
2023-01-23 13:55:33 - INSTALL: always: Spawning background process: /usr/bin/php '/opt/cacti/install/background.php' 1674469533.5868
2023-01-23 13:55:32 - INSTALL: always: Installation was started at 2023-01-23 10:25:31, completed at 2023-01-23 10:25:32
2023-01-23 13:55:32 - INSTALL: always: Finished INSTALL Process for v1.2.23
2023-01-23 13:55:32 - INSTALL: always: Updating remote configuration file
2023-01-23 13:55:32 - INSTALL: always: No tables where found or selected for conversion
2023-01-23 13:55:32 - INSTALL: always: Starting INSTALL Process for v1.2.23
2023-01-23 13:55:31 - INSTALL: always: Setting PHP Option memory_limit = -1
2023-01-23 13:55:31 - INSTALL: always: Setting PHP Option max_execution_time = 0
2023-01-23 13:55:31 - INSTALL: Checking arguments
2023-01-23 13:55:31 - INSTALL: always: Spawning background process: /usr/bin/php '/opt/cacti/install/background.php' 1674469531.4381
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
I don't why it generates "No tables where found or selected for conversion".
Please help me to install RDC(Remote Data Collector)

[phalek]

What exactly did you do here, which variables did you change ?

2. change variables of database.

[mpahlevanzadeh]

It means:
$rdatabase_type = 'mysql';
$rdatabase_default = 'cacti';
$rdatabase_hostname = '172.16.5.35';
$rdatabase_username = 'cacti';
$rdatabase_password = 'P@ssw0rd';
$rdatabase_port = '3306';
$rdatabase_retries = 5;
$rdatabase_ssl = false;
$rdatabase_ssl_key = '';
$rdatabase_ssl_cert = '';
$rdatabase_ssl_ca = '';

[phalek]

Ok, I guess the hostname there is the main server.

Did you also enter/configure the normal "$database_hostname = 'localhost';" part ?

[mpahlevanzadeh]

I have the following variables in RDC:
$database_type = 'mysql';
$database_default = 'cacti';
$database_hostname = 'localhost';
$database_username = 'cacti';
$database_password = 'pppp';
$database_port = '3306';
$database_retries = 5;
$database_ssl = false;
$database_ssl_key = '';
$database_ssl_cert = '';
$database_ssl_ca = '';
$database_persist = false;

[phalek]

Ok, so config looks good.

Can you actually login to the Remote Data Collector or is the installation in a loop ?

[mpahlevanzadeh]

Connection Test is okey.

[mpahlevanzadeh]

When I get tcpdump in Main collector , I see a set of queries.

[mpahlevanzadeh]

Unfortunately I have problem.

[TheWitness]

You may just want to use the CLI script. If there are no plugins, and it's a fresh table, there should be no tables to convert.

[mpahlevanzadeh]

I don't know syncing RDC with Main Collectors which data transfer between them.

[mpahlevanzadeh]

You may just want to use the CLI script. If there are no plugins, and it's a fresh table, there should be no tables to convert.

I have Thold.

[TheWitness]

Well, if it's entirely new system thing should stay reasonably in sync, but doing a full sync one and a while will help if there have been extended disconnects.