WAMP Server Install - Revision history

Sstrutt: /* MySQL */ Minor tweak to procedure

2012-07-03T09:11:49Z

MySQL: Minor tweak to procedure

← Older revision		Revision as of 09:11, 3 July 2012
Line 61:		Line 61:

	=== MySQL ===		=== MySQL ===
	* <code> mysql-installer-5.5.23.0.msi </code>		* EG <code> mysql-installer-5.5.23.0.msi </code>
	# Select '''Install MySQL Products''' and click '''Next'''		# Select '''Install MySQL Products''' and click '''Next'''
	# Accept the GPL and click '''Next'''		# Accept the GPL and click '''Next'''
	# Check for newer updates (if you have internet access)		# Check for newer updates (if you have internet access)
	# Select the '''Custom''' setup type, and click '''Next'''		# Select the '''Custom''' setup type, update the installation path if you require, and click '''Next'''
	#* Tick '''MySQL Server''' to install the core database components		#* Tick '''MySQL Server''' to install the core database components
	#* Tick '''MySQL Workbench'' to install the GUI admin console (optional, can be installed on local desktop instead, if at all)		#* Tick '''MySQL Workbench'' to install the GUI admin console (optional, can be installed on local desktop instead, if at all)

Sstrutt: Formatting and Meta

2012-05-16T15:35:14Z

Formatting and Meta

Sstrutt: Added WIMP link

2012-05-02T15:12:48Z

Added WIMP link

