psycopg2.OperationalError: FATAL: unsupported frontend protocol 1234.5679: server supports 2.0 to 3.0

by

1234.5679 is the special code sent by the client to request SSL-encrypted database connections, and support for that has been in PostgreSQL since commit e0e7daef6da in 1999. But your PostgreSQL cannot be that old, because support for protocol version 3.0 was not added before 2003.

Actually, from studying src/backend/postmaster/postmaster.c and reading the mailing list, this is a bug on the PostgreSQL server:

The client must be configured to try GSS authentication, and when the server rejects, it wants to negotiate an SSL connections, but the server doesn’t expect that at this point; hence the error.

See the discussion here. The bug has been fixed with release 12.3.

As a workaround, disable either GSS authentication or SSL negotiation on the client.

In psycopg2, disabling SSL is done by using sslmode="disable" in the connection string, and disabling GSS is done with gssencmode="disable". See the documentation for details.

More Related Contents:

  1. psycopg2: insert multiple rows with one query
  2. Parameterized queries with psycopg2 / Python DB-API and PostgreSQL
  3. Passing table name as a parameter in psycopg2
  4. DatabaseError: current transaction is aborted, commands ignored until end of transaction block?
  5. error installing psycopg2, library not found for -lssl
  6. Error: pg_config executable not found when installing psycopg2 on Alpine in Docker
  7. How to set up a PostgreSQL database in Django
  8. Psycopg2 image not found
  9. Error Installing Psycopg2 on MacOS 10.9.5
  10. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  11. Create a Postgres database using python
  12. Python/postgres/psycopg2: getting ID of row just inserted
  13. Escape SQL “LIKE” value for Postgres with psycopg2
  14. How to set connection timeout in SQLAlchemy
  15. Mac + virtualenv + pip + postgresql = Error: pg_config executable not found
  16. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip
  17. Psycopg2, Postgresql, Python: Fastest way to bulk-insert
  18. Insert Python Dictionary using Psycopg2
  19. Use binary COPY table FROM with psycopg2
  20. How Postgresql COPY TO STDIN With CSV do on conflic do update?
  21. Pandas read_sql with parameters
  22. Executing multiple statements with Postgresql via SQLAlchemy does not persist changes
  23. Use Django ORM as standalone [duplicate]
  24. How can I use psycopg2.extras in sqlalchemy?
  25. How do you join two tables on a foreign key field using django ORM?
  26. python pip install psycopg2 install error
  27. Creating partial unique index with sqlalchemy on Postgres
  28. Filling Many2many field (odoo 8)
  29. SQLAlchemy func.count on boolean column
  30. Deploying Django to Heroku (Psycopg2 Error)

Leave a Comment