search

fly-apps / laravel-docker

Base Docker images for use with Laravel on Fly.io
38 stars 8 forks source link

Cannot connect to postgresql version 15 #5

Closed anshour closed 6 months ago

anshour commented 11 months ago

I use neon tech postgres sql to power my laravel app, neon tech uses pgsql version 15. but when i deploy it to the fly, it doesnt work, the error says: {"message":"SQLSTATE[08006] [7] ERROR: Endpoint ID is not specified. Either please upgrade the postgres client library (libpq) for SNI support or pass the endpoint ID (first part of the domain name) as a parameter: '?options=endpoint%3D'. See more at https://neon.tech/sni\nERROR: connection is insecure (try using sslmode=require)","context":{"exception":{"class":"PDOException","message":"SQLSTATE[08006] [7] ERROR: Endpoint ID is not specified. Either please upgrade the postgres client library (libpq) for SNI support or pass the endpoint ID (first part of the domain name) as a parameter: '?options=endpoint%3D'

on my windows machine, i simply replace libpq.dll (in php directory ) to the new libpq.dll that i get from postgres installation. i dont know how to do it via docker. please helpp thanks

fideloper commented 6 months ago

Hello from ~4 months later (sorry!)

This type of customization is something you'll need to do in the final Docker image you create.

That being said, it might just resolve itself when I update the base image from 20.04 to 22.04.