Manual talk:Installing MediaWiki on Windows Server 2003

Using 16-bit mySQL Passwords
I installed MediaWiki 1.5.4 on a machine running Win2k3, IIS6, PHP V 5.0.4 and mySQL 4.1 and did not need to make any modifications to the way mySQL passwords are handled.

Install on Win2Kas is different
I installed it and it seems to work but you have to use the ISAPI interface and it's setup in the "properties" dialog box. -- Slamlander
 * This page has huge problems when working with a Win2K Server host. I have no idea why you guys removed the Win2K instructions, even though, they were wrong too. I am considering a dedicated Win2K page linked to this one, using MySQL5, PHP5, and the current MediaWiki. -- Slamlander 05:02, 26 November 2006 (UTC)

Restart MySQL after configuration
Win2k3, MySQL 5.0.18, PHP 5.1.2 -restarting the machine is also required after installing and configuring MySQL. Otherwise, extension=php_mysql.dll won't work due to libmysql.dll not being found.

Can't make email work
I set the SMTP server in php.ini, but the mail function still not work, only recieve this message:

"Error sending mail: SMTP server response: 501 5.5.4 Invalid Address"

Is it a bug of mediawiki-1.6.3?

Then I modify the property of the email collum in wikipedia database from UTF8 to ASCII.And when I was changing the email address of the user in wiki, I got the same error message.

Did wiki post a UTF-8 email address to the SMTP server?

Confirmation Email won't send
Environment: Windows XP, Apache 2.2.2, PHP 5.1.4, MySQL 5.0.21, MediaWiki 1.6.5 This was a new installation.

I kept getting an error that the Address may be invalid when trying to confirm my email address through account preferences.

In php.ini, SMTP was set to our local Exchange Server's IP address. Since I wasn't getting any other errors, I started to add prints to mediawiki to track down what values were being set to variables. This led to finding that the error being returned by sendConfirmationMail was

"Error sending mail: SMTP server response: 501 5.5.4 Invalid Address"

Some further searching lead me to this post http://us3.php.net/manual/en/ref.mail.php#59752

With this information at hand I modified mediawiki's "function toString" in /include/UserMailer.php so that it always returns $this->address; instead of formatting it.

Now email's are being sent from MediaWiki. (Note: I don't have control over the exchange server.)

No Input File Specified
We got all the way through the install but when we try to load the config/index.php page we are getting "No input file specified" Any recommendations?


 * You may need to use "ugly" URLs - an option in LocalSettings.php which will result in page-names that include question-marks. --Muchado 01:52, 20 June 2006 (UTC)

Undefined index: REQUEST_URI
I tested out the 'REQUEST_URI' index of the $_SERVER superglobal by creating a test php script, and I think that this is related to using the virtual directory option - in other words, you don't get the error if you are using a wwwroot directory rather than a virtual directory.


 * Notice: Undefined index: REQUEST_URI in C:\wiki\mediawiki-1.5.5\test.php on line 9

If no-one corrects me on this, then I will move this comment to the content page. --Muchado 01:52, 20 June 2006 (UTC)

Bad CGI Headers
I followed all the instructions and ended up with a "The specified CGI application misbehaved by not returning a complete set of HTTP headers." error in the browser after installation.

I fixed it by including one of the steps from Many Ways to Skin a Wiki -- I extracted php5isapi.dll from the PHP zip package, placed it in the PHP directory, set permissions for IUSR_MACHINENAME, and then under IIS-DefaultWebSite-Properties-HomeDirectory-Configuration I changed the mapping of the .php application extension to point to that DLL.

Please include this fix in the main article where appropriate.

Thank you, Gordon Withers (gordon dot withers at gmail dot com)

No Windows PHP Installer
There is a windows installer for the previous version of PHP, but not the current 5.X version on the page pointed to by the howto. Is this expected to be added or do I need to install PHP manually?

Answer: An installer is available to PHP 5.x, but it is reccommeded that you install it manually. More info...

Problem Creating table
i am getting the following error MediaWiki 1.8.2 Installation Don't forget security updates! Keep an eye on the low-traffic release announcements mailing list. Checking environment... Please include all of the lines below when reporting installation problems.

PHP 5.1.6 installed Found database drivers for: MySQL PHP server API is isapi; using ugly URLs (index.php?title=Page_Title) Have XML / Latin1-UTF-8 conversion support. PHP is configured with no memory_limit. Have zlib support; enabling output compression. Couldn't find Turck MMCache, eAccelerator or APC. Object caching functions cannot be used. GNU diff3 not found. Couldn't find GD library or ImageMagick; image thumbnailing disabled. Installation directory: C:\wiki\mediawiki Script URI path: /wiki Environment checked. You can install MediaWiki. Warning: $wgSecretKey key is insecure, generated with mt_rand. Consider changing it manually. Generating configuration file...

Database type: MySQL Loading class: DatabaseMysql Attempting to connect to database server as root...success. Connected to 5.0.26-community-nt Database wikidb exists

Creating tables... using MySQL 4 table defs...Query "CREATE TABLE `user` ( user_id int(5) unsigned NOT NULL auto_increment, user_name varchar(255) binary NOT NULL default , user_real_name varchar(255) binary NOT NULL default , user_password tinyblob NOT NULL default , user_newpassword tinyblob NOT NULL default , user_email tinytext NOT NULL default , user_options blob NOT NULL default , user_touched char(14) binary NOT NULL default , user_token char(32) binary NOT NULL default , user_email_authenticated char(14) binary, user_email_token char(32) binary, user_email_token_expires char(14) binary, user_registration char(14) binary, PRIMARY KEY user_id (user_id), UNIQUE INDEX user_name (user_name), INDEX (user_email_token) ) TYPE=InnoDB " failed with error code "BLOB/TEXT column 'user_password' can't have a default value (localhost)".

I have tried the following : /Maintenance/MySQL5/tables.sql and removing default'' for all blob column.

However it looks like the old query is still been used. Do i need to change some other file?

please help us to resolve this issue.

I have managed to config the wiki after removing default'' for all blob column and the comlumn "si_text" in Maintenance/tables.sql. I think the other one (/Maintenance/MySQL5/tables.sql) is not called by the script.

Answer : Turn off the "strict mode" in MySQL. Learn how here If your MySQL is already installed, you have to remove (or put a comment sign - # - in front of it) the following line in my.ini file: sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

The answer did solve that issue, but the install sequence did come back with next error (link database was missing). Meanwhile the database was created, not complete but there where entries. I just dropped all created entries and re-run the install again. Guess what, the table was created completly without any fault and the localsettins.php finaly created! Wiki up and running. Rick

Mediawiki and PHP access violation
I receive the following error when I go to access the Mediawiki installation:

PHP has encountered an Access Violation at 7C8224B2

What's interesting is that this error is intermittent, and only occurs with the Mediawiki install. Other PHP applications on the server are running fine. My environment is as follows:

Windows Server 2003, Service Pack 1, IIS 6.0 with PHP 5.2.0, mySQL 5.0.27

I've searched on this error and have come up empty, and hopefully someone else has run into this issue. -- Brad

ANSWER: Brad, I feel terrible that I didn't document exactly what I did when this happened. I experienced same and it turned out to be a permissions error. I can't remember which directory it was, but I had to go back and enable a directory using properties->security, enable modify for IUSR_[machinename]. The only problem is I can't remember which directory it was. Maybe someone else can help with more specifics and update here.--Jack 15:09, 9 March 2007 (UTC)

Mail Notification Via MS SMTP Server with Authentication Required
I would like to allow MediaWiki to send email through an enabled MS SMTP server on the same machine but possibly use the same MS SMTP server for other AUTHENTICATED users on other machines to prevent unauthorized relaying. While this feature is available for users who use other SMTP engines (see |$wgSMTP), when I use this feature to try and connect to the local MS SMTP server, it freezes:

# );
 * 1) Commented out because it seems to freeze the system
 * 2) $wgSMTP = array(
 * 3)  'host'     => "wiki.montcopa.org",
 * 4)  'IDHost'   => "montcopa.org",
 * 5)  'port'     => 25,
 * 6)  'auth'     => true,
 * 7)  'username' => "xxxx",
 * 8)  'password' => "******"

I tried to do this a couple of ways, then just set the SMTP server so it accepts requests only from itself (localhost or physical IP address). I can live with this, but wondered if anyone had solved the problem (without enabling the PEAR server).

If there is a way to solve it, would be great to add to the documentation. --Jack 17:29, 9 March 2007 (UTC)