Difference between revisions of "User:Andreas Plank/new wiki"
From Biowikifarm Metawiki
m |
m |
||
| Line 9: | Line 9: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| − | + | == Database == | |
| − | * copy z_en_template -> as new database, e.g. | + | http://biowikifarm.net/phpmyadmin_v3-3-7/ |
| − | * | + | * copy z_en_template -> as new database, e.g. newdatabase |
| + | * or export structure as SQL and execute it in newdatabase | ||
| − | + | grant rights to user 'wikiuser' for new database | |
| − | <syntaxhighlight lang=" | + | <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> | </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> | * secret key (!) <syntaxhighlight lang="bash">date | sha224sum</syntaxhighlight> | ||
| − | * db, paths, logo, | + | * 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 | ||
| + | |||
| + | == NGINX == | ||
| + | |||
| + | Add URL to /etc/nginx/sites-available/ | ||
<syntaxhighlight lang="bash"> | <syntaxhighlight lang="bash"> | ||
cd /etc/nginx/sites-available/ # : file: default adjustm nginx config: adjust server names | cd /etc/nginx/sites-available/ # : file: default adjustm nginx config: adjust server names | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| − | restart | + | |
| + | 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"> | <syntaxhighlight lang="bash"> | ||
sudo /usr/sbin/apache2ctl -k graceful && sudo service nginx restart && sudo service php5-fpm restart | sudo /usr/sbin/apache2ctl -k graceful && sudo service nginx restart && sudo service php5-fpm restart | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| − | |||
| − | |||
Revision as of 18:24, 5 February 2019
$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
http://biowikifarm.net/phpmyadmin_v3-3-7/
- copy z_en_template -> as new database, e.g. newdatabase
- or export structure as SQL and execute it in 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';
Wiki
Add Wiki paths to and run Mediawiki installation/create or upgrade vhost-wiki.sh
Settings
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
NGINX
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
