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

Failed to connect Falcon to Postgresql #644

Open
@DarrenMidson

Description

@DarrenMidson

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions