server: Under debian 9, can't find SSL config when mounting postgres_fdw remote
erichanson opened this issue · 0 comments
erichanson commented
2021/01/03 10:30:05 HTTP/1.1 GET /endpoint/0.3/function/bundle/remote_mount?args=%7B%22vals%22%3A%5B%2238c5579d-8090-4059-8815-135f17d85013%22%5D%7D&meta_data=true
Auto configuration failed
139782455682880:error:25066067:DSO support routines:DLFCN_LOAD:could not load the shared library:dso_dlfcn.c:185:filename(libssl_conf.so): libssl_conf.so: cannot open shared object file: No such file or directory
139782455682880:error:25070067:DSO support routines:DSO_load:could not load the shared library:dso_lib.c:244:
139782455682880:error:0E07506E:configuration file routines:MODULE_LOAD_DSO:error loading dso:conf_mod.c:285:module=ssl_conf, path=ssl_conf
139782455682880:error:0E076071:configuration file routines:MODULE_RUN:unknown module name:conf_mod.c:222:module=ssl_conf
2021/01/03 10:30:05 💥💥💥💥 API Query failed, unhandled exception: unexpected EOF
The fix is to set an environment variable, OPENSSL_CONF, with this command:
export OPENSSL_CONF=/etc/ssl/
Need to figure out how to do this from within the server?