How to set up a server with Apache , PHP , MySQL , Perl , phpMyAdmin

Let's start by installing apache (http server).

you can download the apache installer on www.apache.org.

download the verion you like ,even thought,in win systems i recomand version 2 (this tutorials is for apache 2). here is a link for it :

Code:

http://apache.mirror.nedlinux.nl/

dist/httpd/binaries/win32/apache_2.0.52-win32-x86-no_ssl.msi
for a faster mirror :

visit http://httpd.apache.org/download.cgi.

After downloading the file (.msi installer),run it.

The installation wizard is a next , next , finish 'work' ... The installer will ask you some details like your server name , your server adress and the admin's mail adress . if you have a domain name or a hostname , enter the info's like this :

Code:
Server Name : your_domain.org
Server Adress : www.your-domain.org
Admin Email : admin@yourdomain.org
if you don't have one , you should get on e free at :
Code:
http://www.no-ip.org/

Check the 'Run as a service for all users on port 8080' option and click next , finish to fiinish the instllation. Advice : Install it in c: (he creates a folder for it , don't worry) to make sure you configure it easyer . If you are finished , open up a browser and write in the adress bar :
Code:
http://localhost/
If you will see a 'Test Page for Apache Installation',everything works .Let's install PHP. download the archives from www.php.net . Here is a direct link for verion 4.3.9 :

Code: http://nl.php.net/get/php-4.3.9-Win32.zip/from/this/mirror

Make sure you download the archive and not the installer.Ok! after downloading it , extract the archive in c:/php (this is to simplify paths).Now , open up c:/apache/conf/httpd.conf and search for this line:
Code:
#LoadModule ssl_module modules/mod_ssl.so
under that line , add this :

Code:

LoadModule rewrite_module modules/mod_rewrite.so
LoadModule php4_module "c:/php/sapi/php4apache2.dll"
AddType application/x-httpd-php .php
AddType application/x-httpd-php .php3
AddType application/x-httpd-php .php4

Now search for this line :
Code:
Change :
Code:
Options Indexes FollowSymLinks
#
# AllowOverride controls what directives may be placed in .htaccess files.
# It can be "All", "None", or any combination of the keywords:
# Options FileInfo AuthConfig Limit
#
AllowOverride None

into :
Code:
Options Indexes Includes FollowSymLinks MultiViews ExecCGI
#
# AllowOverride controls what directives may be placed in .htaccess files.
# It can be "All", "None", or any combination of the keywords:
# Options FileInfo AuthConfig Limit
# AllowOverride All

This will allow .htaccess support on your server and make sure you can see the content of a folder without getting a 403 forbidden error .
Now search for :
Code:
DirectoryIndex index.html index.var.html
and change it into :
Code:
DirectoryIndex index.html index.php

Save the file and restart apache . (you can restart it by pressing the Restart apache server shortcut in the start menu or by writing :
Code: net apache restart
in a command prompt window . Ok!

you have php working for your server icon_wink.gif . Now let's configure php and make sure it really works ! Open up c:/php/php.ini (php.ini-dist renamed) and search for this paragraph :
Code: max_execution_time = 60 ; Maximum execution time of each script, in seconds
max_input_time = 60 ; Maximum amount of time each script may spend parsing request data
memory_limit = 5M ; Maximum amount of memory a script may consume (8MB)
you should change this to whatever you want . here is an option i use :
Code:

max_execution_time = 300 ; Maximum execution time of each script, in seconds
max_input_time = 300 ; Maximum amount of time each script may spend parsing request data
memory_limit = 5M ; Maximum amount of memory a script may consume (8MB)

Now search for :
Code: register_globals = Off
and change it into :
Code: register_globals = On
Search for :
Code: extension_dir = ".\"
and change it into :
Code:extension_dir = "c:/php/extensions"
assuming you have installed php in c: ...
Search for :
Code:

;Windows Extensions
;Note that MySQL and ODBC support is now built in, so no dll is needed for it.and uncomment (delete the ; in the front) the following modules :

Code: extension=php_bz2.dll
extension=php_db.dll
extension=php_gd2.dll
extension=php_java.dll
extension=php_msql.dll
extension=php_pdf.dll
extension=php_pgsql.dll
extension=php_sockets.dll

Ok! now let's change the smtp settings (this is good icon_smile.gif for you mail()
function . you need this !!!) Search for :

Code: [mail function]
; For Win32 only.
SMTP =
smtp_port = 25

; For Win32 only.
;sendmail_from =

and change to :
Code: [mail function]
; For Win32 only.
SMTP = mail.isp.org
smtp_port = 25

; For Win32 only.
sendmail_from = mail@your_domain.org

if you don't have a mail server or :

Code:[mail function]
; For Win32 only.
SMTP = localhost
smtp_port = 25

; For Win32 only.
sendmail_from = mail@your_domain.org

if you have a mail server ...

Save the files . Now let's finalize the php installation . copy all the dll's
from c:/php/dlls into c:/windows/system32 . copy c:/php/php4ts.dll into
c:/windows/system32/ and copy php.ini from your folder php into
windows and system32 folder . restart apache . open up notepad and
add this into the file :

Code: save this file in your htdocs folder (c:/apache/htdocs) as info.php and
open up a browser . in the adress bar write :

Code:http://localhost/info.php

you should see php's configuration in a table . a looong file icon_smile.gif
you can optionaly install zend optimizer . i am using it ... it doesn't
needs a tutorial . to install the PEAR modules for php , just run the
go-pear batch from the php folder and 2click the reg file to finish the
instAllation .

let's install mysql . download mysql from http://www.mysql.com/ .this tutorial applyes to verion 4.0.* ... i don't recomand using mysql 4.1 . here is a direct link :

Code: http://dev.mysql.com/get/Downloads/MySQL-4.0/mysql-4.0.22-win.zip/from/http://mysql.proserve.nl/

after downloading , extract the arhive somewhere and run the setup.exe . install mysql in c:/mysql and complete the installation . open up command prompt and write this :

Code: cd mysql
cd bin
mysqld-max-nt --install

this will install mysql as a service . recomended . now you would probably consider downloading mysql control center . a gui tool to administrate the server in a graphical mode . here is a link :

Code:http://dev.mysql.com/get/Downloads/MySQLCC/mysqlcc-0.9.4-win32.zip/from/http://mysql.proserve.nl/

install it like any other program and run the shortcut in the desktop . a window will pop-up . it will ask you to add a new connection . here are the info's you need to fill in :

Code:

name : localhost or main or whatever :)
host : localhost
user : root
pass :

click add , expand the databases menu and delete databse text . now expand the users menu and delete all users except root@localhost . right click it and select edit user . change it's password to whatever you want icon_smile.gif now right click the server and select edit . change the password to the pass you chosed for user root . as easy as that . mysql is installed !
=====
phpMyADmin . you can download it from http://www.phpmyadmin.net/ . i recommend using verion 2.5.1 pl1 . the last verion is still bugy icon_smile.gif download , unzip the contecnt into a folder in htdocs (phpMyAdmin) and open up config.inc.php with a text editor .

search for :
Code:
$cfg['PmaAbsoluteUri'] = '';

change it to your phpmyadmin url . eg. :
Code:
$cfg['PmaAbsoluteUri'] = http://www.your_domain.org/phpMyAdmin/';
now search for :
Code:
$cfg['blowfish_secret'] = '';
and change it to your mysql root password like this :
Code:
$cfg['blowfish_secret'] = 'password';
now search for :
Code:
$cfg['Servers'][$i]['auth_type'] = 'config';
and change it to :
Code:
$cfg['Servers'][$i]['auth_type'] = 'cookie';
save and exit . that's it ! phpMyAdmin works icon_wink.gif
=====
Perl . Optioanl for your server , very usefull . i recomend you to install it . you can download it from http://www.activestate.com/ . here is a direct link :
Code:
http://downloads.activestate.com/ActivePerl/Windows/5.8/ActivePerl-5.8.4.810-MSWin32-x86.msi download , install and you are ready . put your perl scripts in the /cgi-bin/
folder (c:/apache/cgi-bin) .
=====
Hope this helped , you're welcome . No , you don't need to pay ...

Source:

(http://www.4shared.com/get/37302200/35cbd553/

How_to_set_up_a_server_with_Apache__PHP__MySQL__Perl__phpMyAdmin.html)

Peluang Bisnis Untuk Anda