GLAMS 0.1.9

GLAMS

Title:

GLAMS (Gandhi Lab Animal Management System)

Author:

Kyle Ellefsen

Date:

2013.9.7

Description:

This program creates a MySQL database containing mouse colony information. It also contains a web server which, when launched, allows users to retrieve and update information on the database.

INSTALLATION FOR WINDOWS

1. Install MySQL (for windows.)

   • Install the Developer version.

   • Choose Sever Machine when prompted for ‘server configuration type’.

   • Choose Enable TCP/IP Networking if you would like to access GLAMS from other computers.

   • Leave the port number as the default 3306.

   • Keep Open firewall port for network access checked.

   • Use your lab password as the MySQL Root Password.

   • Add a user.

   • Set ‘host’ to be <All Hosts (%)>.

   • Set ‘Role’ as DB Admin.

   • Leave authentication as MySQL. This user account will be in GLAMS to communicate with MySQL, and it will be saved as plaintext, so make sure it is a password you don’t use for anything else. Remember it for a later step.

   • Run Windows Service as a Standard System Account. This automatically starts MySQL on Windows startup.

   • After the install, create a new database (aka schema) called glams. (instructions at http://stackoverflow.com/questions/5515745/create-a-new-database-with-mysql-workbench)

2. Install the latest version of Python 2 (2.7.6. as of 2013.12.17)

3. Install pip (instructions at pip-installer.org.)

4. Install lxml.

   • Download lxml-3.2.4.win32-py2.7.exe and install.

5. Install GLAMS. In a command line, change directory to where pip.py is installed. In Windows this is usually ‘C:/Python27/Scripts/’. Then type:

   pip install glams

6. In a command line, change directory to where glams is installed (in windows: C:\Python27\Lib\site-packages\glams\). Run the script:

   setup_glams.py

   (you can also double click on the icon) and answer the questions when prompted. This script will create a config.txt file which will save your password as plaintext, so don’t use the lab password. The script will also reset the database.

7. Launch the GLAMS server by running:

   main.py

   in the glams directory. Open a browser, and navigate to localhost. GLAMS has been installed. Login with username=’admin’ and password=’password’.

DONE SINCE LAST EDIT

TODO

• Add full calendar functionality

• Save the column order when a user moves a column.

• add ‘date audited’ to each cage. Create a button a user can push to confirm cage information.

• Add column with ‘Days Since Possible Mating’ in cage view. If any mature male mice entered a cage with mature female mice, count down 21 days

• Add column “Days Since Birth” in cage view.

BUGS

• If viewing on the chrome web browser which has the google docs app installed, you can’t view mouse or cage information. This might be a chrome bug.

• Sometimes creates two ‘housing’ entries when dragging mouse from one cage to another. Very hard to replicate bug though.

• Sometimes the refresh doesn’t go through because when executing mysql command, “ReferenceError: weakly-referenced object no longer exists”