Difference between revisions of "Wikispooks:Site Backup"

From Wikispooks
Jump to navigation Jump to search
(explain about LocalSettings.php)
(Tidier lede)
Line 1: Line 1:
 
{{HelpSection|image=SiteBackup.png}}
 
{{HelpSection|image=SiteBackup.png}}
<div style="font-size:86%; text-align:center; border:1px solid #aaaaaa; background-color:#f9f9f9; color:black; margin-left:1em; padding:0em; float:right; clear:right;">
+
<div style="font-size:86%; text-align:center; border:1px solid #aaaaaa; background-color:#f9f9f9; color:black; margin-left:1em; padding:0em; float:right; clear:right;">{{#widget:Iframe  
{{#widget:Iframe  
 
 
|url={{server}}/backups/?C=N;O=D
 
|url={{server}}/backups/?C=N;O=D
 
|width=300  
 
|width=300  

Revision as of 12:13, 18 October 2015

SiteBackup.png

Wikispooks readers are encouraged to download the wikispooks-latest backup (~3Gb) in case the site goes offline for any reason.


Weekly backup snapshots for the last month are listed on the right in the Backup files list. The wikispooks-latest.zip file is a link to the most recent weekly snapshot. The site is open licenced so you are free to publish the content elsewhere, either as an exact mirror or as part of another website.

Setting up and running a Copy Of The Site

Gnome-system-software-installer.svg System requirements

The backup file contains everything you need to run a mirror of this site on a suitably configured web server; Separate installation of Mediawiki is NOT required.

The web server currently used by Wikispooks is Apache running on Centos 7 Linux. These instructions assume Apache, though NginX, IIS and other web servers may work just as well. The instructions have been slightly modified to try to suit other Linux distos as well.

N.B. WampServer or Xampp provide all the Apache web-server software required (except for Xcache) to run the Wikispooks site locally on either a Linux or Windows machine.. If you do not install either Xcache or APC separately, then you must change $wgMainCacheType = CACHE_ACCEL; to $wgMainCacheType = CACHE_DB; in /w/LocalSettings.php.

Overview

Set up your web server; create a blank MySQL database; download wikispooks-latest.zip to your server root and unpack it; import file path-to-server-root/backups/ws.sql into your blank MySQL database; edit path-to-server-root/w/LocalSettings.php and enter your database name and user credentials; navigate to your web-server root from your web browser to browse your local copy of Wikispooks.

Web server directives

  • Pretty urls are required for full site functionality. Add the following to the bottom of your server or virtual server config file:
Alias /wiki path-to-server-root/w/index.php.
Apache config files are usually located at /etc/httpd/.
  • for correct display of the Site backups list box. Add the following to your server config file:

<Directory "path-to-server-root/backups">
Options +Indexes
IndexIgnore .. header.html
HeaderName header.html
IndexOptions FancyIndexing SuppressDescription SuppressLastModified NameWidth=*
</Directory>

  • Linux only: you may have to tweek a few directory permission for the site to run smoothly. In particular the following require user (Usually Apache) write permissions:
path-to-server-root/w/cache/
path-to-server-root/w/images/

The MySQL database

The database must be created manually (see MySQL manual).
Database name wikispooks and user WSuser are assumed in the downloaded LocalSettings.php.
You can use different names but these must be entered into LocalSettings.php - see below.

The backup file

Place your downloaded latest-site.zip file in the server root directory and and unzip it. This will create a directory structure containing all application and associated site files. It will also place the database content file ws.sql in the path-to-server-root/backups/ directory.

Import the Wikispooks content into your database

Import path-to-server-root/backups/ws.sql into the new database.

N.B. The file is too large for a default configuration of phpMyAdmin to handle. Try a MySQL command for this, e.g.

$ mysql -u username --password=password --host=localhost data-base-name < ws.sql

LocalSettings.php

The file is located at path-to-server-root/w/LocalSettings.php. It needs editing to insert the security credentials to match your new database.

Insert correct Database credentials

Locate the following code block:

## Database settings
include("../../cgi-bin/WsDbInfo.php");
#$wgDBtype = "mysql";
#$wgDBserver = "localhost";
#$wgDBname = "wikispooks";
#$wgDBuser = "";
#$wgDBpassword = "";
#$wgDBadminuser = "";
#$wgDBadminpassword = "";

Delete the line beginning: include. Delete all # characters and enter your new database credentials in the corresponding lines.

Host name and miscellaneous settings

Search and replace/edit where your-host can be either the host name or IP address of your web server:

Replace with: $wgServer = "http://your-host";
Replace with: $wgAllowExternalImagesFrom = array('http://your-host','http://127.0.0.1');
  • search for: enableSemantics('wikispooks.com');
Replace with: enableSemantics('your-host');
  • search for: require_once ('extensions/piwik/Piwik.php');.
Put a # character at the beginning of this and the following 2 lines to disable the Piwik stats extension.

Troubleshooting

If things don't go smoothly, the first thing you should do is go to the end of the file where you will see the following lines:

#$wgShowExceptionDetails = true;
#$wgShowSQLErrors = 1;

Remove the leading # character to get some diagnostic output and help you debug. It's recommended to take comment lines out again once things are working OK.

Warning: include(../../cgi-bin/WsDbInfo.php)...

This occurs if you haven't fixed the database credentials as explained above.

CACHE_ACCEL requested but no suitable object cache is present.

This means that the ACCEL cache is not available on your webserver. The first thing to try is to find the following lines:

$wgMainCacheType = CACHE_ACCEL;
#$wgMainCacheType = CACHE_DB;

Try commenting the first of these out, and uncommenting the second. If this doesn't work, the easiest way to get it running is to comment them both out. This disables the cache, which will impact performance, but that problem can be tackled later if need arises.

Sorry! This site is experiencing technical difficulties.

The active part of this message is a couple of lines lower. If it says "Cannot contact the database server:" this means that the custom Database credentials you entered into Localsettings.php are not functioning properly.

Lua error: Internal error: The interpreter exited with status 2

Lua error: Internal error: Error reading from pipe.

The above error messages indicate that Lua is hitting a memory limit problem.[1] In this case, the pages will appear mostly OK, but will lack infoboxes. In this case, you should raise the amount of memory available for Lua.[2] Find the following two lines and comment them in

#$wgScribuntoEngineConf['luastandalone']['memoryLimit'] = 209715200; # bytes
#$wgMaxShellMemory = 204800; # in KB

Running A Live Site Mirror

If you have interest and resources to set up a realtime site mirror on your server, you are encouraged to do so. We may also be able to provide you with some technical assistance if needed. Requests for help setting up realtime mirrors should be addressed to admin[at]wikispooks.org and encrypted with this key.

Known Issues

  • xdebug is a php debugging tool which produces output similar (but considerably more verbose) to $wgShowExceptionDetails above. It is installed and enabled by default in both Wamp server and Xampp. Wikispooks admins have found it useful in tracking down common installation problems but that a default setting results in ungraceful out of memory failures on some of the more common installation issues, rendering it useless in tracking them down. Either disable it by commenting out the [xdebug] block in php.ini or increase max_nesting_level from the default 100 with the following if you wish to use it: xdebug.max_nesting_level=300
  • Some internal wikilinks are still of the form [[Wikispooks:...]], so will not work unless your project is identically named. This can be tackled with a global search and replace (to "[[Project:...]]"). This issue is being gradually addressed, for easier portability.
  • The backups do not include the Anon Uploads Form or Piwik stats.
  • Suggestions, Queries etc? - Either Email the admin (non-WikiSpooks members) or use this discussion page (WikiSpooks members)
Wikispooks logo.png Policy.png Wikispooks to do.png Tools2.png
Wikispooks
Technical
SMW.png Help.png