Apache php mysql setup
Tech-Today

Apache php mysql setup


Everytime I setup a new unit I have to set the following up and it takes time. So I'm writing a walkthrough and hopefully I don't need to debug :-D.

Before we begin you must download and install/extract the following:
1.) apache - http://httpd.apache.org/download.cgi
2.) php (zipped) - http://php.net/downloads.php
3.) mysql - http://dev.mysql.com/downloads/

I override the default setup and installed in the c drive:
apache - C:\Apache2.2
mysql - C:\mysql51
php - C:\php-5.2.14

Install in order:
1.) mysql - run the installer and select the configuration that you want. Just don't forget to set the installation directory to c: drive.

2.) php - using the zipped installer, extract in c: drive.
Changes you should made with C:\php-5.2.14\php.ini
a.) rename php.ini-recommended to php.ini
b.) set the following:
i.) extension directory: extension_dir = "C:\php-5.2.14\ext"
ii.) upload directory: upload_tmp_dir = "C:\php-5.2.14\uploads"
iii.) upload size: upload_max_filesize = 16M
iv.) session directory: session.save_path = "C:\php-5.2.14\sessions"
c.) uncomment the extensions you need
i.) ;extension=php_mysql.dll -> extension=php_mysql.dll

3.) apache - I've used the installer version for this setup (not zipped)
You can name you server localhost
a.) server root should be: ServerRoot "C:/Apache2.2"
b.) port: Listen 80
c.) the most important, after the series of LoadModules, copy and paste these lines:

PHPIniDir "C:/php-5.2.14"
LoadFile "C:/php-5.2.14/php5ts.dll"
LoadModule php5_module "C:/php-5.2.14/php5apache2_2.dll"
AddType application/x-httpd-php .php

*The above lines set tells apache where to find php.ini, load the the php dll and module.
And add handler to .php file type.
d.) there are 2 instances of document root you should set them (mine is c:\cgipages):
i.) DocumentRoot "C:/cgipages" (find the other instance)
e.) to add a virtual directory:
i.) in this section <IfModule alias_module> add a line similar to:
Alias /webpath /full/filesystem/path
-> Alias /virtualroot "C:/Projects/eclipse/eclipse-helios-php/virtualroot"
ii.) now this is important, you must give apache/php right to the directory via:

<Directory "C:/Projects/eclipse/eclipse-helios-php/virtualroot">
AllowOverride None
Options None
Order allow,deny
Allow from all
</Directory>


Common Problems:
-The connection was reset
->Just copy libmysql.dll from php folder to apache/bin




- How To Install And Setup Magento On A Windows 7 Machine
This tutorial will try to install and setup magento on a local pc running windows 7.  Requirements (I'm using the following versions, you can search the download links using google - lame :-) ): 1.) apache2.2 2.) php-5.2.14 3.) MySQL Server 5.5...

- Solving The Php Startup: Unable To Load Dynamic Library Bug
Okay first I'm no expert in apache or php but I guess writing about this bug might help someone. Yes I've installed perhaps tens of times apache php mysql, but everytime I did I encountered several errors, like the error defined above. Well first...

- Php Extension "curl" Must Be Loaded - Php Warning: Php Startup: Unable To Load Dynamic Library 'c:\\php-5.2.14\\ext\\php_curl.dll' - The Specified Mo
I've recently setup apache/php/mysql (separate installs) on a new laptop which is powered by Windows 7 and would like to setup magento. I encountered an old familiar problem which I forgot long time ago. So I'm blogging the solution now so next...

- Phpmyadmin - The Connection Was Reset . The Connection To The Server Was Reset While The Page Was Loading
Error: The connection was reset The connection to the server was reset while the page was loading. * The site could be temporarily unavailable or too busy. Try again in a few moments. * If you are unable to load any pages, check your computer's...

- Magento 1and1 Vps Setup - Setting Up The Vps Settings
Magento 1and1 VPS Setup - Setting up the VPS settings At this point it is assumed that a VPS Domain is properly setup. Although the magento check : http://www.magentocommerce.com/knowledge-base/entry/how-do-i-know-if-my-server-is-compatible-with-magento...



Tech-Today








.