Installing on Mini-Box

These are installation notes for getting the mini-box LCD appliance up and running with Ubuntu Server 32-bit 8.10 (Intrepid) wth an Atom processor and making use of the menuing system.

Ubuntu

Although we will intend to run this box without a monitor for the moment we will plug in the monitor to install Ubuntu from a USB-CDROM. Make sure the BIOS is configured to boot from the CD-ROM. Also, under Peripheral Devices you will need to enable all legacy support (or it will hang on installation).

For a flash drive, apparently Josh has had some success following these directions.

We will do a Software Raid. Once it has been setup, we need to monitor it using mdadm: To do this:

sudo dpkg-reconfigure mdadm

Please enter the following:

 Yes: periodic, monthly checks of the array
 Yes: MD monitoring daemon
 someone@somwhere.org:  Email address for monitoring
 Yes: Start with degraded array

Mail Server

We don't want our box to be the general mail server for the network. There is a mail server, postfix, installed by default on Ubuntu We will want to set the mail server to relay email to some other place. First we need to do:

sudo apt-get install postfix

Then select

 Satellite System     //the type of system
 somewhere.org        //the name of your organization
 smtp.somewhere.org   //your smtp server to relay mail to

The above assumes that smtp.somewhere.org is an open relay which is probably not the case.

You will probably need to set Postfix up for SMTP Auth

As an alternative here are some instructions for forwarding to a gmail accout.

LAMP Server

In case you forgot to install the LAMP server on Unbuntu installation, make sure you do a

sudo apt-get install openssh-server^
sudo apt-get install lamp-server^
sudo apt-get install php5-cli

and generally follow the instructions:

http://wiki.ihris.org/wiki/Linux_(Ubuntu)_Installation

If you don't want to install phpmyadmin just to create the needed database you can do:

mysql -u root -p
mysql> CREATE DATABASE ihris_manage;
mysql> GRANT ALL PRIVILEGES ON ihris_manage.* TO ihris_manage@localhost identified by 'PASSS';

USBLCD Reader

Download and build the SDK or at least just what it includes usblcd-src. Install 'usbread' into the /home/lcdmenu/bin. To build it you will need to do this:

sudo apt-get install autoconf gcc-4.1-base gcc-4.1 gcc make automake binutils binutils-dev libtool libusb-dev libhid-dev bzr
cd ~lcdmenu
sudo -u lcdmenu bzr branch http://bazaar.launchpad.net/%7Eintrahealth%2Binformatics/lcdmenu/dev-1.0/ bin
cd ~/
wget http://www.mini-itx.com/store/information/usblcd/usblcd-src-0.1.4.tgz
tar -xzvf usblcd-src-0.1.4.tgz
cd usblcd-0.1.4
rm src/Makefile.am lib/usblcd.c
ln -s ~lcdmenu/bin/usblcd lib/usblcd.c
ln -s ~lcdmenu/bin/Makefile.am src/Makefile.am
ln -s ~lcdmenu/bin/main2.c src/main2.c
./autogen.sh
./configure
sudo make install

LCD Menu

First create a user 'lcdmenu' that can't login:

 sudo adduser --disabled-login --gecos \'\' lcdmenu 

(those quotes should not be slashed)

This applies to LCD Menu 1.0 which is not packaged yet. You have already downloaded it via bzr in the step above

Now edit the "sudoers" file by running:

sudo visudo 

and add this line to grant the lcdmenu user limited access to system functions

%lcdmenu ALL=NOPASSWD: /sbin/shutdown, /etc/init.d/networking, /etc/init.d/apache2, /etc/init.d/mysql, /usr/bin/mysqldump, /usr/bin/apt-get, /usr/local/bin/usblcd2, /usr/bin/killall

Create a "backup" user in mysql with localhost only access and no password which can lock and select all tables

  mysql -u root -p
  mysql> GRANT SELECT,LOCK TABLES on *.* TO backup@localhost IDENTIFIED BY PASSWORD \'\';
  mysql> quit;

(again no slashes)

Now we want it to setup to run periodically:

sudo crontab -u lcdmenu -e 
* * * * * /home/lcdmenu/bin/lcdmenu_check.sh >/dev/null 2>&1

Optionally, we can get it up and running as fast as possible by putting it in the startup:

sudo vi /etc/init.d/local

Add these contents:

#!/bin/sh 
case "$1" in
 start)
   sudo -u lcdmenu /home/lcdmenu/bin/lcdmenu_check.sh
   ;;
 stop)
   run=`ps a -Ulcdmenu | grep /home/lcdmenu/bin/lcdmenu.php | grep -v grep | cut -c1-5 | paste -s -`
   if [   "$run" ]; then
        kill -15 $run
   fi;
   run=`ps a -Ulcdmenu | grep /home/lcdmenu/bin/lcdmenu.php | grep -v grep | cut -c1-5 | paste -s -`
   if [   "$run" ]; then
        sleep 1
        kill -9 $run
   fi;
   /usr/local/bin/usblcd clear backlight 1
   ;;
esac

Now do:

sudo chmod +x /etc/init.d/local
sudo update-rc.d local defaults 80

Automount

The LCD Menuing system has a "backup MySQL database to a flash drive" feature. Since we will not be using GNOME, we will need a USB automounter:

  sudo apt-get install usbmount

Then edit the file /etc/usbmount/usbmount.conf and add "vfat" to the FILESYSTEMS e.g:

   FILESYSTEMS="ext2 ext3 vfat"

then make sure the FS_MOUNTOPTIONS line has at least:

   FS_MOUNTOPTIONS="gid=lcdmenu,dmask=0007,fmask=0117"

Power Button

Make sure acpid is installed and running and change /etc/acpi/powerbtn.sh to suit your needs. I suggest you just make it the following:

test -f /var/lock/acpisleep && exit 0
run=`ps a -Ulcdmenu | grep /home/lcdmenu/bin/lcdmenu.php | grep -v grep | cut -c1-5 | paste -s -`
if [   "$run" ]; then
   kill -15 $run
fi;
run=`ps a -Ulcdmenu | grep /home/lcdmenu/bin/lcdmenu.php | grep -v grep | cut -c1-5 | paste -s -`
if [   "$run" ]; then
   sleep 1
   kill -9 $run
fi;
/usr/local/bin/usblcd clear backlight 1 text 0 0  "   Shutting Down   " text 1	0 "    Please Wait  "
/sbin/shutdown -h now "Power button pressed"

UPS

Install nut and follow these directions as well as whatever is available on the home page of the nut package. nut is built for network access to a UPS but seems to be the most up-to-date package available.

Network Status

The MAC Address, to configure your router, can be obtained from the LCD Menu:

>F1:Server Status
>F2:Network Status
>F3:MAC Address

Similarly, if you have plugged the server into a network with DHCP, you can get the IP Address:

>F1:Server Status
>F2:Network Status
>F3:MAC Address

Webmin

See me or just cut and paste:

sudo aptitude install perl libnet-ssleay-perl openssl libauthen-pam-perl libpam-runtime libio-pty-perl libmd5-perl
wget http://garr.dl.sourceforge.net/sourceforge/webadmin/webmin_1.441_all.deb
sudo dpkg -i webmin_1.441_all.deb

Browse to:

https://your-server-ip:10000/

and login as the user you created on Ubuntu installation.