Difference between revisions of "Updating"

From Anarchaserver
 
(16 intermediate revisions by 2 users not shown)
Line 1: Line 1:
How to keep things up to date?!
How to keep things up to date in Our Living Sites?!
Before updating! BACKUP!


Via the graphical use interface (sftp) of the service or via the commandline
= Update from Mediawiki 1.25 to Mediawiki 1.32 =
(the virtual machine) access? Activating ssh by sftp (ssl) means granting 'user' access to root folder to change directories.
Raw bash_history


Guidelines:
<syntaxhighlight lang=bash>
https://devtidbits.com/2011/06/29/implement-a-sftp-service-for-ubuntudebian-with-a-chrooted-isolated-file-directory/
mysqladmin -u thf -p drop anarcha
mysqladmin -u thf -p create anarcha
mysql -u thf -p anarcha < /home/anarcha03052018.sql
cd maintenance/
nano ../LocalSettings.php
# check dbprefix ! set to mw_
php update.php
systemctl start mysql
mysqlcheck -u thf -p anarcha --auto-repair
mysqlcheck -u thf -p anarcha --check
mysqlcheck -u thf -p anarcha --optimize
mysqlcheck -u thf -p anarcha --databases
mysql_upgrade -u root -p
nano LocalSettings.php
wget https://extdist.wmflabs.org/dist/extensions/ConfirmEdit-REL1_32-4a925f4.tar.gz
tar -xzf ConfirmEdit-REL1_32-4a925f4.tar.gz -C /var/www/mediawiki/extensions
nano LocalSettings.php
tail -f /var/log/apache2/alexandria-error.log
ls -al extensions/
chown -R root:root extensions/ConfirmEdit/
ls -al extensions/
ls -al extensions/ConfirmEdit/ConfirmEdit.alias.php
nano extensions/ConfirmEdit/ConfirmEdit.alias.php
nano LocalSettings.php
tail -f /var/log/apache2/alexandria-error.log
nano LocalSettings.php
apt-get install php-pear
pear install mail
pear install net_smtp
nano LocalSettings.php
cd resources/assets/
wget https://repository.anarchaserver.org/_data/i/upload/2018/09/11/20180911142919-de5107ae-me.png
mv 20180911142919-de5107ae-me.png ada.png
nano LocalSettings.php
nano /var/www/mediawiki/skins/Timeless/resources/libraries/normalise.css
nano /etc/php/7.0/apache2/php.ini  # augment upload and max_post_siez
rm ConfirmEdit-REL1_32-4a925f4.tar.gz
wget https://gitlab.com/hydrawiki/extensions/EmbedVideo/-/archive/v2.8.0/EmbedVideo-v2.8.0.zip
unzip EmbedVideo-v2.8.0.zip -d extensions/
nano LocalSettings.php
cd extensions/
mv EmbedVideo-v2.8.0/ EmbedVideo/
apt install install imagemagick
apt install imagemagick
</syntaxhighlight>


An option could also be the hybrid: a commandline interface in Wordpress:
* Update Tips (re index db ...) https://www.mediawiki.org/wiki/Manual:Restoring_a_wiki_from_backup
http://wp-cli.org/
* Config SMTP https://www.mediawiki.org/wiki/Manual:$wgSMTP


____________________________
~Before updating! BACKUPING ~
____________________________


== CSS Tuning for Timeless Mediawiki ==
Possible for 'sysop' users to edit this page and modify the CSS https://alexandria.anarchaserver.org/index.php?title=MediaWiki:Timeless.css&action=edit


Backup mysql datbases
Other tunings :


<code>mysqldump --all-databases -u root -p (password)</code>
To remove Libertine typo
nano skins/Timeless/resources/variables.less
modify line 41
@fonts: 'Helvetica Neue', 'Nimbus Sans', 'Helvetica', 'Arial', sans-serif;
@fonts-secondary: 'Helvetica Neue', 'Nimbus Sans', 'Helvetica', 'Arial', sans-serif;
//@fonts-secondary: 'Linux Libertine', 'Times New Roman', serif;
 
