My initial testing of Piwik was on a W2003 server with the latest versions of PHP and MySQL installed. Unfortunately the web sites that I have to track are currently running on a W2000 server. Although the plan is to migrate it to W2003, that will not happen for a while.
I installed PHP 5.2.17 on a W2000 server specifing it as Other CGI as FastCGi is not support on IIS5.0. I manually selected the extensions based upon what I saw from the php.ini file on the W2003 server. I have created test PHP pages to validate that IIS is handling the PHP pages properly (as far as I can tell).
I added a new user to the MySQL database with DBA priviledges using the IP address of the W2000 system when creating the user.
I installed Piwik on the W2000 server and was able to connect to the remote database during the installation steps. I indicated that I wanted to re-use the existing database and the installation completed normally. However I could not log on. I entered the super user name and password and the web page just goes back to the logon page with no errors.
Although the new MySQL had DBA rights, I also implicitly gave it full access to the Piwik database. The same thing happened.
I renamed the piwik.ini.cfg file and when I went into the piwik site again. It started a new installation. This time I created a new database with a different name. The steps completed normally but I still can not log into Piwik. It just keeps coming back to the log on page without any errors. I checked MySQL on the W2003 server and the new database was created so it appears that I have access to the database.
Being new to Piwik, I am not sure where to look to see if there are any logs to indicated why I can not log on.
I tried to log on using Firefox and Safari but the same thing happens. Although my issue currently is getting this running on W2000 server, my plan is to employ a topography with the MySQL database resident on the secure side of my network.
Any and all help in finding what I have missed will be greatly appreciated.