View source for Building a Wiki

==Full Title or Meme==

'''Building of a Wiki on Microsoft Azure with Minimal Effort'''

This should help anyone wanting to enable MediaWiki on Azure.

==The Context:==

A team that is working on a single problem or area of expertise but is separated by time or distance yet still needs to share information quickly with little extra effort is given a wiki to collect information as it is generated. Sharing is then automatic. Specifically this present site was created to establish community for any interested in online sharing of a user's identifiers, attributes, behaviors and inferences established thereby.

==Author: Tom Jones 2018-05-08==

==The Problem:==
Constructing a set of description pages on a site that can be modified by any person that is willing to establish a persistent identity.

At first it seemed like the logical choice was to build a [https://www.mediawiki.org/wiki/MediaWiki MediaWiki] instance that was part of the [http://tomjones.us tomjones.us web site], but there were multiple challenges that were related to the manner that MediaWiki is designed, or evolved, into its present form. Specifically MediaWiki is a unified web site that depends upon a tight integration with a SQL data base during its entire lifecycle from initial create and updating as determined by [https://www.wikipedia.org/ Wikipedia] from which is was derived. In that mode it can easily be built on an wide variety of infrastructures which are known in current jargon as IaaS, or Infrastructure as a Service. The current [http://tomjones.us tomjones.us site] was created as a SaaS, or Software as a Service from the Azure cloud. One example of the problems is found [https://phabricator.wikimedia.org/T192965#4204936 in the way that fulltext catalogs are trouble in Wikimedia]. Not only is the initial creation with a default value of '', but all the data placed in the table is character data installed in a varbinary field. After a great deal of effort to integrate MediaWiki into that site, it was abandon in favor of a separate IaaS implementation of MediaWiki without the use of Azure SQL services as described below.

The choice of MediaWiki as the solution (or infrastructure platform) was not a requirement for such a sharing environment. The Wikipedia model is well-known and used by many in the computer industry, but it has evolved over time and does not reflect what a new, "clean room" design might provide. Besides the lack of any modularity, as noted above, some of the internal structures are not user friendly. For example the method for building an maintaining a table is bizarre. Other solutions, like Google Docs, work well for an office environment, but not for collaboration. There are good collaboration tools, like [https://phabricator.wikimedia.org/T192965#4204936 git hub where code from this site is posted]. A wiki can be established there for collaboration, but it is project based, while this site is more general.

==The Solution:==

Parts of the details this solution were described by CGillum in his [https://cgillum.tech/2016/06/30/creating-a-corporate-wiki-in-azure/ Dev Blog]. Where MediaWiki is installed on Azure, but [https://www.mediawiki.org/wiki/Manual:SQLite SQLite] is used as the data base. In this solution we start with authenticaiton from MediaWiki itself and plan to move to authentication based on OpenID Connect.

===Enabling PHP on Azure===
* [https://windows.php.net/team/ enabling PHP on Windows]

===Creating the Wiki===
# Create a Web "App Service" on [https://portal.azure.com the Azure Portal].
# Download code from [https://www.mediawiki.org/wiki/MediaWiki MediaWiki site]. This page is based on the most recent release of long term support, 1.27.4.
# Determine how you want to maintain the code. This site loaded the MediaWiki to WebPI and then migrated to Visual Studio to enable publication to Azure.
## An alternate approach from the link above is to just extract the MediaWiki code directly to the Azure site.
# Once the code is on Azure, just run it. If there is no LocalSettings.php file, then an install will be initiated.
## The one way that seems to work is to select SQLite as the data base file, you will need storage on Azure to enable that.
## I tried to use the SQL server on Azure, but found that the problem with Varbinary fields cast as binary was unsolvable and switched to SQLite.
# Once you have a LocalSettings.php file, put it in the web site root and start the site again.

===Maintaining the Wiki===
*Viewing the files on the site is described in the [https://github.com/projectkudu/kudu/wiki Kudu Service Wiki].
*It is easier to use the Kudu services if you have installed a json viewer on a desktop browser, like [https://chrome.google.com/webstore/detail/json-viewer-awesome/iemadiahhbebdklepanmkjenfdebfpfe?hl=en this Awesome Viewer from Rahul Barun].

===Authenticating the Users===
# [https://github.com/FHannes/IPBLoginAuth/blob/master/IPBLoginAuth.php IPBLoginAuth] a MediaWiki extension which authenticates users through an IPB forums database.

===Using Word to Create Wiki Content===
https://answers.microsoft.com/en-us/office/forum/office_2010-word/using-microsoft-office-word-add-in-for-mediawiki/449726c2-6d08-45e1-919a-4b5082ab4b5b?rtAction=1403289479743&auth=1

===References===
# Return to [http://tomjones.us tom jones main page].
# [http://openid.net/connect/ OpenID Connect] is the preferred authentication federation solution.
# [https://azure.microsoft.com/en-us/develop/php/ Azure PHP Developer Center] build and deploy PHP apps on Azure
# [https://stackoverflow.com/questions/26382334/is-there-a-way-to-view-deployed-files-in-azure View deployed files in Azure]