Build a Raspberry Pi Smart Door Lock Security System for your Smart Home!

Поділитися
Вставка
  • Опубліковано 28 січ 2025

КОМЕНТАРІ • 584

  • @GeneralHiro
    @GeneralHiro 6 років тому +80

    Dear God! It's like you actually went through this a few times BEFORE shooting this video! If only every instructional video was as well put together as this one. Two thumbs up mate

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому +2

      Thanks! Worked hard on it - glad you liked it. Thanks for the kind comments, it means a lot 👍

  • @v0ltgaming344
    @v0ltgaming344 6 років тому +5

    Wow! This is an amazing tutorial so far! I look forward to giving my guests a 3 factor authentication system to enter hehe!
    P.S it’s amazing you still reply to comments - you truly are an great creator - got a sub from me

  • @ronaldstilcens3776
    @ronaldstilcens3776 5 років тому +1

    This is an awesome made video! Very clear instructions, shows only needed information, neat video shootage appealing to an eye. A lot of technical information provided with short and clear comments. Is a pleasure to watch!

  • @oneyuuup
    @oneyuuup 5 років тому +2

    Love this project...I think I'm going to refactor into using Facial Recognition as one of the factors for authentication. You have inspired me!

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      Awesome, I'd love to see that!

    • @rhiothelab5251
      @rhiothelab5251 4 роки тому

      @@SwitchedOnNetwork I am here for the same .I am building facial recognition

  • @yogeshkapase9894
    @yogeshkapase9894 3 роки тому +1

    This is amzing project....

  • @stevecharlton3271
    @stevecharlton3271 5 років тому +2

    Absolutely brilliant

  • @johnangula7313
    @johnangula7313 3 роки тому +1

    Simply amazing!!

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  3 роки тому

      Thanks, glad people are still enjoying this years later 😃

  • @philliplanfre347
    @philliplanfre347 Рік тому

    Exactly what we were looking for.

  • @Erik.Magnusson
    @Erik.Magnusson 5 років тому +1

    Very helpful. Thank you!

  • @rxgtv
    @rxgtv 5 років тому +1

    How do I take out the RFID reader so that I just enter the code? And can I make the code 4 digits long?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому +1

      Yes you can do that, both those things, just modify the python code as you require 👍

    • @rxgtv
      @rxgtv 5 років тому +1

      Thank you. I have the original Pi that has less GPIO pins and a composite port. Will this work with that? Also can I use a Monitor instead of the GPIO pins? I plan on using a external keypad.

  • @rorybrowne4973
    @rorybrowne4973 3 роки тому

    Firstly, it's a very useful and informative video. Having that said however, this is still 2 factor authentication.
    The factors in question are something you have, and something you know. Both the fob and your phone are in the "something you know" factor.
    Typically the other factor would be "something you are", which generally means biometrics.

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  3 роки тому

      Hi Rory, thanks and I'm glad you enjoyed the video - despite how old it is now! Great to see people still enjoying it. And yes, I soon realised my mistake at the time (and had the same conversation again and again... then many more times when Raspberry Pi themselves featured this project!). It's technically only 2 factor, although 3 steps :-P And whilst it's open source, it means that anyone can alter it and modify to whatever they like, so could adapt it for fingerprint or retina scanning or something like that. I didn't quite have the budget for those at the time :)

  • @VisaoNocturna
    @VisaoNocturna 6 років тому +2

    There is a way to make just two factor auth?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому

      Yes of course, just modify the Python script as desired :)

  • @nezhympanzu2803
    @nezhympanzu2803 5 років тому +1

    You are the dude I was looking for. You just inspired me. Thank you Paul

  • @nurlanturganov5923
    @nurlanturganov5923 3 роки тому

    Thank you, for sharing your knowledge, sir!

  • @ryanjohnson6194
    @ryanjohnson6194 4 роки тому

    Will it still work if the rfid is replaced with a finger print scanner

  • @silmaril464
    @silmaril464 6 років тому +1

    nice work! thank you for show us your work :)

  • @nnvskh8269
    @nnvskh8269 4 роки тому

    can we do any of this with our own rfid card? like library card or student id cards ? Please help

  • @chadshumaker2789
    @chadshumaker2789 4 роки тому +2

    This is a REALLY NEAT project and nearly exactly what I was looking for. I am not a programmer though and would like to remove the SMS portion and make the RFID and pin code portion both unlock the door. Basically making it dual single factor. Any help with this would be greatly appreciated! I looked at the PY code and generally understand what each command is doing but dont know enough about it to weed out the SMS portion or make both RFID and PIN trigger. Thanks for putting together a great video on this also! VERY well done.

    • @gonsodany
      @gonsodany 3 роки тому +1

      Im trying to do the same and remove the sms part of the code, did you get it working?

  • @aketbi272
    @aketbi272 5 років тому +1

    Dear Paul
    Your Work is Highly Appreciated.
    I am in the last phase where I am trying only to run my python script in shell
    I am trying to Run it using Thonny python installed in Pi.
    I installed MariaDB
    I get an error in line 3. import MySQLdb
    Error: ModuleNotFoundError: No module named 'MySQLdb'

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому +1

      Hi, thanks - glad you liked it! What happens when you try to install the MySQLdb module?

    • @aketbi272
      @aketbi272 5 років тому +1

      The phython script lock.py
      I tried to Run it
      In line 3 of the script
      import MySQLdb
      I get an error. It is not found. I tried to find this specific file inside usr/var/
      It it not there
      Just to clarify, I installed MariaDB,php7, myphpadmin, because Mysql is not downloadable anymore.
      However everything worked and I logged in myphpadmin, imported the database succeeded
      If you could please, give me a lead how to overcome the error Running lock.py

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому +1

      You need to install the MySQLdb module for python, or MariaDB equivalent

  • @eugenemorley809
    @eugenemorley809 5 років тому

    Do you have to upload the usb readers drivers to the pi?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому +1

      Not with a USB one like this - it's plug & play like a keyboard 👍

  • @NightbladeNotty
    @NightbladeNotty 5 років тому +1

    ok i finally figured out the touche screen part, but i dont have the xorg driver. Is there another similar config i can use or somewhere to download it?

  • @Shreya.0083
    @Shreya.0083 5 років тому

    Can i connect 5 inch touch hdmi display and display program is same as 4 inch

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      It will depend on the specific display as to whether you'll have to alter the program. If the resolution is the same, there shouldn't be an issue (but you may need different drivers). Higher resolution will probably require work, I don't think it's responsive (but I've not really looked at that code for about 2 years so can't remember lol)

  • @johnkramer745
    @johnkramer745 4 роки тому +1

    Awesome video to be honest. I had something of the sort in mind to create but i am a beginner so have no clue how to go about implementing this. For now i am creating a simple home security solution (infrared sensor trip to activate video recording and hosting the controls on a web server). i am just getting into this so your video is a bit out of my league for the moment. i will be back to this in a month s time i hope. RESPECT!!

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  4 роки тому

      Sounds like a great project! And glad you liked this video, thanks :)

  • @nonnywinner5039
    @nonnywinner5039 3 роки тому

    Thank you for informative video.

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  3 роки тому

      You're welcome :) Hope you enjoyed it!

    • @nonnywinner5039
      @nonnywinner5039 3 роки тому +1

      @@SwitchedOnNetwork Yes very helpful. Working on a booth strap smart lockers project will be using your solution. Again thank you.

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  3 роки тому +1

      @@nonnywinner5039 Sounds cool, send me details when it's finished, I'd love to see it! :)

  • @Jeancomputech
    @Jeancomputech 4 роки тому

    good afternoon Paul. how do you add users to the system and can it sync with active directory?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  4 роки тому

      Hey! To add new users simply add them to the database table shown in the video, one new row per user. The ID field for their fob must be unique to that user, and if you have a profile image make sure it's a GIF, in the same dir as the script and then input its filename WITHOUT extension in that column of the table.
      Regarding active directory, you'd have to write a separate little script to sync data from there into this system, or rewrite this system to query AD instead.

    • @Jeancomputech
      @Jeancomputech 4 роки тому

      @@SwitchedOnNetwork is there any interface that can integrate in order to prevent access to the database? can i use openhab

  • @Browmbrownbrown
    @Browmbrownbrown 3 роки тому

    Is there a way to remove the sms and the facial recognition and just put the rfid alone?

  • @charliesrccrawler9325
    @charliesrccrawler9325 3 роки тому

    Awesome THANK YOU, Charl south Africa

  • @fridder.
    @fridder. Рік тому

    Cool idea to use an old computer power supply. Nice project

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  Рік тому

      Thanks, it was a fun one. Glad it's still getting the odd view all these years later! 😊

  • @bahamut105
    @bahamut105 3 роки тому

    Hi, would like to check if I would like to incorporate this project with a facial recognition door lock, will it work?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  3 роки тому

      Yes, you can swap out any of the authentication inputs for anything you like 👍😀

  • @leti324
    @leti324 9 місяців тому

    I love this video! But I have a question. You used a 5V relay and connected the IN to a pin on the board, which operates at 3.3V. I'm wondering if this can damage the raspberry pi.

  • @rtcunliffe
    @rtcunliffe 7 років тому +2

    Great video - might use this to secure an internal door in my house that contains my burglar alarm, and more importantly, wine collection. Be good to have that extra layer of security.

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  7 років тому +2

      Protecting your wine collection - an ideal use-case for additional security! :)

  • @rxgtv
    @rxgtv 5 років тому +1

    How do you leave?

  • @thegoldenminecart1447
    @thegoldenminecart1447 4 роки тому

    Is there a way to do this without sending the sms message and using the tag and passcode only

  • @terryterry1655
    @terryterry1655 8 місяців тому

    how to incorporate QR code scanning to pay via e wallet/credit card to unlock a compartment/locker ? after a delay to auto shut and lock back in case user let door ajar after taking the stuff in locker.thx

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  8 місяців тому

      That sounds like a whole new project in itself - let me know if you build it, I'd love to see it!

  • @scorpions333z
    @scorpions333z 3 роки тому

    good, I want to realize that I can turn on my miner remotely, can I get it? which Raspberry P buy? Thank you

  • @jayantsingh2821
    @jayantsingh2821 4 роки тому

    can we add multiple rfid card?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  4 роки тому

      Yes, unlimited - just add another database row for each

  • @Fnta_discovery
    @Fnta_discovery 6 місяців тому

    Did you internet connexion for that

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 місяців тому

      Yes, the Raspberry Pi needs to be connected either via WiFi or an ethernet cable into your network.

  • @nicholasstull6952
    @nicholasstull6952 4 роки тому +1

    Awesome Video, Thanks. I had a few questions. 1. how could I replace the lock with a servo? 2. how could I use an app instead of the touch screen? 3. and how could I replace the RFID to NFC and use my phone instead of a Fob? 4. Would there be anything different using a Raspberry Pi 4, Than the others? Thanks

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  4 роки тому

      Glad you liked the video! :) Yes everything you've suggested is possible. Beyond the scope of a comment reply to go into the hows and details, obviously, but you're more than welcome to take my code/setup and modify it like that to suit your preferences :) The only difference if using a Raspberry Pi 4, just like if you were building this today on a 3, is that this project is 3 years old so all the code and software versions are from that era - you'll need to update accordingly for newer versions of pretty much everything. So take my video and instructions as a conceptual guide, rather than an exact step-by-step. Good luck!

  • @callahanfamily7624
    @callahanfamily7624 4 роки тому

    Do you have a new build sheet for this project. Some of the links are not working on amazon and would really like to use HDMI touchscreen. Thanks in advance.

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  4 роки тому

      I don't I'm afraid, it's quite an old project now. Hopefully it will still inspire you and help with general concepts though, and feel free to share links for updated stuff you find 👍

  • @prabeshbajracharya99
    @prabeshbajracharya99 3 роки тому

    I really neee this system at my business

  • @jennynguyen2309
    @jennynguyen2309 3 роки тому

    Hi Paul! Thank you so much for the tutorial.
    I have gotten up to the point of the 2nd authentication but the GUI is only counting the digits pressed.
    Is there anyway you can help with this?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  3 роки тому

      Hi Jenny, I'm glad you got this sorted - before I had a chance to reply here! :)
      With regards to adding profile pictures, you don't upload an image to phpmyadmin as such, as it's just an interface to the database. The code takes the filename of the image (from db table) and then looks for a GIF with that name in the same dir as the script 👍

  • @henjiitagawa
    @henjiitagawa 6 років тому

    can i ask , if the extension GPIO is 2 instead of 3 use in this video, can it work ?

  • @mvl8209
    @mvl8209 3 роки тому

    I know this is already a few years old, but would this also work with a maglock instead of a door strike?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  3 роки тому

      Yes, it's open source so you can modify or change the code and do what you like with it 👍

  • @ahmedlahmer9343
    @ahmedlahmer9343 4 роки тому

    Hi.how can I add a clock and date onto the screen,and a logo

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  4 роки тому

      Hey there! To add a logo, instead of your picture, you simply need to put a photo in GIF format in the same folder/directory as the Python script, then add the filename (without extension, as it can only be GIF) into the database field for your user. If you want to add this to the welcome screen, look at lines 143-145 of the code (github.com/paulfp/Three-Factor-Security-Door/blob/master/lock.py) to see how this is done and how to add it to the welcome screen.
      To add a clock to the welcome screen, you'll need to create a label for your clock and then set a timer of some sort to update it every second, whilst it's on display, with the current time in HH:MM:SS format. You should then clear this timer when this screen is removed, and start it again when it displays again.
      That's the general concept of how to do both your things, you'll now have to do the leg work yourself on how to turn that concept into reality. Have fun and enjoy learning! :)

  • @gamalmohamed8510
    @gamalmohamed8510 3 роки тому

    thx sir for your effort, please, can I replace pin code with face recognition, and SQL-server can not set up in raspberry pi 4, any solution?

  • @ZonMakers
    @ZonMakers 6 років тому +1

    Please send me any full installation and configuration procedure if possible..

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому

      Hi there, there's a text version of the tutorial here if you'd like to have a read of that: www.switchedonnetwork.com/2017/11/10/build-the-ultimate-door-security-system-with-three-factor-authentication/amp/
      Thanks!

  • @Gnoekeos
    @Gnoekeos 4 роки тому

    Can I set this system up to handle 10 different locks hooked in to the raspberry pi and a selection screen on the touch screen so the user can select which lock they want to affect before they enter their credentials? If that much works the only other thing I'd need it to do is once the first user approaches and open and closes a door the second and all users coming after can't open that particular door again until the first user has come back and open and closed it. It's essentially a tool storage cabinet that everyone needs to gain access to any of the items in it at a moments notice but we need know who took which tool and to have a record that they did indeed return it or to alert us that it's been x number of days and the tool hasn't been returned.

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  4 роки тому

      Yes, you can do all that :) It's unfortunately beyond the scope of a comment reply here, and you'd have to make some changes and code some software updates yourself - but that's all possible! :)

  • @abdulmuhaimin5926
    @abdulmuhaimin5926 6 років тому +1

    this is amazing project

  • @TheAD1978
    @TheAD1978 5 років тому

    Rest is very well explained, but one thing which i don't understand is how you getting SMS through your raspberry pi. I don't see any GSM board is connected to your phone. or you have subscribed any SMS service ?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      It uses a web service, Twilio, to send the SMS so just through the Internet. No extra hardware required 👍

  • @MicroDrop2
    @MicroDrop2 Рік тому +1

    Hey, don’t know if you will reply, but if you did I would be very grateful.
    So I want to get rid of the RFID scanner and the SMS phone text, and JUST have the pin. Is this possible? And what would I have to buy?
    Thanks so much in advance

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  Рік тому +1

      Hello! Yes that's perfectly possible and the code is all open source so change and update as you wish 👍

    • @MicroDrop2
      @MicroDrop2 Рік тому

      Awesome! Any chance you could tell me what to purchase? Thanks 🤩

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  Рік тому

      @@MicroDrop2 - Yep, there are Amazon links for everything you need in the video description.

    • @MicroDrop2
      @MicroDrop2 Рік тому

      That is awesome, sorry to be a bother, but if you could, when you have time, could you tell me what I need to buy specially just for the code part? Don’t need to send links, if you tell me the names I can go check out your links! Thanks so much, and I love how fast you reply! True dedication

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  Рік тому +1

      @MicroDrop2 no worries! It would just be everything apart from the RFID scanner and tags. (The SMS element doesn't include any physical hardware so nothing crossed off the shopping list there...)

  • @Nunnehhh
    @Nunnehhh 6 років тому

    can you use Bio reader instead of RFID? If so what would be required to interface it?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому

      Do you mean something biometric such as fingerprint or retina scanner?
      The answer is absolutely yes! How you'd interface with it would depend on the device and also how it connects to the Pi (eg. USB, GPIO or even via LAN?!)
      Best bet is to play around with the device and write a separate sample script to prove concept then swap that into my code. Good luck!

  • @toleyukhantokhtamys6914
    @toleyukhantokhtamys6914 2 роки тому

    Please specify methods for resetting the as-103 locker?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  2 роки тому

      what's that?

    • @toleyukhantokhtamys6914
      @toleyukhantokhtamys6914 2 роки тому

      @@SwitchedOnNetwork Is there a way to reset the passwort

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  2 роки тому

      If you mean the pin you enter on the touchscreen then yes, in the database table. You could also build an admin front end for that if you want to make it more elegant.

    • @toleyukhantokhtamys6914
      @toleyukhantokhtamys6914 2 роки тому

      @@SwitchedOnNetwork How can I tell if the bar code is not included in the passwort before the scanner?

  • @muchibam5202
    @muchibam5202 5 років тому

    Hii paul.. im want to ask about the hardware. Where do i have to connect the normally close relay switch ? I hope you can help me.

  • @Aminexplore
    @Aminexplore 4 роки тому

    Hi sir i have go trough your code all , can i know what os did you use it . for this .

  • @AkiraSatsujinki
    @AkiraSatsujinki 5 років тому +3

    This is almost perfect for my smart door lock project; except that I'm pretty old school and didn't like the RFID system. I wonder if I could replicate similar system to this, but with a magnetic strip card swipe reader instead. Just swipe and it'll grant access XD
    Awesome tutorial, and very much understandable even for someone with ADHD like me :D

    • @Epiphalactic
      @Epiphalactic 3 роки тому +1

      That would be even easier to do, if you just wanted to swipe and get in. If you wanted to add the other factors, you would be able to essentially do the same thing he's doing just replacing the hardware and some of the coding with your proper hardware and code, essentially just replacing the RFID for the mag stripe. They essentially work the same, inputting a code into something, one just uses radio frequency to do it, while the other uses a magnetic strip.
      If you just wanted the magstripe entry, essentially all you need to do is buy the magstripe reader and the raspberry pi, as well as any other things to operate the electronic door lock and set it up so you swipe and it unlocks. Honestly even using raspi would prolly be overkill, I'd imagine just a simple microcontroller would work, if you aren't gonna make it pull up a profile where you have to input your pin, then and send a temporary authentication code sent to your phone, as there is more processing needed. No need for internet or anything, though, so even a really simple raspi could prolly do it. Like a nano or something.
      This is just me kinda guessing tho

  • @ahmedbachoo9112
    @ahmedbachoo9112 6 років тому +1

    Hey thanks for the video. Does that mean if there is no internet connection the system wouldn't work and people will be locked?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому +1

      Yes, I didn't include a manual override on my demo in the video as it would depend on the location, circumstances and preference of each specific and individual installation as to how the best way to provide that would be.
      The simplest way would be just to fit the front keyhole part of the Yale lock, which I left off. Then you've got an immediate offline override 😀

    • @ahmedbachoo9112
      @ahmedbachoo9112 6 років тому

      @@SwitchedOnNetwork what do you mean by fit the front part of the yale lock?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому

      The bit where you'd insert the key, on the front (outside) side. I only fitted the back latch.

    • @ahmedbachoo9112
      @ahmedbachoo9112 6 років тому

      @@SwitchedOnNetwork oh right ok that's sounds more like another option to use the key if internet fails

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому +1

      That's exactly what it is :)

  • @teobong6939
    @teobong6939 5 років тому +1

    How to disable the sms function? I don't want to get a sms every time i open a door. And can I use the databased stored on a LAN server to have more door locks running on the same db?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому +3

      Yes, you can build a bigger system by having a centralised database as you describe. And to bypass the SMS element, simply remove that bit of code and go straight to activating the relay! 👍

    • @gonsodany
      @gonsodany 4 роки тому

      @@SwitchedOnNetwork what part of the code is the SMS bit?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  4 роки тому

      Line 314

  • @pqrst931
    @pqrst931 Рік тому

    Is it possible to modify this system to open lock with either of three methods (rfid card, password,otp) if yes please give me some references. I don't have much experience in this field 😊 thanks alot

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  Рік тому

      Yes it is, and as I open sourced the code you're free to make changes as use as you see fit (within the terms of the license agreement on GitHub). I can't provide bespoke help here in the comments but if you need one-on-one guidance then get in touch and we can book in some consultancy video call sessions if you like.

  • @Zokusha
    @Zokusha 5 років тому

    Question. Once you got in to that door, how will you get out? Thank you.

  • @richardbrooks9401
    @richardbrooks9401 5 років тому

    I'm so impressed by how easy you make this look. I'm convinced that even I can do it. Here's a question: How would you scale this system up to say a dozen doors in a building and share the same database? And if you were only looking for two-factor authentication (fob & PIN), is there a way to disable the third factor?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      ha, thanks! I'm sure you could :) Yes for scaling up that would be very simple - you'd simply create a central database on a separate machine on the network (that could be another Raspberry Pi, or another computer set up as a database server). Then I'd assign each door its own unique ID number (just 1-12 would do) and slightly modify the scripts running on each door to identify themselves by ID. That could allow you to specify only certain doors that a given user has access to, for instance (via an additional table in the db). The logging as well could include the door ID so you know which door has been accessed. Finally, the scripts running on each door would simply connect to the central DB over the network and not run a db locally on each Raspberry Pi. You could probably get away with using a Pi Zero on each door, in lieu of a full size Pi too, to save money and be more compact.
      You could also make access to some (or all) doors time-sensitive, too... by specifying time windows that user X has access to door Y.
      With regards to disabling the third factor, yes you can do this by just modifying the function calls to skip that altogether and go straight to unlocking the door.
      If I had the budget and a space to do this, I'd love to make another video doing this expanded system. If you make this, I'd love to see it and feature a video guide on the channel!

  • @itspappy
    @itspappy 5 років тому

    I am trying to make a sudo-escape room for my office. The last obstacle will be this device, with a key fob and the pin. I also plan on hooking up a speaker to the stereo port on the pi, and would like to either play a sound file or do text to audio (ex: wrong, try again or success!). So I dont need multiple pins/fobs or the SMS portion. So I think I can just keep everything in the python script, and not need apache/php/mysql. It would even be nice, for the person starting the clock, to be able to do it on this device, and if they run out of time (30 mins), a time's up/siren goes off. Thoughts?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      Awesome idea! Yes if you want to simplify it you could scrap using the database and either hardcode everything into the Python script or use flat .txt files on the Pi (or something like SQLite). I look forward to seeing it when you're done :)

    • @itspappy
      @itspappy 5 років тому

      I can’t get the rfid reader to work on the pi. Works on windows. Tried just about everything.
      Lsusb shows it on bus 001 device 007: id 6688:6850
      Looks like it maps to /dev/usb/hiddev0

    • @itspappy
      @itspappy 5 років тому

      Figured out my problem. I bought the RFID reader/writer. Once I bought the RFID reader, everything worked. Will share a video when everything is finalized.

  • @panos2011
    @panos2011 5 років тому

    Is there any way to turn off the display and then turn on when you touch it?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      You can probably achieve that in the Pi's power saving / screen display settings...?

  • @TheAshassin72
    @TheAshassin72 5 років тому +2

    Hi Paul! Amazing video, and something I'll definitely do. I was just wondering though, Is there a way of making the door open and close remotely via a phone app?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому +2

      Yes, there is! A few people have mentioned this so maybe it's worth a second video as a project on its own 😀

    • @TheAshassin72
      @TheAshassin72 5 років тому

      @@SwitchedOnNetwork Yes Please!! I'm currently trying to design my system with a mixture of 2 different projects on UA-cam, but a mod to this one would be way easier! Thanks Paul!

  • @FluffyCrypto
    @FluffyCrypto 5 років тому +1

    Awesome Video. Can i make this only a 2 factor authentication? Removing the rfid. How do i change it on the python script?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому +1

      Thanks! Yes that's easily done, just swap the functions around so that when it's initialised it's calling the function to wait for PIN entry stray away. You'll have to remove the name and picture elements too.

    • @FluffyCrypto
      @FluffyCrypto 5 років тому

      Switched On Network Thank you for your fast reply. I want to keep the name and give people acces with the code, then once they put the code i gave them they get a 1 time access code to their phone.

    • @FluffyCrypto
      @FluffyCrypto 5 років тому

      Switched On Network How long do the codes last? Also is there a way to Support your Channel without pledging. Like Paypal, Venmo Etc. Doing it 1 time and easy for people? Thank you. Keep Doing good work.

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      Hi, if you mean the smsCode then it's generated and held in memory until it's entered into the screen. You can build in a timeout for the code itself if you like, but the screen will automatically stop waiting and return to idle state after 60s, rendering the code invalid. You can change that if you like (line 260 of script).
      That's very kind of you to want to support the channel, thank you. The best way to make a one-off pledge would be to use Patreon and then cancel after a month (www.patreon.com/SwitchedOnNetwork) or the PayPal email address is paypal@innobellamedia.uk - thank you!

  • @ahmadirfan7251
    @ahmadirfan7251 3 роки тому

    may i ask, how you put image into phpmyadmin?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  3 роки тому

      The filename of a gif (without extension) is simply stored in the database table; not the actual image data itself.

    • @ahmadirfan7251
      @ahmadirfan7251 3 роки тому

      @@SwitchedOnNetwork why keypad not showing up.

  • @johanhjalmarsson6789
    @johanhjalmarsson6789 3 роки тому

    Hi. Great video. As others have said could you make a version that not has sms code and that has support for multiple doors and if you could add support for an exit button or a 2 way system for access and exit . Best regards Johan

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  3 роки тому

      Hi Johan, thanks for your comment and I'm glad you liked the video and it's still being appreciated all these years later :) Yes, as it's an open source project you can do all of that and more - consider this a base of inspiration onto which you can build! I'd love to see what you come up with, so if you're on Twitter do follow me (@paulfp) and send me pics/video of your finished build :)

  • @prabeshbajracharya99
    @prabeshbajracharya99 3 роки тому

    Any way to buy this kit

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  3 роки тому

      Yes, the purchasing links in the video description should all work 👍 let me know if any don't

  • @vsnshankar4932
    @vsnshankar4932 6 років тому

    Can i Use 3.5 inch touch Screen instead of 4 inch?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому

      You're free to change, modify, subtract or add to/from the project in any way you like! Have fun with it, and share a photo/video of it with us on Twitter when you're done :)

    • @vsnshankar4932
      @vsnshankar4932 6 років тому

      @@SwitchedOnNetwork sure.. Buddy

  • @ggarza78
    @ggarza78 6 років тому +2

    Does it need a SIM card to send the SMS message? Great project!

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому +1

      No, as it uses a web service (Twilio in the example, you could use any) instead - so no SIM required 😀

    • @ggarza78
      @ggarza78 6 років тому

      Thanks!

  • @chibunnna
    @chibunnna 5 років тому

    Hello Paul, awesome project. I have managed to get everything working except getting the relay switch to trigger and click once I enter the sms code. Any help would be appreciated. I have the exact setup as you did. Thanks

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      Thanks! Any error output to console if you run from there?

    • @chibunnna
      @chibunnna 5 років тому

      ​@@SwitchedOnNetwork Thanks for replying. Unfortunately no error

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      Try writing a separate, standalone script to trigger the relay and check that all works?

    • @chibunnna
      @chibunnna 5 років тому

      @@SwitchedOnNetwork Yes I tried that with an LED, relay works just fine. The relay has triggered the lock but this happens even before I place my key fob on the rfid reader. Thanks

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      Ah, something definitely up then! Does anything happen at the point where it's meant to unlock? ie. does it lock? Wondering if your Normally Open/Closed might be reversed? If not... you'll have to go through bit by bit debugging until you figure out what's up I'm afraid! Good luck 🤞

  • @muchibam5202
    @muchibam5202 5 років тому

    Hye paul. I just want to ask about the working of the script lock.py work with the electric strike lock ? I really need your help

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      Hi - that's not something I can help you with in the comments here, but I'm always open to contract work so if you ping me a message on social media (I'm @paulfp on Twitter and Facebook) or via my website (www.paulfp.uk) then we can discuss :) Thanks.

  • @ewokkillah
    @ewokkillah 5 років тому

    Great project and video! I would like to adapt it for a package delivery door (we’ve had porch pirates) is there a way to eliminate the rfid and the random code generation features and just have a the single pass code that I could give to the delivery driver and also receive the sms notifications? Thanks for your help.

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      Hi, glad you liked it. Yes, that's fine to do that - if you just modify the Python code to suit your needs, that should work great with the hardware! Let me know how you get on :)

    • @ewokkillah
      @ewokkillah 5 років тому

      Switched On Network I have no experience with python so I will need to do some research. Any advice is appreciated. Thanks

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      @@ewokkillah You'll need to strip out the functions that you don't need and call the ones you do... plus make any changes. Before trying that, find a beginners' Python course and get familiar with the basics. Happy to help :)

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      In fact... you've inspired me to make a "Safe Place" for package delivery, so maybe a video will appear on the channel later this year :)

  • @failvibex3062
    @failvibex3062 4 роки тому

    I love it but can you also open it from the inside

  • @chadfanaroff5120
    @chadfanaroff5120 4 роки тому

    Hi When I try to do the raspberry pi rfid door lock. I keep getting an error with phpmyadmin once I'm on it

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  4 роки тому

      What's the error, can you paste it here?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  4 роки тому

      Thanks for sending me the error separately. You have an authentication issue; have you set up a user in you database and updated the script with those credentials?

  • @byrnewebb4412
    @byrnewebb4412 5 років тому

    Hey Paul
    This is a wonderful project that uses so many of the functions of Python and the Raspberry Pi. Your tutorial was so well documented and delivered. I do have a question though.... I want to remove the SMS authentication and add a step that verifies a number from a separate table in the MySQL database. I can build the table with no problem but I need to figure out where to put the additional code and what it might look like. I also want to make sure and comment out only the SMS configuration if that is possible. Any help would be appreciated!

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      Thanks for your comment and kind words! I'm not quite sure what you mean by "verifies a number from a separate table in the database".... do you mean like a second PIN?

    • @byrnewebb4412
      @byrnewebb4412 5 років тому

      That would be correct. I am wanting to validate that the person using the card has access to a valid work order. The cool thing about your system is that it would log the work order.

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      aaaah I see, so the PIN would be personal to them but the work order ID might be known by several, and also be time-limited so only be valid between pre-defined start and end times? Cool application! Yes that's perfectly possible and easily do-able - let me see it when you've done it!

    • @byrnewebb4412
      @byrnewebb4412 5 років тому

      OK Paul, I have this program just about completed, however, a glitch I am having is if you scan the card then scan it again the verification screen pops up at the bottom of the initial verification screen. How can I turn off the RFID reader until Access Denied or Access Granted? Thanks a lot for your help.

  • @izsubs316
    @izsubs316 4 роки тому

    How would I do it if I were to use a 4 digit passcode that’s the same every time

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  4 роки тому

      you mean instead of the SMS? or just on the virtual keypad? In any case, you can just modify the code and either hard code it into the code itself (not ideal) or have that 4 digit code saved in either a database or a flat text file.

  • @eugenemorley809
    @eugenemorley809 5 років тому

    So I figured out why I couldn't find the Lxsession file, apparently this folder was in /etc/xdg/lxsession/LXDE-pi/autostart. So I attempted to edit this file and add the line you noted and still no luck. I cant seem to figure what else could be wrong. Can I transfer the lxsession file to .config, if so how can this be done?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      What version of Raspbian are you running?

    • @eugenemorley809
      @eugenemorley809 5 років тому

      @@SwitchedOnNetwork Raspbian GNU/Linux 9.8 (stretch)

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      Yes, I believe you can copy that autostart file (using the cp command) to:
      ~/.config/lxsession/LXDE-pi/

  • @muchibam5202
    @muchibam5202 5 років тому

    Hye paul. I hope you can share some tips on why when i touch keypad for no 3 on lcd touchscreen but the keypad select no 1? Help me sir

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      Sounds like you have the touch display mapped wrong - did you edit TWO config files when rotating to portrait?

    • @muchibam5202
      @muchibam5202 5 років тому

      Switched On Network yes i did it. But when i touch keypad using mouse it was perfectly working compare to i touch by my finger. What should i do sir?

    • @muchibam5202
      @muchibam5202 5 років тому

      Switched On Network do you have any ideas what should i do sir?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      Check that you've followed the instructions that came with your screen exactly. As well as rotating it visually, you also have to rotate the invisible matrix that sits above it mapping touch onto the display.

    • @muchibam5202
      @muchibam5202 5 років тому

      Switched On Network sir how to rotate invisible matrix as you mention just now?

  • @gonsodany
    @gonsodany 3 роки тому

    Hi, Im buildings this as a project and im having problems with the gui, im building this without a touchscreen (im doing it conected to a monito), the db and everything is setup correctly, i present my rfid card and it shows the right name on top, but theres no numbers to click, its just a white screen saying "Welcome "my name" ", can you try and help me finding out whats wrong?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  3 роки тому

      That's probably quite an involved issue to solve which I'm guessing can't really be done in comments I'm afraid. This is a VERY old project now, so unless you're using the same versions of everything I used back in 2017 then I imagine a lot of things will be broken and need debugging/recoding.

    • @Browmbrownbrown
      @Browmbrownbrown 3 роки тому

      @@SwitchedOnNetwork is there anyway to get the updated versions?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  3 роки тому

      @@Browmbrownbrown all the software repositories ("repos") will have the updated versions of everything, and if you download Raspbian it'll be latest version. I've not produced updated versions of my code, as this was a one-off project for fun, but with a bit of debugging you should be able to make it work today :)

  • @adefemimicheal9831
    @adefemimicheal9831 6 років тому

    Hello am trying to build a lock system for a solar system project using your previous code. What part do I need to remove from the code. It's going to be a two system authentication because the use of keyfob will not be needed

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому

      Hi, you'll basically need to remove all the bits that relate to waiting for keyboard input (ie the keyfob) and change the initial waiting screen to be that of the PIN entry. So you'll be looking at the show_idle() function, getting rid of the listen_rfid() function, etc. - although of course on that last function you'l be retaining the stuff to draw out the first PIN entry keypad.
      The most important thing is to have a solid enough understanding of Python (read some beginners' guides elsewhere first, if you need to) and then look through my code and make sure you fully understand each part and what it does. I'm by far not the best programmer in the world, but I tried to lay it out logically and use sensible variable and function names etc. to make it easy to understand - have a play around and you should be able to change it to do whatever you like. Good luck!

    • @adefemimicheal9831
      @adefemimicheal9831 6 років тому +1

      @@SwitchedOnNetwork Yes thanks I've actually worked on that and remove those i just wanted to be sure I was doing the right thing. Thanks for your swift response

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому

      No worries, let me know how you get on 👍

    • @adefemimicheal9831
      @adefemimicheal9831 6 років тому

      @@SwitchedOnNetwork hello so have done all necessary things but I keep getting this error each time I run python lock.py: no module named MySQLdb and have installed all necessary things

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому

      you may have installed it for the wrong version of python, or not installed it correctly.

  • @chadfanaroff5120
    @chadfanaroff5120 4 роки тому

    How much do you charge for a paided service

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  4 роки тому

      Channel memberships launching soon - watch this space!

  • @vomm27
    @vomm27 3 роки тому

    Hi bro this is very good video, may I ask if I were to add face authentication how is it possible ?

  • @muchibam5202
    @muchibam5202 5 років тому +1

    Hye paul. Your video is awesome. I have problem on how to monitor phpmyadmin using laptop instead of lcd touchscreen? Help me sir

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      Thanks, glad you like the video. If you've installed a full LAMP stack then you should be able to go to xxxxxxx/phpMyAdmin where the XXX is your pi IP address 👍

    • @muchibam5202
      @muchibam5202 5 років тому

      Switched On Network i try to write on google at my laptop 192.168.x.xxx/phpMyAdmin but google writen not found

    • @muchibam5202
      @muchibam5202 5 років тому

      Switched On Network im sorry paul. What should i do to view the database on laptop screen ? I try to google the link that you wrote by insert my ip address/phpMyAdmin and the result was not found

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      Did you install phpMyAdmin too?

    • @muchibam5202
      @muchibam5202 5 років тому

      Switched On Network sir how do i need to install using laptop?

  • @arnoldmitrica8108
    @arnoldmitrica8108 4 роки тому

    Hi! I have this project for my school, and I got stuck at the error for line 194 in lock.py (rfid_presented += keys[ event.code ] IndexError: string index out of range. Do you have any idea?

  • @ahmedlahmer9343
    @ahmedlahmer9343 4 роки тому

    Should I create a twilio account to receive an SMS?.If no from which account I receive it.I don't undrestand how I get this SMS?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  4 роки тому +1

      Yes, but not to receive it - to SEND it. The SMS is sent to your phone. It's sent using Twilio (you could use any online service) and goes to the second "thing you have", ie. the phone in your pocket.

  • @samsonmwita2930
    @samsonmwita2930 4 роки тому

    Hey Paul fist of all great project, I have tried recreating this but I have reached the stage where everything is booted to the default screen asking to present "your token" but when I tap the key fob it doesn't accept it. I wrote down the number on the keyfob as the code on PHPMyAdmin. Please could you guide me on how to amend this.

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  4 роки тому +1

      Hey, thanks for your comment! The best way to go about this would be to debug as you would any other issue. If you run the script manually from a shell/terminal, rather than autoload on startup, you should hopefully see some errors get spat out to the command line which might point you in the direction of your problem. Failing that, modify the script slightly so you can figure out what's going on - get it to print out to the screen what code it thinks it's getting from the card, for example, and just check every single micro-stage of the process in that way until you find the issue. Good luck!

    • @samsonmwita2930
      @samsonmwita2930 4 роки тому +1

      @@SwitchedOnNetwork I managed to fix the file so it runs but when it comes to scanning the fobs the screen doesn't change it stays stuck on the first screen. What should I do?

    • @arslanshahid6428
      @arslanshahid6428 4 роки тому

      @@SwitchedOnNetwork I got the same question paul can you please update i'm stuck at the same point too. Thanks

  • @ahmedoueslati6333
    @ahmedoueslati6333 2 роки тому

    What an awesome tutorial. I'm implementing this work for my project, and I have a few issues. If you can help me with please, I follow all the steps; however, when I run the python programme, I get this error message : (_tkinter.TclError: no display name and no $DISPLAY environment variable pi ) and also when I turn on the Pi I got a message in the touch screen "failed the load overall spi 2708" I scan the key fob and nothing come up. any help will be much appreciated

  • @muchibam5202
    @muchibam5202 5 років тому

    Dear sir. I just wonder why my rfid presented value in mysql not appears number but it only show XXXXXXXXX? Help me sir

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      You need to replace that in your database with whatever code is stored in your specific fob.

    • @muchibam5202
      @muchibam5202 5 років тому

      Switched On Network i just scan fob to row of rfid_code in access list still happen the same

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому

      Scan the code into a basic text editor like Notepad, and then copy and paste into the database either via command line or using phpMyAdmin

    • @muchibam5202
      @muchibam5202 5 років тому

      Switched On Network i already try as what you proposed me to do but still get the same result. Do i have to write fob in python lock script ?

    • @muchibam5202
      @muchibam5202 5 років тому

      Switched On Network how to write via command? Do you have any suggestion?

  • @sikazwe2010
    @sikazwe2010 6 років тому

    Thanks for sharing this great video. I have a question, if I used a non USB input device, like a switch how can it be monitored for status change using RPI.GPIO?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому

      That would depend very much on the device in question. Your best bet is to see if any documentation or example code comes with the device, and if not use the device name as a starting point for your research into it. Good luck!

    • @sikazwe2010
      @sikazwe2010 6 років тому

      @@SwitchedOnNetwork Cheers. I'm trying to incorporate tkinter with rpi.gpio inputs

  • @barryhines2255
    @barryhines2255 6 років тому

    Great video, what about when you are in the room, can you add an over-ride switch so that you can exit?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому

      Thanks, yes the possibilities are (nearly) endless so you can add/change pretty much whatever you like! 😀
      Also, depending on the type of latch, you might just also have a catch inside for low-tech exit from the inside...

  • @JackPillawa
    @JackPillawa 6 років тому +1

    thanks man, cool video. won't be that guy, but is the power supply not a overkill?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому +2

      Thanks, glad you liked it! You're not the first to ask about the power supply - I looked online and couldn't find a power supply that had a single plug to the mains and would output both 5V and 12V, that didn't cost an arm and a leg. The computer PSU was dead cheap and easy to modify, and fulfilled my single-power-cord-for-everything desire so I don't think it was overkill 😂 a more elegant solution would of course be better though haha

    • @JackPillawa
      @JackPillawa 6 років тому +1

      sure, i can feel you. sometimes when i build something it's a "now or never mentality"

  • @chadfanaroff5120
    @chadfanaroff5120 4 роки тому

    I keep getting a module error no tkinter module what must I do

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  4 роки тому

      Do you have that module installed? Are you using the right python version?

    • @chadfanaroff5120
      @chadfanaroff5120 4 роки тому

      @@SwitchedOnNetwork yes. I don't know what's the problem

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  4 роки тому

      What other steps have you taken to resolve the issue and debug it?

  • @aimanyt7270
    @aimanyt7270 6 років тому

    Hello sir. Im really lost right now. I want to make disabled parking project. I use rfid reader and card for authentication, ultrasonic sensor to detect if there is a car park at the spot, lcd to display the access, and wifi to send notification to the people who in charge. How can i connect all of this ? It makes me down because i dont even know how to do it. Ive been doing some research but not sven one is helping me out. I want to ask if i want to connect all of this, i have to simply coding one by one or there is another way ? Appreciate it so much if you see my comment 🙏🏼

  • @eugenemorley809
    @eugenemorley809 5 років тому

    Hey Paul
    Do I have to make sure all the files go to the home file or just the one that says lock.py file? I keep getting an error saying this file doesn’t exist?

  • @dexterdavid7324
    @dexterdavid7324 6 років тому

    Good day to you sir. I'm currently working on a smart door lock system using Raspberry Pi 3 and I'm using one of your videos as a reference. I'm just wondering, after importing the files for the codes in PhpMyAdmin, it says that it was a success. But there's no tab on the door lock like in your videos. Can you help me out?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому

      Hi - yes happy to help. When you say there's no "tab on the door lock", what do you mean? Can you give some more specifics about what you're expecting, and what you do see? Thanks!

    • @dexterdavid7324
      @dexterdavid7324 6 років тому +1

      @@SwitchedOnNetwork Nevermind. I just managed to import it to my database. Thanks for the quick reply though! And thanks for the tutorial!

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому

      Ah, great - glad you sorted it!

    • @dexterdavid7324
      @dexterdavid7324 6 років тому

      @@SwitchedOnNetwork Good day sir. Can you please do a tutorial on how to handle the database? I'm having trouble understanding on how to add users into the database. Thanks

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому

      @@dexterdavid7324 Inside the phpMyAdmin GUI, if you look under Privileges you'll see all you need in there. I'd recommend reading the official MySQL manual for further details :)

  • @luismarquez9150
    @luismarquez9150 5 років тому

    I'm doing your three-factor security door lock, and i have made a few steps of the installing and then i need to import the python code to the database but the thing is, i'm getting an error and looks like this
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'import sys
    import MySQLdb
    from threading import Thread
    import threadin
    What could be the problem? I read that has to be something about "server mariadb"

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому +1

      Hi! It looks like you're trying to import the Python script into the database..... whoops! That needs to be placed in the Raspberry Pi user's home directory and run from the Terminal. The only thing you need to import to your database server is the door_lock.sql file. Once imported, you can fill in the users table with your name, filename of your photo, your keyfob ID and your mobile number. Enjoy!

    • @luismarquez9150
      @luismarquez9150 5 років тому +1

      @@SwitchedOnNetwork It works, I was importing the wrong file, it's the sql file, not the python one. THANK YOU!

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  5 років тому +1

      Excellent, great!

    • @luismarquez9150
      @luismarquez9150 5 років тому

      @@SwitchedOnNetwork Hi again , I was in the step "Make the Python Script Autoload when Your Raspberry Pi boots up" and then you have to type this command "sudo nano ~/.config/lxsession/LXDE-pi/autostart" but when I'm adding this line "@sudo python lock.py" and trying to save it, it said that the directory doesn't exist and can't save it, there's something that I didn't download?

  • @cupidlsu
    @cupidlsu 5 років тому

    I wonder if some of this could be streamlined. If instead of an RFID, what about a bluetooth reader to detect a signal from the phone, which then detects the user from the phone, which then sends a 1 time code from the server to the phone, which then has the phone send the code to the reader, which then unlocks the door. You won't even need holes, screens, etc in your wall if your bluetooth can transmit through the wall. No?

  • @hafizzaki8212
    @hafizzaki8212 6 років тому

    Hi, just wanna ask, what will happen if I using the same signal pin for the relay switch? Really nice project btw

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому

      Thanks :) same pin as what...?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому

      Thanks :) same pin as what...?

    • @hafizzaki8212
      @hafizzaki8212 6 років тому

      @@SwitchedOnNetwork pin 13 for the relay switch. You mentioned in the video that for the relay switch need to use other signal pin.

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому

      Ah yes, because the touchscreen LCD uses several of the GPIO ports, it's safest to use one which is definitely not already being used for something by that. Since I don't know which specific ones are used, or for what, I just used one which was completely guaranteed to be unused due to not being connected to the ribbon cable or connector for the screen. So I chose 13 - you can of course use any unused one, it doesn't have to be number 13. Hope that makes sense?!

    • @hafizzaki8212
      @hafizzaki8212 6 років тому

      Switched On Network ohh okay got it. One more question, why i cant open the phpmyadmin on the browser? Is there any step I should do first?

  • @upendrachaudhari8766
    @upendrachaudhari8766 6 років тому +1

    Hey...Its Great Video...I just want to ask,How can i write the rfid tags with rfid_code ?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  6 років тому

      Thanks! This USB reader can only read the RFID tags, it can't programme them too. For that, take a look at the RC522 RFID module. Thanks for watching!

    • @upendrachaudhari8766
      @upendrachaudhari8766 6 років тому +1

      @@SwitchedOnNetwork Thanks a lot....

  • @gonsodany
    @gonsodany 3 роки тому

    great video.

    • @gonsodany
      @gonsodany 3 роки тому +1

      my comment asking for help keeps getting deleted....i got everything working, i just got a problem with the GUI, i've been trying to fit the keypad to my monitor but i cant find the line of code that positions the buttons, my current situation
      Can you please help me fix this? or give me the code line that does it? its really bugging me
      the 1,4,7 column always stays in the middle, but the otehr two columns always stick to the right side, any help please?

    • @SwitchedOnNetwork
      @SwitchedOnNetwork  3 роки тому

      Hmm, I'm not sure why that would be happening. The code I wrote isn't very portable so was pretty specific for the hardware I was using. I'd recommend going though and debugging from the ground up until you find the issue. Sorry I can't be of more help, but I hope you get it sorted!

    • @gonsodany
      @gonsodany 3 роки тому

      ​@@SwitchedOnNetwork im getting this problem: prnt . sc / 12vr9ai
      and prnt . sc / 12vt0bg
      when i resize the window it works but if its full screen the 2 last columns always stick to the right side