Instructables

Control Access of Arduino YÚN with MySQL, PHP5 and Python

Featured
Picture of Control Access of Arduino YÚN with MySQL, PHP5 and Python
Hello Friends!

Well, as you know, in September the new premiere shield  of Arduino, Arduino YUN. This little friend has a Linux embedded system with which we can run anything you can think of (at least so far).

While there is very little information on this new board, with departure in the guide that provides the Arduino page (which will link later), plus a little knowledge of many Linux, can carry out a major project a Control Access.

This time I will explain how to do this project, but in a manner sufficient particular all through our Arduino. This works, thanks a database server MySQL which will settle in our YUN, this database will store two tables, one for users associated with a particular RFID and another table to keep records of all cards that have passed through our reader. While we use programming languages ​​PHP and Python scripts to perform some basic and work with our data.

Moreover, the hardware overhead, we use a reader ID-20 next to a Serial LCD of 16 characters, plus an RGB LED which will be our informant states.

We may use this access control everything we can think of, modify, and add a relay or another idea. It can be used on anything where you have cards and want a record.

Recall that this document is free publication, commercial use and exempt modifications are not allowed. I hope it's a way more extensive path of Open Source electronics.

So we go to the next step, the parties need!
 
Remove these adsRemove these ads by Signing Up
(removed by author or community request)
camilo.n1012 (author)  DELETED_mniestroj2 months ago

Hi, when you have a problem about the hostname, you can remember that the host name in the arduino YUN is the address "localhost" or "127.0.0.1". But it's strange that you have this problem, with the host when you install MySQL.

In this case i recommend you, that you review the step about the creation of folders :

mkdir-p / srv / mysql

and the steps:

sed-i 's, ^ datadir. *, datadir = / srv / mysql /, g' / etc / my.cnf

sed-i 's, ^ tmpdir. *, tmpdir = / tmp /, g' / etc / my.cnf

I hope they serve

Regards !

øsvenkerud3 months ago
Thank you:-)
øsvenkerud3 months ago
Hi. It seems like a good tutorial you have made. But I miss an introduction explaining what this thing is supposed to do.
The closest thing I found was this :
"We may use this access control everything we can think of, modify, and add a relay or another idea. It can be used on anything where you have cards and want a record."

Could you please elaborate?
camilo.n1012 (author)  øsvenkerud3 months ago
Hello friend! Well, the access controls consists in implement a mechanical electronic mechanism that identifies if the person who wants to get this approved and based on that give access to some dependency (entry permit).

In this case, the mechanism will use is the RFID technology. Grace making these accesses swatch with Arduino YUN or generally with Arduino, is that you can modify to your taste, that's why this tutorial serves as a basis for implementing it.

If you need more help feel free to ask!
Pro

Get More Out of Instructables

Already have an Account?

close

PDF Downloads
As a Pro member, you will gain access to download any Instructable in the PDF format. You also have the ability to customize your PDF download.

Upgrade to Pro today!