Windows All-In-One Installer [Cacti 1.2.24] [Updated 2023-03-09]

[markbthompson]

I tried this on Server 2012 R2 running under Hyper-V. It threw an error up about SQL during the install.
FATAL ERROR - Error reading MySQL installation location. I had the installer on the desktop.

It does show the MySQL installer in add remove programs however I can't find the install log for it anywhere on the box, I did an index search for it.
I took the default settings, installing on root of C and let it install Apache. I had already turned off the UAC on the box prior to the install. The firewall is disabled.

With no troubleshooting yet, I cannot hit the Apache web server remotely either. I expected to see a basic index page even if MySQL had issues.

where do I go from here?

thanks

[markbthompson]

Sorry, forgot to attach the Cacti log. I can't post the entire log, it is 4 times the limit here but this is the error area about MySql

Output folder: C:\Users\mthomps1\AppData\Local\Temp\2\nse164A.tmp
Installing MySQL Installer...
Extract: mysql.msi
Execute: msiexec /i "C:\Users\mthomps1\AppData\Local\Temp\2\nse164A.tmp\mysql.msi" /qn USERNAME="Valued Cacti Customer"
MySQL installer exited with: 0
Installing MySQL 5.6.20.0...
Loading Installer Configuration.
Loading Product Manifest. This may take some time.

Config value existingpasswd was not supplied but an existing data directory was found

Usage: --config=<Product Name>:<passwd=Root Password>[;Parameter 1 = value][;Parameter 2 = value]

e.g. MySQLInstallerConsole --config=mysql-server-5.5-win32:passwd=root;timeout=300 --action=install --type=Full
e.g. MySQLInstallerConsole --config=mysql-server-5.5-win32:passwd=root;autostartservice=false;openfirewall=true;port=3307;generallog=true;generallogname=MYLOG.log;slowlog=true;slowlogname=MySlowLog.log;binlog=true;binlogname=BIN-LOG;errorlogname=ErrorLog.log --action=install --product=mysql-server-5.5-win32:*
-?, --help, -h Display help for MySQLInstaller console options.
-u, --updates Checks for new products before any action.
Skipped by default.
--nowait Skip the final pause when the program finishes.
-c, --catalog=VALUE Set default catalog.
-t, --type=VALUE [developer|server|client|full|custom] Set
installation type.
--action=VALUE [install|remove|upgrade|list|status] Set
Performing action.
-p, --product[=VALUE1:VALUE2]
product_name[:feature1;feature2] Specify product
and optionally specific features.
--config=VALUE1:VALUE2 product_name:param1=value[;param2=value]
Configuration parameters for most recently
listed product.
--user=VALUE1:VALUE2 product_name:name;host;role;[password|tokens]
Creates a new user.
--mos=VALUE user=username;pass=password Login to mos to
download commercial product updates.

