Problems with PHP ISAPI & IIS 6.0 on Windows 2003 SP2

[smilerza]

Basically I've migrated my Cacti installation to a new server; PHP ISAPI was working 100% until I did some Windows Security Updates which has now broken PHP ISAPI. I'm using PHP Version 5.1.6

When IIS6 has been configured to use PHP ISAPI, I get the following error message:

Error

You have created a new database, but have not yet imported the 'cacti.sql' file. At the command line, execute the following to continue:

mysql -u cacti -p cacti < cacti.sql

This error may also be generated if the cacti database user does not have correct permissions on the cacti database. Please ensure that the cacti database user has the ability to SELECT, INSERT, DELETE, UPDATE, CREATE, ALTER, DROP, INDEX on the cacti database.

If I reconfigure IIS6 to use PHP CGI I don't get the above error but I have to enter my username/password twice as the first time I get an access denied.

I really need to use PHP ISAPI working as I have another web app that doesn't want to work with PHP CGI and entering my logon details twice is rather anoying.

Any ideas??

[BSOD2600]

1) upgrade to php 5.2.2.

2) sounds like you mysql installation isn't properly set up since cacti cant find its database.

[smilerza]

Well there can't be a problem with the Mysql install/config as if I reconfigure IIS to use PHP CGI then everything works with no issues.

When reconfgiuring IIS no changes are made to either the mysql/cacti config.

The problem is that PHP ISAPI doesn't work.. something is stopping ISAPI from connecting to the mysql db.

[BSOD2600]

Well it's something specific to your configuration thats broken, because in general it works fine. What OS? If win2k3, make sure you put the PHP isapi dll in the allowed web extensions too.

When you're using iaspi, run: php -m from the commandline. Are the snmp, sockets, and mysql modules loaded?

Manually run: php <cacti path>\poller.php. Does it give you any errors?