Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Connection to postgres server on Azure fails when I use "sslmode=verify-full"

Tags:

postgresql

azure

azure-database-postgresql

When I select "sslmode=verify-full" when connecting to my postgres server in Azure, the connection fails with the following error:

server certificate for "<region>.control.database.windows.net" (and 7 other names) does not match host name "<servername>.postgres.database.azure.com".

Is "sslmode=verify-full" not allowed for Azure Database for PostgreSQL service? How do I connect to my postgres server in Azure if I have a requirement to use "sslmode=verify-full"?

like image 716
Shantanu Avatar asked May 17 '17 19:05

Shantanu

People also ask

What is SSL mode in PostgreSQL?

In libpq, secure connections can be ensured by setting the sslmode parameter to verify-full or verify-ca , and providing the system with a root certificate to verify against. This is analogous to using an https URL for encrypted web browsing. Once the server has been authenticated, the client can pass sensitive data.

Which deployment option of PostgreSQL in Azure should you use?

For organizations that need to customize their PostgreSQL deployments, and need to overcome the limitations of the Azure Database for PostgreSQL managed service, the self-managed Azure VM option is the most appropriate option.

Which tool is used to connect to the PostgreSQL server in Azure cloud shell?

The psql client is a popular choice for connecting to PostgreSQL servers. You can connect to your server by using psql with Azure Cloud Shell. You can also use psql on your local environment if you have it available. An empty database, postgres, is automatically created with a new PostgreSQL server.

1 Answers

"sslmode=verify-full" is supported in Azure Database for PostgreSQL service, however there is a limitation in the current implementation of the service.

If you require using "sslmode=verify-full", please use the server naming convention <servername>.database.windows.net as your connection string host name instead of the preferred host naming convention <servername>.postgres.database.azure.com.

This limitation is expected to be removed in the future. Connections using other SSL modes should continue to use the preferred host naming convention <servername>.postgres.database.azure.com.

Please refer to How to Configure SSL for Postgres in Azure for more details.

like image 158
Shantanu Avatar answered Nov 15 '22 05:11

Shantanu
Sign in to Comment

Related questions

sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) can't adapt type 'property'
Install pgAgent on AWS RDS for Postgres
NPGSQL with .netCore how to login to schema not just to database
postgres - bigint out of range error, which datatype to use for very large numbers
JPA schema validation with PostgreSQL 9.5
How can I get sum total of each column?
Rails/ActiveRecord Group by month+year with counts
How to add a column to typed table without altering type in PostgreSQL?
SQL select every xth row based on total number
PostgreSQL - Right Index choice for a status field (varchar)
Postgres bulk INSERT function using JSON arguments
How to enable postgresql-9.6 for remote connectivity
Escape single quote in Postgres query inside node js app
How to typecast a join column in Arel
postgresql search text into array of text
How to use IN clause with multiple columns on same data in postgresql?
Speed up INSERT of 1 million+ rows into Postgres via R using COPY?
Using pg_restore to create or overwrite tables
Postgresql: date format and local language output
syntax error at or near "SERIAL" with autoIncrement only

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!