NUC Web

From wikidb
Revision as of 10:50, 27 November 2014 by 10.0.0.253 (Talk)

Jump to: navigation, search

Back

Rainier NUC

Common Setup

  • install apache2
  • install openssh-server - required for Fetch and ssh on Mac

Rainier Home Page

  • From Mac copied from the My Webs/root directory
    • index.htm
    • family0408L.jpg
    • index_files/

My Home Page

  • created /home/epp/public_html
  • chmod 0755 /home/epp/public_html
  • sudo a2enmod userdir
  • sudo service apache2 restart
  • copied web pages from Mac to public_html
    • index.htm
    • Icons/
    • Young.jpg
    • subdirectories
  • Ubuntu guide help
  • Apache docs help

MediaWiki

Install

Install required and optional packages

 sudo apt-get install mysql-server php5 php5-mysql libapache2-mod-php5
 sudo apt-get install php-apc php5-intl imagemagick phpmyadmin vsftpd php5-cli

Mediawiki Download for version 1.23.6.

  • Untar
  • Move to the wiki home. The recomended location for 14.04 ubuntu didn't work (/var/lib/mediawiki). The following worked:
 sudo mv mediawiki-1.23.6/ /var/www/html/wiki

Backup zdome

Backing up a wiki

On zdome:

 mysqldump --user=root --password=jet43fred wikidb > wikidb-20141125.sql tar xzf wiki20141125.tgz
 tar czpf wiki20141125.tgz /var/www/html/wiki/

Move wiki to rainier

Moving a wiki

On rainier copy and unpackage the wiki:

 scp epp@10.0.0.8:/home/dbbackup/dbbackups/wikidb/wikidb-20141125T1125.sql.gz .
 scp epp@10.0.0.8:/home/...../wiki20141125.tgz
 tar xzf wiki20141125.tgz
 gunzip wikidb-20141126T1119.sql.gz

Create the wikidb on MySQL

 mysql -u root -p
 
 mysql> CREATE DATABASE wikidb;
     Query OK, 1 row affected (0.00 sec)
 
 mysql> show databases;
     +--------------------+
     | Database           |
     +--------------------+
     | information_schema |
     | mysql              |
     | performance_schema |
     | wikidb             |
     +--------------------+
     4 rows in set (0.00 sec)
 
 mysql> GRANT ALL ON wikidb.* TO 'epp' IDENTIFIED BY 'passwd';
     Query OK, 0 rows affected (0.00 sec)
 
 mysql> quit
     Bye

Other Databases

Repeated for

  • gallery
  • crowlivia