Installing Converting Table very long time

[DouggieFresh]

Hello,

I am new to Cacti. It looks like a promising, wonderful software. However, I have been working non-stop for 16 hours over the past 2 days to get it installed.

The obstacles are many, but I managed to get to the point where I could move forward in the Cacti Server v1.2.27 - Installation Wizard.

Downloaded the Time_Zone sql file from MySQL and imported it into my MYSQL database.
I believe I ran a command to set the database to UTF8...
During pre-check there were so many warnings.
The database languages were showing as Latin-1 or something.

Now during the install it just sites there for hours. So I ran a command to delete something and started the install again with a minimal amount of Templates.

I started the install again at 6:00pm and it is now 9:00pm and I am at 0%

Installing Cacti Server v1.2.27
Your Cacti Server is now installing

Refresh in ProgressLast updated: 20:47:03

0 %
2024-11-22 20:47:03 - INSTALL: Checking arguments
2024-11-22 20:47:03 - INSTALL: always: Spawning background process: c:/php/php.exe "C:/Apache24/htdocs/cacti/install/background.php" 1732326423.1351
2024-11-22 20:22:02 - INSTALL: Checking arguments
2024-11-22 20:22:01 - INSTALL: always: Spawning background process: c:/php/php.exe "C:/Apache24/htdocs/cacti/install/background.php" 1732324921.1404
2024-11-22 19:56:59 - INSTALL: Checking arguments
2024-11-22 19:56:58 - INSTALL: always: Spawning background process: c:/php/php.exe "C:/Apache24/htdocs/cacti/install/background.php" 1732323418.7302
2024-11-22 19:31:57 - INSTALL: Checking arguments
2024-11-22 19:31:56 - INSTALL: always: Spawning background process: c:/php/php.exe "C:/Apache24/htdocs/cacti/install/background.php" 1732321916.6627
2024-11-22 19:06:55 - INSTALL: Checking arguments
2024-11-22 19:06:54 - INSTALL: always: Spawning background process: c:/php/php.exe "C:/Apache24/htdocs/cacti/install/background.php" 1732320414.7725
2024-11-22 18:41:53 - INSTALL: Checking arguments
2024-11-22 18:41:52 - INSTALL: always: Spawning background process: c:/php/php.exe "C:/Apache24/htdocs/cacti/install/background.php" 1732318912.555
2024-11-22 18:16:51 - INSTALL: Checking arguments
2024-11-22 18:16:50 - INSTALL: always: Spawning background process: c:/php/php.exe "C:/Apache24/htdocs/cacti/install/background.php" 1732317410.6223
2024-11-22 17:51:48 - INSTALL: Checking arguments
2024-11-22 17:51:48 - INSTALL: always: Spawning background process: c:/php/php.exe "C:/Apache24/htdocs/cacti/install/background.php" 1732315908.3274
2024-11-22 17:44:17 - INSTALL: Checking arguments
2024-11-22 17:44:16 - INSTALL: always: Spawning background process: c:/php/php.exe "C:/Apache24/htdocs/cacti/install/background.php" 1732315456.5685
2024-11-22 17:33:21 - INSTALL: Checking arguments
2024-11-22 17:33:20 - INSTALL: always: Spawning background process: c:/php/php.exe "C:/Apache24/htdocs/cacti/install/background.php" 1732314800.5664
2024-11-22 17:04:46 - INSTALL: Checking arguments
2024-11-22 17:04:45 - INSTALL: always: Spawning background process: c:/php/php.exe "C:/Apache24/htdocs/cacti/install/background.php" 1732313085.7139
2024-11-22 16:39:44 - INSTALL: Checking arguments
2024-11-22 16:39:43 - INSTALL: always: Spawning background process: c:/php/php.exe "C:/Apache24/htdocs/cacti/install/background.php" 1732311583.8044
2024-11-22 16:14:43 - INSTALL: Checking arguments
2024-11-22 16:14:42 - INSTALL: always: Spawning background process: c:/php/php.exe "C:/Apache24/htdocs/cacti/install/background.php" 1732310082.7572
2024-11-22 15:49:40 - INSTALL: Checking arguments
2024-11-22 15:49:40 - INSTALL: always: Spawning background process: c:/php/php.exe "C:/Apache24/htdocs/cacti/install/background.php" 1732308580.0022
2024-11-22 15:24:39 - INSTALL: always: About to import Package #13 'Citrix_NetScaler_VPX.xml.gz'.
2024-11-22 15:24:39 - INSTALL: always: Import of Package #12 'Cisco_Router.xml.gz' under Profile '1' succeeded
2024-11-22 15:24:29 - INSTALL: always: About to import Package #12 'Cisco_Router.xml.gz'.
2024-11-22 15:24:29 - INSTALL: always: Import of Package #11 'Cacti_Stats.xml.gz' under Profile '1' succeeded
2024-11-22 15:23:54 - INSTALL: always: About to import Package #11 'Cacti_Stats.xml.gz'.
2024-11-22 15:23:54 - INSTALL: always: Import of Package #10 'BayTech_PDU.xml.gz' under Profile '1' succeeded
2024-11-22 15:23:22 - INSTALL: always: About to import Package #10 'BayTech_PDU.xml.gz'.
2024-11-22 15:23:22 - INSTALL: always: Import of Package #9 'ArubaOS_switch.xml.gz' under Profile '1' succeeded
2024-11-22 15:23:15 - INSTALL: always: About to import Package #9 'ArubaOS_switch.xml.gz'.
2024-11-22 15:23:15 - INSTALL: always: Import of Package #8 'Aruba_Wireless_Controller.xml.gz' under Profile '1' succeeded
2024-11-22 15:22:55 - INSTALL: always: About to import Package #8 'Aruba_Wireless_Controller.xml.gz'.
2024-11-22 15:22:55 - INSTALL: always: Import of Package #7 'Aruba_OSCX_switch_6x00.xml.gz' under Profile '1' succeeded
2024-11-22 15:22:33 - INSTALL: always: About to import Package #7 'Aruba_OSCX_switch_6x00.xml.gz'.
2024-11-22 15:22:33 - INSTALL: always: Import of Package #6 'Aruba_Instant_AP_Cluster.xml.gz' under Profile '1' succeeded
2024-11-22 15:22:26 - INSTALL: always: About to import Package #6 'Aruba_Instant_AP_Cluster.xml.gz'.
2024-11-22 15:22:26 - INSTALL: always: Import of Package #5 'APC_InfraStruXure_PDU.xml.gz' under Profile '1' succeeded
2024-11-22 15:22:09 - INSTALL: always: About to import Package #5 'APC_InfraStruXure_PDU.xml.gz'.
2024-11-22 15:22:09 - INSTALL: always: Import of Package #4 'APC_InfraStruXure_InRow_CRAC.xml.gz' under Profile '1' succeeded
2024-11-22 15:21:49 - INSTALL: always: About to import Package #4 'APC_InfraStruXure_InRow_CRAC.xml.gz'.
2024-11-22 15:21:49 - INSTALL: always: Import of Package #3 'Apache_Webserver.xml.gz' under Profile '1' succeeded
2024-11-22 15:21:39 - INSTALL: always: About to import Package #3 'Apache_Webserver.xml.gz'.
2024-11-22 15:21:39 - INSTALL: always: Import of Package #2 'AKCP_Device.xml.gz' under Profile '1' succeeded
2024-11-22 15:21:31 - INSTALL: always: About to import Package #2 'AKCP_Device.xml.gz'.
2024-11-22 15:21:31 - INSTALL: always: Import of Package #1 'ACME.xml.gz' under Profile '1' succeeded
2024-11-22 15:21:21 - INSTALL: always: About to import Package #1 'ACME.xml.gz'.
2024-11-22 15:21:21 - INSTALL: always: Found 28 templates to install
2024-11-22 15:21:20 - INSTALL: always: Converting Table #113 'version'
2024-11-22 15:21:18 - INSTALL: always: Converting Table #112 'vdef_items'
2024-11-22 15:21:17 - INSTALL: always: Converting Table #111 'vdef'
2024-11-22 15:21:16 - INSTALL: always: Converting Table #110 'user_log'
2024-11-22 15:21:15 - INSTALL: always: Converting Table #109 'user_domains_ldap'
2024-11-22 15:21:14 - INSTALL: always: Converting Table #108 'user_domains'
2024-11-22 15:21:13 - INSTALL: always: Converting Table #107 'user_auth_row_cache'
2024-11-22 15:21:12 - INSTALL: always: Converting Table #106 'user_auth_realm'
2024-11-22 15:21:10 - INSTALL: always: Converting Table #105 'user_auth_perms'
2024-11-22 15:21:09 - INSTALL: always: Converting Table #104 'user_auth_group_realm'
2024-11-22 15:21:08 - INSTALL: always: Converting Table #103 'user_auth_group_perms'
2024-11-22 15:21:07 - INSTALL: always: Converting Table #102 'user_auth_group_members'
2024-11-22 15:21:06 - INSTALL: always: Converting Table #101 'user_auth_group'
2024-11-22 15:21:05 - INSTALL: always: Converting Table #100 'user_auth_cache'
2024-11-22 15:21:04 - INSTALL: always: Converting Table #99 'user_auth'
2024-11-22 15:21:03 - INSTALL: always: Converting Table #98 'snmp_query_graph_sv'
2024-11-22 15:21:02 - INSTALL: always: Converting Table #97 'snmp_query_graph_rrd_sv'
2024-11-22 15:21:01 - INSTALL: always: Converting Table #96 'snmp_query_graph_rrd'
2024-11-22 15:20:59 - INSTALL: always: Converting Table #95 'snmp_query_graph'
2024-11-22 15:20:58 - INSTALL: always: Converting Table #94 'snmp_query'
2024-11-22 15:20:57 - INSTALL: always: Converting Table #93 'snmpagent_notifications_log'
2024-11-22 15:20:56 - INSTALL: always: Converting Table #92 'snmpagent_mibs'
2024-11-22 15:20:54 - INSTALL: always: Converting Table #91 'snmpagent_managers_notifications'
2024-11-22 15:20:53 - INSTALL: always: Converting Table #90 'snmpagent_managers'
2024-11-22 15:20:52 - INSTALL: always: Converting Table #89 'snmpagent_cache_textual_conventions'
2024-11-22 15:20:51 - INSTALL: always: Converting Table #88 'snmpagent_cache_notifications'
2024-11-22 15:20:50 - INSTALL: always: Converting Table #87 'snmpagent_cache'
2024-11-22 15:20:49 - INSTALL: always: Converting Table #86 'sites'
2024-11-22 15:20:47 - INSTALL: always: Converting Table #85 'settings_user_group'
2024-11-22 15:20:46 - INSTALL: always: Converting Table #84 'settings_user'
2024-11-22 15:20:46 - INSTALL: always: Converting Table #83 'settings_tree'
2024-11-22 15:20:44 - INSTALL: always: Converting Table #82 'settings'
2024-11-22 15:20:43 - INSTALL: always: Converting Table #81 'sessions'
2024-11-22 15:20:42 - INSTALL: always: Converting Table #80 'rrdcheck'
2024-11-22 15:20:41 - INSTALL: always: Converting Table #79 'reports_items'
2024-11-22 15:20:40 - INSTALL: always: Converting Table #78 'reports'
2024-11-22 15:20:39 - INSTALL: always: Converting Table #77 'processes'
2024-11-22 15:20:38 - INSTALL: always: Converting Table #76 'poller_time'
2024-11-22 15:20:37 - INSTALL: always: Converting Table #75 'poller_resource_cache'
2024-11-22 15:20:36 - INSTALL: always: Converting Table #74 'poller_reindex'
2024-11-22 15:20:34 - INSTALL: always: Converting Table #73 'poller_output_realtime'
2024-11-22 15:20:33 - INSTALL: always: Converting Table #72 'poller_output_boost_processes'
2024-11-22 15:20:32 - INSTALL: always: Converting Table #71 'poller_output_boost_local_data_ids'
2024-11-22 15:20:31 - INSTALL: always: Converting Table #70 'poller_output_boost'
2024-11-22 15:20:30 - INSTALL: always: Converting Table #69 'poller_output'
2024-11-22 15:20:29 - INSTALL: always: Converting Table #68 'poller_item'

I am at my wits end. It has been a very long haul.

Any ideas?

[macan]

It isn't normal behavior. What is the memory, cpu and disk load?

[DouggieFresh]

Thank you for responding.

For whatever reason, I just could not get Cacti to install. I tried everything that seemed relevant and that I read about and was able to make it to the Cacti installer. However, even then I was hit with a bunch of hurdles. I actually uninstalled all components installed by the Windows installer, 6 or 7 times completely, everything...

I manually deleted any residual folders under the Program Files and programdata folders after each install. I just cannot even list the number of troubleshooting steps I took to try to get the software installed. I spent 3 solid days of trying, 24 hours before I decided to throw in the towel.

I moved on to Zabbix which I installed in about one hour, and it is working.

One day I will come back to Cacti and do it on a Linux distribution because it just seems easier on Linux.