= BACKUP a mysql database =
 
Backup mysql databases
 
sudo mysql -u root
mysql> show databases;
sudo mysqldump (name-database) -u root -p (password) > database.sql
 
 
Copy databases locally
rsync -ah --progress -R (url):/home/(folder)
 
Copy web folder /var/www
rsync -ah --progress -R (url):/var/www
 
 
Export Wordpress by the webinterface

Latest revision as of 20:59, 6 May 2019

How to keep things up to date in Our Living Sites?! Before updating! BACKUP!

Update from Mediawiki 1.25 to Mediawiki 1.32

Raw bash_history

mysqladmin -u thf -p drop anarcha
mysqladmin -u thf -p create anarcha
mysql -u thf -p anarcha < /home/anarcha03052018.sql 
cd maintenance/
nano ../LocalSettings.php
# check dbprefix ! set to mw_
php update.php 
systemctl start mysql
mysqlcheck -u thf -p anarcha --auto-repair
mysqlcheck -u thf -p anarcha --check
mysqlcheck -u thf -p anarcha --optimize
mysqlcheck -u thf -p anarcha --databases
mysql_upgrade -u root -p
nano LocalSettings.php
wget https://extdist.wmflabs.org/dist/extensions/ConfirmEdit-REL1_32-4a925f4.tar.gz
tar -xzf ConfirmEdit-REL1_32-4a925f4.tar.gz -C /var/www/mediawiki/extensions
nano LocalSettings.php
tail -f /var/log/apache2/alexandria-error.log 
ls -al extensions/
chown -R root:root extensions/ConfirmEdit/
ls -al extensions/
ls -al extensions/ConfirmEdit/ConfirmEdit.alias.php 
nano extensions/ConfirmEdit/ConfirmEdit.alias.php 
nano LocalSettings.php
tail -f /var/log/apache2/alexandria-error.log 
nano LocalSettings.php
apt-get install php-pear
pear install mail
pear install net_smtp
nano LocalSettings.php
cd resources/assets/
wget https://repository.anarchaserver.org/_data/i/upload/2018/09/11/20180911142919-de5107ae-me.png
mv 20180911142919-de5107ae-me.png ada.png
nano LocalSettings.php
nano /var/www/mediawiki/skins/Timeless/resources/libraries/normalise.css
nano /etc/php/7.0/apache2/php.ini  # augment upload and max_post_siez
rm ConfirmEdit-REL1_32-4a925f4.tar.gz 
wget https://gitlab.com/hydrawiki/extensions/EmbedVideo/-/archive/v2.8.0/EmbedVideo-v2.8.0.zip
unzip EmbedVideo-v2.8.0.zip -d extensions/
nano LocalSettings.php
cd extensions/
mv EmbedVideo-v2.8.0/ EmbedVideo/
apt install install imagemagick
apt install imagemagick


CSS Tuning for Timeless Mediawiki

Possible for 'sysop' users to edit this page and modify the CSS https://alexandria.anarchaserver.org/index.php?title=MediaWiki:Timeless.css&action=edit

Other tunings :

To remove Libertine typo

nano skins/Timeless/resources/variables.less

modify line 41

@fonts: 'Helvetica Neue', 'Nimbus Sans', 'Helvetica', 'Arial', sans-serif;
@fonts-secondary: 'Helvetica Neue', 'Nimbus Sans', 'Helvetica', 'Arial', sans-serif;
//@fonts-secondary: 'Linux Libertine', 'Times New Roman', serif;

BACKUP a mysql database

Backup mysql databases

sudo mysql -u root
mysql> show databases;
sudo mysqldump (name-database) -u root -p (password) > database.sql


Copy databases locally

rsync -ah --progress -R (url):/home/(folder)

Copy web folder /var/www

rsync -ah --progress -R (url):/var/www


Export Wordpress by the webinterface