← Older revision		Revision as of 15:12, 2 May 2012
Line 1:		Line 1:
	Windows, Apache, MySQL and PHP ([http://www.wikipedia.org/wiki/WAMP WAMP]) install guide for a Windows 2008 64bit server.		'''Windows, Apache, MySQL and PHP ([http://www.wikipedia.org/wiki/WAMP WAMP]) install guide for a Windows 2008 64bit server.'''
			For Windows, IIS, MySQL and PHP (WIMP) see http://blogs.iis.net/bills/archive/2006/09/19/How-to-install-PHP-on-IIS7-_2800_RC1_2900_.aspx

	Whilst this guide intends to be as generic as possible, it is disingenuous to suggest that you can blindly follow the procedures below, for different versions of the software components than were used here, and expect it all to work. I have included the install package filenames that I used, which normally exactly identifies the variant and version I've used (Microsoft supplied packages are the exception, as they like to keep to guessing). Installing LAMP takes seconds (well minutes), installing WAMP constantly reminds you that you're trying to fit a round peg into a square hole, and that it would probably be quicker and easier to learn Linux (its what made me first tinker with [[:Category:Ubuntu\|Ubuntu]]).		Whilst this guide intends to be as generic as possible, it is disingenuous to suggest that you can blindly follow the procedures below, for different versions of the software components than were used here, and expect it all to work. I have included the install package filenames that I used, which normally exactly identifies the variant and version I've used (Microsoft supplied packages are the exception, as they like to keep to guessing).

			Installing LAMP takes seconds (well minutes), installing WAMP constantly reminds you that you're trying to fit a round peg into a square hole, and that it would probably be quicker and easier to learn Linux (its what made me first tinker with [[:Category:Ubuntu\|Ubuntu]]).

	There are numerous [http://en.wikipedia.org/wiki/Comparison_of_WAMPs install bundles] that can supposedly do the job for you, they're always a little out of date, and [http://www.php.net/manual/en/install.windows.php none are endorsed by PHP]. I'm not saying don't consider them, but just do it in a well thought out way.		There are numerous [http://en.wikipedia.org/wiki/Comparison_of_WAMPs install bundles] that can supposedly do the job for you, they're always a little out of date, and [http://www.php.net/manual/en/install.windows.php none are endorsed by PHP]. I'm not saying don't consider them, but just do it in a well thought out way.

Sstrutt: Added Apache category

2012-04-18T17:20:40Z

Added Apache category

← Older revision		Revision as of 17:20, 18 April 2012
Line 140:		Line 140:
	#* If not, check the MySQL service is started (if not check the Windows System Event Logs)		#* If not, check the MySQL service is started (if not check the Windows System Event Logs)

			[[Category:Apache]]
	[[Category:Installation]]		[[Category:Installation]]
	[[Category:MySQL]]		[[Category:MySQL]]
	[[Category:Windows_2008]]		[[Category:Windows_2008]]

Sstrutt: Initial creation

2012-04-18T17:19:16Z

Initial creation

New page

Windows, Apache, MySQL and PHP ([http://www.wikipedia.org/wiki/WAMP WAMP]) install guide for a Windows 2008 64bit server.

Whilst this guide intends to be as generic as possible, it is disingenuous to suggest that you can blindly follow the procedures below, for different versions of the software components than were used here, and expect it all to work. I have included the install package filenames that I used, which normally exactly identifies the variant and version I've used (Microsoft supplied packages are the exception, as they like to keep to guessing). Installing LAMP takes seconds (well minutes), installing WAMP constantly reminds you that you're trying to fit a round peg into a square hole, and that it would probably be quicker and easier to learn Linux (its what made me first tinker with [[:Category:Ubuntu|Ubuntu]]).

There are numerous [http://en.wikipedia.org/wiki/Comparison_of_WAMPs install bundles] that can supposedly do the job for you, they're always a little out of date, and [http://www.php.net/manual/en/install.windows.php none are endorsed by PHP]. I'm not saying don't consider them, but just do it in a well thought out way.

= Downloads =
The following are required to complete an installation.

== Apache ==
Don't download Apache from apache.org, these have not been compiled with the latest Microsoft Visual Studio compiler (VC10), and so do not have the improvements in stability and performance that that provide, and more importantly, are not compatible with the latest VC9 compiled PHP binaries (so will restrict you to older versions).

Download the latest required installers from http://www.apachelounge.com/download/
* '''Apache 2.4 Win32 binary'''
** EG <code> httpd-2.4.2-win32.zip </code>
* '''PHP Handler''' (needs to be the right version for version of PHP)
** EG <code> php5apache2_4.dll-php-5.4-win32.zip </code>

Prerequisites which also need to be downloaded...
* '''Microsoft Visual C++ 2010 SP1 Redistributable Package (x86)''' (VC10), from http://www.microsoft.com/download/en/details.aspx?id=8328
** Rename <code> vcredist_x86.exe </code> to <code> vcredist_x86-2010.exe </code>

== PHP ==
Download the latest thread-safe ZIP package from http://windows.php.net/download/
* '''PHP VC9 x86 Thread Safe'''
** EG <code> php-5.4.0-Win32-VC9-x86.zip </code>

Prerequisites which also need to be downloaded...
* '''Microsoft Visual C++ 2008 SP1 Redistributable Package (x86)''' (VC9), from http://www.microsoft.com/download/en/details.aspx?id=8328
** Rename <code> vcredist_x86.exe </code> to <code> vcredist_x86-2008.exe </code>

== MySQL ==
Download the compete package from http://www.mysql.com/downloads/installer/
* '''MySQL Installer'''
** EG <code> mysql-installer-5.5.23.0.msi </code>

Note that whilst the page states its a 32bit package, on installing the core MySQL Server will be 64bit.

Prerequisites which also need to be downloaded...
* '''.NET Framework v4.0''', from http://go.microsoft.com/fwlink?LinkId=181012 (ignore any additional guff that Microsoft suggest you donwload).
** EG <code> dotNetFx40_Client_setup.exe </code>
** Note that this is just a downloader, it doesn't actually include .NET, if the machine you are installing to doesn't have internet access, download from here http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=24872 instead, EG <code> dotNetFx40_Client_x86_x64.exe </code>

= Installation =
If installing on a Virtual Machine, take a Snapshot 1st, and maybe even at regular intervals once you're happy each component is properly installed.

This procedure assumes you already have a fully working Windows 2008 server, and will install software files to the C:\ drive, with data and website files being located on D:\.

== Pre-Requisite Components ==
# Install Microsoft Visual C++ Redistributable Packages
#* <code> vcredist_x86-2008.exe </code>
#* <code> vcredist_x86-2010.exe </code>
# Install Microsoft .NET Framework 4.0
#* Either <code> dotNetFx40_Client_setup.exe </code> (donwloader)
#* Or <code> dotNetFx40_Client_x86_x64.exe </code> (full-fat installer)
# Perform a Windows Update to ensure all components are up to date

== MySQL ==
* <code> mysql-installer-5.5.23.0.msi </code>
# Select '''Install MySQL Products''' and click '''Next'''
# Accept the GPL and click '''Next'''
# Check for newer updates (if you have internet access)
# Select the '''Custom''' setup type, and click '''Next'''
#* Tick '''MySQL Server''' to install the core database components
#* Tick '''MySQL Workbench'' to install the GUI admin console (optional, can be installed on local desktop instead, if at all)
#* Tick '''MySQL Connectors / Connector/NET''' to install the .NET connector (required for PowerShell support, PHP installs its own connector)
# Confirm pre-requisites are met and click '''Next'''
# Click '''Next''' for installation to complete
# Click '''Next''' to proceed with MySQL Server configuration to take place
#* Select '''Server Machine'''
#* '''Enable TCP/IP networking''' only if remote database connections are required (a remote MySQL Workbench session requires this)
#* Leave '''Create Windows Service''' checked
#* Enter a good root password
# Click '''Next''' and '''Finish''' to exit installer
# Move databases to seperate drive (optional)
## Create new folder
##* EG <code> D:\MySQL\data </code>
## Stop the database service, MySQL55
## Edit the config file <code>C:\ProgramData\MySQL\MySQL Server 5.5\my.ini</code>
## Change the <code>datadir</code> parameter appropriately
##* EG <code>datadir="D:\MySQL\data\"</code>
## ''Copy'' the contents of <code>C:\ProgramData\MySQL\MySQL Server 5.5\data\</code> accross to <code>D:\MySQL\data\</code>
## Rename <code>C:\ProgramData\MySQL\MySQL Server 5.5\data\</code> to <code>C:\ProgramData\MySQL\MySQL Server 5.5\data-old\</code>
## Start the database service
## Assuming the service starts, delete <code>C:\ProgramData\MySQL\MySQL Server 5.5\data-old\</code>

== Apache ==
* <code> httpd-2.4.2-win32.zip </code>
# Uncompress the file, and move the <code>Apache24</code> folder to <code>C:\Program Files (x86)\</code>
# Create a folder for your web root, and copy across the <code>C:\Program Files (x86)\Apache24\htdocs\index.html</code> file
#* <code> D:\Apache\htdocs </code>
# Edit the <code>C:\Program Files (x86)\Apache24\conf\http.conf</code> and change
#* NOTE: Apache paths must use <code>/</code> as folder seperators, not <code>\</code> !!
#* <code> ServerRoot "C:/Program Files (x86)/Apache24" </code>
#* <code> ServerAdmin admin@domain.com </code> (to something appropriate for your environment)
#* <code> DocumentRoot "D:/Apache/htdocs" </code>
#* <code> <Directory "D:/Apache/htdocs"> </code> (should match <code> DocumentRoot </code> directive)
# Install as a service, from a command prompt...
#* <code> cd "c:\Program Files (x86)\Apache24\bin" </code>
#* <code> httpd.exe -k install </code>
# You should now be able to browse to the server (http://yourserver), and get a basic "It works!" page back, in case of errors, double check your config file, and check the Windows Application log

== PHP ==
* <code> php-5.4.0-Win32-VC9-x86.zip </code>
# Uncompress the file, move the resultant folder to <code> C:\Program Files (x86)\ </code>, and rename to <code>PHP</code>
# Extract the <code>php5apache2_4.dll</code> file from <code> php5apache2_4.dll-php-5.4-win32.zip </code> and move to <code> C:\Program Files (x86)\PHP\ </code>
# Rename <code>C:\Program Files (x86)\PHP\php.ini-production</code> to <code>C:\Program Files (x86)\PHP\php.ini</code>
# Update the PHP config (<code>C:\Program Files (x86)\PHP\php.ini</code>)
#* <code> extension_dir = "C:\Program Files (x86)\PHP\ext" </code>
#* <code> date.timezone = Europe/London </code> - use the appropriate location from http://php.net/date.timezone
# Update the Apache config (<code>C:\Program Files (x86)\Apache24\conf\http.conf</code>), add the following
#* <code> # PHP Handler</code>
#* <code> LoadModule php5_module "C:/Program Files (x86)/PHP/php5apache2_4.dll"</code>
#* <code> AddHandler application/x-httpd-php .php</code>
#* <code> PHPIniDir "C:/Program Files (x86)/PHP"</code>
# Restart the Apache, in case of errors, double check your config file, and check the Windows Application log

= Testing and Troubleshooting =
In order to test your install, you need 3 files in your <code>D:\Apache\htdocs</code> folder
* '''<code>index.html</code>'''
** Comes with Apache, copy across from <code>C:/Program Files (x86)/Apache24/htdocs </code> if it doesn't exist
* '''<code>phpinfo.php</code>'''
** Create the file, with the following single line contents: <code><?php phpinfo(); ?></code>
* '''<code>mysqltest.php</code>'''
** Create the file with contents as per [[PHP MySQL Test Script]]
<br>
In each of the following tests there are really only two places to look for errors if they don't appear in the browser window...
* Apache log - <code>C:\Program Files (x86)\Apache24\logs\error.log</code>
* Windows System and Application Event Logs - Found in Server Manager | Diagnostics
<br>
# Browse to http://yourserver
#* You should get a basic '''It Works!''' page, this will confirm that Apache is installed and working
#* If not, check that the Apache service is started, and for any errors in the Windows System and Application event logs
# Browse to http://yourserver/phpinfo.php
#* You should get a page detailing the PHP install
#*# Check that that there is a section for <code>mysql</code> (not <code>mysqlnd</code>), which confirms that the MySQL module is being loaded. If not, in a Command prompt, cd to <code>"C:\Program Files (x86)\PHP" </code> and run <code>php -m</code> which will confirm which modules are being loaded, and hopefully an error as to why <code>mysql</code> isn't.
#* If not, check the Apache error log
# Browse to http://yourserver/mysqltest.php and enter the password for your MySQL root account
#* You should get a page listing the default databases
#* If not, check the MySQL service is started (if not check the Windows System Event Logs)

[[Category:Installation]]
[[Category:MySQL]]
[[Category:Windows_2008]]

← Older revision		Revision as of 15:35, 16 May 2012
Line 1:		Line 1:
	'''Windows, Apache, MySQL and PHP ([http://www.wikipedia.org/wiki/WAMP WAMP]) install guide for a Windows 2008 64bit server.'''		'''Windows, Apache, MySQL and PHP ([http://www.wikipedia.org/wiki/WAMP WAMP]) install guide for a Windows 2008 64bit server.'''

	For Windows, IIS, MySQL and PHP (WIMP) see http://blogs.iis.net/bills/archive/2006/09/19/How-to-install-PHP-on-IIS7-_2800_RC1_2900_.aspx		For Windows, IIS, MySQL and PHP (WIMP) see http://blogs.iis.net/bills/archive/2006/09/19/How-to-install-PHP-on-IIS7-_2800_RC1_2900_.aspx

Line 8:		Line 9:
	There are numerous [http://en.wikipedia.org/wiki/Comparison_of_WAMPs install bundles] that can supposedly do the job for you, they're always a little out of date, and [http://www.php.net/manual/en/install.windows.php none are endorsed by PHP]. I'm not saying don't consider them, but just do it in a well thought out way.		There are numerous [http://en.wikipedia.org/wiki/Comparison_of_WAMPs install bundles] that can supposedly do the job for you, they're always a little out of date, and [http://www.php.net/manual/en/install.windows.php none are endorsed by PHP]. I'm not saying don't consider them, but just do it in a well thought out way.

	= Downloads =		== Downloads ==
	The following are required to complete an installation.		The following are required to complete an installation.

	== Apache ==		=== Apache ===
	Don't download Apache from apache.org, these have not been compiled with the latest Microsoft Visual Studio compiler (VC10), and so do not have the improvements in stability and performance that that provide, and more importantly, are not compatible with the latest VC9 compiled PHP binaries (so will restrict you to older versions).		Don't download Apache from apache.org, these have not been compiled with the latest Microsoft Visual Studio compiler (VC10), and so do not have the improvements in stability and performance that that provide, and more importantly, are not compatible with the latest VC9 compiled PHP binaries (so will restrict you to older versions).

Line 24:		Line 25:
	** Rename <code> vcredist_x86.exe </code> to <code> vcredist_x86-2010.exe </code>		** Rename <code> vcredist_x86.exe </code> to <code> vcredist_x86-2010.exe </code>

	== PHP ==		=== PHP ===
	Download the latest thread-safe ZIP package from http://windows.php.net/download/		Download the latest thread-safe ZIP package from http://windows.php.net/download/
	* '''PHP VC9 x86 Thread Safe'''		* '''PHP VC9 x86 Thread Safe'''
Line 33:		Line 34:
	** Rename <code> vcredist_x86.exe </code> to <code> vcredist_x86-2008.exe </code>		** Rename <code> vcredist_x86.exe </code> to <code> vcredist_x86-2008.exe </code>

	== MySQL ==		=== MySQL ===
	Download the compete package from http://www.mysql.com/downloads/installer/		Download the compete package from http://www.mysql.com/downloads/installer/
	* '''MySQL Installer'''		* '''MySQL Installer'''
Line 41:		Line 42:

	Prerequisites which also need to be downloaded...		Prerequisites which also need to be downloaded...
	* '''.NET Framework v4.0''', from http://go.microsoft.com/fwlink?LinkId=181012 (ignore any additional guff that Microsoft suggest you ~~donwload~~).		* '''.NET Framework v4.0''', from http://go.microsoft.com/fwlink?LinkId=181012 (ignore any additional guff that Microsoft suggest you download).
	** EG <code> dotNetFx40_Client_setup.exe </code>		** EG <code> dotNetFx40_Client_setup.exe </code>
	** Note that this is just a downloader, it doesn't actually include .NET, if the machine you are installing to doesn't have internet access, download from here http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=24872 instead, EG <code> dotNetFx40_Client_x86_x64.exe </code>		** Note that this is just a downloader, it doesn't actually include .NET, if the machine you are installing to doesn't have internet access, download from here http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=24872 instead, EG <code> dotNetFx40_Client_x86_x64.exe </code>

	= Installation =		== Installation ==
	If installing on a Virtual Machine, take a Snapshot 1st, and maybe even at regular intervals once you're happy each component is properly installed.		If installing on a Virtual Machine, take a Snapshot 1st, and maybe even at regular intervals once you're happy each component is properly installed.

	This procedure assumes you already have a fully working Windows 2008 server, and will install software files to the C:\ drive, with data and website files being located on D:\.		This procedure assumes you already have a fully working Windows 2008 server, and will install software files to the C:\ drive, with data and website files being located on D:\.

	== Pre-Requisite Components ==		=== Pre-Requisite Components ===
	# Install Microsoft Visual C++ Redistributable Packages		# Install Microsoft Visual C++ Redistributable Packages
	#* <code> vcredist_x86-2008.exe </code>		#* <code> vcredist_x86-2008.exe </code>
Line 59:		Line 60:
	# Perform a Windows Update to ensure all components are up to date		# Perform a Windows Update to ensure all components are up to date

	== MySQL ==		=== MySQL ===
	* <code> mysql-installer-5.5.23.0.msi </code>		* <code> mysql-installer-5.5.23.0.msi </code>
	# Select '''Install MySQL Products''' and click '''Next'''		# Select '''Install MySQL Products''' and click '''Next'''
Line 88:		Line 89:
	## Assuming the service starts, delete <code>C:\ProgramData\MySQL\MySQL Server 5.5\data-old\</code>		## Assuming the service starts, delete <code>C:\ProgramData\MySQL\MySQL Server 5.5\data-old\</code>

	== Apache ==		=== Apache ===
	* <code> httpd-2.4.2-win32.zip </code>		* <code> httpd-2.4.2-win32.zip </code>
	# Uncompress the file, and move the <code>Apache24</code> folder to <code>C:\Program Files (x86)\</code>		# Uncompress the file, and move the <code>Apache24</code> folder to <code>C:\Program Files (x86)\</code>
Line 104:		Line 105:
	# You should now be able to browse to the server (http://yourserver), and get a basic "It works!" page back, in case of errors, double check your config file, and check the Windows Application log		# You should now be able to browse to the server (http://yourserver), and get a basic "It works!" page back, in case of errors, double check your config file, and check the Windows Application log

	== PHP ==		=== PHP ===
	* <code> php-5.4.0-Win32-VC9-x86.zip </code>		* <code> php-5.4.0-Win32-VC9-x86.zip </code>
	# Uncompress the file, move the resultant folder to <code> C:\Program Files (x86)\ </code>, and rename to <code>PHP</code>		# Uncompress the file, move the resultant folder to <code> C:\Program Files (x86)\ </code>, and rename to <code>PHP</code>
Line 119:		Line 120:
	# Restart the Apache, in case of errors, double check your config file, and check the Windows Application log		# Restart the Apache, in case of errors, double check your config file, and check the Windows Application log

	= Testing and Troubleshooting =		== Testing and Troubleshooting ==
	In order to test your install, you need 3 files in your <code>D:\Apache\htdocs</code> folder		In order to test your install, you need 3 files in your <code>D:\Apache\htdocs</code> folder
	* '''<code>index.html</code>'''		* '''<code>index.html</code>'''