View source for Ubuntu Local Wiki Import

Tested on Ubuntu-Mate 20.04<br \>
Download CompleteNoobs wiki and Keep Private Copy you can edit as you wish on your own computer.

==Download CompleteNoobs's XML dump==

[https://xml.completenoobs.com CompleteNoobs xml dump]

==Create a container==

<code>lxc launch ubuntu:20.04 localwiki</code><br \>
Push file conataining xml dump to container<br \>
<code>lxc file push wiki-dump.xml localwiki/root/</code><br \>
Log/Chroot into container<br \>
<code>lxc exec localwiki bash</code><br \>

===update container and set to auto update===
update container<br \>
<code>apt update && apt upgrade -y</code><br \>
Auto updates<br \>
<code>$EDITOR /etc/apt/apt.conf.d/50unattended-upgrades</code><br \>
Uncomment the line:<br \>
<pre>// "${distro_id}:${distro_codename}-updates";</pre>
to
<pre>"${distro_id}:${distro_codename}-updates";</pre>
===Install mediawiki===
<code>apt install apache2 mysql-server php php-mysql libapache2-mod-php php-xml php-mbstring php-intl -y</code>

<code>wget https://releases.wikimedia.org/mediawiki/1.39/mediawiki-1.39.2.tar.gz</code>

<code>tar -zxvf mediawiki-1.39.2.tar.gz</code>

<code>mv mediawiki-1.39.2 /var/www/html/mediawiki </code>

===Create database===

As this is just for your own computer on your own network, you can keep it super simple:<br \>
<code>mysql -u root</code><br \>
<code>CREATE USER 'u'@'localhost' IDENTIFIED BY 'passwd';</code><br \>
<code>CREATE DATABASE db;</code><br \>
<code>use db;</code><br \>
<code>GRANT ALL ON db.* TO 'u'@'localhost';</code><br \>
<code>quit;</code><br \>
<div class="toccolours mw-collapsible mw-collapsed">
Syntax Database setup:
<div class="mw-collapsible-content">
Login to Mysql as user root:
<code>mysql -u $USER</code><br \>
<br \>
<code>CREATE USER '$USERNAME'@'localhost' IDENTIFIED BY '$PASSWORD';</code><br \>
<code>CREATE DATABASE $DATABASE_NAME;</code><br \>
<code>use $DATABASE_NAME;</code><br \>
<code>GRANT ALL ON $DATABASE_NAME.* TO '$USER'@'localhost';</code><br \>
</div>
</div>

===Config Apache2===


<code>$EDITOR /etc/apache2/sites-available/000-default.conf</code>
<pre>
<VirtualHost *:80>
        DocumentRoot /var/www/html/mediawiki
</VirtualHost>

</pre>


====Reload Apache2====

<code>
systemctl restart apache2 
</code>

===Visit webpage and carry on with normal basic wiki setup===

Use <code>lxc list</code> on host to get IP address for your container: mine is 
<b>10.3.45.40</b><br \>
With a web browser visit enter the ip in the address bar.<br \>
You will now find yourself on the mediawiki setup landing page.<br \>
<blockquote>
MediaWiki 1.36.1
LocalSettings.php not found.
Please complete the installation and download LocalSettings.php.
</blockquote>

Click <b>complete the installation</b><br \>

<div class="toccolours mw-collapsible mw-collapsed">
Language Page
<div class="mw-collapsible-content">
Just pick a language mate
</div>
</div>

<div class="toccolours mw-collapsible mw-collapsed">
Welcome to MediaWiki!
<div class="mw-collapsible-content">
read and click Continue
</div>
</div>

<div class="toccolours mw-collapsible mw-collapsed">
Connect to database - going to need the details from when you created the database.
<div class="mw-collapsible-content">
Database host:localhost<br \>
Database name:db<br \>
Database table prefix (no hyphens): <b>LEAVE BLANK</b><br \>
Database username:u<br \>
Database password:passwd<br \>
</div>
</div>

<div class="toccolours mw-collapsible mw-collapsed">
Database Settings
<div class="mw-collapsible-content">
Database account for web access<br \>
[x]Use the same account as for installation<br \>
<b>Leave ticked</b>
</div>
</div>

<div class="toccolours mw-collapsible mw-collapsed">
Name
<div class="mw-collapsible-content">
<b>Name of wiki:</b>LocalWiki<br \>
<b>Project namespace:</b><br \>
[x]Same as the wiki name:<br \>
[ ]Project<br \>
[ ]Other (specify)<br \>
<b>Administrator account</b>
Will be the admin account on the wiki.
<br \>
<b>CLICK I'm bored already, just install the wiki.</b>
</div>
</div>

At the end you would of downloaded a file called <b>LocalSettings.php</b><br \>
Now lets send it to the container from host.

===Send LocalSettings to Container===

From host:<br \>
<code>lxc file push Downloads/LocalSettings.php localwiki/var/www/html/mediawiki/</code><br \>

===restore xml dump===

In container<br \>
<code>php /var/www/html/mediawiki/maintenance/importDump.php --conf /var/www/html/mediawiki/LocalSettings.php /root/wiki-dump.xml</code><br \><br \>
<code>php /var/www/html/mediawiki/maintenance/rebuildrecentchanges.php</code><br \>
<code>php /var/www/html/mediawiki/maintenance/initSiteStats.php</code><br \>
<code>php /var/www/html/mediawiki/maintenance/rebuildall.php</code><br \>

:* can be done in one line using '''&&'': <code>php /var/www/html/mediawiki/maintenance/rebuildrecentchanges.php && php /var/www/html/mediawiki/maintenance/initSiteStats.php && php /var/www/html/mediawiki/maintenance/rebuildall.php</code>
:** The '''&&''' operator is known as the "AND" operator. It is used to execute a command only if the previous command completes successfully.

===Youtube extension===
https://www.mediawiki.org/wiki/Extension:YouTube

<code>wget https://extdist.wmflabs.org/dist/extensions/YouTube-REL1_39-f272bb3.tar.gz</code>

<code>tar -xzf YouTube-REL1_39-f272bb3.tar.gz -C /var/www/html/mediawiki/extensions/</code>

* Append to '''LocalSettings.php'''
<code>wfLoadExtension( 'YouTube' );</code>

* On wiki page can now embed youtube videos
** https://www.youtube.com/watch?v=wB4gvSgYmfY
** After '''watch?v='''
** <nowiki><youtube>wB4gvSgYmfY</youtube></nowiki>
* Defaults '''width'''=640 pixels '''height'''=385 pixels
* Change defaults <nowiki><youtube width="800" height="400">wB4gvSgYmfY</youtube></nowiki>

===Visit your local copy of CompleteNoobs===

In Browser go to http://$YOUR_CONTAINERS_IP<br \>

Everything apart from <b>index.php/Main_Page</b> restored.<br \>
Edit main page to have link to main_index<br \>
<nowiki>[[Main_Index | wiki index]]</nowiki><br \>
And thats why we have a [[Main_Index]] page.

==Syntax highlighting not working==
Install <b>pygments</b><br>
<code>apt install python3-pygments</code><br>

Add to LocalSettings:<br>
<code>wfLoadExtension( 'SyntaxHighlight_GeSHi' );</code><br>

==script to auto install wiki in container - Draft0==

<syntaxhighlight lang='bash' line>
#!/bin/bash

# check root
if [ "$EUID" -ne 0 ]
  then echo "you need to run as root!"
  exit
fi
#check running ubuntu 22.04
CHECK_UBUNTU=$(lsb_release -i | awk '{print $3}')
CHECK_UBUNTU2004=$(lsb_release -r | awk '{print $2}')
if [ $CHECK_UBUNTU == "Ubuntu" ]
    then
        if [ $CHECK_UBUNTU2004 == "22.04" ]
            then
                printf "You are running $CHECK_UBUNTU $CHECK_UBUNTU2004\n\n"
            else
                echo "are you sure your running ubuntu 22.04?"
                echo $CHECK_UBUNTU $CHECK_UBUNTU2004
                printf "This script is intended for Ubuntu 22.04\nExiting script\n"
                exit 1
        fi
     else
         printf "This script is intended for ubuntu 22.04!\nScript exiting\n"
         exit 1
fi


#####################################################

printf "\nThis is a script in development!\n"
printf "For quickly installing the basic's of mediawiki on a ubuntu 22.04 container\n"
printf "Enter \"yes\" to continue with script or press anykey to exit!\n"

printf "\n
What this script will do:\n
\n\t3. Install software packages:
\t\t apache2
\t\t mysql-server
\t\t php
\t\t php-mysql
\t\t libapache2-mod-php
\t\t php-xml
\t\t php-mbstring
\t\t php-intl
\t\t mediawiki-1.39.2
\n\t4. Take name for your localwiki
\n\t 5a. Download, checksum, extract to path: \'MediaWiki-1.34.2\'
\t 5b. Download, checksum and move to path file \'apache.conf.backup\' - template for configuring apache
\n\t7. Create Database for mediawiki
\n\t8. Configure Apache
\n\t10. Will echo/display details required for finishing media setup on web browser
\n\n\tPlease type \"yes\" case sensitive to continue!\n
\tJust Press Enter to Exit Script!\n
\tEnter anwser here :"

read anypress

if [ -z "$anypress" ]
    then
        printf "Exiting Script!"
        sleep 1
        exit 1
    else
        if [ $anypress == "yes" ]
        then
            printf "starting script ....."
            sleep 1
        else
            printf "Exiting Script!"
            sleep 1
            exit 1
        fi
fi

####################################################
########### check system up to date
apt update && apt upgrade -y && apt autoremove -y


###########################################
########### Install packages
# checksum of mediawiki download.
# add patch and check sig
# when downloading from github add(?raw=true) at the end or you will download a html page.

# Install main packages from ubuntu repos
apt install apache2 mysql-server php php-mysql libapache2-mod-php php-xml php-mbstring php-intl -y

######
# download and checksums of media wiki
MediaWiki_Sum="ddb51d228a19ca68cd8871d850175f6bef46874476ed1466f015cf9846d9c7a5"
wget https://releases.wikimedia.org/mediawiki/1.39/mediawiki-1.39.2.tar.gz

# Check md5sum of download and extract to directory
MediaWiki_Sum_CHECK="$(sha256sum mediawiki-1.39.2.tar.gz | awk '{print $1}')"

if [ $MediaWiki_Sum == $MediaWiki_Sum_CHECK ] ;
    then
        echo "checksum checks out:"
        tar -zxvf mediawiki-1.39.2.tar.gz -C /var/www/html/
        mv /var/www/html/mediawiki-1.39.2 /var/www/html/mediawiki
        rm mediawiki-1.39.2.tar.gz
    else
        echo "Checksum not checking out"
        printf "looking for $MediaWiki_Sum but found $MediaWiki_Sum_CHECK"
        read -r -p $" Press Enter to Exit Script"
        exit 1
fi

#########################

# apache quick config
function apacheconfigfunc {
printf "<VirtualHost *:80>\n\tDocumentRoot /var/www/html/mediawiki\n</VirtualHost>\n"
}

apacheconfigfunc >  /etc/apache2/sites-available/000-default.conf
# restart apache2
systemctl restart apache2

#end apache quick config
##########################################

#Container ip function
####Print IP for container
function conIPfun {
hostname -I | awk '{print $1}'
}

ConIPVar=$(hostname -I | awk '{print $1}')

echo $ConIPVar

###################
########################
##EmbedVideo extension
EmbedSum="b8b4ccf516e5ba8f47f11e415fe0ac325e9d05eb1cc750c808191e7e8a15360f"
apt install unzip -y
wget https://gitlab.com/hydrawiki/extensions/EmbedVideo/-/archive/v2.9.0/EmbedVideo-v2.9.0.zip
CheckEmbed="$(sha256sum EmbedVideo-v2.9.0.zip | awk '{print $1}')"

if [ $CheckEmbed == $EmbedSum ] ;
    then
        echo "checksum checks out:"
        unzip EmbedVideo-v2.9.0.zip -d /var/www/html/mediawiki/extensions/
        mv /var/www/html/mediawiki/extensions/EmbedVideo-v2.9.0 /var/www/html/mediawiki/extensions/EmbedVideo
    else
        echo "Checksum not checking out"
        printf "looking for $EmbedSum but found $CheckEmbed"
        read -r -p $" Press Enter to Exit Script"
        exit 1
fi

#####
# Create Database
mysql -u root <<MYSQL_SCRIPT
CREATE USER 'wiki'@'localhost'; # not needed for root
CREATE DATABASE my_wiki;
use my_wiki;
GRANT ALL ON my_wiki.* TO 'wiki'@'localhost';
MYSQL_SCRIPT
# Remember to change name from 'root' to 'wiki' and push file to container:
CON_NAME=$(uname -a | awk '{print $2}')

echo "Now visit the IP $ConIPVar from a browser"
echo "and change the database username from 'root' to 'wiki' on the DateBase Page"
echo "When finished you will download a 'LocalSettings.php' file"
echo "You need to push this file into the container $CON_NAME from your download directory"
echo "you can use 'lxc file push' to copy the file into the container"
echo "lxc file push /home/USERNAME/Downloads/LocalSettings.php $CON_NAME/var/www/html/mediawiki/"
echo "the setup script will continue as few seconds after."

###################################
# Wait for LocalSettings.php to be imported to Container #
while [ ! -f /var/www/html/mediawiki/LocalSettings.php ]
do
  sleep 2 # will check every 2 seconds to see if file is there
done

#####################################

#Noobs
curl -L xml.completenoobs.com/xmlDumps | grep Noobs | awk -F '"' '{print $2}' > /tmp/wi-dump.txt

#grep will find newest dated dump and assign to $newest
newest=$(grep -oE '^[0-9]{2}_[0-9]{2}_[0-9]{2}' /tmp/wi-dump.txt | sort -r | head -n 1)

temppath="/tmp/wi-dir/"
md5=$newest.md5sum.txt
xml=$newest.Noobs.xml
sha256=$newest.sha256sum.txt

#mkdir for dumps
mkdir /tmp/wi-dir

wget https://xml.completenoobs.com/xmlDumps/$newest.Noobs/$md5 -P /tmp/wi-dir/
wget https://xml.completenoobs.com/xmlDumps/$newest.Noobs/$sha256 -P /tmp/wi-dir/
wget https://xml.completenoobs.com/xmlDumps/$newest.Noobs/$xml -P /tmp/wi-dir/

# CheckSums before import
md5_dl=$(md5sum $temppath$xml | awk '{print $1}')
md5_file=$(cat /tmp/wi-dir/$md5 | awk '{print $1}')
sha256_dl=$(sha256sum $temppath$xml | awk '{print $1}')
sha256_file=$(cat $temppath$sha256 | awk '{print $1}')

if [ $md5file == $md5dl ];
then
	echo 'md5 checks out'
else
	echo 'does not check out'
fi

if [ $sha256_dl == $sha256_file ];
then 
	echo "sha256 checks out"
	#import to wiki
	echo "importing mediawiki database"
	php /var/www/html/mediawiki/maintenance/importDump.php --conf /var/www/html/mediawiki/LocalSettings.php $temppath$xml
	php /var/www/html/mediawiki/maintenance/rebuildrecentchanges.php
	php /var/www/html/mediawiki/maintenance/initSiteStats.php
	php /var/www/html/mediawiki/maintenance/rebuildall.php
else
	echo "checksum not checking out"
	exit 1
fi

# dont forget clean up
rm -rf /tmp/wi-dir/*

</syntaxhighlight>