search

m2i / AccessControlBox

The code for the access control boxes.
0 stars 0 forks source link

Database setup #2

Open ghost opened 6 years ago

ghost commented 6 years ago

We need an actual database for permissions. Will had some ideas.

ghost commented 6 years ago

Planning to use Postgre

ghost commented 6 years ago

Postgre does not have a arm package (for Raspberry Pis) and I prefer to not build things from source (generally). @matgyver Can we use a spare box from on top of locker 8? We can put linux on it, and will just need it and any access control boxes net-registered by IT.

matgyver commented 6 years ago

@Talonj123 yes, that is fine.

ghost commented 6 years ago

That PC has S-Video and DMS-59 ports only. I don't think the lab has adapters for those.

ghost commented 6 years ago

The lab had a DMS-59 adapter :) Also, the database is installed and set up with two tables.

  1. users: just a table to link card numbers to netids
  2. equipment_authorization: whould have a boolean field for each peice of equipment in addition to the netid field (configured to have foreign-key constraint from the users table)
ghost commented 6 years ago

The postgre password is postgres (machine and database accounts).

ghost commented 6 years ago

The administration interface can be accessed by running pgadmin4

ghost commented 6 years ago

It looks like the machine has crashed. It won't boot at all. If I pull put the graphics card and use the built in VGA port, it at least shows error messages as it tries to boot, otherwise it does nothing.

matgyver commented 6 years ago

Let's visit on this.

ghost commented 6 years ago

So, the solution is to get a VM from IT. Do I need to follow up on this, or is this something for you @matgyver?