My Bug Report to PHP.net...

beo27

[mod]Removed bad post[/mod]

[synopsis]User cannot get MySQL and PHP working together under a Windows environment.[/synopsis]

PLEASE DO NOT EDIT MOD EDITED POSTS

bpat1434

First of all, please note that we are NOT the creators, maintainers, nor developers of PHP. We are not affiliated with PHP.net in any specific way.

Secondly, you could not have tried everything, seeing as how I've had MySQL and PHP running in a windows environment and I've had no trouble. Have you followed the tutorial pinned at the top of this board? If not, try that. That's what I use every time and it works.

Have you tried adding php to the path and restarting the computer?

beo27

I have gone as far as to format my O/S in the past 12 hours I've spent on this god forsaken task.

I'll take another 2 hours (rough estimate, likely accurate) and do as requested(forum guide), then report back. I really do appreciate your reply. With the way I despise PHP, I'm sure I've bothered someone, if not you as well.

FYI: I'm using IIS (I'm sure it's a contributing factor).

bpat1434

If you're running IIS 6, I'd suggest you look at this tutorial as I've followed it and gotten it running successfully.

With regard to mySQL, it's nothing more than making sure the extensions are actually available in the path and that MySQL is running.

beo27

"PLEASE DO NOT EDIT MOD EDITED POSTS"
Some forewarning would have been nice, or ample time to copy my message before you deleted it. I also don't see that rule posted anywhere. Is there a particular reason you decided to enforce this upon me?

Also, I went through the entire guide posted, as well as the troubleshooting steps. I have paid particular attention to this:

5.10 None of the mySQL extensions are loading! No errors when I run PHP, but phpinfo() does not list any of the mySQL extensions.
Adam Carter worked through this problem and came to the insightful conclusion that the problem was caused by his mySQL install's bin folder being inculded in the PATH before PHP's install folder. That caused mySQL's libmysql.dll file to be loaded before PHP's libmysql.dll file when PHP went looking for a libmysql.dll file upon loading its mySQL extension. Putting PHP's install folder in the PATH prior to mySQL's bin folder enabled PHP to find its own libmysql.dll file. Hence the instruction in step 2.5 to add PHP's install folder to the beginning of the PATH. Alternately, you can put PHP's libmysql.dll in %systemroot%\system32. That will have the same effect of putting it in the PATH before mySQL's bin folder.

I'm happy to see that atleast someone was able to figure this out. No suprise that PHP.net did none of the work.

As I have said(Since removed....), nothing in Event Log. No error messages anywhere. I even directed php.ini to log errors to a file. This file is empty, still.
I have tried copying libmysql to windows and system32. Hell, I have tried copying everything(directory exclusive) to both of these directories... Every extension, every dll, every exe, even php.ini. I have resinstalled it... god knows how many times.
PHP works. But who knows where the mysql extension is? phpinfo() sure doesn't. I have even reinstalled Windows from a fresh format.

I went ahead and copied this post to clipboard, in the case you wish to delete it as well. (Sarcasm)

P.S. Please do let me know if my rudeness bothers you. I'm not intending to be rude to any one specific person... I'm just pissed off. I believe I have good reason to be, do I not?

bpat1434

The reason for the editing of your post was language and general color of your post. It's one thing to be upset, it's another to point it to a community that is undeserving of it.

Okay, so some trouble-shooting steps.

Where is php looking for the extensions? Is it an absolute path or relative? (absolute: C:/program files/php/ext; relative: ./ext)
How did you install PHP? The php.net .exe installer or the zip file?
Did you add the path to PHP to the Windows path?
How did you install MySQL? With all the default options?
Did you add mySQL to the Windows path?
What version of IIS are you using?

bradgrafelman

It's hard to diagnose this specific problem because it's hard to understand exactly what was done thus far, nevertheless I'll do my best. Like bpat above, I, too, have gone through the process many times before, so it's at least possible - we just have to figure out what's missing with your installation.

I'm just going to make a list of things that commonly go wrong, so let me know if any of the following apply to your situation:

Didn't add the main PHP folder (e.g. c:\php) to the system's PATH environment variable.
Didn't add the PHPRC environment variable to point to the main PHP directory.
Didn't uncomment the apporpriate line in php.ini (e.g. either the php_mysql.dll or php_mysqli.dll line).
Didn't restart Windows (not just IIS, due to the system changes) after making the above changes.
Didn't enable display_startup_errors and restart IIS to see if PHP is complaining of any errors.

