imported>mutante |
imported>Kunda m (cosmetics) |
||
(14 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
__TOC__ |
|||
⚫ | |||
⚫ | |||
==Obligatory Caution== |
|||
s23/seti23 is not responsible for any damages or data loss you experience by following this tutorial. |
|||
===What for?=== |
===What for?=== |
||
Maybe Wikipedia/Mediawiki developers are taking care of things in the next version of Mediawiki, but in the mean time smaller wikis are getting totally blasted with spam. This is totally wearing the wiki maintainers down |
Maybe Wikipedia/Mediawiki developers are taking care of things in the next version of Mediawiki, but in the mean time smaller wikis are getting totally blasted with spam. This is totally wearing the wiki maintainers down, stifling creativity and constructivness. Most of the creative energies are spent on making monotonous repetitive rollbacking to non-spammed page versions and IP blocking which is ineffective against multiple dynamic IP spam attacks. So this wikipage has been created to help those folks who are looking to control the amount of spam on their wiki. |
||
===This tutorial assumes...=== |
|||
that you are somewhat familiar with: |
|||
*using a *nix shell, |
|||
*installing patches, |
|||
*recompiling sourcecode, |
|||
*and reinstalling the mediawiki installation. |
|||
===Requirements=== |
===Requirements=== |
||
*A working [[mediawiki]] installation of the 1.4 or 1.5 branch. (Yes, sadly you will need to upgrade to a these more recent branches, and only then patch and recompile). See [[Mediawiki Upgrade Tutorial with Spamblacklist patch#Upgrading Mediawiki]] |
|||
*The [http://meta.wikimedia.org/wiki/SpamBlacklist_extension SpamBlacklist extension] Download files [http://cvs.sourceforge.net/viewcvs.py/wikipedia/extensions/SpamBlacklist/#dirlist here]. |
|||
{{Expandsect}} |
{{Expandsect}} |
||
===Upgrading Mediawiki=== |
|||
(If you have Version 1.4 or 1.5 skip this step) |
|||
Check out [http://meta.wikimedia.org/wiki/Help:Upgrading_MediaWiki Upgrading Mediawiki] <br> |
|||
IMPORTANT: Make sure you read the [[Mediawiki Upgrade Tutorial with Spamblacklist patch#Backup before you Upgrade|Backup before you Upgrade]] step before you start this. |
|||
===SpamBlacklist=== |
===SpamBlacklist=== |
||
Here you can find [http://meta.wikimedia.org/wiki/SpamBlacklist_extension#Compatible_Blacklists compatible blacklists] or create your own, just like we have here in the s23 wiki --> [[Spam blacklist]] |
|||
[http://meta.wikimedia.org/wiki/Spam_blacklist meta.wikimedia blacklist] |
|||
{{Expandsect}} |
{{Expandsect}} |
||
===Backup before you Upgrade=== |
===Backup before you Upgrade=== |
||
Line 13: | Line 45: | ||
==== Copy "w" directory ==== |
==== Copy "w" directory ==== |
||
If you follow the standard wikipedia way to hide "index.php" in |
1. If you follow the standard wikipedia way to [http://meta.wikimedia.org/wiki/Eliminating_index.php_from_the_url hide "index.php" in URLs] and your webserver's document root is /var/www/, you will have the wiki physically installed in /var/www/w and an [http://meta.wikimedia.org/wiki/Eliminating_index.php_from_the_url#Using_aliases_in_httpd.conf alias for /var/www/wiki] in your [[apache]] config. Hence, something like: |
||
:<tt>'''cp -r /var/www/w /home/backup/w_20051223'''</tt> |
|||
⚫ | |||
If you are not hiding index.php and you have installed your wiki to a physical directory /var/www/wiki or another place, change the path accordingly. (''cp -r /path/to/your/wiki /path/to/your/backup'') |
|||
⚫ | |||
==== Dump Database ==== |
==== Dump Database ==== |
||
To make a dump of the [[Mysql]] database, use the "mysqldump" command on a console. |
2. To make a dump of the [[Mysql]] database, use the "mysqldump" command on a console. |
||
:<tt>'''mysqldump -u root -p wikidb > wikidb_20051223.sql'''</tt> |
|||
==== Compress Data ==== |
==== Compress Data ==== |
||
To save diskspace and bandwidth you can now [[HowTo/UncompressFilesInLinux|compress]] the files, f.e. with .tar.gz (or [[zip]]). |
3. To save diskspace and bandwidth you can now [[HowTo/UncompressFilesInLinux|compress]] the files, f.e. with .tar.gz (or [[zip]]). |
||
:<tt>'''tar zcvf wikidb_20051223.sql.tar.gz wikidb_20051223.sql'''</tt> |
|||
:<tt>'''tar zcvf w_20051223.tar.gz /home/backup/w_20051223'''</tt> |
|||
==== Copy to remote location ==== |
==== Copy to remote location ==== |
||
Finally copy the files to a remote server, f.e. via [[scp]] (or [[ftp]]). |
4. Finally copy the files to a remote server, f.e. via [[scp]] (or [[ftp]]). |
||
:<tt>'''scp wikidb_20051223.sql.tar.gz user@backupserver.com:/home/user/backups/'''</tt> |
|||
:<tt>'''scp w_20051223.tar.gz user@backupserver.com:/home/user/backups/'''</tt> |
|||
{{Expandsect}} |
{{Expandsect}} |
||
Line 45: | Line 78: | ||
'''Keep in mind that your backup files will include passwords for the wiki database.''' |
'''Keep in mind that your backup files will include passwords for the wiki database.''' |
||
Before putting them in a public location consider editing LocalSettings.php (and possibly AdminSettings.php if existing). |
Before putting them in a public location consider editing [http://meta.wikimedia.org/wiki/LocalSettings.php LocalSettings.php] (and possibly AdminSettings.php if existing). |
||
[[Category:Internal]] |
[[Category:Internal]] |
Latest revision as of 21:55, 19 December 2005
Please drop a line on the talk page with feedback or comments on this page
Obligatory Caution[edit]
s23/seti23 is not responsible for any damages or data loss you experience by following this tutorial.
What for?[edit]
Maybe Wikipedia/Mediawiki developers are taking care of things in the next version of Mediawiki, but in the mean time smaller wikis are getting totally blasted with spam. This is totally wearing the wiki maintainers down, stifling creativity and constructivness. Most of the creative energies are spent on making monotonous repetitive rollbacking to non-spammed page versions and IP blocking which is ineffective against multiple dynamic IP spam attacks. So this wikipage has been created to help those folks who are looking to control the amount of spam on their wiki.
This tutorial assumes...[edit]
that you are somewhat familiar with:
- using a *nix shell,
- installing patches,
- recompiling sourcecode,
- and reinstalling the mediawiki installation.
Requirements[edit]
- A working mediawiki installation of the 1.4 or 1.5 branch. (Yes, sadly you will need to upgrade to a these more recent branches, and only then patch and recompile). See Mediawiki Upgrade Tutorial with Spamblacklist patch#Upgrading Mediawiki
- The SpamBlacklist extension Download files here.
Upgrading Mediawiki[edit]
(If you have Version 1.4 or 1.5 skip this step)
Check out Upgrading Mediawiki
IMPORTANT: Make sure you read the Backup before you Upgrade step before you start this.
SpamBlacklist[edit]
Here you can find compatible blacklists or create your own, just like we have here in the s23 wiki --> Spam blacklist
Backup before you Upgrade[edit]
Making a backup of a mediawiki installation is basically a four-step process. Copying the regular files, making a database backup,compressing the files and sending them to a remote backup location.
Copy "w" directory[edit]
1. If you follow the standard wikipedia way to hide "index.php" in URLs and your webserver's document root is /var/www/, you will have the wiki physically installed in /var/www/w and an alias for /var/www/wiki in your apache config. Hence, something like:
- cp -r /var/www/w /home/backup/w_20051223
would be sufficient.
If you are not hiding index.php and you have installed your wiki to a physical directory /var/www/wiki or another place, change the path accordingly. (cp -r /path/to/your/wiki /path/to/your/backup)
Dump Database[edit]
2. To make a dump of the Mysql database, use the "mysqldump" command on a console.
- mysqldump -u root -p wikidb > wikidb_20051223.sql
Compress Data[edit]
3. To save diskspace and bandwidth you can now compress the files, f.e. with .tar.gz (or zip).
- tar zcvf wikidb_20051223.sql.tar.gz wikidb_20051223.sql
- tar zcvf w_20051223.tar.gz /home/backup/w_20051223
Copy to remote location[edit]
4. Finally copy the files to a remote server, f.e. via scp (or ftp).
- scp wikidb_20051223.sql.tar.gz user@backupserver.com:/home/user/backups/
- scp w_20051223.tar.gz user@backupserver.com:/home/user/backups/
Beware![edit]
Keep in mind that your backup files will include passwords for the wiki database.
Before putting them in a public location consider editing LocalSettings.php (and possibly AdminSettings.php if existing).