Skip to content
Kong Logo | Kong Docs Logo
search
  • We're Hiring!
  • Docs
    • Kong Gateway
    • Kong Konnect
    • Kong Mesh
    • Plugin Hub
    • decK
    • Kubernetes Ingress Controller
    • Insomnia
    • Kuma

    • Docs contribution guidelines
  • Plugin Hub
  • Support
  • Community
  • Kong Academy
Get a Demo Start Free Trial
  • Kong Gateway
  • Kong Konnect
  • Kong Mesh
  • Plugin Hub
  • decK
  • Kubernetes Ingress Controller
  • Insomnia
  • Kuma

  • Docs contribution guidelines
  • 3.2.x (latest)
  • 3.1.x
  • 3.0.x
  • 2.8.x
  • 2.7.x
  • 2.6.x
  • Older Enterprise versions (2.1-2.5)
  • Older OSS versions (2.1-2.5)
  • Archive (pre-2.1)
    • Overview of Kong Gateway
      • Version Support Policy
      • Third Party Dependencies
      • Browser Support
    • Stability
    • Release Notes
      • Services
        • Overview
        • Configure Routes with Expressions
      • Upstreams
      • Plugins
      • Routing Traffic
      • Load Balancing
      • Health Checks and Circuit Breakers
      • Kong Performance Testing
    • Glossary
    • Get Kong
    • Services and Routes
    • Rate Limiting
    • Proxy Caching
    • Key Authentication
    • Load-Balancing
      • Overview
        • Overview
        • Deploy Kong Gateway in Hybrid mode
      • DB-less Deployment
      • Traditional
      • Overview
        • Helm
        • OpenShift with Helm
        • kubectl apply
        • Kubernetes Deployment Options
        • Using docker run
        • Build your own Docker images
        • Amazon Linux
        • Debian
        • Red Hat
        • Ubuntu
      • Running Kong as a non-root user
      • Securing the Admin API
      • Using systemd
      • Start Kong Gateway Securely
      • Programatically Creating Admins
      • Enabling RBAC
      • Overview
      • Download your License
      • Deploy Enterprise License
      • Using the License API
      • Monitor Licenses Usage
      • Default Ports
      • DNS Considerations
      • Network and Firewall
      • CP/DP Communication through a Forward Proxy
        • Configure PostgreSQL TLS
        • Troubleshooting PostgreSQL TLS
    • Kong Configuration File
    • Environment Variables
    • Serving a Website and APIs from Kong
      • Overview
      • Prometheus
      • StatsD
      • Datadog
      • Overview
      • Writing a Custom Trace Exporter
      • Tracing API Reference
    • Resource Sizing Guidelines
    • Security Update Process
    • Blue-Green Deployments
    • Canary Deployments
    • Clustering Reference
      • Log Reference
      • Dynamic log level updates
      • Customize Gateway Logs
      • Upgrade Kong Gateway 3.x.x
      • Migrate from OSS to Enterprise
    • Overview
      • Overview
      • Metrics
      • Analytics with InfluxDB
      • Analytics with Prometheus
      • Estimate Analytics Storage in PostgreSQL
      • Overview
      • Getting Started
      • Advanced Usage
        • Overview
        • Environment Variables
        • AWS Secrets Manager
        • Google Secrets Manager
        • Hashicorp Vault
        • Securing the Database with AWS Secrets Manager
      • Reference Format
      • Overview
      • Get Started with Dynamic Plugin Ordering
      • Overview
      • Enable the Dev Portal
      • Publish an OpenAPI Spec
      • Structure and File Types
      • Themes Files
      • Working with Templates
      • Using the Editor
        • Basic Auth
        • Key Auth
        • OIDC
        • Sessions
        • Adding Custom Registration Fields
        • Manage Developers
        • Developer Roles and Content Permissions
        • Authorization Provider Strategy
        • Enable Application Registration
        • Enable Key Authentication for Application Registration
          • External OAuth2 Support
          • Set up Okta and Kong for External Oauth
          • Set up Azure AD and Kong for External Authentication
        • Manage Applications
        • Theme Editing
        • Migrating Templates Between Workspaces
        • Markdown Rendering Module
        • Customizing Portal Emails
        • Adding and Using JavaScript Assets
        • Single Page App in Dev Portal
        • Alternate OpenAPI Renderer
      • SMTP
      • Workspaces
      • Helpers CLI
      • Portal API Documentation
    • Audit Logging
    • Keyring and Data Encryption
    • Workspaces
    • Consumer Groups
    • Event Hooks
    • Configure Data Plane Resilience
    • About Control Plane Outage Management
      • Overview
      • Install the FIPS Compliant Package
      • FIPS 140-2 Compliant Plugins
    • Overview
    • Enable Kong Manager
      • Services and Routes
      • Rate Limiting
      • Proxy Caching
      • Authentication with Consumers
      • Load Balancing
      • Overview
      • Create a Super Admin
      • Workspaces and Teams
      • Reset Passwords and RBAC Tokens
      • Basic Auth
        • Configure LDAP
        • LDAP Service Directory Mapping
        • Configure OIDC
        • OIDC Authenticated Group Mapping
      • Sessions
        • Overview
        • Enable RBAC
        • Add a Role and Permissions
        • Create a User
        • Create an Admin
    • Networking Configuration
    • Workspaces
    • Create Consumer Groups
    • Sending Email
    • Overview
    • File Structure
    • Implementing Custom Logic
    • Plugin Configuration
    • Accessing the Data Store
    • Storing Custom Entities
    • Caching Custom Entities
    • Extending the Admin API
    • Writing Tests
    • (un)Installing your Plugin
      • Overview
      • kong.client
      • kong.client.tls
      • kong.cluster
      • kong.ctx
      • kong.ip
      • kong.jwe
      • kong.log
      • kong.nginx
      • kong.node
      • kong.request
      • kong.response
      • kong.router
      • kong.service
      • kong.service.request
      • kong.service.response
      • kong.table
      • kong.tracing
      • kong.vault
      • kong.websocket.client
      • kong.websocket.upstream
      • Go
      • Javascript
      • Python
      • Running Plugins in Containers
      • External Plugin Performance
    • Overview
        • Overview
        • OpenID Connect with Curity
        • OpenID Connect with Azure AD
        • OpenID Connect with Google
        • OpenID Connect with Okta
        • OpenID Connect with Auth0
        • OpenID Connect with Cognito
      • Authentication Reference
      • Allow Multiple Authentication Plugins
    • Rate Limiting Plugin
      • Add a Body Value
    • GraphQL
      • gRPC Plugins
      • Configure a gRPC service
    • Overview
    • Information Routes
    • Health Routes
    • Tags
    • Debug Routes
    • Services
    • Routes
    • Consumers
    • Plugins
    • Certificates
    • CA Certificates
    • SNIs
    • Upstreams
    • Targets
    • Vaults
    • Keys
    • Licenses
    • Workspaces
    • RBAC
    • Admins
    • Developers
    • Consumer Groups
    • Event Hooks
    • Keyring and Data Encryption
    • Audit Logs
    • kong.conf
    • Injecting Nginx Directives
    • CLI
    • Key Management
    • Performance Testing Framework
    • Router Expressions Language
    • FAQ

github-edit-pageEdit this page

report-issueReport an issue

enterprise-switcher-iconSwitch to OSS

On this page
  • PostgreSQL
    • Could not accept SSL connection
    • Could not load server certificate file
    • Could not access private key file
    • Incorrect private key permissions
    • Failed to verify the SSL certificate
    • Certificate verify failed
    • Certificate authentication failed for user
    • Connection requires a valid client certificate
  • Troubleshooting TLS on Kong Gateway
    • Protocol versions are not a match
    • The server does not support SSL connections
    • Certificate verify failed
    • Connection requires a valid client certificate
    • tlsv1 alert unknown ca
    • Certificate authentication failed for user
Kong Gateway
3.2.x (latest)
  • Home
  • Kong Gateway
  • Production Deployment
  • Networking
  • Troubleshoot PostgreSQL TLS

Troubleshoot PostgreSQL TLS

PostgreSQL

Could not accept SSL connection

If you receive either of the following error messages, you are experiencing an issue with mismatched SSL versions.

LOG:  could not accept SSL connection: wrong version number
HINT:  This may indicate that the client does not support any SSL protocol version between TLSv1.1 and TLSv1.1.
LOG:  could not accept SSL connection: unsupported protocol
HINT:  This may indicate that the client does not support any SSL protocol version between TLSv1.2 and TLSv1.3.

In this case, the client is trying to connect to the server using a version of the TLS protocol that is not supported by the server. Check which version PostgreSQL supports and adjust the client-side TLS version.

You can check the TLS version by running the pg_config --configure command.

Kong recommends TLSv1.2 or higher. Lower versions are deprecated and are not considered secure.

Could not load server certificate file

If you are receiving this error message:

FATAL:  could not load server certificate file "server.crt": No such file or directory

The server is unable to find the certificate file. By default, the certificate file should be named server.crt, and it should be placed in the server’s data directory. Other names are allowed, but they should be explicitly specified in the ssl_cert_file.

Could not access private key file

If you are receiving this error message:

FATAL:  could not access private key file "server.key": No such file or directory

The server is unable to find the private key file. By default, the private key file should be named server.key, and it should be placed in the server’s data directory. If you used another naming convention it should be explicitly set using the ssl_key_file parameter in the postgresql.conf file.

Incorrect private key permissions

FATAL:  private key file "/certs/example.com.key" has group or world access
DETAIL:  File must have permissions u=rw (0600) or less if owned by the database user, or permissions u=rw,g=r (0640) or less if owned by root.

If you receive this error, the permissions for the private key are incorrect. Use the information in the error message to apply the correct permissions to your private key.

Failed to verify the SSL certificate

LOG:  could not accept SSL connection: tlsv1 alert unknown ca

The client has failed to verify the PostgreSQL server certificate. To resolve this issue, make sure that the certificate matches the one applied to Kong Gateway.

Certificate verify failed

LOG:  could not accept SSL connection: certificate verify failed

The PostgreSQL server failed to verify the client certificate. You can fix this by verifying that the server provided in the ssl_ca_file parameter in postgres.conf is trusted by the CA.

Certificate authentication failed for user

LOG:  provided user name (kong) and authenticated user name (foo@example.com) do not match
FATAL:  certificate authentication failed for user "kong"

This error message happens when the client certificate doesn’t match the username specified in the database.

Connection requires a valid client certificate

FATAL:  connection requires a valid client certificate

This error occurs when the PostgreSQL server requires a client certificate for authentication, but the client, in this case Kong Gateway, was unable to provide a valid certificate. For this type of error, check if pg_ssl_cert and pg_ssl_cert_key are correctly set in kong.conf.

Troubleshooting TLS on Kong Gateway

Protocol versions are not a match

If you receive either of the following error messages:

Error: [PostgreSQL error] failed to retrieve PostgreSQL server_version_num: tlsv1 alert protocol version
Error: [PostgreSQL error] failed to retrieve PostgreSQL server_version_num: unsupported protocol

The server and client versions are not in sync. Check the version that the PostgreSQL server is using and adjust the Kong Gateway version accordingly.

The server does not support SSL connections

Error: [PostgreSQL error] failed to retrieve PostgreSQL server_version_num: the server does not support SSL connections

This error occurs when SSL is not supported by PostgreSQL. Configure PostgreSQL according to the configuration instructions.

Certificate verify failed

Error: [PostgreSQL error] failed to retrieve PostgreSQL server_version_num: certificate verify failed

This error occurs when Kong Gateway fails to verify the PostgreSQL server certificate. Ensure that the PostgreSQL server has configured a trusted certificate and the corresponding CA chain is correctly set in lua_ssl_trusted_certificate within kong.conf.

Connection requires a valid client certificate

Error: [PostgreSQL error] failed to retrieve PostgreSQL server_version_num: FATAL: connection requires a valid client certificate

Kong Gateway requires a client certificate for authentication, but the client was unable to provide a valid certificate.

This error occurs when the PostgreSQL server requires a client certificate for authentication, but the Kong Gateway is unable to provide a valid certificate. For this type of error, check if pg_ssl_cert and pg_ssl_cert_key are correctly set in kong.conf.

tlsv1 alert unknown ca

Error: [PostgreSQL error] failed to retrieve PostgreSQL server_version_num: tlsv1 alert unknown ca

The PostgreSQL server failed to verify the client certificate. Use a client certificate which is trusted by the CA set in ssl_ca_file within postgres.conf.

Certificate authentication failed for user

Error: [PostgreSQL error] failed to retrieve PostgreSQL server_version_num: FATAL: certificate authentication failed for user "kong"

The common name of the client certificate doesn’t match the username set in the database. Add a username mapping in pg_ident.conf as described in the PostgreSQL configuration instructions.

Thank you for your feedback.
Was this page useful?
  • Kong
    THE CLOUD CONNECTIVITY COMPANY

    Kong powers reliable digital connections across APIs, hybrid and multi-cloud environments.

    • Company
    • Customers
    • Events
    • Investors
    • Careers Hiring!
    • Partners
    • Press
    • Contact
  • Products
    • Kong Konnect
    • Kong Gateway
    • Kong Mesh
    • Get Started
    • Pricing
  • Resources
    • eBooks
    • Webinars
    • Briefs
    • Blog
    • API Gateway
    • Microservices
  • Open Source
    • Install Kong Gateway
    • Kong Community
    • Kubernetes Ingress
    • Kuma
    • Insomnia
  • Solutions
    • Decentralize
    • Secure & Govern
    • Create a Dev Platform
    • API Gateway
    • Kubernetes
    • Service Mesh
Star
  • Terms•Privacy
© Kong Inc. 2023