Edit this page
(last edited July 8, 2010)
Open Wiki | Sand Box | Create Page | User Preferences | Recent Changes | Title Index | Random Page | Find Page | Help
This page is here to help out the system administrators of Open Wiki software.
Compacting the database
Reverse DNS Lookup
RSS
Export your Recent Changes page as an RSS feed
Import RSS feeds from remote sites
Aggregation of multiple RSS feeds from remote sites into one list
Automating refreshing syndicated content
MultipleWikiSingleServer
Compacting the database
When users are editing pages a lot, you will see the size of the database
growing rapidly. 
<- How rapidly? 100KB? 100GB?
If you are using an mdb file, you can compact in MS Access, using the command
Tools > Database utilities > Compact and Repair database. Make a backup
copy first!
This may not help much, if all updates happened within a short time period. It
may help to set the constant OPENWIKI_DAYSTOKEEP in the owconfig.asp file to a
lower value. By default it's set to 30, meaning that when someone edits a page
any revision older than 30 days gets deleted.
To delete old revisions manually, you can enter:
DELETE FROM openwiki_revisions WHERE wrv_current = 0 AND wrv_timestamp <
(DATE() - 10);
This will delete all revisions edited more than 10 days and which are not the
current revision.
If you want to delete ALL old revisions you could execute:
DELETE FROM openwiki_revisions WHERE wrv_current = 0;
Thanks to Laurens
- Victor van Uitert
Reverse DNS Lookup
Instead of storing the IP addresses of the author editing a page it's possible
to store the DNS name. This feature can only work with IIS (afaik), not PWS. To
use this feature you have to set the system option cUseLookup equal to
value 1 in file owconfig.asp.
Read the
HowTo page at microsoft.
Then run the sub EnableRemoteHostLookup located in ow.asp once to
tell IIS to do reverse DNS lookup.
RSS
RSS stands for RDF Site Summary. For more info see RDFSite Summary.
Export your Recent Changes page as an RSS feed
The Recent Changes of the Open Wiki site can be retrieved as an RSS feed via the
URL http://openwiki.com/?a=rss. Similarly, if your Open Wiki site is located at
e.g. http://www.mysite.com/openwiki/ow.asp then the
RSS feed of your site would be
http://www.mysite.com/openwiki/ow.asp?a=rss.
You are invited to put the link to your RSS feed on
http://openwiki.com/?OpenWikiSites if you have a publicly available wiki site.
You can disable the export of your Recent Changes page as an RSS feed by
setting the system option cAllowRSSExport to value 0 in file
owconfig.asp.
Import RSS feeds from remote sites
Open Wiki can import RSS feeds from remote sites into a Wiki Page. See the
paragraph "Syndicate" at Help On Macros for info on how users could do
this.
An RSS feeds will be imported when:
- a user hits a page which contains syndicated content that is
"out-of-date".
- a user explicitely refreshes a feed.
- an automated process (a cron job) regularly queries the URL containing
the syndicated content.
Because syndicating RSS feeds is an expensive operation for a webserver you
might want to disable the feature to be used by anyone. Then you have a few
options:
- Set the system option cAllowNewSyndications to value 0 in file
owconfig.asp. In this case users cannot add new feeds to be syndicated.
- Though users cannot add new feeds to be syndicated, you as the
administrator of Open Wiki, can still put syndicated content in your site. Simply
install the Open Wiki files in a secured place on your webserver (e.g.
http://www.mysite.com/ow/admin/ow.asp) and use an
owconfig.asp file where the system option cAllowNewSyndications is
set to value 1. From your secured admin area you can edit any wiki page and add
links to RSS feeds that need to syndicated.
- If you do not want to allow anyone to refresh syndicated content then
open file ow.xsl and delete every line that contains the word
refresh completely. Also, in file ow.asp you can completely delete
the sub ActionRefresh.
Aggregation of multiple RSS feeds from remote sites into one list
Next to syndicating RSS feeds, Open Wiki can also aggregate multiple RSS feeds
into one view. See the paragraph "Aggregate" at Help On Macros for info
on how users could do this.
Because the aggregation process is even more resource intensive you might to
disable this feature. You can do this by setting the value
cAllowAggregations to 0 in file owconfig.asp.
Furthermore, basically you have the same options described in the previous
paragraph.
==== Other mechanisms to control the way syndication and aggregation of feeds
works ====
Because feeds can come in from various parts of the worlds it's useful to tell
in which timezone your wiki is running. In owconfig.asp set the constant
OPENWIKI_TIMEZONE. Valid values are "+01:00",
"+04:00", "-08:00", etc.
Because the aggregation of syndicated content can be quite large you can limit
the number of rows that will be shown by setting the constant
OPENWIKI_MAXNROFAGGR.
Because the syndication of RSS feeds involves retrieving information from
remote sources it can sometimes take a "long" time before the
operation finishes. You can change the default timeout value that is used by the
syndication and aggregation processes by setting the constant
OPENWIKI_SCRIPTTIMEOUT. The value is in seconds.
Because one wikipage can have many links to remote sources to be syndicated,
you might want to limit the number of feeds that may be refreshed for one user
request. You do this by setting the constant OPENWIKI_MAXWEBGETS.
Automating refreshing syndicated content
You might want to automate refreshing of syndicated and/or aggregated content.
On Windows machines you can configure Task Scheduler to run your tasks
(Properties -> Advanced) as often as you like. On Unix machines you can define cron
jobs that can run every minute if you wish.
For example, the pages All The News, Rss Page and BSD of this site are
automatically refreshed a few times a day by using the following commands in
crontab on a Linux system:
17,37,57 * * * * wget -q --spider
http://openwiki.com/?p=AllTheNews\&a=refresh
7,27,47 * * * * wget -q --spider http://openwiki.com/?p=RssPage\&a=refresh
14 8,12,19,23,3 * * * wget -q --spider
http://openwiki.com/?p=BSD\&a=refresh
If you have disabled the feature for users to refresh syndicated and/or
aggregated content themselves then you can still refresh the content you allow
by using a separate ow.asp script in a secured place.
MultipleWikiSingleServer
The short answer is this summary picture:
Internet Information Services
ServerName
Default Web Site
Openwiki (irrelevant but installed by OpenWiki_078sp1.exe)
Ow (points toward local path ../owbase/ow Required. )
Web1 (points toward local path ../~Web1)
Ow (points toward local path ../owbase/ow)
Web2 (points toward local path ../~Web2)
Ow (points toward local path ../owbase/ow)
Multiple Wiki Single Server Verbose
