From: Magnus Hagander on
On Mon, Apr 5, 2010 at 07:16, TAKATSUKA Haruka <harukat(a)sraoss.co.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/

--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

From: TAKATSUKA Haruka on
Magnus, Thanks your help.

When I set 64bit version of zlib1.dll, msvcr80.dll and msvcr90.dll into
Windows\system32 directory correctiry, it run well.
(Perhaps I did copy with MSYS's "cp command that does not work on
system directory.)


On Mon, 5 Apr 2010 11:44:53 +0200
Magnus Hagander <magnus(a)hagander.net> wrote:

> On Mon, Apr 5, 2010 at 07:16, TAKATSUKA Haruka <harukat(a)sraoss.co.jp> wrote:
> > 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.
(snip)
> > 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?

______________________________________________________________________
TAKATSUKA Haruka <harukat(a)sraoss.co.jp>
SRA OSS, Inc. Japan http://www.sraoss.co.jp/index_en.php



--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers