Wikiable scribble

To change the access levels of users in each groups, alter attribution in "includes/DefaultSettings.php"

http://meta.wikimedia.org/wiki/Help:User_levels

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

These two concretely describe about how to install and set Mediawiki in more detail (All written in Japanese)

• Wiki Installation guide:
  Installation tips explaining by kind and proper procedure of what it needs and what shape it is in
  
  http://qwik.jp/wikibana-gihyo/MediaWikiSample.html

• Tips for PHP/Perl on Windows2003 Server:
  My PHP installation went well actually by this way

  http://www.spencernetwork.com/windows-sp7.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

Wiki name: Engineering Dictionery
Contact e-mail: ito@isidsea.com
Language: en - English
Copyright/license: No license metadata
Admin username: wikisid
Password: ********
Password confirm: ********
Shared memory caching: No caching
Memcached servers:

E-mail: Enabled
User-to-user e-mail: Enabled
E-mail notification: Enabled for user_talk and watch list changes (not recommended for large wikis)
E-mail authentiction: Enabled

Database type: MySQL
SQL server host: localhost
Database name: wikidb
DB username: gep
DB password: ********
DB password confirm: ********
Database table prefix: mw_
Database charset: Backwards-compatible UTF-8

Superuser account: root
Superuser password:

Incoming further disturbance, was occurred during Mediwwiki installation on a halfway, and it was:

The ‘InnoDB’ feature is disabled; you need MySQL built with ‘InnoDB’ to have it working

1. Shut down your MySQL server (stop the service)
2. Open my.ini (mysql’s config file), which is located in your MySQL program folder.
3. In my.ini, find the following:
    skip-innodb
4. Replace this line(uncomment) with:
    # skip-innodb
5. Save the file
6. Start the MySQL server again

After doing aboves, installation was successfully completed, and the case is closed…

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.

gumax_link_navigation.css

• – web site link and navigation style
• Header
• – login Tools
• – navgation menu style
  Navigation bar on the top, can change text and background color
• Main content
• —- Navigation
• —- new link style
• —- internal and external link style
• —- internal link navigation style
• —- external link navigation style
• —- internal and external active link style
• Navigation
• Footer
• – content Actions
  Links on the footer, can change text and background color
• – personal Tools
• – gumax-footer
• Table pager
• The end

gumax_template.css

• Basic Structure
• – Setting for the Website: font style, font size
• —- content width, excluding shadow
• —- main content style
  Lines drawn round content at the sides
• —- content actions
  footer background color

gumax_main.css

• web site link and navigation style
  – Your customization: un-comment lines according to your needs
• header size
• page size
• The end