Skip to content
This repository has been archived by the owner on Jun 4, 2024. It is now read-only.

Failed to connect Falcon to Postgresql #644

Open
DarrenMidson opened this issue Mar 16, 2024 · 0 comments
Open

Failed to connect Falcon to Postgresql #644

DarrenMidson opened this issue Mar 16, 2024 · 0 comments

Comments

@DarrenMidson
Copy link

Hi

I have created a postgresql database on my windows 10 laptop and I can read and write data from the database via Python.

code snipnet

conn = psycopg2.connect(database="Test", user='postgres', password='xxxxxx', host='127.0.0.1', port= '5432')
conn.autocommit = True
cursor = conn.cursor()

cursor.execute('''insert into esptemp values(%s,%s, %s)''', (UDP_PORT, datetime.now(timezone.utc), float(writestring)) )

cursor.execute('''SELECT * from ESPTEMP''')
However, I want to be able to display the data using plotly Dash which requires, I think, their Falcon software to connect.

But when I run falcon and try and connect to my database I get

Unknown authenticationOk message typeMessage { name: 'authenticationOk', length: 23 }

Help greatly appreciated

Regards

Darren

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant