View source for User:Andreas Plank/new wiki

<syntaxhighlight lang="php">
$wgSiteNotice = "Announcing message of upgrade";
$wgReadOnly = 'Database is in read only mode, because of Upgrading to MediaWiki 1.26.XX';
</syntaxhighlight>
<syntaxhighlight lang="bash">
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" '{}' ';'
</syntaxhighlight>

== Database ==
http://biowikifarm.net/phpmyadmin_v3-3-7/ (there is a bug in 3.7.7 that crashes because it merges some SQL together with  <code>current_timestamp()</code>) 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
<syntaxhighlight lang="mysql">
-- 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';
</syntaxhighlight>

== Wiki ==
Add Wiki paths to and run [[Mediawiki installation/create or upgrade vhost-wiki.sh]]

=== Settings ===
Adjust LocalSettings.php/Common Settings
* secret key (!) <syntaxhighlight lang="bash">date | sha224sum</syntaxhighlight>
* 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"

=== Sites ===

* [[MediaWiki:Shared-repo-name-openmedia]]
* [[MediaWiki:Shared-repo-name-specialmedia]]

=== Medaia ===

check if <syntaxhighlight lang="php" inline>"$wgUploadDirectory/temp";</syntaxhighlight> is in place

== NGINX ==

Add URL to /etc/nginx/sites-available/
<syntaxhighlight lang="bash">
cd /etc/nginx/sites-available/ # : file: default adjustm nginx config: adjust server names
</syntaxhighlight>

Symlink newwiki in /etc/nginx/sites-available/ to /etc/nginx/sites-enabled/
* test all nginx configuration before restarting <code>sudo nginx -t -c /etc/nginx/nginx.conf</code>
* restart nginx <code>sudo service nginx restart</code>

=== Add certificate ===
Add URL for a new certificate to get also https working see [[HTTPS_Support_via_Let’s_Encrypt#Updating_the_certificates_for_newly_added_wikis|HTTPS Support via Let’s Encrypt]]

=== Optionally restarts ===
Usually not needed: restart nginx, php5-fpm, apache
<syntaxhighlight lang="bash">
sudo /usr/sbin/apache2ctl -k graceful && sudo service nginx restart && sudo service php5-fpm restart
</syntaxhighlight>