I can't get pgadmin_servers.json to work with sslmode verify-full, I really don't know if it's a configuration bug or a misswriten configuration by my side.
I know the certificate and key + authority are working since my PGAdmin settings are connected to postgresql with the environment variables "PGADMIN_CONFIG_CONFIG_DATABASE_URI" and I verified them multiple times just in case.
pgadmin_servers.json :
{
"Servers": {
"1": {
"Name": "Core",
"Group": "Servers",
"Host": "[redacted]",
"Port": [redacted],
"MaintenanceDB": "postgresql",
"Username": "[redacted]",
"ConnectionParameters": {
"connect_timeout": 10,
"sslmode": "verify-full",
"sslcert": "/mypath/chain.crt",
"sslkey": "/mypath/key.pem"
}
}
}
}
I have the following environment variables :
- PGADMIN_CONFIG_CONFIG_DATABASE_URI : postgresql+psycopg://[redacted]:[redacted]@[redacted]:[redacted]/[redacted]?sslmode=verify-full&sslrootcert=/mypath/authority/chain_authority.crt&sslcert=/mypath/chain.crt&sslkey=/mypath/key.pem
- PGSSLROOTCERT=/mypath/authority/chain_authority.crt
Without specifying PGSSLROOTCERT, I was having errors that PGAdmin could not find any root.crt in the home path which i'm not using and after this error I got the one in the image below.
Expected behavior
Normally after configuring sslcert and sslkey inside of ConnectionParameters, the server connection should use those settings to establish the connection.
Error message
Here is the error I'm getting when I input the database password :
Desktop (please complete the following information):
- OS: Arch Linux
- pgAdmin version: 9.15.0
- Mode: Server
- Browser Opera GX
- Package type: Docker
I can't get pgadmin_servers.json to work with sslmode verify-full, I really don't know if it's a configuration bug or a misswriten configuration by my side.
I know the certificate and key + authority are working since my PGAdmin settings are connected to postgresql with the environment variables "PGADMIN_CONFIG_CONFIG_DATABASE_URI" and I verified them multiple times just in case.
pgadmin_servers.json :
{ "Servers": { "1": { "Name": "Core", "Group": "Servers", "Host": "[redacted]", "Port": [redacted], "MaintenanceDB": "postgresql", "Username": "[redacted]", "ConnectionParameters": { "connect_timeout": 10, "sslmode": "verify-full", "sslcert": "/mypath/chain.crt", "sslkey": "/mypath/key.pem" } } } }I have the following environment variables :
Without specifying PGSSLROOTCERT, I was having errors that PGAdmin could not find any root.crt in the home path which i'm not using and after this error I got the one in the image below.
Expected behavior
Normally after configuring sslcert and sslkey inside of ConnectionParameters, the server connection should use those settings to establish the connection.
Error message
Here is the error I'm getting when I input the database password :
Desktop (please complete the following information):