Also, if you make any change in php.ini (e.g. change display_startup_errors from Off to On) and restart IIS, does a phpinfo() reflect the new value (check before and after the change)?

EDIT: Looks like bpat and I were typing at the same time. :p

beo27

bpat1434;10913305 wrote:
The reason for the editing of your post was language and general color of your post. It's one thing to be upset, it's another to point it to a community that is undeserving of it.

Understood.

Where is php looking for the extensions? A: "C:\php\ext" (absolute)
How did you install PHP? The php.net .exe installer or the zip file? A: Both and more. I used the PHP for IIS installer, as well as the zip file and "essentials" installer for php.net. I additionally swapped the binary applications and dll's (seperately , for obvious reasons), to see if a different version of mysql ext would help - no luck.
Did you add the path to PHP to the Windows path? A: Definitely. Via Right-Click on My Computer->Advanced->Env Vars button.
How did you install MySQL? With all the default options? A: Absolutely default. I even tried "Standard Configuration" option (which uses a default my.ini). MySQL is running perfectly by the way.
Did you add mySQL to the Windows path? A: No, but I just now tried that, and no change.
What version of IIS are you using? A: I believe the Vista version is 7, so my version must then be version 6.0. (Right off the win xp pro cd, no updates aside SP3, granted not POST-php).

I appreciate your leniency with my poor attitude, bpat, as well as your help.

@
1. Didn't add the main PHP folder (e.g. c:\php) to the system's PATH environment variable.
This one is good to go.
2. Didn't add the PHPRC environment variable to point to the main PHP directory.
I'm unsure if I have done this or not, because I'm not sure I understand the question. Perhaps not doing this, could be the culprit?
3. Didn't uncomment the apporpriate line in php.ini (e.g. either the php_mysql.dll or php_mysqli.dll line).
php_mysql.dll is the current one being used, however I have tried the Lite version as well. I even downloaded a trial of MS SQL to see if that extension worked, and it did.
4. Didn't restart Windows (not just IIS, due to the system changes) after making the above changes.
Done this many times, also formatted the drive and put a fresh Win XP Install.
5. Didn't enable display_startup_errors and restart IIS to see if PHP is complaining of any errors.
I don't think there was a point in time that I didn't have it enabled, to be honest lol. It just doesn't tell me anything, unfortunately. 🙁

Also, if you make any change in php.ini (e.g. change display_startup_errors from Off to On) and restart IIS, does a phpinfo() reflect the new value (check before and after the change)?
Changes are reflected yes.

I have a VNC server up if one of you are willing to take a look at it. I'm dead serious, this has to be the worst encounter with PHP I have ever had.... I am seriously about to bust out OllyDebug and see what's going on..

Additional Info:
O/S: Win XP Pro ( of course)
Server Type: Local @ Home
For your convenience(ie. Temporary):
[indent]URL for phpinfo(): http://treva.servebeer.com/site/php.php
The php.ini file: http://treva.servebeer.com/php.ini
MSN Messenger (To VNC into server): (MOD EDIT: E-mail removed) (MSN Live "Alias" - just type it in for success)[/indent]

I look forward to any responses.

bpat1434

At this point, I want to ask a few extra questions (take no offense to these):

Why do you want to use IIS 7?
Is there a reason you're required to use Windows (any version) for the server?
Would you totally be turned off to using Ubuntu Server or CentOS or FreeBSD?

I ask because many times while people may feel more familiar with IIS, it's not always the "best" server. If you want windows but don't need IIS, I'd suggest using Apache (or LightTPD) instead of IIS. Easier to setup and control 😉

If you don't need Windows (or IIS) then I'd suggest running Ubuntu Server or CentOS (CentOS is the Red Had Enterprise Linux "free" version). I'm running an Ubuntu server at home and it's working great for what I need (development and testing).

WIth a Linux setup I can help (security not so much, but getting things up and running I can do).

cahva

If you really dont need IIS, just install WAMP or XAMP. They will setup you with Apache, Mysql and PHP for windows with no hassle.

bpat1434

While I applaud the efforts of WAMP and XAMP, I'm not particularly fond of them. When I attempted to use them (and this was years ago) I couldn't ever get them working just right. But spending 20 minutes installing Apache, PHP, and MySQL myself totally worked out better.

bradgrafelman

Since it doesn't sound like we're getting anywhere, I'll volunteer to take a look at the server itself. beo27; I'll contact you on MSN sometime you're online. PM me if you'd rather setup a specific time.

bpat1434

I tried to do the vpn last night; however, every time I logged on, it killed my current X session... so I had to give up.