Open Wiki/Installation

Installation

System Requirements

• PWS (Personal Web Server) or IIS v4.0 or higher
• VBScript v5.5 or higher installed
• MSXML Parser 3.0 or higher installed

(I had to install MSXML Parser 3 SP 2 -- Al Gaspar, 2/11/02)

• a database like MS Access, MS SQL Server, Oracle, My SQL or Postgre SQL
• Windows Script 5.7 for Windows XP
• Microsoft XML Parser (MSXML) 3.0 Service Pack 7 (SP7)

MSXML_VERSION = 4

Notes

For Windows Users (XP and IIS 6.0 work well)

• Download the Open Wiki zip file

• Download the NSIS Installer

• Download MSXML Parser v4.0

• Install MSXML by just clicking on it (it's an .msi file and will use the internal Microsoft installser)

• Unzip the Open Wiki zip file to a temp directory

• Locate the file "Open Wiki.nsi" in the /openwiki/installer folder

• I then opened the file with notepad and commented out the lines "EnabledBitmap?" and "DisabledBitmap?" because it kept hanging up on those two lines (I don't know why).

• Install the NSIS installer

• Run the "/OpenWiki/installer/Build.bat" file. Inside that file it will look for the NSIS installer. You may have to edit the bat file to tell it where "makensis" is located.

• MakeNSIS? (from inside the Build.Bat file) will start a normal installation process and prompt for the folder that you want your Open Wiki files to reside. After that, let it go and it will create the appropriate folders and copy the appropriate files.

• The entry point for the wiki is /owbase/ow.asp or default.asp or if you want to create an index.asp.

• (jjc 09/08/2008)

  ==> 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

  
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"
  

  ==> 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)

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

Software

• In addition to installing IIS and SQL Server 2005 Express Edition you will need:
• Microsoft SQL Server Management Studio Express
• Microsoft SQL Server Migration Assistant for Access (DTS replacement) (Download from Microsoft Downloads)
• MSXML 4 SP 2 (Microsoft Downloads) - Be sure to patch your system after installing, there have been several security fixes for MSXML released.

Database setup

• Create a database and user on SQL Server using the SQL Server Management Studio Express.
• Grant the user dbo (or dbread/dbwrite) on the database

• Select the database and run the Open Wiki-Sql Server.sql script from the Open Wiki\data directory

• Use the SQL Server Migration Assistant for Access to import data from Access database in data directory
• Only import the openwiki_pages and openwiki_revisions tables
• When prompted during import to overwrite objects click Skip or Skip All otherwise the table definitions will be overwritten with incorrect tables. The data will still be imported properly.

IIS setup

• Copy the owbase folder to the path you want the wiki to appear at in your URL
• you can rename owbase to wiki (or other name) if desired. If you want the wiki to show up at the root of your web pages (e.g. http://server/) then copy the CONTENTS of owbase to that location.

• Enable Active Server Pages for IIS

OpenWiki configuration

• Edit the owconfig_default.asp file in the ow folder from where you copied the files for IIS
• edit the OPENWIKI_DB line to:

• SERVER\INSTANCE is the servername and instance where the database was created
• username is the database user created
• strongpwd is the the strong password you gave the user when created
• Open Wiki Dist is the name of the database created (replace with database name you created)
• edit the MSXML_VERSION:

• (optional) edit the OPENWIKI_DB_SYNTAX:

' 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