Gitea: PGSQL auth fails during install

[ghost]

• Gitea version (or commit ref): 1.2.3
• Git version: 2.15.0
• Operating system: FreeBSD 11.1
• Database (use [x]):
  
  
  
  • [x] PostgreSQL
  
  
  • [ ] MySQL
  
  
  • [ ] MSSQL
  
  
  • [ ] SQLite
  
  
• Can you reproduce the bug at https://try.gitea.io:
  
  
  
  • [ ] Yes (provide example URL)
  
  
  • [x] No
  
  
  • [ ] Not relevant
  
  
• Log gist:

Description

When configuring the PostgreSQL database I see the following error:

Database setting is invalid: pq: unknown authentication response: 10

The same error is reported in the logs when using unix socket types instead of http.

The issue is I am using SCRAM-SHA-256 authentication for the gitea user, the upstream pq library does not support this from what I can tell.

Is it possible to use a library which does support this?

[lafriks]

Depends on used library lib/pq#608

[ghost]

With pq not being updated are there plans to use another library for this functionality?

[ghost]

Any updates here?

[lunny]

@evitalis do you know any other driver fix this issue?

[lunny]

maybe we could try this one https://github.com/jackc/pgx

[ghost]

I am not familiar with Go enough to suggest an alternative library. But given the inactivity of the current one it may be worth looking into another to keep up with PostgreSQL features and security improvements.

[jsan4christ]

Have the same problem, any leads?
Database setting is invalid: pq: SSL is not enabled on the server

[techknowlogick]

Please test if #6640 resolves your issue.