Differences

This shows you the differences between two versions of the page.

--- rb-projects-access:start [14/01/2025 17:59] – [DB structure] andrew
+++ rb-projects-access:start [21/02/2025 13:25] (current) – [Access Control] andrew
@@ Line 1: / Line 1: @@
 ====== Access Control ======
+{{ :rb-projects-access:hid_reader_and_mifare_card.jpg?200|}}
 Very much embryonic and alpha project to play with commands which would be required to implement a electronic door lock system.
 Key cards with a serial number are issued and each door has a Wiegand or rfid style reader, optionally requiring a PIN as well as card to unlock. Maybe bluetooth instead of PIN?
-Also, by abstracting the keypad / reader and lock from the physical device, it should enable MQTT enabled devices to be included. If they are to be trusted..... So PKI is probably needed to maintain trust and security. (Trust but Verify!)
+Also, by abstracting the keypad / reader and lock from the physical device, it should enable MQTT enabled devices to be included. If they are to be trusted..... So PKI is probably needed to maintain trust and security.  [[https://en.wikipedia.org/wiki/Trust,_but_verify| (Trust but Verify!) ]]
+[[https://dbdiagram.io/d]]
+[[https://www.usmartcards.co.uk/Access-control]]
 ===== Flow =====
@@ Line 37: / Line 39: @@
 </code>
-Get access level for user
+Get access level for user, I don't really like this, I need a way to record info for many users for many doors whilst remaining workable. My idea to store JSON in the SQL was a way to combine a NoSQL style db with MySQL. Seemed cool at the time.....
 <code sql> select accesslevel from access where userID = 3;
 +------------------------------------------------------------+