Re: contrib check fail at pgcrypto on Windows Server 2008 64bit 9.0dev (HEAD near alpha5)

On Mon, Apr 5, 2010 at 07:16, TAKATSUKA Haruka <harukat(at)sraoss(dot)co(dot)jp> wrote:
> Hi, all.
>
> I built pgsql with following regulation (for buildfarm new entry).
>  - Windows Server 2008 64bit
>  - VC2005
>  - 9.0dev (HEAD near alpha5) 64bit
>
> And I got a fail at "vcregress contribcheck" about only pgcrypto.
> All CREATE FUNCTION of pgcrypto got ERROR.
> (It passed "vcregress check")
>
> STATEMENT:  CREATE OR REPLACE FUNCTION decrypt_iv(bytea, bytea, bytea, text)
>        RETURNS bytea
>        AS '$libdir/pgcrypto', 'pg_decrypt_iv'
>        LANGUAGE C IMMUTABLE STRICT;
> ERROR:  could not load library "C:/Users/Administrator/mhome/pgsql-inst/lib/pgcrypto.dll": The specified module could not be found.
>
> I tried LOAD command following:
>
> test=# LOAD 'sslinfo.dll';
> LOAD
> test=# LOAD 'pgcrypto.dll';
> ERROR:  could not load library "C:/Users/Administrator/mhome/pgsql-inst/lib/pgcrypto.dll": The specified module could not be found.
>
> I traced it with VC2005 debugger.
> API "LoadLibrary" was called (and return NULL).
> DLL's "DllMain" was not called in case of "pgcrypto.dll".
>
>
> Is there any idea ?

What do you get if you run "depends" on pgcrypto.dll?

Due to "smart linking" or whatever they call it, it may be that
sslinfo is only pulling in one of the two OpenSSL DLL files, and the
other one is fialing pehaps?

I assume you've tried this on a clean sourcetree so it's not just some
weird leftover or mismaatch between 32 and 64-bit?

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/