PGSQL auth fails during install #1251

New Issue

GiteaMirror · 2025-11-02T03:54:08-06:00

GiteaMirror commented

2025-11-02 03:54:08 -06:00

Originally created by @ghost on GitHub (Nov 17, 2017).

Gitea version (or commit ref): 1.2.3
Git version: 2.15.0
Operating system: FreeBSD 11.1
Database (use [x]):
- PostgreSQL
- MySQL
- MSSQL
- SQLite
Can you reproduce the bug at https://try.gitea.io:
- Yes (provide example URL)
- 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?

Originally created by @ghost on GitHub (Nov 17, 2017). - 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?

GiteaMirror added the type/bug label 2025-11-02 03:54:08 -06:00

GiteaMirror closed this issue

2025-11-02 03:54:08 -06:00

GiteaMirror commented

2025-11-02 03:54:09 -06:00

@lafriks commented on GitHub (Nov 17, 2017):

Depends on used library lib/pq#608

@lafriks commented on GitHub (Nov 17, 2017): Depends on used library lib/pq#608

GiteaMirror commented

2025-11-02 03:54:09 -06:00

@ghost commented on GitHub (Jan 17, 2018):

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

@ghost commented on GitHub (Jan 17, 2018): With pq not being updated are there plans to use another library for this functionality?

GiteaMirror commented

2025-11-02 03:54:09 -06:00

@ghost commented on GitHub (Feb 23, 2018):

Any updates here?

@ghost commented on GitHub (Feb 23, 2018): Any updates here?

GiteaMirror commented

2025-11-02 03:54:10 -06:00

@lunny commented on GitHub (Feb 24, 2018):

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

@lunny commented on GitHub (Feb 24, 2018): @evitalis do you know any other driver fix this issue?

GiteaMirror commented

2025-11-02 03:54:10 -06:00

@lunny commented on GitHub (Feb 24, 2018):

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

@lunny commented on GitHub (Feb 24, 2018): maybe we could try this one https://github.com/jackc/pgx

GiteaMirror commented

2025-11-02 03:54:10 -06:00

@ghost commented on GitHub (Mar 5, 2018):

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.

@ghost commented on GitHub (Mar 5, 2018): 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.

GiteaMirror commented

2025-11-02 03:54:10 -06:00

@jsan4christ commented on GitHub (Oct 23, 2018):

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

@jsan4christ commented on GitHub (Oct 23, 2018): Have the same problem, any leads? Database setting is invalid: pq: SSL is not enabled on the server

GiteaMirror commented

2025-11-02 03:54:10 -06:00

@techknowlogick commented on GitHub (Apr 15, 2019):

Please test if #6640 resolves your issue.

@techknowlogick commented on GitHub (Apr 15, 2019): Please test if #6640 resolves your issue.

GiteaMirror referenced this issue

2025-11-02 11:55:39 -06:00