SquaresDB lives at https://mv-ezproxy-com.ezproxyberklee.flo.org/ and is the club's membership database and attendance tracking system. It's unlikely there's much of use on this page unless you're doing administrative stuff of some form.
| Table of Contents |
|---|
Login and Accounts
...
Doing gate and books requires a device (smartphone works okay, something with a larger screen like a tablet or laptop is preferable – the club has a tablet) and an account on the site. If working on a personal device, ideally one uses a personal account for improved auditability, but the "signin" account is also available – see "Login and Accounts" section for details to get access. The gate&books pages in SquaresDB themselves have some instructions as do the nightly jobs instructions.
New Subscriptions
Once prices for the subscription period have been decided on
...
, you'll need to load them into SquaresDB:
- Go to https://mv-ezproxy-com.ezproxyberklee.flo.org/gate/new_period/.
- Enter the first and last dance dates.
- Select the relevant season.
- Time should be correct (assuming the club dance time hasn't changed), and name and slug should populate automatically.
- Change the default price scheme to "normal2023", and fill in the subscription prices.
- Hit create (don't check "confirm").
- Confirm the dates look right, check "confirm", and hit create again.
...
It has a Discuss archive – you can view it at https://mv-ezproxy-com.ezproxyberklee.flo.org:8443/pergamon.mit.edu/squares-db-errorlog/ (requires certs). View access is occasionally synced to the tech-squraessquares-officers list by running:
...
Currently, squaresdb.mit.edu is the same VM as tech-squares-photos.mit.edu. As of September 2024, the following people have admin access: admin:x:115:kchen,vboyce,adehnert,lhuhmann . If something goes wrong with SquaresDB and Alex isn't available to fix it, somebody with admin access to the server has the technical permissions needed to deploy code fixes or gain superuser access within SquaresDB. (Naturally, this should be avoided. Possession of technical permissions doesn't mean they have familiarity with the code such that this will be a smooth process.)
To give somebody shell access, use "adduser $NEWUSER --disabled-password" to create an account for ssh pubkey access, and add a public key to ~/.ssh/authorized_keys. If they need to administer the server, either set a password and add them to the "admin" group so they can use sudo, or add them to root's authorized_keys.
...