win2k8 R2 : Installation using Microsoft Platform Installer

[petoulachi]

Hello,

I'm new to cacti and trying to install it on my windows 2008 R2 server.
I've choose, to install php/MySql, to use the Web Platform Installer from Microsoft. Using it configure IIS to work properly with php (FastCGI etc), so I've just to changed some config in php.ini (in fact doing it via the Php Manager in IIS management console).

Anyways, I know that php works (testing using phpinfo.php). I've also installed MySQL, create the cacti database and cacti user. Using heidisql I'm also able to connect to the MySQL server using the cacti credential, and can do select on the cacti database so I guess that the sql user is OK.

But I'm unable to browse my website for the first time : it can't connect to the database provide in the cacti php.ini file : "FATAL: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php' ".
My config.php seems correct :
$database_type = "mysql";
$database_default = "cacti";
$database_hostname = "localhost";
$database_username = "cactiuser";
$database_password = "mypassword";
$database_port = "3306";


I don't have any event record in eventlog, nor in the log file from cacti, so I really don't know what's wrong here ?

Thanks for your help !

[petoulachi]

searching on the forum, I've found, in patch note for the installer :
"* Installation path checking now doesn't allow spaces (since it breaks Cacti) "
Using Web Platform Installer, I cannot choose folder installation for PHP/MySql. They both have spaces.

Should it be my issue ?

[BSOD2600]

The Microsoft installer is only for fastcgi... unless you're talking about the cacti windows installer found in this forum? At any rate, its ok to install the factcgi and mysql stuff in a path containing spaces since cacti doesn't explicitly invoke either of them.

What version of everything did you install?
UAC on?

[petoulachi]

No I'm talking about Web Platform Installer, it's a tool given with IIS management (http://www.microsoft.com/downloads/fr-f ... a39f50bbf9). It's great because you select what you want to install and don't have to configure anything after install.
The problem is that you can't choose installation directory, so I guess I have to uninstall it and reinstall them manually in this case, as there are spaces.

cacti 0.8.7g (and last patch), MySQL 5.1 and PHP 5.3

[petoulachi]

Okay I tried using your installer, but I can't access the website. I'm not using default website because I have a specific binding for cacti (http://cacti.mydomain.lan), this website is pointing on the c:\cacti directory containing all the needed files.
Default document is set with index.php, but I've a got a 404 error, it's weird.

Checked the installation log, nothing in cacti.log but mysql_install_log says :
"Service name: "MySQL"
Parameters: "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.1\\my.ini" MySQL.
Windows service MySQL installed.
Service started successfully.
The security settings could not be applied to the database because the connection has failed with the following error.

Error Nr. 1045
Access denied for user 'root'@'localhost' (using password: NO)"

I guess uninstalling my previous manual installation of MySql does not delete the settings, but anyway this is not related with my 404 error.

[petoulachi]

Okay so I don't know why, but using procmon I was able to see that php_cgi.exe was not looking at the correct path to access index.php. It was because a variable named "doc_root" was set to C: on my php.ini (the installer given in this forum do that ?)

Now everything seems to work properly !