- Karandeep Singh Nagra
- Nader Morshed
An online gathering place for each house in the BSC. Scalable and modular, intended to be used as an instance at each house.
No authorship claim is made to the contents of the subdirectories ckeditor, tinymce, jquery, jquery-ui, and bootstrap of directory /base/static, with the exception of the file /base/static/ckeditor/config.js. Please consult the relevant licenses before distributing or using those portions of this software.
Logos included in the /static/ui/images/oauth are property and copyright of the respective companies.
Built with Django, Python, and SQLite. Tested and deployed on PostgreSQL.
A live version of the site can be accessed at https://kingmanhall.org/.
Check /DOCS/README.md
(here)
for complete details on the logical structure of the application, where to begin when
first introducing yourself to Farnsworth, and how to develop the site further.
To install all of the dependencies of CentOS, run the following as root:
# yum install epel-release
# yum install postgres python python-devel python-virtualenv gcc mod_wsgi git libffi-devel postgresql-devel pandoc
CentOS comes pre-packaged with SELinux for increased security. To enable the use of PostgreSQL and elasticsearch in this context, run the following as root:
# setsebool -P httpd_can_network_connect_db 1
# setsebool -P httpd_can_network_connect on
To install all of the dependencies of Debian, run the following as root:
# apt-get install postgresql python python-dev python-virtualenv gcc libapache2-mod-wsgi libpq-dev sqlite3 git libffi-dev
See http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/setup-repositories.html on installing elasticsearch on either distribution.
Once your system packages have been installed, run the following as the apache user or root to set up a virtual environment with the site-specific packages:
$ cd /path/to/farnsworth
$ virtualenv .
$ source bin/activate
$ pip install -r requirements.txt
In order to configure your personal Farnsworth, you will need to configure its settings. A brief list of house-specific settings is read from farnsworth/house_settings.py
:
$ cd /path/to/farnsworth
$ cp farnsworth/house_settings.py.example farnsworth/house_settings.py
$ $EDITOR farnsworth/house_settings.py
See farnsworth/settings.py
for the full list of settings used by Django.
Though you can run django applications with ./manage.py runserver, it is usually preferable to place them behind a HTTP proxy. This allows you to add HTTPS for encryption and host other applications or static pages on the same domain. Popular proxies include Apache, nginx, and unicorn.
Add the following lines to the httpd.conf file for Apache:
WSGIPythonPath /path/to/farnsworth/lib/python<python-version>/site-packages
...
<VirtualHost domainname.com:80>
...
WSGIScriptAlias /farnsworth /path/to/farnsworth/farnsworth/wsgi.py
Alias /static/ /path/to/farnsworth/static/
</VirtualHost>
Farnsworth is set up to use SQLite by default. The database will be stored in farnsworth/farnsworth.db
To create the PostgreSQL database, run the following commands as root:
# su - postgres
$ createdb <house>
$ createuser -PS <house>_admin
Enter password for new role:
Enter it again:
Shall the new role be able to create databases? (y/n) n
Shall the new role be allowed to create more new roles? (y/n) n
$ psql
postgres=# GRANT ALL PRIVILEGES ON DATABASE <house> TO <house>_admin;
GRANT
postgres=# \q
Make sure to update farnsworth/house_settings.py with the password for the postgres user.
In order for the workshift application to regularly mark shifts as blown, you will need to add a cron job to execute an internal scheduler every five minutes. Here, can be the apache / httpd user or another user that has access to the installation:
crontab -u <username> -e
# Append the following line:
*/5 * * * * source /path/to/farnsworth/bin/activate && /path/to/farnsworth/manage.py runcrons
Alternatively, create the following file:
# cat > /etc/cron.d/farnsworth <<< "*/5 * * * * <username> source /path/to/farnsworth/bin/activate && /path/to/farnsworth/manage.py runcrons"
To create the tables in the database and an initial user, first start elasticsearch as root:
# service elasticsearch start
Then run the following as a user with write access to the farnsworth directory:
$ cd /path/to/farnsworth
$ source bin/activate
$ ./manage.py collectstatic
$ ./manage.py migrate
There will be a prompt to create a superuser, if you mistakenly close the prompt before the user is created, you can get back to it with: ./manage.py createsuperuser
.
Once you have the site up and running, navigate to /admin/sites/site/ and update the example.com site to have your domain. Django grabs this domain when sending e-mails, etc. to create links to your site.
Simply copy and compress the SQLite database file:
$ gzip farnsworth/<house>.db > "backup-<house>-$(date +%F).db.gz"
And restore by decompressing and copying back:
$ gunzip backup-<house>-<date>.db.gz > farnsworth/<house>.db
Back up the house's database with the following command:
$ pg_dump -U <house>_admin <house> | gzip > "backup-<house>-$(date +%F).db.gz"
Restore the house's database with the following command:
$ gunzip -c backup-<house>-<date>.db.gz | psql -U <house>_admin <house>
See http://www.postgresql.org/docs/current/static/backup.html for a detailed description of other methods to back up the database.