-
Notifications
You must be signed in to change notification settings - Fork 4.8k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Can't start postgresql 16 over tls #12702
Comments
I bet that's because of the 0.8.25 to 1.2.0 upgrade of |
I have the same problem but with postgres 15 |
Yes, in |
Just link some context here: local ssl = require("resty.openssl.ssl").from_socket(self.sock) -- it seams this line returns `nil`
local server_cert = ssl:get_peer_certificate() @michael-todorovic, could you modify that line (in most probably local ssl = require("resty.openssl.ssl").from_socket(self.sock) -- it seams this line returns `nil` to: local ssl, err = require("resty.openssl.ssl").from_socket(self.sock) -- it seams this line returns `nil`
if err then
error(err)
end And report back? |
Also @fffonion could you take a look at it. Is the auxilary module compiled with CE? Is it a requirement now? Is there difference in EE shipped |
Any updates on this? I got the same, working on 3.5 and stopped with 3.6 and 3.6.1. Leaving my trace just in case :)
On 3.5:
On 3.6.1:
|
We are working on fix right now : ) Thanks for you patience. |
Alerady some updates on this topic? |
The fix will be shipped with 3.7.x release. |
And is there already an approximate ETA for 3.7.x ? |
We are still working on publishing the artifacts for 3.7.x, they will be released anytime soon. cc @AndyZhang0707 |
I started investigating this as well, Seems lua-resty-openssl-aux-module was not baked into the bazel build process? To fix it right away some form of this can be added to those who build from source:
Hoping 3.7.x drops soon so I can skip adding this as a fork in my build flow though! |
kong 3.7 is released now. See: https://github.com/Kong/kong/releases/tag/3.7.0 |
@chronolaw , not seeing anything about Kong fixing the postgres tls issue though in the changelog? Did the fix make it into the version, trying to see what PR fixed it if the changelog lacks a reference point? Edit - might be related but says its a temporary fix - #12665 , is the full fix going to be adding Edit edit - yeah seems 1.2.1 bump https://github.com/fffonion/lua-resty-openssl/pull/148/files has the fixes needed for that version of OpenResty that ships with Kong without the need for the aux module necessarily. |
@fffonion , could you give us the explanation of this fix in 3.7? |
and when will it be pushed to docker hub? :) |
It's fixed in 3.7, please refer to #12592 |
Bump |
it's available now, was pushed last evening |
I just installed the new images and I can confirm it works. Thanks for the effort! |
Can also confirm - issue seems to be solved. Thanks a lot! |
Thanks a lot for solving this issue with Kong 3.7. We were stuck on Kong 3.5 so far because of this. Now, we are trying to upgrade to Kong 3.7. However, we cannot upgrade from 3.5 to 3.7 directly (see also the table here) as we're getting the error |
we migrated from 3.5 to 3.7 successfully in one step by running |
Thank you for your help, we will try to do it the same way |
Is there an existing issue for this?
Kong version (
$ kong version
)3.6.1
Current Behavior
I'm currently migrating from pg 13 to 16. Kong 3.6.1 (docker image) worked well on pg13 but when I try to start or just run a
kong migrations list
on pg16 (bypassing pgbouncer to reduce potential issues), I get:I'm using postgres 16.2-1.pgdg120+2 on Debian 12. The TLS config itself is ok:
I checked, just in case, the docker image supports those TLS versions+ciphers.
I tried:
On each try, this was the same pg16 cluster of course 😄
I tried to open pgmoon lua code but can't really understand what can be an issue nor how to get more details.
I also checked what went at the network level with tcpdump/wireshark but nothing was really showing.
On postgres side, I don't have any logs about the failure either.
Do you have an idea how to make progress debugging this issue?
Thanks for your help!
Expected Behavior
No response
Steps To Reproduce
I run:
docker run --name kong --rm -e KONG_ADMIN_ACCESS_LOG="/dev/stdout json_admin" -e KONG_ADMIN_LISTEN=0.0.0.0:8001 -e KONG_DATABASE=postgres -e KONG_PG_DATABASE=kong361 -e KONG_PG_HOST=master-postgres.domain.com -e KONG_PG_USER=kong_user -e KONG_PLUGINS=bundled,jwt-consumer-to-users -e KONG_PROXY_ACCESS_LOG="/dev/stdout json_proxy" -e KONG_PROXY_ERROR_LOG=/dev/stdout -e KONG_PROXY_LISTEN=0.0.0.0:8000 -e KONG_PG_SSL="on" -e KONG_PG_PORT=5431 -e KONG_PG_PASSWORD=xxx -e KONG_LOG_LEVEL=debug kong:3.6.1 kong migrations list -vv
Anything else?
No response
The text was updated successfully, but these errors were encountered: