I don't have time to work on this, but I started a project for this exact purpose a few months ago. I have the database design drafted up for MySQL workbench, and started on stored procedures. If anyone is interested in checking it out and continuing on, the github link is: <a href="https://github.com/HackRVA/RFID-Access-Control-System">https://github.com/HackRVA/RFID-Access-Control-System</a>. Fork away!<div>

<br></div><div>-Luke<br><br><div class="gmail_quote">On Thu, Dec 9, 2010 at 9:04 PM, Jordan Bunker <span dir="ltr"><<a href="mailto:jordan@pumpingstationone.org">jordan@pumpingstationone.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">

<span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">Hello
 assembled hackerspaces, makerspaces, and coworking spaces of the world!
 I am writing to let you know about the OpenDoor Hackathon, which starts
 this weekend on Saturday!</span><br><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"></span><br>


<span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">If
 you have (or have thought of) creating an RFID, iButton, keypad, or 
other door access system, and you love connecting and working with other
 hacking, making, and coworking spaces, then you won’t want to miss out 
on this!</span><br><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"></span><br>
<span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">Here’s the run-down:</span><br>
<span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"></span><br><span style="font-size:14pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:bold;font-style:normal;text-decoration:none;vertical-align:baseline">What is the OpenDoor Hackathon?</span><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:bold;font-style:normal;text-decoration:none;vertical-align:baseline"></span><br>


<span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">The
 OpenDoor Hackathon is a hackathon to benefit the members of 
hacker/maker/artist/co-working spaces by creating a standardized, Open 
Source door access and membership management system that can be used by 
everyone. At the end of the hackathon, the systems (or subsystems) 
created by each space will be voted upon, and the best system (or 
combination of systems) will be chosen. Implementing the system 
afterwards is, of course, optional.</span><br><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"></span><br>


<span style="font-size:14pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:bold;font-style:normal;text-decoration:none;vertical-align:baseline">Why are we doing this?</span><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:bold;font-style:normal;text-decoration:none;vertical-align:baseline"></span><br>


<span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">I
 know, the word "standardized" sends chills down my spine too, but I 
assure you that this is a good thing! Deciding upon a common system 
would enable the following things:</span><ul><li style="list-style-type:disc;font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">


<span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">The ability to share membership between spaces</span></li>


<li style="list-style-type:disc;font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">Crowdsourced security enhancements and feature additions</span></li>


<li style="list-style-type:disc;font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">Easier membership management</span></li>


<li style="list-style-type:disc;font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">A warm fuzzy feeling of being connected with other spaces</span></li>


</ul><br><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"></span><br><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">What
 we're envisioning (and what many of you already have) is a sort of 
Reciprocikey or Space Passport system. We believe that the only way to 
create such an awesome system is to work together on it!</span><br><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"></span><br>


<span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">Prize of an</span><a href="http://www.adafruit.com/index.php?main_page=product_info&products_id=194" target="_blank"><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"> </span><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 153);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:underline;vertical-align:baseline">Ice Tube Clock</span></a><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"> from</span><a href="http://adafruit.com/" target="_blank"><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"> </span><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 153);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:underline;vertical-align:baseline">Adafruit</span></a><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"> for the space who best implements the </span><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:bold;font-style:normal;text-decoration:none;vertical-align:baseline">standardization of interface specification between custom softwares and access control</span><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">.
 Each space will review submissions at 2:00p PST on Sunday and rank the 
systems they would most like to use (you cannot vote for your own). The 
runner up will receive a</span><a href="http://www.adafruit.com/index.php?main_page=product_info&products_id=14" target="_blank"><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"> </span><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 153);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:underline;vertical-align:baseline">Minty Boost</span></a><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"> pack.</span><br>


<span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">You
 can also vote on best hardware system, most elegant code, best 
independent member management software - the top three of each will 
receive</span><a href="http://www.adafruit.com/index.php?main_page=product_info&products_id=14" target="_blank"><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"> </span><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 153);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:underline;vertical-align:baseline">Minty Boost</span></a><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"> packs, also via Adafruit.</span><br>


<span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"></span><br><span style="font-size:14pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:bold;font-style:normal;text-decoration:none;vertical-align:baseline">Systems needed:</span><ul>


<li style="list-style-type:disc;font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"><span style="font-size:12pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:bold;font-style:normal;text-decoration:none;vertical-align:baseline">Software for access control (reads from memory stored users and network user databases)</span></li>


<ul><li style="list-style-type:circle;font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">Create a functional specification for how authentication can be done securely.</span></li>


