Gandhi Lab Animal Management System
|Title:||GLAMS (Gandhi Lab Animal Management System)|
|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
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)
Install the latest version of Python 2 (2.7.6. as of 2013.12.17)
Install pip (instructions at pip-installer.org.)
- Download lxml-3.2.4.win32-py2.7.exe and install.
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
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.
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’.
DONE SINCE LAST EDIT
- 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.