Upgrade (Windows) from 8.7g to 8.8a also graph template ?

[hammondo]

Hello all,

Rest assured I have perused all the docs I can find and I cannot find Windows-related upgrade info. I presume that the prep basics (backup the mysql database, various cacti directories) are the same for lynix/unix and for Windows? Can someone point me to the Windows-specific upgrade information?

Cacti version 0.8.7g
Server OS Windows 2008 Server R2 Datacenter (64 bit)
Cacti OS win32
Apache version 2.2.16
Mysql version 5.1
Net-SNMP version 5.5.0

Also the user template posted on 04-15-2009 at the URL at the bottom of this post, is of interest to management (where I work) and I note the caveats related to importing this template - importing it will overwrite the standard traffic graph template however I am not understanding that caveat. We are using the ucd/net Load Average graph template on all of our graphs so would importing this template impact any of our existing graphs? Also when I go to Console>Templates>Graph Templates I see 30 templates (the defaults, I have never imported a template before) and I'm not seeing which of them would be the "standard traffic graph template".

Here's that URL and I thank you in advance for any assistance you can provide:

http://docs.cacti.net/usertemplate:grap ... ce_traffic

Steve

[hammondo]

Oops forgot to complete my version info, here it is:

Cacti Version 0.8.7g
Cacti OS win32
SNMP Version NET-SNMP version: 5.5
RRDTool Version RRDTool 1.2.x
Hosts 75
Graphs 2958
Data Sources Script/Command: 5
SNMP: 3
SNMP Query: 2953
Total: 2961
nterval 300
Type cmd.php
Items Action[0]: 5909
Action[1]: 5
Total: 5914
Concurrent Processes 1
Max Threads 1
PHP Servers 1
Script Timeout 25
Max OID 10
Last Run Statistics Time:298.9779 Method:cmd.php Processes:1 Threads:N/A Hosts:76 HostsPerProcess:76 DataSources:5914 RRDsProcessed:2910
PHP Version 5.2.14
PHP OS WINNT
PHP uname Windows NT RV08SYSLOG 6.1 build 7601
PHP SNMP Installed
max_execution_time 30
memory_limit 128M

[BSOD2600]

I presume that the prep basics (backup the mysql database, various cacti directories) are the same for lynix/unix and for Windows?

Yes. The MySQL command is the same.

We are using the ucd/net Load Average graph template on all of our graphs so would importing this template impact any of our existing graphs?

Possibly. Best to have a test installation where you can evaluate what a new template updates/overrides/breaks before importing into your production.

Also when I go to Console>Templates>Graph Templates I see 30 templates (the defaults, I have never imported a template before) and I'm not seeing which of them would be the "standard traffic graph template".

Interface - Errors/Discards
Interface - Non-Unicast Packets
Interface - Traffic (bits/sec)
Interface - Traffic (bits/sec, 95th Percentile)
Interface - Traffic (bits/sec, Total Bandwidth)
Interface - Traffic (bytes/sec)
Interface - Traffic (bytes/sec, Total Bandwidth)
Interface - Unicast Packets

[hammondo]

I presume that the prep basics (backup the mysql database, various cacti directories) are the same for lynix/unix and for Windows?

Yes. The MySQL command is the same.

Thanks BSOD2006 - I can't seem to find where I put the -p for the cactiuser password in the syntax, if I put it before or after the -l it thinks the password is the database, if I put it at the end it thinks it's a table, and if I don't specify the -p at all I get an Access Denied error

Also when I go to Console>Templates>Graph Templates I see 30 templates (the defaults, I have never imported a template before) and I'm not seeing which of them would be the "standard traffic graph template".

Interface - Errors/Discards
Interface - Non-Unicast Packets
Interface - Traffic (bits/sec)
Interface - Traffic (bits/sec, 95th Percentile)
Interface - Traffic (bits/sec, Total Bandwidth)
Interface - Traffic (bytes/sec)
Interface - Traffic (bytes/sec, Total Bandwidth)
Interface - Unicast Packets

So - sorry if I'm asking a stupid question - are all these templates "standard graph templates"?

[hammondo]

I presume that the prep basics (backup the mysql database, various cacti directories) are the same for lynix/unix and for Windows?

Yes. The MySQL command is the same.

Thanks BSOD2006 - I can't seem to find where I put the -p for the cactiuser password in the syntax, if I put it before or after the -l it thinks the password is the database, if I put it at the end it thinks it's a table, and if I don't specify the -p at all I get an Access Denied error

Found it - leave just the "-p" without specifying the password in the command, and it worked. On to the next steps in the upgrade process. Thanks again

[BSOD2600]

So - sorry if I'm asking a stupid question - are all these templates "standard graph templates"?

Yes. A clean install of cacti includes these templates (plus many more).

[hammondo]

The upgrade was successful, I am now installing Cacti on my test server (Win 2008 R2 Datacenter). I have Apache, Cacti, PHP, RRDTool, MySQL, performed the SQL command prompt tasks outlined in the Win install docs, configured the httpd.conf, config.php and php.ini files as per those same docs, yet when I go to localhost/cacti I get a list of files in the cacti folder and when I click on "Parent Folder" I see the "It Works!" page. The only item in the instructions I couldn't figure out to do is the Start Parameter change to the MySQL service (--old-password). Outside of that I followed the instructions per the product versions I have installed.

Please advise to what I can check, to get the Cacti UI to appear? Thank you

[hammondo]

I think I found part of the problem, my Cacti folder under apache2\htdocs had an upper case "C" rather than a lower case "c". I stopped Apache and MySQL services, then changed the folder name to "cacti" but now the Apache server service won't stop as it cannot find the c:\php\php5apache2.dll file. I specified this file in my httpd.conf file per the Install instructions "If using Apache 2.2 and PHP 5 then add the following lines". Apache version is 2.2, PHP version is 5.4.5.0. I cannot find that dll file anywhere on my server.

[hammondo]

Latest is I downloaded both php5apache2.dll and php5apache2_2.dll from Sourceforge, put them both in the c:\php folder, and tried starting the Apache Server service with httpd.conf pointing to either one and am still getting the error (in Event Viewer>Application Logs) "specified module could not be found". The Event Viewer event shows the correct path.

[BSOD2600]

1) I seem to recall seeing a few bugs with Cacti and PHP 5.4.x. For now, you'll probably want to stick with 5.3.x.
2) This guy just had a similar issue with the php apache dll - http://forums.cacti.net/viewtopic.php?f=3&t=47952
3) Files not being found when you can "see" them in Explorer some times is a NTFS corruption issue. ran chkdsk /f lately?

[hammondo]

1) I seem to recall seeing a few bugs with Cacti and PHP 5.4.x. For now, you'll probably want to stick with 5.3.x.
2) This guy just had a similar issue with the php apache dll - http://forums.cacti.net/viewtopic.php?f=3&t=47952
3) Files not being found when you can "see" them in Explorer some times is a NTFS corruption issue. ran chkdsk /f lately?

I tried PHP 5.3.15 but I think I bungled things up. I ran the Windows Installer and can't find any .dll that starts with "phpxapache" in program files\php\ext so I'm not sure where to point that loader line in the httpd.conf now.

Thanks BSOD, I do appreciate the response.

[BSOD2600]

I ran the Windows Installer and can't find any .dll that starts with "phpxapache" in program files\php\ext so I'm not sure where to point that loader line in the httpd.conf now

Did you enable the apache plugins in the PHP installer?

did you read how the guy solved his problem in the linked thread?

|-php5apache2_2.dll -- does not exist in non thread safe version
|
|-php5apache2_2_filter.dll -- does not exist in non thread safe version