284 could not be located in the dynamic link library SSLEAY32.dll

Question

Postgres 8.3 is installed on a windows 2008 server. Ruby 1.8-6 installed. gem install ruby-postgres.

When trying a simple connect I get

ruby.exe - Ordinal Not Found

The ordinal 284 could not be located in the dynamic link library SSLEAY32.dll.

OK

There seems to be some conflict betweeen the ssleay32 shipped with postgres 8.3 and the ruby 1.8-6

I know I could use the gem postgres-pr but I would prefere to use the ruby-postgres because that is what I use on all my other setup even if most of them is running under linux and not windows.

So the question is, Have any one solved this and how?

Answer 1

Any even better solution, in so far as using the latest binaries for OpenSSL, is to rename both libeay32.dll and ssleay32.dll in both the ruby\bin folder and also the posgresql\lib folder and install the latest OpenSSL from http://www.slproweb.com/products/Win32OpenSSL.html, at the time of writing it was "Win32 OpenSSL v0.9.8j Light" put the dir in the path and away you go, it worked for me! You get the warm feeling of using the most up to date and secure OpenSSL libraries.