loop of reinstallation

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

Moderators: Developers, Moderators

Post Reply
ataha
Posts: 28
Joined: Mon Dec 04, 2023 8:48 am

loop of reinstallation

Post by ataha »

i have cacti Version 0.8.8a need to upgrade to the latest version but I found loop of reinstallation
i try to run php -q upgrade-database 1.2.27 but still same problem
Top
User avatar
macan
Cacti Guru User
Posts: 1137
Joined: Tue Mar 18, 2008 2:30 am
Location: Czech

Re: loop of reinstallation

Post by macan »

in /path/to/cacti/log you have few logs, please show
install-complete.log
install-general.log
Let the Cacti grow!
Top
ataha
Posts: 28
Joined: Mon Dec 04, 2023 8:48 am

Re: loop of reinstallation

Post by ataha »

getDefaultTemplate(): Default Device Template is '3'
[2024-05-20 12:38:01] [ template always ] setDefaultTemplate(): Device default template is '3'
[2024-05-20 12:38:01] [ global always ] Spawning background process: /usr/bin/php '/var/www/html/cacti/install/background.php' 1716197881.6735
[2024-05-20 12:38:01] [ global always ] Setting PHP Option max_execution_time = 0
[2024-05-20 12:38:01] [ global always ] Setting PHP Option memory_limit = -1
[2024-05-20 12:38:01] [ templates always ] getDefaultTemplate(): Default Device Template is '3'
[2024-05-20 12:38:01] [ templates always ] getDefaultTemplate(): Default Device Template is '3'
[2024-05-20 12:38:01] [ template always ] setDefaultTemplate(): Device default template is '3'
[2024-05-20 12:38:02] [ global always ] Starting UPGRADE Process for v1.2.27
[2024-05-20 12:38:02] [ global always ] Found 1 tables to convert
[2024-05-20 12:38:02] [ global always ] Converting Table #1 'reportit_cache_reports'
[2024-05-20 12:38:02] [ global always ] Switched from to /tmp/cduPkMgw4
[2024-05-20 12:38:02] [ global always ] NOTE: Using temporary file for db cache: /tmp/cduPkMgw4
[2024-05-20 12:38:02] [ global always ] Upgrading from v1.0.4 (DB 1.2.27 (DB: 1.0.4)) to v1.0.5
[2024-05-20 12:38:02] [ global always ] Finished UPGRADE Process for v1.2.27
[2024-05-20 12:38:02] [ global always ] WARNING: One or more upgrades failed to install correctly
[2024-05-20 12:38:02] [ global always ] Installation was started at 2024-05-20 09:38:01, completed at 2024-05-20 09:38:02
[2024-05-20 13:27:08] [ templates always ] getDefaultTemplate(): Default Device Template is '3'