Configuring MySQL...
* FATAL ERROR *
Error reading MySQL install location
-----------------------------------------------------------------------------------------------
Installing Aggregate plugin...
Output folder: C:\Apache24\htdocs\cacti\plugins\aggregate
Extract: LICENSE... 100%
Extract: README... 100%
Extract: aggregate.php... 100%
Extract: aggregate_functions.php... 100%
Extract: aggregate_graphs.php... 100%
Extract: aggregate_items.php... 100%
Extract: aggregate_manual.pdf... 100%
Extract: aggregate_templates.php... 100%
Extract: color_html.php... 100%
Extract: color_templates.php... 100%
Extract: color_templates_items.php... 100%
Extract: index.php
Extract: setup.php... 100%
Output folder: C:\Apache24\htdocs\cacti\plugins\aggregate\images
Extract: index.php
Output folder: C:\Apache24\htdocs\cacti\plugins\aggregate\js
Extract: index.php
Extract: jquery.min.js... 100%
Output folder: C:\Apache24\htdocs\cacti\plugins\aggregate\patches
Output folder: C:\Apache24\htdocs\cacti\plugins\aggregate\patches\0.8.7g
Extract: graphs.php... 100%
Output folder: C:\Apache24\htdocs\cacti\plugins\aggregate
-----------------------------------------------------------------------------------------------
Installing autom8 plugin...
Output folder: C:\Apache24\htdocs\cacti\plugins\autom8
Extract: LICENSE... 100%
Extract: README... 100%
Extract: autom8_actions.php... 100%
Extract: autom8_functions.php... 100%
Extract: autom8_graph_rules.php... 100%
Extract: autom8_sql.php... 100%
Extract: autom8_tree_rules.php... 100%
Extract: autom8_utilities.php... 100%
Extract: automate_manual.pdf... 100%
Extract: setup.php... 100%
Output folder: C:\Apache24\htdocs\cacti\plugins\autom8\patches-087d
Extract: cli.patch... 100%
Extract: host.php.patch... 100%
Extract: lib_api_automation_tools.php.patch... 100%
Extract: lib_api_device.php.patch... 100%
Extract: lib_api_tree.php.patch... 100%
Extract: lib_data_query.php.patch... 100%
Extract: lib_html_utility.patch... 100%
Extract: lib_template.php.patch... 100%
Output folder: C:\Apache24\htdocs\cacti\plugins\autom8\patches-087e
Extract: cli.patch... 100%
Extract: host.php.patch... 100%
Extract: lib_api_automation_tools.php.patch... 100%
Extract: lib_api_device.php.patch... 100%
Extract: lib_api_tree.php.patch... 100%
Extract: lib_data_query.php.patch... 100%
Extract: lib_html_utility.patch... 100%
Extract: lib_template.php.patch... 100%
Output folder: C:\Apache24\htdocs\cacti\plugins\autom8\patches-087g
Extract: cacti087g_autom8.patch... 100%
Output folder: C:\Apache24\htdocs\cacti\plugins\autom8\patches-087h
Extract: no_patch_required.php
Output folder: C:\Apache24\htdocs\cacti\plugins\autom8
-----------------------------------------------------------------------------------------------
Installing Boost plugin...
Output folder: C:\Apache24\htdocs\cacti\plugins\boost
Extract: LICENSE... 100%
Extract: README... 100%
Extract: boost_rrdupdate.php... 100%
Extract: boost_server.php... 100%
Extract: boost_sql_memory.sql... 100%
Extract: boost_sql_myisam.sql... 100%
Extract: cacti_boost.conf... 100%
Extract: cacti_rrdsvc... 100%
Extract: index.php
Extract: poller_boost.php... 100%
Extract: setup.php... 100%
Output folder: C:\Apache24\htdocs\cacti\plugins\boost

[BSOD2600]

The MySQL installer believes an existing installation exists:

Code: Select all

Config value existingpasswd was not supplied but an existing data directory was found

rollback to the snapshot before cacti (or just run its uninstaller), remove C:\ProgramData\MySQL\, and try again.

The next installer I really need to have it detect an existing MySQL installation...

[markbthompson]

ok, is there a bundled uninstaller or do I remove all the packages from add-remove programs plus clear that directory? I don't see an included uninstaller with this package.
There is no snapshot of this VM to roll back to, worst case is I reload it all from new OS and start over.

thanks

[BSOD2600]

No need to flatten the VM.

Is there a C:\ProgramData\MySQL\MySQL Server X.Y\data\ folder(s)? If so, delete all of them. This is typically what the MySQL installer is finding for the error message and preventing a reconfiguration. The run the cacti installer again.

[markbthompson]

There is no \Programdata folder path. I did a search for MySQL and deleted every existing folder with MySQL in it, including the invisible appdata temp folders and I get the exact same error.

[markbthompson]

I even deleted my profile in case the files were in it, installed as local Administrator and I get the same error on MySQL. Where is this data written to?

[markbthompson]

Ok, I found the INVISIBLE \appdata folder and removed all of the MySql data, rebooted, same error.

[markbthompson]

I got a clean install after removing the Cacti folder plus the other data folder and installing from a new profile.

thanks

[markbthompson]

Everything working fine now!

thanks again

[gringo]

