skip to navigation
skip to content

GLAMS 0.2.0

Gandhi Lab Animal Management System

Latest Version: 0.2.5


Title:GLAMS (Gandhi Lab Animal Management System)
Author:Kyle Ellefsen
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.


  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
  2. Install the latest version of Python 2 (2.7.6. as of 2013.12.17)

  3. Install pip (instructions at

  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 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:

    (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:

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



  • 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.


  • 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.
File Type Py Version Uploaded on Size (md5) Source 2014-03-29 355KB