search

lunarmodules / luasql

LuaSQL is a simple interface from Lua to a DBMS.
http://lunarmodules.github.io/luasql
535 stars 192 forks source link

Does luasql.postgres support SSL #164

Closed tomdaniels41 closed 2 months ago

tomdaniels41 commented 2 months ago

Hi,

does the luasql.postgres driver support SSL? if so how do i get it working?

Thank you for your time

tomasguisasola commented 2 months ago

I've never tried it but I think -- by superficially looking at the docs -- that this support depends only on the compilation of both sides, client and server. If I am correct, you can manage to compile the driver with the apropriate configuration and install the certificate files on the client and server sides and then the connection could be established over SSL.

tomasguisasola commented 2 months ago

By the way, if you try the approach mentioned above, feel free to write anything about it! If there are any impossibilities, feel free to ask for correction or improvements too.

tomdaniels41 commented 2 months ago

Hi, I have tried, certificate are working correctly as I can connect remotely using pgAdmin with ssl and both client side and server side are correct, Is there away to force ssl? and yes, i will be happy to do a wight on how to connect with ssl when we can get it working.

thank you for your time

tom