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

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
mpahlevanzadeh
Cacti User
Posts: 50
Joined: Wed Jan 04, 2023 6:52 am
Contact:

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

Post by 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)
Attachments
Screenshot from 2023-01-23 18-00-54.png
Screenshot from 2023-01-23 18-00-54.png (341.77 KiB) Viewed 610 times
User avatar
phalek
Developer
Posts: 2838
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

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

Post by phalek »

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

2. change variables of database.
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusReporting
mpahlevanzadeh
Cacti User
Posts: 50
Joined: Wed Jan 04, 2023 6:52 am
Contact:

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

Post by 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 = '';
User avatar
phalek
Developer
Posts: 2838
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

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

Post by phalek »

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

Did you also enter/configure the normal "$database_hostname = 'localhost';" part ?
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusReporting
mpahlevanzadeh
Cacti User
Posts: 50
Joined: Wed Jan 04, 2023 6:52 am
Contact:

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

Post by 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;
User avatar
phalek
Developer
Posts: 2838
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

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

Post by phalek »

Ok, so config looks good.

Can you actually login to the Remote Data Collector or is the installation in a loop ?
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusReporting
mpahlevanzadeh
Cacti User
Posts: 50
Joined: Wed Jan 04, 2023 6:52 am
Contact:

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

Post by mpahlevanzadeh »

Connection Test is okey.
mpahlevanzadeh
Cacti User
Posts: 50
Joined: Wed Jan 04, 2023 6:52 am
Contact:

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

Post by mpahlevanzadeh »

When I get tcpdump in Main collector , I see a set of queries.
mpahlevanzadeh
Cacti User
Posts: 50
Joined: Wed Jan 04, 2023 6:52 am
Contact:

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

Post by mpahlevanzadeh »

Unfortunately I have problem.
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

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

Post by 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.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
mpahlevanzadeh
Cacti User
Posts: 50
Joined: Wed Jan 04, 2023 6:52 am
Contact:

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

Post by mpahlevanzadeh »

I don't know syncing RDC with Main Collectors which data transfer between them.
mpahlevanzadeh
Cacti User
Posts: 50
Joined: Wed Jan 04, 2023 6:52 am
Contact:

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

Post by mpahlevanzadeh »

TheWitness wrote: Mon Jan 23, 2023 8:07 pm 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.
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

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

Post by 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.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests