apache, php, tomcat, mysql, connector/j, phpmyadmin

for lack of a no-frills installation guide for
apache, php, tomcat, mysql, connector/j, phpmyadmin
on windows 2000 / xp, i've gone through great
pains to author and test one myself.

----

installing
apache,
php,
tomcat,
mysql,
mysql connector/j,
& phpmyadmin
on windows 2000 / xp


1. apache
--------------------------------

execute apache_2.2.3-win32-x86-no_ssl.msi
network domain: localhost
server name: localhost
administrator's email address: admin@localhost
for all users, on port 80, as a service
setup type custom
install to:
change... c:\server\apache\

create directory c:\server\documentroot
create directory c:\server\sessions

edit c:\server\apache\conf\httpd.conf
change: DocumentRoot "C:/server/apache/htdocs"
to: DocumentRoot "c:/server/documentroot"
change: <Directory "C:/server/apache/htdocs">
to: <Directory "c:/server/documentroot">

restart apache

copy test.html to c:\server\documentroot

test --
http://localhost/test.html


2. php
--------------------------------

extract php-5.1.6-win32.zip to c:\server\php
make sure to 'use folder names'

copy php.ini-recommended to php.ini

edit c:\server\php\php.ini
change: ;include_path = ".;c:\php\includes"
to: include_path = ".;c:\server\php\includes"
change: doc_root =
to: doc_root = c:\server\documentroot
change: extension_dir = "./"
to: extension_dir = "c:\server\php\ext"
change: ;session.save_path = "/tmp"
to: session.save_path = "c:\server\sessions"

copy php5apache2_2.dll to c:\server\php

edit c:\server\apache\conf\httpd.conf
add: LoadModule php5_module "c:/server/php/php5apache2_2.dll"
add: AddType application/x-httpd-php .php
add: PHPIniDir "c:/server/php"
change: DirectoryIndex index.html
to: DirectoryIndex index.php index.html

restart apache

copy test.php to c:\server\documentroot

test --
http://localhost/test.php


3. tomcat
--------------------------------

execute jre-1_5_0_09-windows-i586-p.exe
custom setup
install to:
change... c:\server\jre
browser registration
uncheck both

execute apache-tomcat-5.5.20.exe
select the type of install: normal
destination folder
change to: c:\server\tomcat
password: testing
please select the path of a J2SE 5.0 JRE
change to: c:\server\jre

test --
http://localhost:8080/

start > programs > administrative tools > services
apache tomcat > properties > startup type: automatic

copy mod_jk-apache-2.2.3.so to c:\server\apache\modules
rename it mod_jk.so

edit c:\server\apache\conf\httpd.conf
add: LoadModule jk_module "c:/server/apache/modules/mod_jk.so"
add:
<VirtualHost localhost>
ServerName localhost
JkMount /*.jsp ajp13
</VirtualHost>
change: DirectoryIndex index.php index.html
to: DirectoryIndex index.php index.jsp index.html

edit c:\server\tomcat\conf\server.xml
before: <Host name="localhost" appBase="webapps"
insert:
<Realm className="org.apache.catalina.realm.UserDatabaseR ealm" />
<Listener className="org.apache.jk.config.ApacheConfig"
modJk="c:/server/apache/modules/mod_jk.so" />
change: appBase="webapps"
to: appBase="c:/server/documentroot"
before: </Host>
insert:
<Context path="" docBase="c:/server/documentroot"
reloadable="true" />

restart tomcat
restart apache

copy test.jsp to c:\server\documentroot

test --
http://localhost/test.jsp


4. mysql
--------------------------------

execute mysql-5.0.27-win32.exe
setup type custom
install to:
change... c:\server\mysql
skip sign-up
leave configure the mysql server now checked
standard configuration
service name: MySQL5
root password: testing

edit c:\server\php\php.ini
change: ;extension=php_mysql.dll
to: extension=php_mysql.dll

copy c:\server\php\libmysql.dll to c:\winnt\system32

reboot

copy testdb.php to c:\server\documentroot

test --
http://localhost/testdb.php


5. mysql connector/j
--------------------------------

extract mysql-connector-java-5.0.4.zip to c:\server
make sure to 'use folder names'
rename mysql-connector-java-5.0.4 to connector_j

copy mysql-connector-java-5.0.4-bin.jar to
c:\server\tomcat\common\endorsed

restart tomcat

copy testdb.jsp to c:\server\documentroot

test --
http://localhost/testdb.jsp


6. phpmyadmin
--------------------------------

extract phpmyadmin-2.9.1-rc2-english.zip to c:\server\documentroot
make sure to 'use folder names'
rename phpMyAdmin-2.9.1-rc2-english to dbadmin

copy config.sample.inc.php to config.inc.php

edit c:\server\documentroot\dbadmin\config.inc.php
change: $cfg['blowfish_secret'] = '';
to: $cfg['blowfish_secret'] = 'secret';
change: 'pmausr';
to: 'root';
change: 'pmapass';
to: 'testing';

test --
http://localhost/dbadmin/
username: root
password: testing


7. verify
--------------------------------

reboot

test --
http://localhost/test.html
http://localhost/test.php
http://localhost/test.jsp
http://localhost/testdb.php
http://localhost/testdb.jsp
http://localhost/dbadmin/


..

krisjanis p gale
nov 02 '06
k@krisgale.com

might help to have a 'package' of all the files referenced in the
above:

http://krisgale.com/apache_php_jsp_mysql.zip

..