Re: Trying to install DBD::Pg on Windows XP

Lamprecht <[email protected]> Mon, 18 May 2009 22:49:28 +0200

Newsgroups	gmane.comp.db.postgresql.dbdpg
Message-ID	<[email protected]>

Greg Sabino Mullane wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: RIPEMD160
> 
> 
>> The directions in the README got me a DBD::Pg that could not connect to
>> a database at all... (the tests should not pass if it does that!)
> 
> Yes, those directions are outdated and need to be updated. So feel free
> to submit a patch! We have very few people on the list running Windows,
> thus it doesn't get as much attention as the *nix side of things.
> 

Hi,

these instructions still work perfect. To be sureI just built DBD::Pg with 
strawberry 5.10.4 following Mark Dootsons recipe:

> Makefile.PL -
> add 'use DBI::DBD;'.
> comment out "unlink $output->{MAKEFILE};" at line 247
> 
> set required environment:
> 
> set PATH=C:\PROGRA~1\PostgreSQL\8.3\bin;%PATH%
> set DBI_DSN=dbi:Pg:dbname=testdb
> set DBI_USER=username
> set DBI_PASS=password
> set POSTGRES_HOME=C:/PROGRA~1/PostgreSQL/8.3
> set POSTGRES_INCLUDE=C:/PROGRA~1/PostgreSQL/8.3/include
> set POSTGRES_LIB=C:/PROGRA~1/PostgreSQL/8.3/lib
> 
> 
> perl Makefile.PL
> 
> Now here's the ugly bit: edited both EXTRALIBS and LDLOADLIBS in the resulting Makefile to include 
> C:\PROGRA~1\PostgreSQL\8.3\lib\libpq.lib
> 
> then
> 
> dmake
> dmake test
> 
> all works fine.

(See attached file)
I had an error related to File::Temp and one failing test in connect.t which 
might be related to my local configuration - I didn't examine further.

Regards, Christoph

MakeDBDPg.txt (text/plain, 8.4 KB)

C:\Dokumente und Einstellungen\perl5105\Desktop\DBD-Pg-2.13.1>dmake
gcc -c  -I"C:/Programme/PostgreSQL/8.3/include" -IC:\strawberry\perl\site\lib\au
to\DBI  -s -O2 -DWIN32 -DHAVE_DES_FCRYPT  -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICI
T_SYS -fno-strict-aliasing -DPERL_MSVCRT_READFIX -DPGLIBVERSION=80306 -DPGDEFPOR
T=5432 -s -O2     -DVERSION=\"2.13.1\"  -DXS_VERSION=\"2.13.1\"  "-IC:\strawberr
y\perl\lib\CORE"   Pg.c
In file included from C:/strawberry/perl/lib/CORE/win32thread.h:4,
                 from C:/strawberry/perl/lib/CORE/perl.h:2748,
                 from C:/strawberry/perl/site/lib/auto/DBI/DBIXS.h:19,
                 from Pg.h:57,
                 from Pg.xs:14:
C:/strawberry/perl/lib/CORE/win32.h:238:1: warning: "isnan" redefined
In file included from Pg.h:13,
                 from Pg.xs:14:
C:/strawberry/c/bin/../lib/gcc/mingw32/3.4.5/../../../../include/math.h:380:1: w
arning: this is the location of the previous definition
gcc -c  -I"C:/Programme/PostgreSQL/8.3/include" -IC:\strawberry\perl\site\lib\au
to\DBI  -s -O2 -DWIN32 -DHAVE_DES_FCRYPT  -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICI
T_SYS -fno-strict-aliasing -DPERL_MSVCRT_READFIX -DPGLIBVERSION=80306 -DPGDEFPOR
T=5432 -s -O2     -DVERSION=\"2.13.1\"  -DXS_VERSION=\"2.13.1\"  "-IC:\strawberr
y\perl\lib\CORE"   dbdimp.c
In file included from C:/strawberry/perl/lib/CORE/win32thread.h:4,
                 from C:/strawberry/perl/lib/CORE/perl.h:2748,
                 from C:/strawberry/perl/site/lib/auto/DBI/DBIXS.h:19,
                 from Pg.h:57,
                 from dbdimp.c:16:
C:/strawberry/perl/lib/CORE/win32.h:238:1: warning: "isnan" redefined
In file included from Pg.h:13,
                 from dbdimp.c:16:
C:/strawberry/c/bin/../lib/gcc/mingw32/3.4.5/../../../../include/math.h:380:1: w
arning: this is the location of the previous definition
gcc -c  -I"C:/Programme/PostgreSQL/8.3/include" -IC:\strawberry\perl\site\lib\au
to\DBI  -s -O2 -DWIN32 -DHAVE_DES_FCRYPT  -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICI
T_SYS -fno-strict-aliasing -DPERL_MSVCRT_READFIX -DPGLIBVERSION=80306 -DPGDEFPOR
T=5432 -s -O2     -DVERSION=\"2.13.1\"  -DXS_VERSION=\"2.13.1\"  "-IC:\strawberr
y\perl\lib\CORE"   quote.c
In file included from C:/strawberry/perl/lib/CORE/win32thread.h:4,
                 from C:/strawberry/perl/lib/CORE/perl.h:2748,
                 from C:/strawberry/perl/site/lib/auto/DBI/DBIXS.h:19,
                 from Pg.h:57,
                 from quote.c:12:
C:/strawberry/perl/lib/CORE/win32.h:238:1: warning: "isnan" redefined
In file included from Pg.h:13,
                 from quote.c:12:
C:/strawberry/c/bin/../lib/gcc/mingw32/3.4.5/../../../../include/math.h:380:1: w
arning: this is the location of the previous definition
gcc -c  -I"C:/Programme/PostgreSQL/8.3/include" -IC:\strawberry\perl\site\lib\au
to\DBI  -s -O2 -DWIN32 -DHAVE_DES_FCRYPT  -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICI
T_SYS -fno-strict-aliasing -DPERL_MSVCRT_READFIX -DPGLIBVERSION=80306 -DPGDEFPOR
T=5432 -s -O2     -DVERSION=\"2.13.1\"  -DXS_VERSION=\"2.13.1\"  "-IC:\strawberr
y\perl\lib\CORE"   types.c
In file included from C:/strawberry/perl/lib/CORE/win32thread.h:4,
                 from C:/strawberry/perl/lib/CORE/perl.h:2748,
                 from C:/strawberry/perl/site/lib/auto/DBI/DBIXS.h:19,
                 from Pg.h:57,
                 from types.c:17:
C:/strawberry/perl/lib/CORE/win32.h:238:1: warning: "isnan" redefined
In file included from Pg.h:13,
                 from types.c:17:
C:/strawberry/c/bin/../lib/gcc/mingw32/3.4.5/../../../../include/math.h:380:1: w
arning: this is the location of the previous definition
Running Mkbootstrap for DBD::Pg ()
C:\strawberry\perl\bin\perl.exe -MExtUtils::Command -e chmod 644 Pg.bs
dlltool --def Pg.def --output-exp dll.exp
g++ -o blib\arch\auto\DBD\Pg\Pg.dll -Wl,--base-file -Wl,dll.base -mdll -s -L"C:\
strawberry\perl\lib\CORE" -L"C:\strawberry\c\lib" Pg.o dbdimp.o quote.o types.o
-Wl,--image-base,0x3c0b0000  C:\strawberry\perl\lib\CORE\libperl510.a C:\strawbe
rry\c\lib\libm.a C:\strawberry\c\lib\libsecur32.a C:\strawberry\c\lib\libmsvcrt.
a C:\strawberry\c\lib\libmoldname.a C:\strawberry\c\lib\libkernel32.a C:\strawbe
rry\c\lib\libuser32.a C:\strawberry\c\lib\libgdi32.a C:\strawberry\c\lib\libwins
pool.a C:\strawberry\c\lib\libcomdlg32.a C:\strawberry\c\lib\libadvapi32.a C:\st
rawberry\c\lib\libshell32.a C:\strawberry\c\lib\libole32.a C:\strawberry\c\lib\l
iboleaut32.a C:\strawberry\c\lib\libnetapi32.a C:\strawberry\c\lib\libuuid.a C:\
strawberry\c\lib\libws2_32.a C:\strawberry\c\lib\libmpr.a C:\strawberry\c\lib\li
bwinmm.a C:\strawberry\c\lib\libversion.a C:\strawberry\c\lib\libodbc32.a C:\str
awberry\c\lib\libodbccp32.a C:\Programme\PostgreSQL\8.3\lib\libpq.lib dll.exp
dlltool --def Pg.def --base-file dll.base --output-exp dll.exp
g++ -o blib\arch\auto\DBD\Pg\Pg.dll -mdll -s -L"C:\strawberry\perl\lib\CORE" -L"
C:\strawberry\c\lib" Pg.o dbdimp.o quote.o types.o -Wl,--image-base,0x3c0b0000
C:\strawberry\perl\lib\CORE\libperl510.a C:\strawberry\c\lib\libm.a C:\strawberr
y\c\lib\libsecur32.a C:\strawberry\c\lib\libmsvcrt.a C:\strawberry\c\lib\libmold
name.a C:\strawberry\c\lib\libkernel32.a C:\strawberry\c\lib\libuser32.a C:\stra
wberry\c\lib\libgdi32.a C:\strawberry\c\lib\libwinspool.a C:\strawberry\c\lib\li
bcomdlg32.a C:\strawberry\c\lib\libadvapi32.a C:\strawberry\c\lib\libshell32.a C
:\strawberry\c\lib\libole32.a C:\strawberry\c\lib\liboleaut32.a C:\strawberry\c\
lib\libnetapi32.a C:\strawberry\c\lib\libuuid.a C:\strawberry\c\lib\libws2_32.a
C:\strawberry\c\lib\libmpr.a C:\strawberry\c\lib\libwinmm.a C:\strawberry\c\lib\
libversion.a C:\strawberry\c\lib\libodbc32.a C:\strawberry\c\lib\libodbccp32.a C
:\Programme\PostgreSQL\8.3\lib\libpq.lib dll.exp
C:\strawberry\perl\bin\perl.exe -MExtUtils::Command -e chmod 755 blib\arch\auto\
DBD\Pg\Pg.dll
C:\strawberry\perl\bin\perl.exe -MExtUtils::Command -e cp Pg.bs blib\arch\auto\D
BD\Pg\Pg.bs
C:\strawberry\perl\bin\perl.exe -MExtUtils::Command -e chmod 644 blib\arch\auto\
DBD\Pg\Pg.bs

C:\Dokumente und Einstellungen\perl5105\Desktop\DBD-Pg-2.13.1>dmake test
C:\strawberry\perl\bin\perl.exe "-MExtUtils::Command::MM" "-e" "test_harness(0,
'blib\lib', 'blib\arch')" t/*.t
t/00-signature......skipped: Set the environment variable TEST_SIGNATURE to enab
le this test
t/00basic...........ok
t/01connect.........4/13
#   Failed test 'Connect with invalid option fails'
#   at t/01connect.t line 76.
#                   ''
#     doesn't match '(?-xism:DBI connect.+failed:)'
t/01connect.........12/13 #
# DBI                         Version 1.607
# DBD::Pg                     Version 2.13.1
# Perl                        Version 5.10.0
# OS                          MSWin32
# PostgreSQL (compiled)       80306
# PostgreSQL (target)         80306
# PostgreSQL (reported)       PostgreSQL 8.3.6, compiled by Visual C++ build 140
0
# Default port                5432
# DBI_DSN                     dbi:Pg:db="testdb"
# DBI_USER                    postgres
# Test schema                 dbd_pg_testschema
# array_nulls                 on
# backslash_quote             safe_encoding
# client_encoding             UTF8
# server_encoding             UTF8
# standard_conforming_strings off
# Looks like you failed 1 test of 13.
t/01connect......... Dubious, test returned 1 (wstat 256, 0x100)
 Failed 1/13 subtests
t/01constants.......ok
t/02attribs.........ok
t/03dbmethod........ok
t/03smethod.........ok
t/04misc............43/54 Error removing dbdpg_test_Pum0ehtst at C:/STRAWB~3/per
l/lib/File/Temp.pm line 890.
t/04misc............ok
t/06bytea...........ok
t/07copy............ok
t/08async...........ok
t/09arrays..........ok
t/12placeholders....ok
t/20savepoints......ok
t/99_perlcritic.....skipped: Set the environment variable TEST_CRITIC to enable
this test
t/99_pod............skipped: Set the environment variable TEST_AUTHOR to enable
this test
t/99_spellcheck.....skipped: Set the environment variable TEST_SPELL to enable t
his test
t/99_yaml...........ok
t/99cleanup.........1/1 Removing test database directory
t/99cleanup.........ok

Test Summary Report
-------------------
t/01connect     (Wstat: 256 Tests: 13 Failed: 1)
  Failed test:  9
  Non-zero exit status: 1
Files=19, Tests=1500, 60 wallclock secs ( 1.00 usr +  0.09 sys =  1.09 CPU)
Result: FAIL
Failed 1/19 test programs. 1/1500 subtests failed.
dmake:  Error code 255, while making 'test_dynamic'

C:\Dokumente und Einstellungen\perl5105\Desktop\DBD-Pg-2.13.1>