postgresql-interfaces/psqlodbc GitHub issues and pull requests (mirror)help / color / mirror / Atom feed
[postgresql-interfaces/psqlodbc] issue #26: It seems 32bit driver does not have ssl compiled in ? 3+ messages / 2 participants [nested] [flat]
* [postgresql-interfaces/psqlodbc] issue #26: It seems 32bit driver does not have ssl compiled in ? @ 2024-05-27 15:01 "musashi-garami (@musashi-garami)" <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: musashi-garami (@musashi-garami) @ 2024-05-27 15:01 UTC (permalink / raw) To: postgresql-interfaces/psqlodbc <[email protected]> I'm not 100% sure, although I've tested many setups. 64bit driver works 100%, connects with SSL (seems to ignore when I try add the cert path in my connection string, it looks like it's hardcoded to look C:\Users\<user>\AppData\Roaming\postgresql\root.crt - this is fine, if I put the root cert there it works. I was setting up on another pc, with 32bit MS ACCESS (the frontend connecting to my postgres backend). And it would not work at all, when trying to create the DSN, (32bit) I get a message saying SSL not compiled in. 64bit works in the ODBC manager, creating DSN's. It also works with MS access in my connection string (as long as I put the certificate in the hard coded location). 32bit doesn't seem to work with SSL, so I suspect 2 things: 1) The hard coded path that 32bit is searching for root cert is different and I don't know what it is 2) 32bit compiled psqlodbc driver does not have ssl compiled in (I suspect it's this). I'm not an expert in this area, and could be wrong in my understanding, but from a lot of testing, this seems to be the conclusion. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [postgresql-interfaces/psqlodbc] issue #26: It seems 32bit driver does not have ssl compiled in ? @ 2024-05-27 15:29 "RegisWeduLabs (@RegisWeduLabs)" <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: RegisWeduLabs (@RegisWeduLabs) @ 2024-05-27 15:29 UTC (permalink / raw) To: postgresql-interfaces/psqlodbc <[email protected]> +1 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [postgresql-interfaces/psqlodbc] issue #26: It seems 32bit driver does not have ssl compiled in ? @ 2024-05-28 13:13 "musashi-garami (@musashi-garami)" <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: musashi-garami (@musashi-garami) @ 2024-05-28 13:13 UTC (permalink / raw) To: postgresql-interfaces/psqlodbc <[email protected]> This is fixed in REL-16_00_0005 https://github.com/postgresql-interfaces/psqlodbc/releases/tag/REL-16_00_0005 Thank you @davecramer ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-05-28 13:13 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-05-27 15:01 [postgresql-interfaces/psqlodbc] issue #26: It seems 32bit driver does not have ssl compiled in ? "musashi-garami (@musashi-garami)" <[email protected]> 2024-05-27 15:29 ` "RegisWeduLabs (@RegisWeduLabs)" <[email protected]> 2024-05-28 13:13 ` "musashi-garami (@musashi-garami)" <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox