OpenWiki

Open Wiki/Installation

Installation

System Requirements

To run Open Wiki on your own machine you should make sure to have:

If you install the IE 5.5 SP2 or IE 6.x browser, then the first three items are covered. All Windows installed machines have at least (the drivers of) MS Access already installed, but if you need a more serious database and can't afford to spend anything on it try PostgreSQL or MySQL which you can use for free.

If you have MSXML Parser v4.0 installed, then change the constant MSXML_VERSION in the file owconfig_default.asp to value 4. 
MSXML_VERSION = 4

Administrators of Open Wiki software should look at /Sys Admin

Notes

Open Wiki is stateless - you don't need a virtual directory. You also don't need a domain name (DNS).

For Windows Users (XP and IIS 6.0 work well)

Database Setup

If you have a DSN set up, use it: OPENWIKI_DB = "OpenWikiDist" 

  ==> does DSN means "System DSN" or what? -- KW 2007-08-05
  ==> a system DSN is not needed, instead use the OPENWIKI_DB={SQL Server} form. -- KvH 2007-09-12

If you have the path to your database, just specify the standard ADO/ODBC connection string for OPENWIKI_DB (in owconfig_default.asp). 

  
OPENWIKI_DB = "Driver={SQL Server};server=myserver;uid=myusername;pwd=mypassword;database=myopenwikidb"
  or
OPENWIKI_DB = "Driver={Microsoft Access Driver (*.mdb)};DBQ=e:\data\openwiki\OpenWiki.mdb"

Directory Pathing

Drop the contents of the \owbase directory into whatever directory on your server you want the wiki to run in. So, for instance, if you are using the default configuration for IIS, you would have a website at C:\INetPub\wwwroot. You could create a new directory C:\INetPub\wwwroot\wiki and drop the contents of \owbase there (so that owbase is not included but all of its contents are in the \wiki directory). Check to verify now that you can access your ow.asp path at C:\INetPub\wwwroot\wiki\ow.asp. If so, then you should be able to access the wiki at http://localhost/wiki. 

  ==> Has anyone noticed there IS no such file\directory called "\owbase" in the latest openwiki_077.zip file?


  ==> but nothing called "owbase".


  ==> The "owbase" folder is created by the installation program (see above, jjc)

Sample Installation on a Remote Server

Unfortunately the installation is predetermined for a specific local user - so run the installation on your local machine to get the files extracted. Then you will need to push those files up to your remote server as follows:

  1. Setup your database.
    1. MSACCESS: Drop the Open Wiki Dist.mdb file from the data directory in the specified data directory for your site.
    2. SQLSERVER: Create or Identify which database you will use for OpenWiki
      1. Run the OpenWiki-SqlServer.sql script in the database that you want to use
      2. Create a user and password and give them db_datareader/db_datawriter access to this database.
      3. Use DTS to import the help pages from the MSAccess OpenWikiDist.mdb that is shipped with OpenWiki (Import the openwiki_pages and openwiki_revisions tables).
  2. Specify your database in owconfig_default.asp
    1. DSN: Setup the DSN per your provider and set the OPENWIKI_DB variable to your DSN name. OPENWIKI_DB = "OpenWikiDist"
    2. No DSN: Set the OPENWIKI_DB variable to an ODBC/ADO connection string.
      1. MSACCESS: OPENWIKI_DB = "Driver={Microsoft Access Driver (*.mdb)};DBQ=e:\data\mydir\OpenWikiDist.mdb"
      2. SQLSERVER: OPENWIKI_DB = "Driver={SQL Server};server=myserver;uid=myusername;pwd=mypassword;database=myopenwikidb"
  3. Setup OpenWiki web files
    1. Create a folder on your website for OpenWiki (does NOT have to be a virtual directory, just a folder will do).
    2. Copy the contents of your local \owbase folder to the new folder you created.

Installation on Windows 2003 SP1, IIS 6 and SQL Server 2005 Express Edition

Instructions assume you're already familiar with installation of IIS and SQL Server 2005 Express Edition

Software

Database setup

IIS setup

OpenWiki configuration

OPENWIKI_DB = "Driver={SQL Server};server=SERVER\INSTANCE;uid=username;pwd=strongpwd;database=OpenWikiDist" MSXML_VERSION = 4 ' use 4 if you've installed MSXML v4.0 OPENWIKI_DB_SYNTAX = DB_SQLSERVER ' see owpreamble.asp for possible values

Just modify the owconfig_default.asp as below: 
' Following are all the configuration items with default values set.
' Override them if you want in a separate file, see e.g. /web1/ow.asp.

' "The Truth about MS Access" : http://www.15seconds.com/Issue/010514.htm

Dim Db
Db = "data/OpenWikiDist.mdb"
OPENWIKI_DB = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & Server.MapPath(db)

'OPENWIKI_DB = "Driver={Microsoft Access Driver (*.mdb)};DBQ=OpenWikiDist.mdb"
' OPENWIKI_DB = "Driver={SQL Server};server=mymachine;uid=openwiki;pwd=openwiki;database=OpenWiki"
' OPENWIKI_DB = "Driver={Microsoft ODBC for Oracle};Server=OW;Uid=laurens;Pwd=aphex2twin;"
' OPENWIKI_DB = "MySystemDSName"
' OPENWIKI_DB = "MySQLOpenWiki"
' OPENWIKI_DB = "PostgreSQLOpenWiki"

'OPENWIKI_DB = "OpenWikiDist"

'OPENWIKI_DB_SYNTAX = DB_ACCESS               ' see owpreamble.asp for possible values

Open Wiki works great for many users, however, if you are having problems, please refer to the following page:

Open Wiki Installation Problems

Powered by OpenWiki.com