Wikiable scribble

After the long journey, I hereby summarize achievement with the following listed everything I have installed to run Mediawiki. Important points are commonly those path mistakes as well as comment out issues found in configuration file as is always the case with installation.

Server Environment:

• Internet Information Services (IIS)
  Windows Server 2003 Standard Editioon Version 5.2

• Mediawiki-1.9.3
  mediawiki-1.9.3.tar.gz
  http://www.mediawiki.org/wiki/Download

• PHP5.2.3
  php-5.2.3-Win32.zip
  http://www.php.net/downloads.php

• MySQL Server 5.0
  http://dev.mysql.com/downloads/mysql/5.0.html

PHP Installation:

1. Download php-5.2.3-Win32.zip and extract zip archive
2. Rename directory with PHP, and move it under C drive
   • php-5.2.3-Win32 -> PHP (change of directory name)
   • C:¥PHP (move directory)
3. Move php.ini-dist
   • C:¥PHP¥php.ini-dist => C:¥WINDOWS¥php.ini
     (change file name and move to WINDOWS directory)
   • Also to work with MySQL subsequently, ensure the php_mysql.dll and php_mysqli.dll dlls were in the ext folder of PHP, open your php.ini file to remove the following comments(semicolon):
     ;extension=php_mysql.dll
     ;extension=php_mysqli.dll
   • Change the extension_dir parameter to point to "c:\php\ext"
   • To enable email sending to registered users(from mediawiki), you go to PHP.ini, and alter the line "SMTP = localhost" to actual SMTP server name you are using.
     
4. To register php5isapi.dll to IIS, you first open IIS Manager and click Web Service Extensions then go on to click Add a new Web service extension
5. On the New Web Service Extention, key in "PHP" in extention name field then click "Add"
6. Subsequently, Key in the path of php5isapi.dll then click "ok"
   • C:¥PHP¥php5isapi.dll
7. Tick the checkbox Set extension status to Allowed
8. Go to left panel of "Web sites", right click properties on a web service you are going on.
9. Press Home Directory tab and press Configuration, and then press "Add" on Add/Edit Application Extension Mapping window
10. Set everything up as follows:
• Executable: C:\PHP\php5isapi.dll
• Extension: .php
• Script engine: check
11. After everything is done, restart IIS server with iisreset command on the prompt

MySQL Installation:
Install MySQL to the default directory using the default options:

1. Download MySQL Server 5.0 and just follow the installer
2. Select “Detailed Configuration”
3. Choose “Developer Machine”
4. Choose “MultiFunctional Database”
5. Select path for Data, this configuration used the default location.
6. Choose “Decision Support (DSS)/OLAP
7. Enable TCP/IP Networking on 3306 and Enable Strict Mode
8. Enable standard character set
9. Install as a Windows Service and set to launch automatically, check “Include Bin Directory in Windows PATH”
10. Enter a Root Password
11. Create the setup
12. Not to skip InnoDB, find a configuration file my.ini under your MySQL program directory, and just disable the line skip-innodb with hatch "#", otherwise it will disturb your Mediawiki installation.
    Sources said InnoDB is the most popular transactional storage engine for MySQL also known as one of a various table in MySQL enabling functions such as commit, rollback, clash recovery, etc.

Mediawiki Installation:

1. Download zip package from website and extract
2. Alter directory name from Mediawiki-1.9.3 to wiki, and move its directory to anywhere you like where PHP is applied
3. Open web browser and connect to its URL which may be http://localhost/wiki/index.php
4. With sunflower shown on the browser, you can start installing Mediawiki, then just click the word below flower
5. Fill up everything followed by, then click the button at bottom.
6. If you stuck in trouble during installation, please go check again those configuration files of MySQL and PHP

To add super user in MySQL with the username "gep", put the following two commands at prompt

GRANT ALL PRIVILEGES ON *.* TO gep@localhost IDENTIFIED BY ‘password‘ WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO gep@"%" IDENTIFIED BY ‘password‘ WITH GRANT OPTION;

See also http://dev.mysql.com/doc/refman/4.1/en/grant.html

I have checked all those MySQL and PHP operation as well as Mediawiki placement, and have attempted "click here" below the sunflower, I’m faced with  the following bug despite a lot of checking with uncommenting "extension=php_mysql.dll" at php.ini

PHP 5.2.0 installed Could not find a suitable database driver!
For MySQL, compile PHP using –with-mysql, or install the mysql.so module
For PostgreSQL, compile PHP using –with-pgsql, or install the pgsql.so module

After much trial and error, I changed the extension_dir parameter in "php.ini" to point to "c:\php\ext" from just "./" and finally mediawiki installation form turned up at …wiki/index.php

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\Administrator>mysql -u root -p
‘mysql’ is not recognized as an internal or external command,
operable program or batch file.

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqlshow
mysqlshow: Can’t connect to MySQL server on ‘localhost’ (10061)

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u root -p
Enter password: **********
ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)

Today, I finally give up use of EasyPHP beta version due to unknown confliction, and attempt to install PHP 5.2.3 individually to run on IIS Server, and see how it goes…

1. Just download package from PHP site and install under C: program files
2. Along the installation procedure, I have chosen "IIS ISAPI" on the "Web Server Setup", and the rest of selection related to IIS was "IIS CGI" among the other Apaches and so on.
3. However, MySQL installed a while ago is not accepting root password which has been specified, so I have been installing the same thing again, and it ended up causing web server to have broke down.

I have tried installing another Mediawiki into a space I have gotten by free hosting service

1. To get space in www.prohosts.org, registration was quite easy without dozen of input items
2. You will be given necessary information from email, subsequently, connect to your directory under ftp.prohosts.org, and just upload wiki package under the htdocs
3. After upload of Mediawiki package, open  web browser and connect to specific URL(root of your directory), then "wiki" you have installed shall be listed there, and click it, then follow subsequent instructions(at MySQL field, don’t forget to specify same thing as you were given by prohosts.com)
4. Before you finally press installation button on the bottom, go to CPANEL with Username and Password to create MySQL Database name, and name the same thing as what you’ve inputted at Mediawiki installation.
   http://cpanel.prohosts.org
5. Just press install button…

Latest version of mediawiki and EasyPHP been installed:

• C:\Program Files\EasyPHP 2.0b1
• C:\Program Files\EasyPHP 2.0b1\www\mediawiki-1.9.3

I’ve installed those two packages for customizing skins due to scalability enhancement but the problem is the other services running on IIS server disturbing port 80, despite the port number has changed to 8095. However, Apache doesn’t smash through the port…

EasyPHP enables launching Apache when programs "isidsgp" and "Portal" got turned off on IIS manager, and I put everything back the way they were, so these are running now while applications I have installed are disabled as of today.

EasyPHP of old version(v1.8) installed is working well under same conditions without confliction as the port number changed to 8095. 

1. Press and hold "Start" button on the right bottom of the screen, and then choose "run"
2. On the field, type "Inetmgr" then IIS Manager will turn up
3. On the left pane of IIS manager, click your Computer, then default website, then click the stop button.

        ref:http://support.microsoft.com/kb/185382/en-us

Local IP specified in (Listen)httpd.conf has been changed to global IP 203.125.156.126, so that contents can be browsed from web with "colon" + "8095" added following "domain"

Conflict is caused by the other MySQL already running earlier which has been occupying port number 3306