[RESOLVED] [help!] PHP Unable to Load MSSQL (from ext)

big_nerd

I am attempting to merge from Apache to IIS, I need some ASP (etc) before you ask.

I have PHP working smashingly, which wasn't difficult at all, however, I am unable to use any extensions.

The strange thing is under phpinfo();

Configuration File (php.ini) Path C:\WINNT

This is fine, I guess, I even copied the working php.ini (from the apache distro) into the C:\WINNT path; the strange part is here:

extension_dir C:\php5 C:\php5

Which is of course the local/master value.

C:\php5 only has a "pear" directory.

I am cleaning up someone else's mess here so i don't know why both directories exist.

In PHP.INI the extensions directory is C:\PHP\EXT

Any ideas where this php5 thing came from?

big.nerd

[edit]

After more testing, I realized I didn't restart IIS, when I have the php.ini in the C:\WINNT\ Directory, I get "No Input file specified" from the phpinfo command.

I can't figure it out, all of the paths are correct, i.e. c:\php\ext as ext. directory.

bradgrafelman

Never put files in the Windows (aka WINNT) directory. Or system32. Never.
Keep all of the php files - including php.ini - centralized, e.g. in c:\php. Since you're using IIS, you need to add the 'PHPRC' environment variable to your system. See this FAQ for more information, and yes, you must restart Windows (not just IIS) for this to take effect.
You also should add the PHP directory itself to your system's PATH environment variable, as there should be other .dll files out in the root of your c:\php\ directory. For more information on how to do this, see this FAQ entry.

EDIT: Also, how is PHP integrated with IIS; CGI binary, or ISAPI .dll filter?

big_nerd

brad;

First and foremost, thank you.

I never did want to put the php.ini into the winnt directory, normally I'm a linux guy and something about that irked me, however I am not a foremost expert on windows either.

It is the ISASPI.dll filter, I am unaware of how to "integrate" it with IIS. I think the issue lies completely in the PHPRC envronment variable. I will have to arrange a time to go down to that building and reboot the server.

I do have the PATH set to C:\PHP; C:\PHP\EXT; [etc etc etc] in the system variables (not user).

I strongly believe this will aleviate this issue, but I will wait before marking resolved.

Thank you again; I will try this.

big_nerd

bradgrafelman,

thanks for the suggestion, however..

I updated the system with PHPRC, now for some odd reason, whenever I attempt to connect to the site with IIS, it ignores the PHP files, even gives a 404 error.

And when I am in the Internet Services Manager, and I am browsing the directory (as it shows your home directory as set) it see html files, but no php.

Any ideas?

bradgrafelman

You can't even see .php files in the IIS manager? That's very odd... I've never heard of that happening before...

First of all, are you positive there are PHP files where you think there are, e.g. c:\Inetpub\wwwroot\ ?

If so, I'm not sure where to direct you next... can you detail all of the changes you've made to IIS? Have you tried rebooting the entire server itself?

big_nerd

100% sure. In fact I also have Apache win32 running perfectly (which yes, I shut down for testing purposes).

I will go through the system tomorrow I suppose and note all of the php-related changes.

The worst part of all this is; I had PHP /IIS setup before. This system just does NOT want it setup!

I will outline all of the changes on my next workday (I have to see the system) and maybe you can find out my silly mistake.

bradgrafelman

big.nerd wrote:
I will outline all of the changes on my next workday

You need to experience the joys of VPN & Remote Desktop! 🙂 That's what I use when I need to answer Server 2k3/IIS questions (currently building a test environment here at home in Virtual PC, haven't got it done yet though).

While you're at it, would you mind grabbing a copy of your IIS' Metabase for me to examine? To do this:

Open IIS manager
Right click on your server's name (the first node under "Internet Information Services" on the left)
Under "All tasks" choose "Backup/Restore Configuration"
Click Create Backup, and type in a file name.
Zip up the two files created in \WINDOWS\system32\inetsrv\MetaBack\ that have the same name as the filename you just chose (.MD0 and .SC0 files)
Attach the .zip file to this post, or, if you don't want the world to see your IIS configuration, e-mail it to me at brad AT njoe DOT com (@ and . replaced with words to prevent spam :p).

big_nerd

Well, I have Remote Desktop, at work.. certainly like that it saves me the trip between buildings. However, I will do so, via your email; although it is not a public server it will be soon, then I can remote in from home (yay! more taking work home!) and well .. security ..

Thank you again, I would really like to see this resolved so I can finish my work sometime this year (literally).

big_nerd

[Resolved]

The issue has been resolved. It appears one of the IT Guys (who is no longer with the company, thank god) felt I didn't know what I was doing, and change PHP.INI doc_root to the default C:\Inetpub\wwwroot. I do not host out of there and aparently when you set the DocRoot wrong, your IIS Admin can't see PHP files, and you get an ERROR404 even though the file is there.

My own foolish mistake, I figured, since I configured it, and I knew I don't use that directory.. I didn't check it over.

Thanks again brad and all who read..