RFIDv2: Difference between revisions

(2 intermediate revisions by the same user not shown)

Line 28:

*All RFID fob numbers must start with 00 - sometimes the reader reports numbers incorrectly - the number on the fob will be be the number in the RFID field in WA.

*Make sure the member has an active account

*Make sure the tags in RFID field are separated by a comma. All RFID tags are stored in otherPager field ~~in AD.~~

*Make sure the tags in RFID field are separated by a comma. All RFID tags are stored in otherPager field (which contains an array of numbers) in AD.

*

~~There is an old HP (add specs) Windows XP machine that was added to the PS1 domain~~ (~~called RFID-2) that pulls user information from~~ an ~~SQL database on a VM called RFID2 and pushes that information to all the door controllers with a piece~~ of ~~software called Professional Door Control Management. You can remote into this machine using Windows Remote Desktop using rfid-2.ad.pumpingstationone.org.~~

~~A VM on Proxmox Cloud 2 called RFID2 (10.100.11.31~~) houses the SQL database so that current members can access the doors. Eventually a job will run that will populate the database usernames, RFID tags, and member status from PS1AUTH. This may help accomplish this task:

*https://technet.microsoft.com/en-us/library/cc720650(v=ws.10).aspx

*https://www.mssqltips.com/sqlservertip/4190/import-active-directory-data-to-a-sql-server-table/

*https://cwiki.apache.~~org/confluence/display/SYNCOPE/Synchronize+Active+Directory+with+SQL+database#SynchronizeActiveDirectorywithSQLdatabase-Provide_a_user_template~~

=What's next=

Line 44:

Line 36:

*Writing a cron job to sync PS1Auth data (that members can add their RFID) to the RFID2 SQL database the door reader uses.

*Create an Auto-it script that presses the upload button in the control software to send info from the SQL database to the controller.

==DEV2AD==

A wifi enabled microcontroller with an RFID reader makes a webservice call to Glue. Dev2AD is running on Glue and receives the call. DEV2AD validates that the tag is associated with the authorization for that tool. Currently the theory would be that DEV2AD would look at the AD group for a particular piece of equipment, grab the list of all users in that group, and search for a matching tag - if a tag matches then an activity will be initiated.

==Status==

@@ Line 28: / Line 28: @@
 *All RFID fob numbers must start with 00 - sometimes the reader reports numbers incorrectly - the number on the fob will be be the number in the RFID field in WA.
 *Make sure the member has an active account
-*Make sure the tags in RFID field are separated by a comma. All RFID tags are stored in otherPager field in AD.
+*Make sure the tags in RFID field are separated by a comma. All RFID tags are stored in otherPager field (which contains an array of numbers) in AD.
-*
-There is an old HP (add specs) Windows XP machine that was added to the PS1 domain (called RFID-2) that pulls user information from an SQL database on a VM called RFID2 and  pushes that information to all the door controllers with a piece of software called Professional Door Control Management. You can remote into this machine using Windows Remote Desktop using rfid-2.ad.pumpingstationone.org.
-A VM on Proxmox Cloud 2 called RFID2 (10.100.11.31) houses the SQL database so that current members can access the doors. Eventually a job will run that will populate the database usernames, RFID tags, and member status from PS1AUTH. This may help accomplish this task:
-*https://technet.microsoft.com/en-us/library/cc720650(v=ws.10).aspx
-*https://www.mssqltips.com/sqlservertip/4190/import-active-directory-data-to-a-sql-server-table/
-*https://cwiki.apache.org/confluence/display/SYNCOPE/Synchronize+Active+Directory+with+SQL+database#SynchronizeActiveDirectorywithSQLdatabase-Provide_a_user_template
 =What's next=
@@ Line 44: / Line 36: @@
 *Writing a cron job to sync PS1Auth data (that members can add their RFID) to the RFID2 SQL database the door reader uses.
 *Create an Auto-it script that presses the upload button in the control software to send info from the SQL database to the controller.
+==DEV2AD==
+A wifi enabled microcontroller with an RFID reader makes a webservice call to Glue. Dev2AD is running on Glue and receives the call. DEV2AD validates that the tag is associated with the authorization for that tool. Currently the theory would be that DEV2AD would look at the AD group for a particular piece of equipment, grab the list of all users in that group, and search for a matching tag - if a tag matches then an activity will be initiated.
 ==Status==