'
[2024-05-20 13:27:47] [ template always ] setDefaultTemplate(): Device default template is '3'
[2024-05-20 13:27:47] [ global always ] Spawning background process: /usr/bin/php '/var/www/html/cacti/install/background.php' 1716200867.4835
[2024-05-20 13:27:47] [ global always ] Setting PHP Option max_execution_time = 0
[2024-05-20 13:27:47] [ global always ] Setting PHP Option memory_limit = -1
[2024-05-20 13:27:47] [ templates always ] getDefaultTemplate(): Default Device Template is '3'
[2024-05-20 13:27:47] [ templates always ] getDefaultTemplate(): Default Device Template is '3'
[2024-05-20 13:27:47] [ template always ] setDefaultTemplate(): Device default template is '3'
[2024-05-20 13:27:47] [ global always ] Starting UPGRADE Process for v1.2.27
[2024-05-20 13:27:48] [ global always ] Found 1 tables to convert
[2024-05-20 13:27:48] [ global always ] Converting Table #1 'reportit_cache_reports'
[2024-05-20 13:27:48] [ global always ] Switched from to /tmp/cdu2akirw
[2024-05-20 13:27:48] [ global always ] NOTE: Using temporary file for db cache: /tmp/cdu2akirw
[2024-05-20 13:27:48] [ global always ] Upgrading from v1.0.4 (DB 1.2.27 (DB: 1.0.4)) to v1.0.5
[2024-05-20 13:27:48] [ global always ] Finished UPGRADE Process for v1.2.27
[2024-05-20 13:27:48] [ global always ] WARNING: One or more upgrades failed to install correctly
[2024-05-20 13:27:48] [ global always ] Installation was started at 2024-05-20 10:27:47, completed at 2024-05-20 10:27:48
[2024-05-20 13:55:21] [ templates always ] getDefaultTemplate(): Default Device Template is '3'
[
[2024-05-20 14:02:18] [ template always ] setDefaultTemplate(): Device default template is '3'
root@RHPRLCACTI02:/var/www/html/cacti/log# tail -F install-complete.log
[2024-05-20 13:27:48] [ global always ] Upgrading from v1.0.4 (DB 1.2.27 (DB: 1.0.4)) to v1.0.5
[2024-05-20 13:27:48] [ global always ] Finished UPGRADE Process for v1.2.27
[2024-05-20 13:27:48] [ global always ] WARNING: One or more upgrades failed to install correctly
[2024-05-20 13:27:48] [ global always ] Installation was started at 2024-05-20 10:27:47, completed at 2024-05-20 10:27:48
[2024-05-20 13:55:21] [ templates always ] getDefaultTemplate(): Default Device Template is '3'

[2024-05-20 14:02:18] [ template always ] setDefaultTemplate(): Device default template is '3'


[2024-05-20 16:32:34] [ templates always ] getDefaultTemplate(): Default Device Template is '3'

[2024-05-20 16:32:51] [ template always ] setDefaultTemplate(): Device default template is '3'
[2024-05-20 16:32:52] [ global always ] Spawning background process: /usr/bin/php '/var/www/html/cacti/install/background.php' 1716211972.166
[2024-05-20 16:32:52] [ global always ] Setting PHP Option max_execution_time = 0
[2024-05-20 16:32:52] [ global always ] Setting PHP Option memory_limit = -1
[2024-05-20 16:32:52] [ templates always ] getDefaultTemplate(): Default Device Template is '3'
[2024-05-20 16:32:52] [ templates always ] getDefaultTemplate(): Default Device Template is '3'
[2024-05-20 16:32:52] [ template always ] setDefaultTemplate(): Device default template is '3'
[2024-05-20 16:32:52] [ global always ] Starting UPGRADE Process for v1.2.27
[2024-05-20 16:32:52] [ global always ] Found 1 tables to convert
[2024-05-20 16:32:52] [ global always ] Converting Table #1 'reportit_cache_reports'
[2024-05-20 16:32:52] [ global always ] Switched from to /tmp/cduLhtWIk
[2024-05-20 16:32:52] [ global always ] NOTE: Using temporary file for db cache: /tmp/cduLhtWIk
[2024-05-20 16:32:52] [ global always ] Upgrading from v1.0.4 (DB 1.2.27 (DB: 1.0.4)) to v1.0.5
[2024-05-20 16:32:52] [ global always ] Finished UPGRADE Process for v1.2.27
[2024-05-20 16:32:52] [ global always ] WARNING: One or more upgrades failed to install correctly
[2024-05-20 16:32:52] [ global always ] Installation was started at 2024-05-20 13:32:52, completed at 2024-05-20 13:32:52
Top
ataha
Posts: 28
Joined: Mon Dec 04, 2023 8:48 am

Re: loop of reinstallation

Post by ataha »

[2024-05-20 09:50:20] [ always ] Installation was started at 2024-05-20 06:50:19, completed at 2024-05-20 06:50:20
[2024-05-20 10:05:41] [ always ] Spawning background process: /usr/bin/php '/var/www/html/cacti/install/background.php' 1716188741.8967
[2024-05-20 10:05:41] [ always ] Setting PHP Option max_execution_time = 0
[2024-05-20 10:05:41] [ always ] Setting PHP Option memory_limit = -1
[2024-05-20 10:05:42] [ always ] Starting UPGRADE Process for v1.2.27
[2024-05-20 10:05:42] [ always ] Found 1 tables to convert
[2024-05-20 10:05:42] [ always ] Converting Table #1 'reportit_cache_reports'
[2024-05-20 10:05:42] [ always ] Switched from to /tmp/cdudQfQvo
[2024-05-20 10:05:42] [ always ] NOTE: Using temporary file for db cache: /tmp/cdudQfQvo
[2024-05-20 10:05:42] [ always ] Upgrading from v1.0.4 (DB 1.2.27 (DB: 1.0.4)) to v1.0.5
[2024-05-20 10:05:42] [ always ] Finished UPGRADE Process for v1.2.27
[2024-05-20 10:05:42] [ always ] WARNING: One or more upgrades failed to install correctly
[2024-05-20 10:05:42] [ always ] Installation was started at 2024-05-20 07:05:41, completed at 2024-05-20 07:05:42
[2024-05-20 12:38:01] [ always ] Spawning background process: /usr/bin/php '/var/www/html/cacti/install/background.php' 1716197881.6735
[2024-05-20 12:38:01] [ always ] Setting PHP Option max_execution_time = 0
[2024-05-20 12:38:01] [ always ] Setting PHP Option memory_limit = -1
[2024-05-20 12:38:02] [ always ] Starting UPGRADE Process for v1.2.27
[2024-05-20 12:38:02] [ always ] Found 1 tables to convert
[2024-05-20 12:38:02] [ always ] Converting Table #1 'reportit_cache_reports'
[2024-05-20 12:38:02] [ always ] Switched from to /tmp/cduPkMgw4
[2024-05-20 12:38:02] [ always ] NOTE: Using temporary file for db cache: /tmp/cduPkMgw4
[2024-05-20 12:38:02] [ always ] Upgrading from v1.0.4 (DB 1.2.27 (DB: 1.0.4)) to v1.0.5
[2024-05-20 12:38:02] [ always ] Finished UPGRADE Process for v1.2.27
[2024-05-20 12:38:02] [ always ] WARNING: One or more upgrades failed to install correctly
[2024-05-20 12:38:02] [ always ] Installation was started at 2024-05-20 09:38:01, completed at 2024-05-20 09:38:02
[2024-05-20 13:27:47] [ always ] Spawning background process: /usr/bin/php '/var/www/html/cacti/install/background.php' 1716200867.4835
[2024-05-20 13:27:47] [ always ] Setting PHP Option max_execution_time = 0
[2024-05-20 13:27:47] [ always ] Setting PHP Option memory_limit = -1
[2024-05-20 13:27:47] [ always ] Starting UPGRADE Process for v1.2.27
[2024-05-20 13:27:48] [ always ] Found 1 tables to convert
[2024-05-20 13:27:48] [ always ] Converting Table #1 'reportit_cache_reports'
[2024-05-20 13:27:48] [ always ] Switched from to /tmp/cdu2akirw
[2024-05-20 13:27:48] [ always ] NOTE: Using temporary file for db cache: /tmp/cdu2akirw
[2024-05-20 13:27:48] [ always ] Upgrading from v1.0.4 (DB 1.2.27 (DB: 1.0.4)) to v1.0.5
[2024-05-20 13:27:48] [ always ] Finished UPGRADE Process for v1.2.27
[2024-05-20 13:27:48] [ always ] WARNING: One or more upgrades failed to install correctly
[2024-05-20 13:27:48] [ always ] Installation was started at 2024-05-20 10:27:47, completed at 2024-05-20 10:27:48
[2024-05-20 16:32:52] [ always ] Spawning background process: /usr/bin/php '/var/www/html/cacti/install/background.php' 1716211972.166
[2024-05-20 16:32:52] [ always ] Setting PHP Option max_execution_time = 0
[2024-05-20 16:32:52] [ always ] Setting PHP Option memory_limit = -1
[2024-05-20 16:32:52] [ always ] Starting UPGRADE Process for v1.2.27
[2024-05-20 16:32:52] [ always ] Found 1 tables to convert
[2024-05-20 16:32:52] [ always ] Converting Table #1 'reportit_cache_reports'
[2024-05-20 16:32:52] [ always ] Switched from to /tmp/cduLhtWIk
[2024-05-20 16:32:52] [ always ] NOTE: Using temporary file for db cache: /tmp/cduLhtWIk
[2024-05-20 16:32:52] [ always ] Upgrading from v1.0.4 (DB 1.2.27 (DB: 1.0.4)) to v1.0.5
[2024-05-20 16:32:52] [ always ] Finished UPGRADE Process for v1.2.27
[2024-05-20 16:32:52] [ always ] WARNING: One or more upgrades failed to install correctly
[2024-05-20 16:32:52] [ always ] Installation was started at 2024-05-20 13:32:52, completed at 2024-05-20 13:32:52
Top
ataha
Posts: 28
Joined: Mon Dec 04, 2023 8:48 am

Re: loop of reinstallation

Post by ataha »

the system enters the reinstall LOOP after upgrade to 1.0.4 from oldest version .8

(NOTE: This process will guide you through the steps for upgrading from version '1.0.4'.)
Top
ataha
Posts: 28
Joined: Mon Dec 04, 2023 8:48 am

Re: loop of reinstallation

Post by ataha »

is there any help
Top
User avatar
macan
Cacti Guru User
Posts: 1137
Joined: Tue Mar 18, 2008 2:30 am
Location: Czech

Re: loop of reinstallation

Post by macan »

show result of SQL query:
show create table poller_output_boost;
Let the Cacti grow!
Top
ataha
Posts: 28
Joined: Mon Dec 04, 2023 8:48 am

Re: loop of reinstallation

Post by ataha »

MariaDB [cacti]> create table poller_output_boost;
ERROR 1050 (42S01): Table 'poller_output_boost' already exists
Top
User avatar
macan
Cacti Guru User
Posts: 1137
Joined: Tue Mar 18, 2008 2:30 am
Location: Czech

Re: loop of reinstallation

Post by macan »

The command is "show create table poller_output_boost;"
Let the Cacti grow!
Top
ataha
Posts: 28
Joined: Mon Dec 04, 2023 8:48 am

Re: loop of reinstallation

Post by ataha »

MariaDB [cacti]> show create table poller_output_boost;
+---------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+---------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| poller_output_boost | CREATE TABLE `poller_output_boost` (
`local_data_id` mediumint(8) unsigned NOT NULL DEFAULT 0,
`rrd_name` varchar(19) NOT NULL DEFAULT '',
`time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`output` varchar(512) NOT NULL,
PRIMARY KEY (`local_data_id`,`rrd_name`,`time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC |
+---------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.001 sec)

MariaDB [cacti]>
Top
ataha
Posts: 28
Joined: Mon Dec 04, 2023 8:48 am

Re: loop of reinstallation

Post by ataha »

my issue is: the system upgrade from .8 to 1.04 but cannot move and finish the upgrade to 1.2.7
Top
ataha
Posts: 28
Joined: Mon Dec 04, 2023 8:48 am

Re: loop of reinstallation

Post by ataha »

root@RHPRLCACTI02:/home/cactiprd01a# tail -n 200 /var/www/html/cacti/log/cacti.log


2024-05-26 17:01:06 - AUTH LOGIN FAILED: Local Login Failed for user 'a.taha' from IP Address '172.16.3.156'.
2024-05-26 17:01:12 - AUTH LOGIN FAILED: Local Login Failed for user 'admin' from IP Address '172.16.3.156'.
2024-05-26 17:01:43 - AUTH LOGIN: User 'a.taha' authenticated
2024-05-26 17:01:45 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is ''
2024-05-26 17:01:45 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Changing Device Template to 'Net-SNMP Device'
2024-05-26 17:01:45 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:01:45 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:01:45 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
2024-05-26 17:02:05 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:02:05 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:02:05 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
2024-05-26 17:02:09 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:02:09 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:02:09 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
2024-05-26 17:14:49 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:14:49 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:14:49 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
2024-05-26 17:14:53 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:14:53 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:14:53 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
2024-05-26 17:14:55 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:14:55 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:14:55 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
2024-05-26 17:14:57 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:14:57 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:14:57 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
2024-05-26 17:15:01 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:15:01 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:15:01 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
2024-05-26 17:15:05 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:15:05 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:15:05 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
2024-05-26 17:15:05 - INSTALL: always: Spawning background process: /usr/bin/php '/var/www/html/cacti/install/background.php' 1716732905.7659
2024-05-26 17:15:05 - INSTALL: Checking arguments
2024-05-26 17:15:05 - INSTALL: always: Setting PHP Option max_execution_time = 0
2024-05-26 17:15:05 - INSTALL: always: Setting PHP Option memory_limit = -1
2024-05-26 17:15:05 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:15:05 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:15:05 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
2024-05-26 17:15:06 - INSTALL: always: Starting UPGRADE Process for v1.2.27
2024-05-26 17:15:06 - INSTALL: always: Found 72 tables to convert
2024-05-26 17:15:06 - INSTALL: always: Converting Table #1 'colors'
2024-05-26 17:15:06 - INSTALL: always: Converting Table #2 'data_input'
2024-05-26 17:15:06 - INSTALL: always: Converting Table #3 'cdef'
2024-05-26 17:15:06 - INSTALL: always: Converting Table #4 'cdef_items'
2024-05-26 17:15:06 - INSTALL: always: Converting Table #5 'data_input_data'
2024-05-26 17:15:06 - INSTALL: always: Converting Table #6 'data_input_fields'
2024-05-26 17:15:06 - INSTALL: always: Converting Table #7 'data_local'
2024-05-26 17:15:07 - INSTALL: always: Converting Table #8 'data_template'
2024-05-26 17:15:07 - INSTALL: always: Converting Table #9 'data_template_data'
2024-05-26 17:15:07 - INSTALL: always: Converting Table #10 'data_template_data_rra'
2024-05-26 17:15:07 - INSTALL: always: Converting Table #11 'data_template_rrd'
2024-05-26 17:15:07 - INSTALL: always: Converting Table #12 'graph_local'
2024-05-26 17:15:07 - INSTALL: always: Converting Table #13 'graph_template_input'
2024-05-26 17:15:08 - INSTALL: always: Converting Table #14 'graph_template_input_defs'
2024-05-26 17:15:08 - INSTALL: always: Converting Table #15 'graph_templates'
2024-05-26 17:15:08 - INSTALL: always: Converting Table #16 'graph_templates_gprint'
2024-05-26 17:15:08 - INSTALL: always: Converting Table #17 'graph_templates_graph'
2024-05-26 17:15:08 - INSTALL: always: Converting Table #18 'graph_templates_item'
2024-05-26 17:15:08 - INSTALL: always: Converting Table #19 'graph_tree'
2024-05-26 17:15:09 - INSTALL: always: Converting Table #20 'graph_tree_items'
2024-05-26 17:15:09 - INSTALL: always: Converting Table #21 'host'
2024-05-26 17:15:09 - INSTALL: always: Converting Table #22 'host_graph'
2024-05-26 17:15:09 - INSTALL: always: Converting Table #23 'host_snmp_cache'
2024-05-26 17:15:17 - INSTALL: always: Converting Table #24 'host_snmp_query'
2024-05-26 17:15:17 - INSTALL: always: Converting Table #25 'host_template'
2024-05-26 17:15:18 - INSTALL: always: Converting Table #26 'host_template_graph'
2024-05-26 17:15:18 - INSTALL: always: Converting Table #27 'host_template_snmp_query'
2024-05-26 17:15:18 - INSTALL: always: Converting Table #28 'plugin_aggregate_color_template_items'
2024-05-26 17:15:18 - INSTALL: always: Converting Table #29 'plugin_aggregate_color_templates'
2024-05-26 17:15:18 - INSTALL: always: Converting Table #30 'plugin_config'
2024-05-26 17:15:18 - INSTALL: always: Converting Table #31 'plugin_db_changes'
2024-05-26 17:15:18 - INSTALL: always: Converting Table #32 'plugin_hooks'
2024-05-26 17:15:18 - INSTALL: always: Converting Table #33 'plugin_realms'
2024-05-26 17:15:18 - INSTALL: always: Converting Table #34 'poller'
2024-05-26 17:15:18 - INSTALL: always: Converting Table #35 'poller_command'
2024-05-26 17:15:19 - INSTALL: always: Converting Table #36 'poller_item'
2024-05-26 17:15:19 - INSTALL: always: Converting Table #37 'poller_output'
2024-05-26 17:15:19 - INSTALL: always: Converting Table #38 'poller_output_rt'
2024-05-26 17:15:19 - INSTALL: always: Converting Table #39 'poller_reindex'
2024-05-26 17:15:19 - INSTALL: always: Converting Table #40 'poller_time'
2024-05-26 17:15:19 - INSTALL: always: Converting Table #41 'reportit_cache_measurands'
2024-05-26 17:15:19 - INSTALL: always: Converting Table #42 'reportit_cache_reports'
2024-05-26 17:15:19 - 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
2024-05-26 17:15:19 - CMDPHP SQL Backtrace: (/cli/convert_tables.php[222]:db_execute(), /lib/database.php[385]:db_execute_prepared())
2024-05-26 17:15:19 - 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'
2024-05-26 17:15:19 - INSTALL: always: Converting Table #43 'reportit_cache_variables'
2024-05-26 17:15:20 - INSTALL: always: Converting Table #44 'reportit_data_items'
2024-05-26 17:15:20 - INSTALL: always: Converting Table #45 'reportit_data_source_items'
2024-05-26 17:15:20 - INSTALL: always: Converting Table #46 'reportit_measurands'
2024-05-26 17:15:20 - INSTALL: always: Converting Table #47 'reportit_presets'
2024-05-26 17:15:20 - INSTALL: always: Converting Table #48 'reportit_recipients'
2024-05-26 17:15:20 - INSTALL: always: Converting Table #49 'reportit_reports'
2024-05-26 17:15:20 - INSTALL: always: Converting Table #50 'reportit_rvars'
2024-05-26 17:15:20 - INSTALL: always: Converting Table #51 'reportit_templates'
2024-05-26 17:15:20 - INSTALL: always: Converting Table #52 'reportit_variables'
2024-05-26 17:15:21 - INSTALL: always: Converting Table #53 'rra'
2024-05-26 17:15:21 - INSTALL: always: Converting Table #54 'rra_cf'
2024-05-26 17:15:21 - INSTALL: always: Converting Table #55 'settings'
2024-05-26 17:15:21 - INSTALL: always: Converting Table #56 'settings_graphs'
2024-05-26 17:15:21 - INSTALL: always: Converting Table #57 'settings_tree'
2024-05-26 17:15:21 - INSTALL: always: Converting Table #58 'snmp_query'
2024-05-26 17:15:21 - INSTALL: always: Converting Table #59 'snmp_query_graph'
2024-05-26 17:15:21 - INSTALL: always: Converting Table #60 'snmp_query_graph_rrd'
2024-05-26 17:15:21 - INSTALL: always: Converting Table #61 'snmp_query_graph_rrd_sv'
2024-05-26 17:15:22 - INSTALL: always: Converting Table #62 'snmp_query_graph_sv'
2024-05-26 17:15:22 - INSTALL: always: Converting Table #63 'user_auth'
2024-05-26 17:15:22 - INSTALL: always: Converting Table #64 'user_auth_perms'
2024-05-26 17:15:22 - INSTALL: always: Converting Table #65 'user_auth_realm'
2024-05-26 17:15:22 - INSTALL: always: Converting Table #66 'user_log'
2024-05-26 17:15:22 - INSTALL: always: Converting Table #67 'version'
2024-05-26 17:15:22 - INSTALL: always: Converting Table #68 'weathermap_auth'
2024-05-26 17:15:23 - INSTALL: always: Converting Table #69 'weathermap_data'
2024-05-26 17:15:23 - INSTALL: always: Converting Table #70 'weathermap_groups'
2024-05-26 17:15:23 - INSTALL: always: Converting Table #71 'weathermap_maps'
2024-05-26 17:15:23 - INSTALL: always: Converting Table #72 'weathermap_settings'
2024-05-26 17:15:23 - INSTALL: always: Switched from to /tmp/cdu7EcfEx
2024-05-26 17:15:23 - INSTALL: always: NOTE: Using temporary file for db cache: /tmp/cdu7EcfEx
2024-05-26 17:15:23 - INSTALL: always: Upgrading from v0.8.8a (DB 1.2.27 (DB: 0.8.8a)) to v1.0.0
2024-05-26 17:15:30 - CMDPHP UPGRADE NOTE: Repairing 2 Damaged data_input_fields
2024-05-26 17:15:30 - CMDPHP UPGRADE NOTE: Found 17 Damaged data_input_fields
2024-05-26 17:15:30 - CMDPHP UPGRADE NOTE: Found 17 Damaged data_input_fields
2024-05-26 17:15:31 - INSTALL: always: Upgrading from v1.0.0 (DB 1.0.0) to v1.0.4
2024-05-26 17:15:31 - INSTALL: always: Upgrading from v1.0.4 (DB 1.0.4) to v1.0.5
2024-05-26 17:15:37 - CMDPHP ERROR: A DB Exec Failed!, Error: Array to string conversion
2024-05-26 17:15:37 - CMDPHP SQL Backtrace: (/install/background.php[55]:Installer::beginInstall(), /lib/installer.php[3530]:Installer->install(), /lib/installer.php[3025]:Installer->upgradeDatabase(), /lib/installer.php[3423]:upgrade_to_1_0_5(), /install/upgrades/1_0_5.php[39]:db_install_execute(), /install/functions.php[160]:db_execute_prepared())
2024-05-26 17:15:37 - INSTALL: always: Finished UPGRADE Process for v1.2.27
2024-05-26 17:15:37 - INSTALL: always: WARNING: One or more upgrades failed to install correctly
2024-05-26 17:15:38 - INSTALL: always: Installation was started at 2024-05-26 14:15:05, completed at 2024-05-26 14:15:38
2024-05-26 17:15:47 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:15:47 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:15:47 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
2024-05-26 17:15:49 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:15:49 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:15:49 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
2024-05-26 17:15:53 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:15:53 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:15:53 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
2024-05-26 17:15:56 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:15:56 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:15:56 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
2024-05-26 17:15:57 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:15:57 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:15:57 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
2024-05-26 17:15:59 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:15:59 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:15:59 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
2024-05-26 17:16:03 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:16:03 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:16:03 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
2024-05-26 17:16:06 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:16:06 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:16:06 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
2024-05-26 17:16:07 - INSTALL: always: Spawning background process: /usr/bin/php '/var/www/html/cacti/install/background.php' 1716732967.0477
2024-05-26 17:16:07 - INSTALL: Checking arguments
2024-05-26 17:16:07 - INSTALL: always: Setting PHP Option max_execution_time = 0
2024-05-26 17:16:07 - INSTALL: always: Setting PHP Option memory_limit = -1
2024-05-26 17:16:07 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:16:07 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-26 17:16:07 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
2024-05-26 17:16:07 - INSTALL: always: Starting UPGRADE Process for v1.2.27
2024-05-26 17:16:07 - INSTALL: always: Found 1 tables to convert
2024-05-26 17:16:07 - INSTALL: always: Converting Table #1 'reportit_cache_reports'
2024-05-26 17:16:07 - 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
2024-05-26 17:16:07 - CMDPHP SQL Backtrace: (/cli/convert_tables.php[222]:db_execute(), /lib/database.php[385]:db_execute_prepared())
2024-05-26 17:16:07 - 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'
2024-05-26 17:16:07 - INSTALL: always: Switched from to /tmp/cduKw30Gp
2024-05-26 17:16:07 - INSTALL: always: NOTE: Using temporary file for db cache: /tmp/cduKw30Gp
2024-05-26 17:16:07 - INSTALL: always: Upgrading from v1.0.4 (DB 1.2.27 (DB: 1.0.4)) to v1.0.5
2024-05-26 17:16:07 - CMDPHP ERROR: A DB Exec Failed!, Error: Array to string conversion
2024-05-26 17:16:07 - CMDPHP SQL Backtrace: (/install/background.php[55]:Installer::beginInstall(), /lib/installer.php[3530]:Installer->install(), /lib/installer.php[3025]:Installer->upgradeDatabase(), /lib/installer.php[3423]:upgrade_to_1_0_5(), /install/upgrades/1_0_5.php[39]:db_install_execute(), /install/functions.php[160]:db_execute_prepared())
2024-05-26 17:16:07 - INSTALL: always: Finished UPGRADE Process for v1.2.27
2024-05-26 17:16:07 - INSTALL: always: WARNING: One or more upgrades failed to install correctly
2024-05-26 17:16:07 - INSTALL: always: Installation was started at 2024-05-26 14:16:07, completed at 2024-05-26 14:16:07
2024-05-27 10:38:54 - AUTH LOGIN: User 'a.taha' authenticated
2024-05-27 10:38:55 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-27 10:38:55 - INSTALL-TEMPLATES: always: getDefaultTemplate(): Default Device Template is '3'
2024-05-27 10:38:55 - INSTALL-TEMPLATE: always: setDefaultTemplate(): Device default template is '3'
Top
ataha
Posts: 28
Joined: Mon Dec 04, 2023 8:48 am

Re: loop of reinstallation

Post by ataha »

any help please , because i will install the devices from scratch without old database and RRD , :( :( :(
Top
User avatar
macan
Cacti Guru User
Posts: 1137
Joined: Tue Mar 18, 2008 2:30 am
Location: Czech

Re: loop of reinstallation

Post by macan »

workaround but you lost data from reportit plugin.

Before update disable and deinstall reportit plugin
Let the Cacti grow!
Top
ataha
Posts: 28
Joined: Mon Dec 04, 2023 8:48 am

Re: loop of reinstallation

Post by ataha »

kindly explain
now when i open
http://IP-address/cacti
i found the installation steps, how to install or uninstall plugin do you mean from CLI
Top
Post Reply

Return to “Help: General”

Who is online

Users browsing this forum: No registered users and 0 guests