Skip to main content

Gandhi Lab Animal Management System

Project description


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.

Project details

Release history Release notifications

History Node


History Node


History Node


History Node


History Node


This version
History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date (364.0 kB) Copy SHA256 hash SHA256 Source None Mar 29, 2014

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page