Database Tables conversion process occurs on *every* upgrade?

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
User avatar
Jeeves
Cacti User
Posts: 91
Joined: Wed Jun 12, 2013 6:25 pm

Database Tables conversion process occurs on *every* upgrade?

Post by Jeeves »

Every upgrade, the "tables conversion" process has all the same tables selected, which says to me nothing has been done to them.
If it converts a table to UTF8 & InnoDB during .20, it shouldn't have to do the same for .21.

This occurs on multiple servers of mine, attached are an image from two of them at both the .20 and .21 upgrades.

During the .20 upgrade:
cacti-upgrade.png
cacti-upgrade.png (22.42 KiB) Viewed 1236 times


Another during the .21 upgrade:
cacti-upgrade-everytime.png
cacti-upgrade-everytime.png (42.25 KiB) Viewed 1236 times
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Database Tables conversion process occurs on *every* upgrade?

Post by TheWitness »

You must have something that's changing the charset of your tables. We are using utf8mb4 for internationalization. Takes more data, but works just fine.
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?
User avatar
Jeeves
Cacti User
Posts: 91
Joined: Wed Jun 12, 2013 6:25 pm

Re: Database Tables conversion process occurs on *every* upgrade?

Post by Jeeves »

TheWitness wrote: Fri May 27, 2022 12:19 pm You must have something that's changing the charset of your tables. We are using utf8mb4 for internationalization. Takes more data, but works just fine.
I have this issue on multiple servers, the only thing those servers do is Cacti.

I'm all ears, but as far as I know the only thing that touches the cactidb IS Cacti. I know for a fact that nothing else has credentials to the db.
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Database Tables conversion process occurs on *every* upgrade?

Post by TheWitness »

Make sure that the following is what is in your server.cnf file as well as verifying it's not in the client.cnf file if you have one.

Code: Select all

[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
Once that's done, you should force the migration from the command line:

Code: Select all

php -q convert_tables.php --help
Cacti Database Conversion Utility, Version 1.2.21 (DB: 1.2.21), Copyright (C) 2004-2022 The Cacti Group

usage: convert_tables.php [--debug] [--innodb] [--utf8] [--table=N] [--size=N] [--rebuild] [--dynamic]

A utility to convert a Cacti Database from MyISAM to the InnoDB table format.
MEMORY tables are not converted to InnoDB in this process.

Required (one or more):
-i | --innodb  - Convert any MyISAM tables to InnoDB
-u | --utf8    - Convert any non-UTF8 tables to utf8mb4_unicode_ci

Optional:
-t | --table=S - The name of a single table to change
-n | --skip-innodb="table1 table2 ..." - Skip converting tables to InnoDB
-s | --size=N  - The largest table size in records to convert.  Default is 1,000,000 rows.
-r | --rebuild - Will compress/optimize existing InnoDB tables if found
     --dynamic - Convert a table to Dynamic row format if available
     --local   - Perform the action on the Remote Data Collector if run from there
-f | --force   - Proceed with conversion regardless of table size

-d | --debug   - Display verbose output during execution
You might have to increase the --size or other settings to make it work.
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?
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Database Tables conversion process occurs on *every* upgrade?

Post by TheWitness »

Once that is done, you can verify the changes from the Configuration > Settings > Technical Support > Database Tables page.
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?
User avatar
Jeeves
Cacti User
Posts: 91
Joined: Wed Jun 12, 2013 6:25 pm

Re: Database Tables conversion process occurs on *every* upgrade?

Post by Jeeves »

TheWitness wrote: Sun Jun 05, 2022 9:42 am Once that is done, you can verify the changes from the Configuration > Settings > Technical Support > Database Tables page.
"Technical Support" is under "System Utilities", but yes. I found it.

I think I found the problem as well. Largely my own stupidity, but I'll explain.

I moved most critical cacti components to another path outside the main cacti path I then symlinked them. my RRA, Scripts, Config, etc. are all symlinked.
In this way I could nuke a path, and as long as I setup my symlinks were created, Cacti worked. I don't recall when I did this, but an update broke everything and I did this to save myself future headaches, it's been a long time.

Well, when updating cacti; I untar/gz in tmp, them delete config.php, then do: yes | cp -R * /../../cactipath/cacti

Apparently when doing so, the new files are not copied into the symlinked paths. This detail I was unaware of but discovered when convert_tables.php was missing.

So, it looks like maybe a check for the cacti setup could be useful? The php script it tried to run was missing for years.

Now I need to go re-evaluate my sanity and the cp command.

Thanks!
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Database Tables conversion process occurs on *every* upgrade?

Post by TheWitness »

In my setups, or at least my home lab setup, I have the RRA directory symlinked to a CEPH volume. So, upgrading involves something like:

Code: Select all

cd /var/www/html
tar --exclude="*.gz" --exclude='rra' --exclude='log' --exclude='cache' -zcf backups/cacti_backup.$$.tgz
git clone -b 1.2.x https://github.com/cacti/cacti.git cacti-new
cp -rp cacti-net cacti
chown -R apache:apache cacti
rm -rf cacti-new
Double check by tar exclude syntax, but it's about right anyway. After that, I just hit the refresh button on the browser and follow the prompts.
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?
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Database Tables conversion process occurs on *every* upgrade?

Post by TheWitness »

Of course, going to the 1.2.x branch can be dangerous even though I try hard not to break it. Going to releases is better.
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?
User avatar
Jeeves
Cacti User
Posts: 91
Joined: Wed Jun 12, 2013 6:25 pm

Re: Database Tables conversion process occurs on *every* upgrade?

Post by Jeeves »

TheWitness wrote: Wed Jun 08, 2022 7:43 am In my setups, or at least my home lab setup, I have the RRA directory symlinked to a CEPH volume. So, upgrading involves something like:

Code: Select all

cd /var/www/html
tar --exclude="*.gz" --exclude='rra' --exclude='log' --exclude='cache' -zcf backups/cacti_backup.$$.tgz
git clone -b 1.2.x https://github.com/cacti/cacti.git cacti-new
cp -rp cacti-net cacti
chown -R apache:apache cacti
rm -rf cacti-new
Double check by tar exclude syntax, but it's about right anyway. After that, I just hit the refresh button on the browser and follow the prompts.
That's not far off from how I set mine up, I appreciate the insight into your methods.
Personally; I only run releases. I need things working rather than being up to the minute updated ;)
And as always, thanks for the support.
netniV
Cacti Guru User
Posts: 3441
Joined: Sun Aug 27, 2017 12:05 am

