Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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 join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant