BUG #5248: Cannot find SSLEAY32.dll problem.

The following bug has been logged online:

Bug reference: 5248
Logged by: Vincent Pinto
Email address: vincent_pinto(at)mentor(dot)com
PostgreSQL version: 8.3.1.876
Operating system: Windows XP SP3
Description: Cannot find SSLEAY32.dll problem.
Details:

We have an application that installs postgres. But during the install,
while it tries to start the database, and error "This application failed to
start because SSLEAY32.dll was not found. Re-installing the application may
fix this problem." pops up.

I have been able to install and use the application on an earlier laptop
(Dell D620), but I have a new one now (M4400). This is the only thing that
is different. I suspect some of the Microsoft patches, etc may not be
present. Is this needed?

I tried reinstalling but that does not help. I also noticed on my earlier
laptop that ssleay32.dll is not in the windows/system32 dir (many folks on
various forums suggest to do so, but I did not do it because the db starts
on the earlier machine, so why should it not start on the newer on?)

Any help is appreciated. Thanks.

On 17/12/2009 6:10 PM, Vincent Pinto wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5248
> Logged by: Vincent Pinto
> Email address: vincent_pinto(at)mentor(dot)com
> PostgreSQL version: 8.3.1.876
> Operating system: Windows XP SP3
> Description: Cannot find SSLEAY32.dll problem.
> Details:
>
> We have an application that installs postgres.

How? Using the OneClick installer's silent/scripted install? From the
zip files? If the latter, how and where?

> But during the install,
> while it tries to start the database, and error "This application failed to
> start because SSLEAY32.dll was not found. Re-installing the application may
> fix this problem." pops up.

SSLEAY32.DLL should be part of the PostgreSQL install and in the same
directory as the PostgreSQL binaries. Is it not?

> I tried reinstalling but that does not help. I also noticed on my earlier
> laptop that ssleay32.dll is not in the windows/system32 dir (many folks on
> various forums suggest to do so, but I did not do it because the db starts
> on the earlier machine, so why should it not start on the newer on?)

No, do *not* mess with WINDOWS\SYSTEM32 . People who tell you to install
random libraries there are almost certainly wrong, and are parroting
advice that used to apply back in the Windows 95/98 days before Windows
preferentially loaded libraries from the same directory as the application.

--
Craig Ringer

Thanks for your response. Please see inline...

-----Original Message-----
From: Craig Ringer [mailto:craig(at)postnewspapers(dot)com(dot)au]
Sent: Friday, December 18, 2009 7:30 AM
To: Pinto, Vincent
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #5248: Cannot find SSLEAY32.dll problem.

On 17/12/2009 6:10 PM, Vincent Pinto wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5248
> Logged by: Vincent Pinto
> Email address: vincent_pinto(at)mentor(dot)com
> PostgreSQL version: 8.3.1.876
> Operating system: Windows XP SP3
> Description: Cannot find SSLEAY32.dll problem.
> Details:
>
> We have an application that installs postgres.

How? Using the OneClick installer's silent/scripted install? From the
zip files? If the latter, how and where?

<vpinto> Our application installation starts by the user double-clicking
install.exe (It is simply a 320MB install.exe, which contains all the
stuff; the db, the application files, the help files, etc). It then
installs various application files, and somewhere in this flow, I
suspect a scripted install happens of the postgres db. Once that is
done, I an attempt is made to start the database, all as part of the
script. When the db has started, some default data is loaded, so that
the user begins using the application with the data. When the db is
attempted to be started, we get the error.

> But during the install,
> while it tries to start the database, and error "This application
> failed to start because SSLEAY32.dll was not found. Re-installing the
> application may fix this problem." pops up.

SSLEAY32.DLL should be part of the PostgreSQL install and in the same
directory as the PostgreSQL binaries. Is it not?

<vpinto> Yes it is. That is what is very confusing.

> I tried reinstalling but that does not help. I also noticed on my
> earlier laptop that ssleay32.dll is not in the windows/system32 dir
> (many folks on various forums suggest to do so, but I did not do it
> because the db starts on the earlier machine, so why should it not
> start on the newer on?)

No, do *not* mess with WINDOWS\SYSTEM32 . People who tell you to install
random libraries there are almost certainly wrong, and are parroting
advice that used to apply back in the Windows 95/98 days before Windows
preferentially loaded libraries from the same directory as the
application.

<vpinto> Quite correct. I will not.

--
Craig Ringer

On 18/12/2009 11:34 AM, Pinto, Vincent wrote:

> <vpinto> Our application installation starts by the user double-clicking
> install.exe (It is simply a 320MB install.exe, which contains all the
> stuff; the db, the application files, the help files, etc).

Yes, but is the copy of PostgreSQL included as an embedded copy of the
one-click installer run via silent install, or is it just the PostgreSQL
program (etc) files that get installed directly by your own installer?

Look inside your installer package. Do you see a postgresql installer
exe? Or do you see "postgres.exe", "psql.exe", etc? If the latter, where
did they come from?

I'm beginning to wonder if somebody installed PostgreSQL from the
one-click installer, then just took a copy of C:\Program
Files\PostgreSQL and bundled it up in the installer.

> It then
> installs various application files, and somewhere in this flow, I
> suspect a scripted install happens of the postgres db.

You *suspect*?

Have a look at the sources for your installer, and find out. If you
can't, you need to get in touch with somebody who actually has control
over your installer package and get their help tracking down this issue
- you cannot usefully do it yourself if you do not know exactly how your
installer works.

> <vpinto> Yes it is. That is what is very confusing.

Are you _sure_ it's there at the time you first try to run PostgreSQL,
though?

Is it possible ssleay32.dll is copied in there _after_ the attempt to
start PostgreSQL is made?

--
Craig Ringer

On Fri, Dec 18, 2009 at 1:59 AM, Craig Ringer
<craig(at)postnewspapers(dot)com(dot)au> wrote:
> On 17/12/2009 6:10 PM, Vincent Pinto wrote:
>>
>> The following bug has been logged online:
>>
>> Bug reference:      5248
>> Logged by:          Vincent Pinto
>> Email address:      vincent_pinto(at)mentor(dot)com
>> PostgreSQL version: 8.3.1.876
>> Operating system:   Windows XP SP3
>> Description:        Cannot find SSLEAY32.dll problem.
>> Details:
>>
>> We have an application that installs postgres.
>
> How? Using the OneClick installer's silent/scripted install? From the zip
> files? If the latter, how and where?

There wasn't a one-click version of 8.3.1.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

On 18/12/2009 4:00 PM, Dave Page wrote:
> On Fri, Dec 18, 2009 at 1:59 AM, Craig Ringer
> <craig(at)postnewspapers(dot)com(dot)au> wrote:
>> On 17/12/2009 6:10 PM, Vincent Pinto wrote:
>>>
>>> The following bug has been logged online:
>>>
>>> Bug reference: 5248
>>> Logged by: Vincent Pinto
>>> Email address: vincent_pinto(at)mentor(dot)com
>>> PostgreSQL version: 8.3.1.876
>>> Operating system: Windows XP SP3
>>> Description: Cannot find SSLEAY32.dll problem.
>>> Details:
>>>
>>> We have an application that installs postgres.
>>
>> How? Using the OneClick installer's silent/scripted install? From the zip
>> files? If the latter, how and where?
>
> There wasn't a one-click version of 8.3.1.

Ah. Sorry. The MSI installer, then, rather than the EnterpriseDB
one-click installer.

--
Craig Ringer

On Fri, Dec 18, 2009 at 8:01 AM, Craig Ringer
<craig(at)postnewspapers(dot)com(dot)au> wrote:
> On 18/12/2009 4:00 PM, Dave Page wrote:
>>
>> On Fri, Dec 18, 2009 at 1:59 AM, Craig Ringer
>> <craig(at)postnewspapers(dot)com(dot)au>  wrote:
>>>
>>> On 17/12/2009 6:10 PM, Vincent Pinto wrote:
>>>>
>>>> The following bug has been logged online:
>>>>
>>>> Bug reference:      5248
>>>> Logged by:          Vincent Pinto
>>>> Email address:      vincent_pinto(at)mentor(dot)com
>>>> PostgreSQL version: 8.3.1.876
>>>> Operating system:   Windows XP SP3
>>>> Description:        Cannot find SSLEAY32.dll problem.
>>>> Details:
>>>>
>>>> We have an application that installs postgres.
>>>
>>> How? Using the OneClick installer's silent/scripted install? From the zip
>>> files? If the latter, how and where?
>>
>> There wasn't a one-click version of 8.3.1.
>
> Ah. Sorry. The MSI installer, then, rather than the EnterpriseDB one-click
> installer.

I suspect we would have heard by now if that was missing such a
critical library. I'd suggest trying 8.3.9 anyway - we're certainly
not going to be hacking on 8.3.1 any more.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

On 18/12/2009 4:15 PM, Dave Page wrote:
> On Fri, Dec 18, 2009 at 8:01 AM, Craig Ringer
> <craig(at)postnewspapers(dot)com(dot)au> wrote:
>> On 18/12/2009 4:00 PM, Dave Page wrote:
>>>
>>> On Fri, Dec 18, 2009 at 1:59 AM, Craig Ringer
>>> <craig(at)postnewspapers(dot)com(dot)au> wrote:
>>>>
>>>> On 17/12/2009 6:10 PM, Vincent Pinto wrote:
>>>>>
>>>>> The following bug has been logged online:
>>>>>
>>>>> Bug reference: 5248
>>>>> Logged by: Vincent Pinto
>>>>> Email address: vincent_pinto(at)mentor(dot)com
>>>>> PostgreSQL version: 8.3.1.876
>>>>> Operating system: Windows XP SP3
>>>>> Description: Cannot find SSLEAY32.dll problem.
>>>>> Details:
>>>>>
>>>>> We have an application that installs postgres.
>>>>
>>>> How? Using the OneClick installer's silent/scripted install? From the zip
>>>> files? If the latter, how and where?
>>>
>>> There wasn't a one-click version of 8.3.1.
>>
>> Ah. Sorry. The MSI installer, then, rather than the EnterpriseDB one-click
>> installer.
>
> I suspect we would have heard by now if that was missing such a
> critical library. I'd suggest trying 8.3.9 anyway - we're certainly
> not going to be hacking on 8.3.1 any more.

Of course. Personally, I suspect they've taken a copy of the install dir
and missed some bits, are using an incomplete subset of the .zip
package, or (most likely) have a buggy installer.

Rather than suggesting there was anything wrong with the one-click or
MSI installers, I was just trying to determine what it was that they
were using. If they were using the .msi or oneclick installers it
would've eliminated some possibilities about what might be wrong.

--
Craig Ringer

Thanks Dave, Craig,

I'm actually a user of the software which our division writes. More of an-eyes-of-the-customer inhouse. The strange thing is everyone in the division, and even our customers have been able to install the application, and the database is all OK. The starting of the database is installed as a service for automatic start-up on system Start. No one in the division has this problem, and no customer has complained to the customer support folks! I'm flabbergasted. None of the developers are able to figure it out as well.

The only thing different is my earlier laptop was a dell 620, and new one is a dell m4400. What I am wondering is if some for the Microsoft patchs (or other pre-requisite software) were not installed when I got the new laptop, and which might have been needed, and so in the absense, the pg_ctl, etc is not working as expected.

Thanks,
Vincent

________________________________

From: Craig Ringer [mailto:craig(at)postnewspapers(dot)com(dot)au]
Sent: Fri 18/12/2009 1:31 PM
To: Dave Page
Cc: Pinto, Vincent; pgsql-bugs
Subject: Re: [BUGS] BUG #5248: Cannot find SSLEAY32.dll problem.

On 18/12/2009 4:00 PM, Dave Page wrote:
> On Fri, Dec 18, 2009 at 1:59 AM, Craig Ringer
> <craig(at)postnewspapers(dot)com(dot)au> wrote:
>> On 17/12/2009 6:10 PM, Vincent Pinto wrote:
>>>
>>> The following bug has been logged online:
>>>
>>> Bug reference: 5248
>>> Logged by: Vincent Pinto
>>> Email address: vincent_pinto(at)mentor(dot)com
>>> PostgreSQL version: 8.3.1.876
>>> Operating system: Windows XP SP3
>>> Description: Cannot find SSLEAY32.dll problem.
>>> Details:
>>>
>>> We have an application that installs postgres.
>>
>> How? Using the OneClick installer's silent/scripted install? From the zip
>> files? If the latter, how and where?
>
> There wasn't a one-click version of 8.3.1.

Ah. Sorry. The MSI installer, then, rather than the EnterpriseDB
one-click installer.

--
Craig Ringer

On 18/12/2009 4:50 PM, Pinto, Vincent wrote:
> Thanks Dave, Craig,
> I'm actually a user of the software which our division writes. More of
> an-eyes-of-the-customer inhouse. The strange thing is everyone in the
> division, and even our customers have been able to install the
> application, and the database is all OK. The starting of the database is
> installed as a service for automatic start-up on system Start. No one in
> the division has this problem, and no customer has complained to the
> customer support folks! I'm flabbergasted. None of the developers are
> able to figure it out as well.
> The only thing different is my earlier laptop was a dell 620, and new
> one is a dell m4400. What I am wondering is if some for the Microsoft
> patchs (or other pre-requisite software) were not installed when I got
> the new laptop, and which might have been needed, and so in the absense,
> the pg_ctl, etc is not working as expected.

Well, you can receive a "library not found" error when in fact the
library DOES exist, but cannot be loaded because a library it depends on
does not exist or is unusable.

Try looking at ssleay32.dll with depends.exe
(http://dependencywalker.com) and seeing if it there's any sign of a
missing required library.

--
Craig Ringer

On Fri, Dec 18, 2009 at 8:42 AM, Craig Ringer
<craig(at)postnewspapers(dot)com(dot)au> wrote:

> Rather than suggesting there was anything wrong with the one-click or MSI
> installers, I was just trying to determine what it was that they were using.
> If they were using the .msi or oneclick installers it would've eliminated
> some possibilities about what might be wrong.

Yeah, I realise that. I guess my response was a little curt which was
unintended. In my defence, I hadn't had coffee then :-)

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

On Fri, Dec 18, 2009 at 9:11 AM, Craig Ringer
<craig(at)postnewspapers(dot)com(dot)au> wrote:
> On 18/12/2009 4:50 PM, Pinto, Vincent wrote:
>> The only thing different is my earlier laptop was a dell 620, and new
>> one is a dell m4400. What I am wondering is if some for the Microsoft
>> patchs (or other pre-requisite software) were not installed when I got
>> the new laptop, and which might have been needed, and so in the absense,
>> the pg_ctl, etc is not working as expected.

If it were a Microsoft runtime that were missing, I'd expect to see a
slightly different error, such as "This application has failed to
start because the application configuration is incorrect." In that
case, there should also be more info in the event log.

> Well, you can receive a "library not found" error when in fact the library
> DOES exist, but cannot be loaded because a library it depends on does not
> exist or is unusable.
>
> Try looking at ssleay32.dll with depends.exe (http://dependencywalker.com)
> and seeing if it there's any sign of a missing required library.

That would be my suggestion. Actually, I'd throw libpq.dll at depends
and check from there down. There are one or two Microsoft libraries
that are sometimes missing and don't matter - let us know what it
complains about and we can comment.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com