PHP 5.3 and MySQL: A connection attempt failed because the connected party did not properly respond after a period of time…

Having difficulty connecting to MySQL through PHP 5.3.x? Know that MySQL and PHP are properly configured? Using Windows Vista / 7? The problem may very well be that you’re connecting to ‘localhost.’ According to Joe Bedan, simply changing ‘localhost’ to ‘127.0.0.7’ will fix the problem, and he’s right!

According to another forum post, this is because Vista/7 does some goofy stuff with the ‘localhost’ alias. This person suggests that modifying the C:\Windows\System32\drivers\etc\hosts file to contain the line ‘127.0.0.1 localhost’ will fix the problem (make sure to do this as an administrator!). Unfortunately, this wasn’t the case for me. However, it’s worth a shot for anyone experiencing this problem.


–Adam

Lack of Rear-Panel Audio in OEM Motherboards

For the other two people on the planet that have rescued HP, Dell, or other OEM motherboards from their stock cases, you might have noticed that the rear-panel audio jack on the motherboard stopped working. Apparently, some motherboards (an HP dC7100 CMT in my case) will turn off the rear-panel audio jack if the front-panel audio connector is disconnected. As it turns out, this is actually quite an easy fix.

According to Intel’s official front-panel connector specifications (see attached screenshot for a jumper layout), the motherboard uses pins 5, 6, 7,9 and 10 to detect whether or not the front-panel audio jack is connected to the system.  To bypass the need for the front-panel connector, simply short pin 5 to pin 6 and pin 7 to pins 9 and 10 using some solder.  After that, you should be solid.

–Adam