https://discord.gg/botpress logo
PostgreSQL in SSL Custom Integration Error
# šŸ¤help
b
Hi everyone, I’m working on an integration to connect Botpress to my PostgreSQL database over SSL. Right now, ssl=require works fine, but when I try ssl=verify-ca, I get the error: self-signed certificate in certificate chain I believe the usual way to fix this is to upload a .pem certificate file in Node and read it via the file system. However, it seems like Botpress doesn’t support accessing the file system directly. Am I correct in this assumption? If so, is there any workaround to get ssl=verify-ca working with Botpress? Thanks in advance for any advice!
w
You have two options: - Don’t use a self-signed certificate: obtain a valid CA-signed certificate to use
verify-ca
. - Don’t use the
verify-ca
option: if you use a self-signed certificate, disable
verify-ca
because you’re calling your own endpoint and accept the certificate.
r
yeah you're correct most botpress environments (especially botpress Cloud) don’t allow direct access to the file system using fs, so uploading and reading a .pem file isn’t supported the same way as in a standard node.js server