Difference between revisions of "User:Andreas Plank/new wiki"

From Biowikifarm Metawiki
Jump to: navigation, search
m
m (→‎Wiki)
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
phpMyAdmin: http://biowikifarm.net/phpmyadmin_v3-3-7/
+
<syntaxhighlight lang="php">
−
* copy z_en_template ->  as new database, e.g. my_new_wiki
+
$wgSiteNotice = "Announcing message of upgrade";
−
* grant rights to user 'wikiuser' for new database ( SELECT, INSERT, UPDATE, DELETE, DROP, INDEX, CREATE TEMPORARY TABLES )
+
$wgReadOnly = 'Database is in read only mode, because of Upgrading to MediaWiki 1.26.XX';
−
 
+
</syntaxhighlight>
−
in shell: copy a recent wiki: v-XXX (virtuel)
+
 
<syntaxhighlight lang="bash">
 
<syntaxhighlight lang="bash">
−
sudo cp --recursive --verbose XXX YYY
+
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>
 
</syntaxhighlight>
−
duplicate folder w:
 
−
* for short name
 
−
* clear cache directory
 
−
* remove images from old wiki
 
  
−
adjaust LocalSettings.php
+
== 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>
 
* secret key (!) <syntaxhighlight lang="bash">date | sha224sum</syntaxhighlight>
−
* db, paths, logo, contentlanguage
+
* db, paths, logo, content language
 +
* for SMW in Common Settings: use the dbname as switch
  
−
Common Settings file for SMW: dbname as switch to
+
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">
 
<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 apache, nginx, php5-fpm
+
 
 +
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>

Latest revision as of 22:48, 25 February 2020

$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/ (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';

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

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

Medaia

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

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
Retrieved from "https://biowikifarm.net/metawiki/index.php?title=User:Andreas_Plank/new_wiki&oldid=6572"