Re: Azure Database for PostgreSQL flexible server: password authentication failed

2025-02-28 Thread Alicja Kucharczyk
Hi Alex, pt., 28 lut 2025 o 16:05 Alexander Farber napisaƂ(a): > Now the connection from a container in AKS works for me: > > $ psql "postgresql://postgresql:password12345!!@ > 172.21.32.4:5432/postgres?sslmode=require" > psql (17.4, server 16.6) > SSL connection (protocol: TLSv1.3, cipher: TLS_

Re: Azure Database for PostgreSQL flexible server: password authentication failed

2025-02-28 Thread Alexander Farber
Ah my team mate has spotted the error for me. And it paid off, that he has no experience with PostgreSQL yet :-) Because the admin user for Azure Database for PostgreSQL flexible server is not "postgres" but "postgresql" Now the connection from a container in AKS works for me: $ psql "postgresq

Re: Azure Database for PostgreSQL flexible server: password authentication failed

2025-02-28 Thread Alexander Farber
Sorry, correction for the openssl command output: $ openssl s_client -connect 172.21.32.4:5432 -starttls postgres Connecting to 172.21.32.4 CONNECTED(0003) Can't use SSL_get_servername depth=2 C=US, O=DigiCert Inc, OU=www.digicert.com, CN=DigiCert Global Root G2 verify return:1 depth=1 C=US, O

Azure Database for PostgreSQL flexible server: password authentication failed

2025-02-28 Thread Alexander Farber
Good afternoon, I am using an Azure Database for PostgreSQL flexible server with no public ip. It is connected to a private VNet and I try to access it from an Alpine Linux container with openssl and postgresql-client installed. In Azure portal I have clicked the "Reset password" button, entered