search

Cacti / cacti

Cacti ™
http://www.cacti.net
GNU General Public License v2.0
1.65k stars 406 forks source link

Update Cacti 0.8.8 to 1.2.18 #4402

Closed Asterix785 closed 3 years ago

Asterix785 commented 3 years ago

Hello, I followed the documentation on the cacti website to update from version 0.8.8h to 1.2.18. https://docs.cacti.net/Upgrading-Cacti-Under-Windows.md But I can't seem to resolve an error when the update is completed. After pasting the contents of the zip, change the credentials in cacti/include/config.

  1. I go to localhost/cacti/install/install.php
  2. I identify myself
  3. I accept the terms of the GPL license and click on "begin".
  4. In the Pre-installation Checks everything is green except the gettext module is yellow. I click on "next".
  5. I click on "Next" a second time
  6. The Permissions to the folders are green. I click on "Next".
  7. I check all the templates and click on "next".
  8. I check "Confirm Upgrade" and click on "Upgrade".

And this is the error I encounter during the installation : https://we.tl/t-Nt5yOPknNu The link contains my cacti log file : https://we.tl/t-FA2HraDVTA

Thank you for your help.

Desktop

netniV commented 3 years ago

So your actual error appears to be:

2021-09-16 20:10:44 - CMDPHP ERROR: A DB Exec Failed!, Error: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
2021-09-16 20:10:44 - CMDPHP SQL Backtrace:  (C:\Apache24\htdocs\cacti\cli\convert_tables.php[194]:db_execute(), C:\Apache24\htdocs\cacti\lib\database.php[238]:db_execute_prepared())
2021-09-16 20:10:44 - CONVERT FATAL: Conversion of Table 'reportit_cache_reports' Failed.  Command: 'ALTER TABLE `reportit_cache_reports`  CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, ENGINE=Innodb'

So, it would appear that your problems have revolved around plugins, as the above is for reportit, and there were also pre-upgrade errors that you are also having with weathermaps that you had installed.

Asterix785 commented 3 years ago

This morning I notice that cacti has been upgraded. I have access to the console but I have no graph. Only the history. I changed the password in spine.conf. The snmp is working but I notice two errors in the log file. 1- 2021-09-17 10:40:01 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler()) 2021-09-17 10:40:01 - PHP ERROR: Maximum execution time of 299 seconds exceeded in file: C:\Apache24\htdocs\cacti\poller.php on line: 710 2- 2021-09-17 10:25:01 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler()) 2021-09-17 10:25:01 - PHP ERROR: Maximum execution time of 299 seconds exceeded in file: C:\Apache24\htdocs\cacti\lib\poller.php on line: 132

I specify that the CACTI task, which executes C:\PHP\pho.exe with the argument C:\Apache24htdocs\cacti\poller.php is running.

The data collection is on and I've added my community in the parameters. Do you have an idea?

Asterix785 commented 3 years ago

I deleted and redid some graphs, here is the error: "Unable to open data file, poller may not have been executed yet: XXX.rrd (RRAfolder:4)". I'm trying to find the cause at the same time on the forums.

netniV commented 3 years ago

So, another issue you are having is that things are taking too longer to poll. Likely you have a number of timeouts which are too large (and possibly too many retries). T R = secs and if those secs devices > polling time, then you've got timeouts.

TheWitness commented 3 years ago

This looks to be more of a support issue. Let's here what comes back in the next few days, and if nothing substantial, let's close this one.