Back again and, of course, as before with an issue can't find anywhere. I've already filled the beer kitty if for no other reason than you need 100 times what I can afford for the astonishing amount of time you must have put into these installers. Since last time around once you helped me get up and running after weeks of chasing my tail like everybody else until running your installer things have been just peachy. I decided to do the "update" to 8.8c and all was well for a little better than 2 weeks; absolutely no issues. One day I decided I'd like the Realtime plugin but after enabling it got the "no cache" issue that others have had. While trying to chase that down I saw the "Manage" plugin was not installed nor enabled so decided to add that as well. Bye bye Cacti, it immediately went to blank white screen HTTP 500 error. After wasting a few days decided to just run your uninstaller as I had to do back in October, delete the "ProgramData\MySql" directory and do a fresh install using your new installer. To my chagrin STILL white screen when trying to login. I have included install log and screenshots of file structure in case it helps. I overlayed over top of login screen (white) the file structure of "cacti_old" which I created at the update and the now new "cacti" directory from the new install. Another oddity was it produced NO "Cacti-Password" doc like before. This may be a piece of cake for you but I'm gonna create another VM and move on as I can't spend my life troubleshooting PHP, Spine, Cygwin, etc. that I have absolutely zero knowledge of. IF you feel like giving me some suggestions to try I've left this thing up and running as I hate to "give up", I HATE defeat but I can't wait any longer and will be building another VM. Your beer kitty has been sent anyway but do NOT feel obligated to troubleshoot this thing. Again, you deserve 100 fold what I've thrown at you for your work building this

THANKS, Bro for everything you do here.................

[BSOD2600]

If a plugin isnt compatible with Cacti, the only way to disable it is to remote the folder from \cacti\plugins\. then cacti wont attempt to load it and cause any issues like you've experienced.

While the cacti uninstaller cleans up after itself, it relies on the 3rd party [un]installation tools too... MySQL always leaves behind its C:\ProgramData\MySQL\MySQL Server X.Y\data\mysql\ folder which causes issues with future installs. delete said folder(s) and the cacti installer should successfully complete.

[normal]

Dear BSOD2600,

I just installed Cacti wtih the latest installer prepared by you. Everything is working fine except the graph is unable to show.

Attached is screenshot of the graph debug mode and cacti log.

RRD debug output.jpg (36.91 KiB) Viewed 9487 times

Cacti log file.jpg (245.79 KiB) Viewed 9487 times

As shown on the screenshot, the RRD tool doesn't show any error and the log looks normal for me. Therefore I have no idea what's wrong with it actually.

FYI. Following is versions of the software I'm using

- OS : Windows Server 2012 Standard R2
- Web server : IIS 8
-Cacti 0.8.8c
-Spine 0.8.8c (x86/x64)
-Apache 2.4.10 VC11 (x86/x64)
-MySQL 5.6.20.0 (x86/x64)
-PHP 5.6.3 VC11 (x86/x64)
-Net-SNMP 5.7.0 (x86/x64)
-RRDTool 1.4.5 VC10 (x86)

BTW, the related graph is working fine in my old server which using Cacti 0.8.7b on Windows Server 2003 Std R2.

Do you have any idea what's wrong actually ?

Looking forward to your advice and any help would be much appreciated.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

11-May-2015 update : I'd got my issue resolved and shared in this thread : http://forums.cacti.net/viewtopic.php?f=3&t=54593

[firehawk]

Any luck with gettting the graph to show?

I downloaded and installed the CACTI 0.8.8g package from this threat yesterday onto my Server 2012 R2. Install went flawlessly. I log onto Cacti (http://localhost/cacti) and was able to setup the localhost monitor and added a Cisco 2921 as well. The SNMP discovered all the interfaces, CPU, memory, etc. without any issue. But when I created graphs for them, all the graphs are blank. I checked scheduled event and I see the CACTI poller is setup in there for every 5 minutes. I have attached some screen shots below if that helped.

Any idea?

[BSOD2600]

normal:
looks like you're using 3rd party templates. do the stock ones that come with cacti work? did you wait 10 min before checking the graphs?

firehawk:
looks like cacti is getting valid data. did you wait 10 min before checking the graphs?