Tipps and Tricks

• Installing LAMP at Ubuntu: http://www.howtoforge.com/ubuntu_lamp_for_newbies
• MYSQL Password reset: https://help.ubuntu.com/community/MysqlPasswordReset
• Add User to (secondary) group: usermod -a -G {group-name} username

• Allow SSH console login (from PC with PUTTY)
1. check if package openssh-server is installed.
2. copy file /etc/ssh/sshd_config to a backup copy /etc/ssh/sshd_config.bak
3. allow user "wolfgang" to get access via ssh by adding the line
   AllowUsers wolfgang
   to the file /etc/ssh/sshd_config
• Install LAMP like in http://wiki.ubuntuusers.de/LAMP:
  1. sudo apt-get install apache2 php5 php5-mysql mysql-server
  2. start apache2: sudo service apache2 start
  3. test by navigating to http://ursubuntu.fritz.box/
• Install MySQL, set user "root", and install PHPMYADMIN
• Setup NFS-mounts to puconnas01:
  • Install nfs-components: http://www.cyberciti.biz/tips/ubuntu-linux-nfs-client-configuration-to-mount-nfs-share.html
  • Setup NFS mounts permanentely: http://blog.stevenocchipinti.com/2011/08/mounting-nfs-in-ubuntu.html
  • Mount public:
    • mkdir /mnt/puconnas01
    • mkdir /mnt/puconnas01/public
    • sudo mount -o soft,intr,rsize=8192,wsize=8192 puconnas01.lan:/public /mnt/puconnas01/public
  • Mount scanBuffer:
    • mkdir /mnt/puconnas01/scanBuffer
    • sudo mount -o soft,intr,rsize=8192,wsize=8192 puconnas01.lan:/scanBuffer /mnt/puconnas01/scanBuffer
• Move MySQL Data Directories to NAS:
  • Instructions
  • create MYSQL data directory on NAS: # sudo mkdir /mnt/puconnas01/public/mysql_data
  • sudo chown -R mysql /mnt/puconnas01/public/mysql_data
  • sudo chgrp -R mysql /mnt/puconnas01/public/mysql_data
  • stop MYSQL: # sudo /etc/init.d/mysql stop
  • find out current MYSQL data directory: # grep datadir /etc/mysql/my.cnf
  • this should deliver /var/lib/mysql
  • copy data files over to NAS: # sudo cp -R -p /var/lib/mysql/. /mnt/puconnas01/public/mysql_data
  • tell MYSQL by editing my.cnf: sudo vi /etc/mysql/my.cnf
  • change the datadir entry from /var/lib/mysql to /mnt/puconnas01/public/mysql_data
  • now tell AppArmor to allow MYSQL to access the new data directory:
    • edit: sudo vi /etc/apparmor.d/usr.sbin.mysqld
    • Change 2 Lines containting /var/lib/mysql to new directory /mnt/puconnas01/public/mysql_data
    • # sudo /etc/init.d/apparmor reload
  • Restart MYSQL: sudo /etc/init.d/mysql restart or (better) $ sudo service mysql restart
• Link Web files to NAS:
  • cd /var/www
  • ln -s /mnt/puconnas01/public/www ./public
• Install and set up MediaWiki
  • Instructions:
    • http://www.mediawiki.org/wiki/Manual:Installing_MediaWiki/de
    • http://www.mediawiki.org/wiki/Manual:Running_MediaWiki_on_Ubuntu
  • ursubuntu actions to install:
    • $ cd /mnt/puconnas01/public/www
    • $ sudo cp /mnt/puconnas01/public/Software/Linux/Ubuntu/Mediawiki/mediawi* .
    • $ sudo tar -xvzf ./mediawiki-*.tar.gz
    • $ sudo ln -s mediaw<TAB> wiki
  • invoke configuration web application by navigating to http://ursubuntu.fritz.box/public/wiki/
  • ursubuntu-specific parameters:
    • Datenbankserver: ursubuntu.fritz.box
    • Datenbankname: mediawiki
    • Datenbanktabellenprefix: mw_
    • Datenbankkonto für den Webzugriff: wikiuser, (the usual password)
    • Datenbankzeichensatz: UTF-8
    • Administratorkonto: root, (the usual password), Email: w.scherer@aon.at
    • Profil der Benutzerberechtigungen: Ausschließlich berechtigte Bearbeiter
    • Email-Adresse für Antworten: w.scherer@aon.at
    • Erweiterungen: alle
    • Das Hochladen von Dateien ermöglichen: ja
  • After running the configuration, the file LocalSettings.php is saved to file:////puconnas01/public/Software/Linux/Ubuntu/Mediawiki/LocalSettings.php and uploaded un ursubuntu to /mnt/puconnas01/public/www/wiki/LocalSettings.php
  • As of mediawiki V 1.21.1 a fix has to be done to LocalSettings.php:
    • according to this thread:
    • After require_once( “$IP/extensions/LocalisationUpdate/LocalisationUpdate.php” ); an additional line has to be inserted:
    • $wgLocalisationUpdateDirectory = "$IP/cache";
  • Enabling file: Links:
    • Add: array_push($wgUrlProtocols, "file://"); to LocalSettings.php.