The docs are “ok” at best so here are my quick instructions to help you understand quickly how to get ScrewTurn Wiki configured to use a SQL Server Database.
This is based on version 2. of the wiki. The RC0 3.0 has improved the process a LOT so if you are not using the RC, this should help you save a lot of time and frustration for older versions of the Wiki.
Steps:
1) Download the ScrewTurn wiki source code
2) Compile it
3) Run it and once the site comes up, on the left nav, choose “Administration”
4) Log in. The default username for ScrewTurn Wiki Administrator is “admin”. The password is configured in the following key below in the web.config and is typically “password” out of the box:
<add key="MasterPassword" value="password"/>
5) Create a blank database in SQL Server (2005 or 2008, works in both)
6) Give adequate rights to that database (modify, etc.) to a user you specify in security for SQL Server for that database
7) in ScrewWiki Administration, click on the Providers tab. Select on one of the MSSQL providers and then click “Configure”
Paste in your connection string. This connection string must work and make sure it’s not malformed! Because once you put the connection string in then save, ScrewTurn Wiki does an automatic check for auth and it will fail if the connection string is malformed or the values are not correct, or the user you setup in SQL Server is not right or doesn’t have the appropriate security to the DB you created. If the connection string fails, you’ll get a strange generic message such as “The provider refused…blah blah blah”. If you get weird errors, check the log under the System Log tab.
8) Once you’re able to save your connection string without error, highlight the provider again and click the Enable button.
9) Repeat these steps for the other SQL provider.
10) Once you have both providers working with that connection string and enabled, check the database to ensure that the tables were created. By configuring and enabling the providers, ScrewTurn Wiki automatically creates the needed tables in your blank database:
11) Now you need to perform once more step. Change all the default providers to use the MSSQL providers instead of local in your Provider tab and click Save:
12) That’s it! Anytime you add data such as categories or content to ScrewWiki, it should show up in your SQL Tables, not the local file system.
Please digg, dzone, & kick if you found this post interesting or useful.
Print | posted on Sunday, April 26, 2009 8:34 PM
