Main Page
 The gatekeeper of reality is
 quantified imagination.

Stay notified when site changes by adding your email address:

Your Email:

Bookmark and Share
Email Notification
Project Screwturn Wiki
Purpose
The purpose of this documentation is to show the steps that were taken to get the full source version of the screwturn wiki 3.0.5.600 (runs under Windows Server 2003/2008) to operate with SQL capability. This tutorial shows the steps that were taken for Windows Server 2008 and SQL Server 2008 with the project itself in Visual Studio 2010. By the end of this step by step guide you should be able to successfully build, publish and use the SQL capability.


(Enlarge)
  1. Under WebApplication create a new folder "public". Under WebApplication -> public create a new folder "Plugins". Import "SqlServerProviders.dll" into the "Plugins" folder.

(Enlarge)
  1. Locate Anthem.dll and Anthem.XML in the original full source files (if they are missing from VS2010). They should be located at wiki\References\Lib\Anthem.NET. Copy those files.

(Enlarge)
  1. Paste them into WebApplication\bin.

(Enlarge)
  1. Locate SgmlReaderDll.dll in the original full source files (if it is missing from VS2010). It should be located at wiki\References\Lib\MindTouch SGML Reader. Copy the file.

(Enlarge)
  1. Paste the file into Core\bin\Debug.

(Enlarge)
  1. There are a series of projects that you will need to unload. The first one is "TestScaffolding".

(Enlarge)
  1. After you unload it the project should show up as "unavailable".

(Enlarge)
  1. Now you'll need to unload "AclEngine-Tests", "Core-Tests" and "SearchEngine-Tests".

(Enlarge)
  1. Under the Plugins folder you will need to unload "DownloadCounterPlugin-Tests", "SqlProvidersCommon-Tests" and "SqlServerProviders-Tests".

(Enlarge)
  1. After those are unloaded you should see the "unavailable" note next to them. At this point, for the solution itself you should have a count of 15 projects.

(Enlarge)
  1. If you are targeting a SQL Server machine, and you've already set things up on the SQL Server machine and altered the web configuration to something similar to the following, you should be good to go (see additional notes in the wiki):
    <add key="SettingsStorageProvider" value="ScrewTurn.Wiki.Plugins.SqlServer.SqlServerSettingsStorageProvider, SqlServerProviders.dll" />
    <add key="SettingsStorageProviderConfig" value="Data Source=SQLServerMachine; Initial Catalog=DbName; User ID=TheWikiUser; Password=TheWikiUserPassword;" />
  2. While your publish settings may vary, the publish method of file system was used in this particular instance.

(Enlarge)
  1. When you access the default.aspx file for the first time in your web browser a series of tables should be created on the SQL Server machine in the database you specified in the web configuration.

(Enlarge)
  1. Finally, you should see a nice, refreshing wiki page in the web browser as shown.


About Joe