</ul><li style="list-style-type:disc;font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"><span style="font-size:12pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:bold;font-style:normal;text-decoration:none;vertical-align:baseline">Software that manages membership rights (grants rights/features to users based on conditions specified by managers</span></li>


<ul><li style="list-style-type:circle;font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"><span style="font-size:11pt;font-family:Arial;color:rgb(68, 68, 68);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">Standardize an interface specification for how custom software can talk to the access control software interface.</span></li>


<ul><li style="list-style-type:square;font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"><span style="font-size:11pt;font-family:Arial;color:rgb(68, 68, 68);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">example: 3rd party space has a member visiting, presents auth token.</span></li>


<li style="list-style-type:square;font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"><span style="font-size:11pt;font-family:Arial;color:rgb(68, 68, 68);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">example: someone wants to create a custom trusted UI (web, phone, etc.) for talking to the auth daemon</span></li>


</ul></ul><li style="list-style-type:disc;font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">
<span style="font-size:12pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:bold;font-style:normal;text-decoration:none;vertical-align:baseline">Web, phone, etc UI for membership management and access control software</span></li>


<ul><li style="list-style-type:circle;font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"><span style="font-size:11pt;font-family:Arial;color:rgb(68, 68, 68);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">Involve
 user interface management.  See what tools people are using today to 
manage membership and build hooks in the software to manage access 
control, or build your own.</span></li></ul><li style="list-style-type:disc;font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">


<span style="font-size:12pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:bold;font-style:normal;text-decoration:none;vertical-align:baseline">Hardware for reading identity (RFID reader, USB stick, etc.)</span></li>


<ul><li style="list-style-type:circle;font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"><span style="font-size:11pt;font-family:Arial;color:rgb(68, 68, 68);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">Build plug-ins to support common hardware (don't get stuck on any given vendor).</span><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"></span></li>


</ul></ul><br><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"></span><br><span style="font-size:14pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:bold;font-style:normal;text-decoration:none;vertical-align:baseline">When is the OpenDoor Hackathon?</span><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:bold;font-style:normal;text-decoration:none;vertical-align:baseline"></span><br>


<span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">The
 OpenDoor Hackathon will begin on Saturday, December 11th at 2pm PST, 
ending 24 hours later at 2pm PST on Sunday, December 12th. The freenode 
channel will be #opendoor and you can see existing conversations on </span><a href="http://groups.google.com/group/opendoorhack-a-thon" target="_blank"><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 153);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:underline;vertical-align:baseline">the google group</span></a><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">. We’ll do a check-in an hour into the hackathon to see where everyone is at and what systems people intend to use.</span><span style="font-size:11pt;font-family:Arial;color:rgb(68, 68, 68);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"></span><br>


<span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"></span><br><span style="font-size:14pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:bold;font-style:normal;text-decoration:none;vertical-align:baseline">How do I sign up?</span><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:bold;font-style:normal;text-decoration:none;vertical-align:baseline"></span><br>


<span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">You can register your space's team at the Eventbrite</span><a href="http://www.eventbrite.com/event/1054836043" target="_blank"><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"> </span><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 153);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:underline;vertical-align:baseline">here</span></a><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">!</span><span style="font-size:11pt;font-family:Arial;color:rgb(68, 68, 68);background-color:transparent;font-weight:bold;font-style:normal;text-decoration:none;vertical-align:baseline"></span><br>


<span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"></span><br><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">Join in the conversation at</span><a href="http://groups.google.com/group/opendoorhack-a-thon" target="_blank"><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline"> </span><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 153);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:underline;vertical-align:baseline">http://groups.google.com/group/opendoorhack-a-thon</span></a><span style="font-size:11pt;font-family:Arial;color:rgb(0, 0, 0);background-color:transparent;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline">!</span><br clear="all">

<font color="#888888">
<br>-- <br>Jordan Bunker<br>Pumping Station: One - PR Director<br><a href="mailto:jordan@pumpingstationone.org" target="_blank">jordan@pumpingstationone.org</a><br>(773) 789-8658<br>
</font><br>_______________________________________________<br>
Hack.rva mailing list<br>
<a href="mailto:Hack.rva@lists.hackrva.org">Hack.rva@lists.hackrva.org</a><br>
<a href="http://lists.hackrva.org/listinfo.cgi/hack.rva-hackrva.org" target="_blank">http://lists.hackrva.org/listinfo.cgi/hack.rva-hackrva.org</a><br>
<br></blockquote></div><br></div>