Re: Database Tables conversion process occurs on *every* upgrade?

Post by netniV »

Honestly, I never mess around with cp. I just use git clone and then checkout to the tagged release you want.
Cacti Developer & Release Manager
The Cacti Group

Director
BV IT Solutions Ltd

+--------------------------------------------------------------------------+

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
User avatar
Jeeves
Cacti User
Posts: 91
Joined: Wed Jun 12, 2013 6:25 pm

Re: Database Tables conversion process occurs on *every* upgrade?

Post by Jeeves »

netniV wrote: Fri Jun 10, 2022 7:55 pm Honestly, I never mess around with cp. I just use git clone and then checkout to the tagged release you want.
I don't use git on a day to day basis, so I tend to lean away from it's use.
netniV
Cacti Guru User
Posts: 3441
Joined: Sun Aug 27, 2017 12:05 am

Re: Database Tables conversion process occurs on *every* upgrade?

Post by netniV »

I’ve heard that argument a lot from people but it’s as simple as

Code: Select all

git checkout release/1.2.21
Cacti Developer & Release Manager
The Cacti Group

Director
BV IT Solutions Ltd

+--------------------------------------------------------------------------+

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
User avatar
Jeeves
Cacti User
Posts: 91
Joined: Wed Jun 12, 2013 6:25 pm

Re: Database Tables conversion process occurs on *every* upgrade?

Post by Jeeves »

netniV wrote: Sat Jun 11, 2022 1:19 pm I’ve heard that argument a lot from people but it’s as simple as

Code: Select all

git checkout release/1.2.21
I wasn't saying it was difficult, simply that if I'm more familiar with one tool than another, it's clear which will get favored.
netniV
Cacti Guru User
Posts: 3441
Joined: Sun Aug 27, 2017 12:05 am

Re: Database Tables conversion process occurs on *every* upgrade?

Post by netniV »

Yaeh appreciate that, the other benefit of using the git method, you can see if someone messes with your files too :D
Cacti Developer & Release Manager
The Cacti Group

Director
BV IT Solutions Ltd

+--------------------------------------------------------------------------+

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests