User:Andreas Plank/new wiki

From Biowikifarm Metawiki
Jump to: navigation, search
$wgSiteNotice = "Announcing message of upgrade";
$wgReadOnly = 'Database is in read only mode, because of Upgrading to MediaWiki 1.26.XX';
cd /var/www
# find an extension
sudo find . -maxdepth 3 -iname '*settings*.php' -type f -exec sudo grep --ignore-case --with-filename --line-number --color=auto "/Arrays" '{}' ';'

Database (there is a bug in 3.7.7 that crashes because it merges some SQL together with current_timestamp()) but you can export the whole DB structure and execute it on the new data base)

  • export structure of a database to SQL-query window, copy that SQL code, change to new database or
  • copy z_en_template -> as new database, e.g. newdatabase

grant rights to user 'wikiuser' for new database

-- DROP , INDEX ,CREATE TEMPORARY TABLES seems necessary only for Semantic MediaWiki Wikis or maybe only Semantic Forms
GRANT SELECT , INSERT , UPDATE , DELETE , DROP , INDEX ,CREATE TEMPORARY TABLES ON  `newdatabase` . * TO  'wikiuser'@'localhost';


Add Wiki paths to and run Mediawiki installation/create or upgrade


Adjust LocalSettings.php/Common Settings

  • secret key (!)
    date | sha224sum
  • db, paths, logo, content language
  • for SMW in Common Settings: use the dbname as switch

Run maintenance wiki update script

sudo -u www-data php ./maintenance/update.php --dbuser wikiadmin --conf ./LocalSettings.php

User Rights

php ./maintenance/createAndPromote.php --help  --conf ./LocalSettings.php 
sudo -u www-data php ./maintenance/createAndPromote.php --force  --bureaucrat --sysop --conf ./LocalSettings.php "User Name"



check if "$wgUploadDirectory/temp"; is in place


Add URL to /etc/nginx/sites-available/

cd /etc/nginx/sites-available/ # : file: default adjustm nginx config: adjust server names

Symlink newwiki in /etc/nginx/sites-available/ to /etc/nginx/sites-enabled/

  • test all nginx configuration before restarting sudo nginx -t -c /etc/nginx/nginx.conf
  • restart nginx sudo service nginx restart

Add certificate

Add URL for a new certificate to get also https working see HTTPS Support via Let’s Encrypt

Optionally restarts

Usually not needed: restart nginx, php5-fpm, apache

sudo /usr/sbin/apache2ctl -k graceful && sudo service nginx restart && sudo service php5-fpm restart