Saturday, July 14, 2007

Setting up Apache, PHP, MySQL under Vista

Update 7-22-07:

For some reason, and I’m not sure why, I wasn’t able to get MySQL to work with PHP. PhP was working, and MySQL was working from the command prompt, but php was not loading the the mysql dll, or not loading it properly. I tried many different scenarios to get it work and finally gave up. I uninstalled Apache, PhP and MySQL and downloaded WAMP5 (www.wampserver.com). WAMP is an installer that installs Apache, MySQL and PHP so that they all work together right from the start. After spending 3 days trying to Install those on my own, I used WAMP and was up and running in 15 minutes. Once installed you can make changes to the httpd.conf, php.ini and mysql as you normally would to customize it for yourself. However, you may still need to disable UAC, but I’m not sure about this.

If you would still like to manually install php/mysql/apache on vista then check out the post below which got php and apache running just fine. If you get MySQL to work with PhP on Vista, I would love to hear how you did it!

Disable User Account Control (UAC) and never look back!

As I mentioned in my last post, I now have Vista Home (for good or bad, it came with my new laptop). First thing I must say is if you have a working system on XP, unless you have a specific NEED to upgrade to Microsoft Vista, then Don’t. It has been a troublesome experience for me and now that I have everything working pretty well, there are still little unexplained annoyances (i.e., explorer.exe crashes about once every day or two for no apparent reason, though it does start right back up in about 30 seconds and doesn’t effect my other open programs).

That being said, if you do have Vista and are installing (or planning to install) a web server (especially the Apache/PhP/MySQL variety) than the first thing you should do to eliminate at least half of your head-aches is to disable User Account Control. There are many different ways of turning this off and you can find them described here:
http://www.petri.co.il/disable_uac_in_windows_vista.htm

Once you have done this, you should have no problem installing Apache the way you are familiar with (I’m not going to get into that here). Now you are ready to install php.

Install PhP under Apache and Vista:

If you have disabled User Account Control and have successfully installed Appache then check out the step-by-step instructions here:
http://senese.wordpress.com/2007/06/06/install-php-5-under-apache-22-and-windows-vista/

I follwed that procedure from start to finish (after removing my innitial php install attempt) and was up and running with no problems.

I am now working on installing MySQL and if anything weird should come up, I’ll add it to this post.

~Billy Flaherty
Website Developer
www.billyswebdesign.com

Posted by Billy at 05:19:54 | Permalink | Comments (8)

Thursday, July 12, 2007

Running multiple versions of IE on Vista

I recently began using windows Vista which comes pre loaded with Internet Explorer 7. As most web developers know, to produce a quality site that works on all current browsers you need to test on multiple versions of Internet Explorer. On XP you could use standalone versions of of older IE versions (including IE6 and down) along side of IE7. However, the standalone installations of IE do not work on Vista. I did find a solution but it is a bit more involved.

First off, if you are running XP and want the easy to install standalone versions of IE, check them out at evolt.

A solution:

The team at IE Blog have generously provided a hard disk image of a windows XP installation (with IE 6) which you can use.

  1. First download and install Microsoft virtual PC (its free)
  2. Next, head over to IEBlog and get the image here. The file is a whopping 450mb, so put your feet up and wait. If your on dial-up, give up.
  3. Run virtual PC and set up a new machine (the process is pretty self explanatory). Use the XP image you just downloaded.
  4. Run the system, you now have access to IE 6

Thats IE6 out of the way, what about the rest?

  • IE7 - Your on vista, so you have it!
  • IE6 - On your virtual PC
  • IE5/IE5.5 - Copy the standalone version (found at evolt) to your virtual PC (drag and drop, easy!)
  • Fix conditional comments on the virtual machine, by going start > run and typing regedit. Find HKLMSOFTWAREMicrosoftInternet ExplorerVersion Vector and rename the ‘IE’ key to ‘zIE’. Conditional comments will now function in the standalone versions.

Like I said, not the easiest, but it works!

~Billy Flaherty
Website Developer
www.billyswebdesign.com

Posted by Billy at 22:20:55 | Permalink | Comments (7)

Hello World

Greetings!

This is my first entry for my web design blog which will chronicle problems and solutions I come across, updates on current design projects and other random bits of information/news (Transformers anyone?) to keep things interesting. All work and no play is no way to stay creative and productive!

~Billy Flaherty
Website Developer
www.billyswebdesign.com

Posted by Billy at 21:26:09 | Permalink | Comments (1) »