Annihilation989
Posts: 9
Joined: Wed Feb 14, 2018 3:37 pm

Raspberry pi rfid door lock

Sun Sep 08, 2019 7:29 pm

Hello, I was wondering if anyone could help me,
I have been following this guide (https://github.com/plenkyman/RFID_RC522 ... lation.txt) to make an rfid door lock, however, when I try to set up the cards, I get an error, might it be that i'm running this on buster, but it says it is run on jessie.
I have tried contacting the creator, but unfortunately, he hasn't been online since 2017.
Any help would be greatly appreciated,
Tim

The error:

Traceback (most recent call last):
File "/usr/local/lib/python3.7/dist-packages/pymysql/connections.py", line 571, in connect
sock.connect(self.unix_socket)
FileNotFoundError: [Errno 2] No such file or directory

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "SetupCards.py", line 26, in <module>
connection = pymysql.connect(host=tdp.rpi_ip,unix_socket='/var/run/mysqld/mysqld.sock', user=tdp.dbUs, passwd=tdp.dbPW, db=tdp.dbNa)
File "/usr/local/lib/python3.7/dist-packages/pymysql/__init__.py", line 94, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.7/dist-packages/pymysql/connections.py", line 325, in __init__
self.connect()
File "/usr/local/lib/python3.7/dist-packages/pymysql/connections.py", line 630, in connect
raise exc
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([Errno 2] No such file or directory)")

User avatar
topguy
Posts: 5755
Joined: Tue Oct 09, 2012 11:46 am
Location: Trondheim, Norway

Re: Raspberry pi rfid door lock

Mon Sep 09, 2019 10:36 am

The script expect a running MySQL server on "localhost" that connection is what fails.
There is a big chance that the "thedoor_full_install_v9.sh" doesnt quite work on Buster because packages has changed names etc..

Annihilation989
Posts: 9
Joined: Wed Feb 14, 2018 3:37 pm

Re: Raspberry pi rfid door lock

Mon Sep 09, 2019 5:55 pm

Thanks for the reply, I will try jessie

Annihilation989
Posts: 9
Joined: Wed Feb 14, 2018 3:37 pm

Re: Raspberry pi rfid door lock

Thu Sep 12, 2019 9:54 pm

Hello,
I have tried jessie, but the reader wasn't running, I googled around and found out the reader doesn't work with the latest version of jessie, could anyone confirm this?
Many thanks,
Tim

User avatar
topguy
Posts: 5755
Joined: Tue Oct 09, 2012 11:46 am
Location: Trondheim, Norway

Re: Raspberry pi rfid door lock

Fri Sep 13, 2019 8:49 am

Using Jessie which is very old, could be difficult in general, a better solution is to learn how the solution is supposed to work and learn set it up manually.

Annihilation989
Posts: 9
Joined: Wed Feb 14, 2018 3:37 pm

Re: Raspberry pi rfid door lock

Sun Oct 13, 2019 7:14 am

Everything works, except the script for setup cards fails because I don't know the directory for the reader

User avatar
topguy
Posts: 5755
Joined: Tue Oct 09, 2012 11:46 am
Location: Trondheim, Norway

Re: Raspberry pi rfid door lock

Sun Oct 13, 2019 10:51 am

You have to give more information about the script and what directory you are talking about if you want help.

Return to “Other projects”