Appion

h1. myami on Ubuntu

This is a work in progress. Use at your own risk.  This is mainly a log of various experiences installing myami on Ubuntu which will gradually evolve into a more formal document.  This will attempt to demonstrate the installation of all of myami including both leginon and appion on a single Ubuntu host.  This will also include running MySQL, Apache Torque, etc. on this local host without needing to connect to any other host.

h2. Installing a basic Ubuntu system

We use Ubuntu 12.04 LTS (Precise) Desktop 64 bit.  Install a basic system from an image on CD or bootable USB drive. Default selections during the install process, no 3rd party repositories, no network configuration and no updates during the installation.  This makes it easier in the remainder of this document to know that we have started from a known base system.  Reboot.

Following the initial reboot:

* connect to the internet (click network icon in upper right)

* update packages:<pre>sudo apt-get update

sudo apt-get upgrade</pre>

* Reboot

You now have a basic up-to-date Ubuntu system

h2. Configuring MySQL

* create /etc/mysql/conf.d/myami.cnf with the following contents:<pre>[mysqld]

default-storage-engine=myisam

query_cache_size = 100M

query_cache_limit = 100M</pre>

* restart mysql server:<pre>sudo service mysql restart</pre>

* create databases for leginon and appion:<pre>sudo mysqladmin create leginondb

sudo mysqladmin create projectdb</pre>

* create user and grand privileges... login to mysql as root:<pre>mysql -u root mysql</pre>

**once inside mysql client, grant privs:<pre>create user user usr_object@'localhost';

grant all privileges on leginondb.* to usr_object@'localhost';

grant all privileges on projectdb.* to usr_object@'localhost';

grant alter, create, insert, select, update on `ap%`.* to usr_object@localhost;</pre>

h2. Installing additional packages required by myami

There are many additional packages to install, but we can try to condense that list to the smallest set necessary to pass to the update command which will then figure out all the other dependencies.

Here is a single command to install all the necessary packages:<pre>sudo apt-get install subversion vim python-MySQLdb python-wxgtk2.8 python-fs mysql-server php5 php5-mysql libssh2-php php5-gd</pre>During installation, you will be prompted several times to create a mysql root password.  This can optionally be left blank at the expense of less security.  Note:  installing the vim text editor is my own preference... use an inferior text editor if you wish :)

The Scipy package is also required, but the current version 0.9.0 that comes with Ubuntu 12.04 is broken.  You need to grab the more recent version of Scipy from Ubuntu Quantal (development version).  To make a clean installation that will not confuse the package manager we have prepared a mini-repository that includes this new scipy.  You can download and install scipy using the following set of commands copied into your terminal.<pre>sudo mkdir /usr/local/share/myami</pre>That should get your password in the sudo cache so you can copy the rest of these without entering a password:<pre>cd /usr/local/share/myami

sudo wget http://emg.nysbc.org/attachments/download/1488/ubuntu-scipy-0.10.1.tar.bz

sudo tar jxf ubuntu-scipy-0.10.1.tar.bz

sudo sh -c 'echo "deb file:///usr/local/share/myami/ubuntu-scipy-0.10.1 ./" > /etc/apt/sources.list.d/myami.list'

sudo apt-get update

sudo apt-get install python-scipy</pre>Make sure that last line executes (may have to hit enter).  Also, you may have to confirm installing it without authentication.