Hi,
Environment:
- latest available 64 bit cyqwin environment on win7 64 bit environment
- latest available postgres (9.6.1)
I wanted to install perl modules to access
I tried it using msys2 and cygwin using 64 bit setup. I have failed. Under
msys2 I have failed with conflicting sets of <sys/ ...> include files
Cygwin is my primary Unix like environment, so we can focus on this only
I have added
*PATH="/cygdrive/c/Program Files/PostgreSQL/9.6/bin:$PATH"*
to reach pg_config
Since in my environment pg_config.exe running in windows environment I got
directory not found errors. The first problem was the script does not
remove \r from answer of pg_config.
I tried too approaches refined step by steps, my final one
*export POSTGRES_INCLUDE='/cygdrive/c/Progra~1/PostgreSQL/9.6/include'*
*export POSTGRES_LIB='/cygdrive/c/Progra~1/PostgreSQL/9.6/lib'*
to overcome scripting error related to space in path
This way finally the library is compiled successfully, however all test
were failed with a strange error - maybe pure cygwin problem
c*pan install Bundle::DBD::Pg > xxx.txt 2>&1*
I have attached the xxx.txt file form above command to show the details.
Any advice?
Thanks for your support in advance:
Gyula
Loading internal null logger. Install Log::Log4perl for logging messages
CPAN: Storable loaded ok (v2.53_01)
Reading '/home/Gyula/.cpan/Metadata'
Database was generated on Mon, 05 Dec 2016 07:41:02 GMT
CPAN: Module::CoreList loaded ok (v5.20160429)
DBI is up to date (1.636).
Running install for module 'DBD::Pg'
CPAN: Digest::SHA loaded ok (v5.95)
CPAN: Compress::Zlib loaded ok (v2.068)
Checksum for
/home/Gyula/.cpan/sources/authors/id/T/TU/TURNSTEP/DBD-Pg-3.5.3.tar.gz ok
CPAN: File::Temp loaded ok (v0.2304)
CPAN: YAML loaded ok (v1.18)
CPAN: CPAN::Meta::Requirements loaded ok (v2.140)
CPAN: Parse::CPAN::Meta loaded ok (v2.150010)
CPAN: CPAN::Meta loaded ok (v2.150010)
Configuring T/TU/TURNSTEP/DBD-Pg-3.5.3.tar.gz with Makefile.PL
Configuring DBD::Pg 3.5.3
PostgreSQL version: 90601 (default port: 5432)
POSTGRES_HOME: (not set)
POSTGRES_INCLUDE: /cygdrive/c/Progra~1/PostgreSQL/9.6/include
POSTGRES_LIB: /cygdrive/c/Progra~1/PostgreSQL/9.6/lib
OS: cygwin
Checking if your kit is complete...
Looks good
Using DBI 1.636 (for perl 5.022002 on cygwin-thread-multi) installed in
/usr/lib/perl5/vendor_perl/5.22/x86_64-cygwin-threads/auto/DBI/
Generating a Unix-style Makefile
Writing Makefile for DBD::Pg
Writing MYMETA.yml and MYMETA.json
TURNSTEP/DBD-Pg-3.5.3.tar.gz
/usr/bin/perl Makefile.PL -- OK
Running make for T/TU/TURNSTEP/DBD-Pg-3.5.3.tar.gz
cp Pg.pm blib/lib/DBD/Pg.pm
cp lib/Bundle/DBD/Pg.pm blib/lib/Bundle/DBD/Pg.pm
Running Mkbootstrap for DBD::Pg ()
chmod 644 "Pg.bs"
"/usr/bin/perl.exe" -p -e "s/~DRIVER~/Pg/g; s/^do\(/dontdo\(/"
/usr/lib/perl5/vendor_perl/5.22/x86_64-cygwin-threads/auto/DBI/Driver.xst >
Pg.xsi
"/usr/bin/perl.exe" "/usr/lib/perl5/5.22/ExtUtils/xsubpp" -typemap
"/usr/lib/perl5/5.22/ExtUtils/typemap" Pg.xs > Pg.xsc && mv Pg.xsc Pg.c
gcc -c -I/cygdrive/c/Progra~1/PostgreSQL/9.6/include
-I/usr/lib/perl5/vendor_perl/5.22/x86_64-cygwin-threads/auto/DBI
-DPERL_USE_SAFE_PUTENV -D_GNU_SOURCE -U__STRICT_ANSI__ -ggdb -O2 -pipe
-Wimplicit-function-declaration
-fdebug-prefix-map=/mnt/share/maint/perl.x86_64/build=/usr/src/debug/perl-5.22.2-1
-fdebug-prefix-map=/mnt/share/maint/perl.x86_64/src/perl-5.22.2=/usr/src/debug/perl-5.22.2-1
-fwrapv -fno-strict-aliasing -fstack-protector-strong -D_FORTIFY_SOURCE=2
-DPGLIBVERSION=90601 -DPGDEFPORT=5432 -DUSEIMPORTLIB -O3 -DVERSION=\"3.5.3\"
-DXS_VERSION=\"3.5.3\" "-I/usr/lib/perl5/5.22/x86_64-cygwin-threads/CORE"
Pg.c
gcc -c -I/cygdrive/c/Progra~1/PostgreSQL/9.6/include
-I/usr/lib/perl5/vendor_perl/5.22/x86_64-cygwin-threads/auto/DBI
-DPERL_USE_SAFE_PUTENV -D_GNU_SOURCE -U__STRICT_ANSI__ -ggdb -O2 -pipe
-Wimplicit-function-declaration
-fdebug-prefix-map=/mnt/share/maint/perl.x86_64/build=/usr/src/debug/perl-5.22.2-1
-fdebug-prefix-map=/mnt/share/maint/perl.x86_64/src/perl-5.22.2=/usr/src/debug/perl-5.22.2-1
-fwrapv -fno-strict-aliasing -fstack-protector-strong -D_FORTIFY_SOURCE=2
-DPGLIBVERSION=90601 -DPGDEFPORT=5432 -DUSEIMPORTLIB -O3 -DVERSION=\"3.5.3\"
-DXS_VERSION=\"3.5.3\" "-I/usr/lib/perl5/5.22/x86_64-cygwin-threads/CORE"
dbdimp.c
dbdimp.c: In function ‘pg_db_login6’:
dbdimp.c:242:31: warning: implicit declaration of function ‘getpid’
[-Wimplicit-function-declaration]
imp_dbh->pid_number = getpid();
^
gcc -c -I/cygdrive/c/Progra~1/PostgreSQL/9.6/include
-I/usr/lib/perl5/vendor_perl/5.22/x86_64-cygwin-threads/auto/DBI
-DPERL_USE_SAFE_PUTENV -D_GNU_SOURCE -U__STRICT_ANSI__ -ggdb -O2 -pipe
-Wimplicit-function-declaration
-fdebug-prefix-map=/mnt/share/maint/perl.x86_64/build=/usr/src/debug/perl-5.22.2-1
-fdebug-prefix-map=/mnt/share/maint/perl.x86_64/src/perl-5.22.2=/usr/src/debug/perl-5.22.2-1
-fwrapv -fno-strict-aliasing -fstack-protector-strong -D_FORTIFY_SOURCE=2
-DPGLIBVERSION=90601 -DPGDEFPORT=5432 -DUSEIMPORTLIB -O3 -DVERSION=\"3.5.3\"
-DXS_VERSION=\"3.5.3\" "-I/usr/lib/perl5/5.22/x86_64-cygwin-threads/CORE"
quote.c
gcc -c -I/cygdrive/c/Progra~1/PostgreSQL/9.6/include
-I/usr/lib/perl5/vendor_perl/5.22/x86_64-cygwin-threads/auto/DBI
-DPERL_USE_SAFE_PUTENV -D_GNU_SOURCE -U__STRICT_ANSI__ -ggdb -O2 -pipe
-Wimplicit-function-declaration
-fdebug-prefix-map=/mnt/share/maint/perl.x86_64/build=/usr/src/debug/perl-5.22.2-1
-fdebug-prefix-map=/mnt/share/maint/perl.x86_64/src/perl-5.22.2=/usr/src/debug/perl-5.22.2-1
-fwrapv -fno-strict-aliasing -fstack-protector-strong -D_FORTIFY_SOURCE=2
-DPGLIBVERSION=90601 -DPGDEFPORT=5432 -DUSEIMPORTLIB -O3 -DVERSION=\"3.5.3\"
-DXS_VERSION=\"3.5.3\" "-I/usr/lib/perl5/5.22/x86_64-cygwin-threads/CORE"
types.c
rm -f blib/arch/auto/DBD/Pg/Pg.dll
LD_RUN_PATH="/cygdrive/c/Progra~1/PostgreSQL/9.6/lib" g++ --shared
-Wl,--enable-auto-import -Wl,--export-all-symbols -Wl,--enable-auto-image-base
-fstack-protector-strong Pg.o dbdimp.o quote.o types.o -o
blib/arch/auto/DBD/Pg/Pg.dll \
/usr/lib/perl5/5.22/x86_64-cygwin-threads/CORE/cygperl5_22.dll
-L/cygdrive/c/Progra~1/PostgreSQL/9.6/lib -lpq -lm \
chmod 755 blib/arch/auto/DBD/Pg/Pg.dll
"/usr/bin/perl.exe" -MExtUtils::Command::MM -e 'cp_nonempty' -- Pg.bs
blib/arch/auto/DBD/Pg/Pg.bs 644
Manifying 2 pod documents
TURNSTEP/DBD-Pg-3.5.3.tar.gz
make -- OK
Running make test
Running Mkbootstrap for DBD::Pg ()
chmod 644 "Pg.bs"
PGINITDB="" PERL_DL_NONLAZY=1 "/usr/bin/perl.exe" "-MExtUtils::Command::MM"
"-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_harness(0,
'blib/lib', 'blib/arch')" t/*.t
t/00_signature.t .... skipped: Set the environment variable TEST_SIGNATURE to
enable this test
Cygwin runtime failure: /usr/bin/perl.exe: Invalid relocation. Offset
0xfffffffb71cb4df2 at address 0x48e4a139a doesn't fit into 32 bits
t/00basic.t .........
Dubious, test returned 127 (wstat 32512, 0x7f00)
Failed 2/3 subtests
Cygwin runtime failure: /usr/bin/perl.exe: Invalid relocation. Offset
0xfffffffb71bb4df2 at address 0x48e4a139a doesn't fit into 32 bits
t/01connect.t .......
Dubious, test returned 127 (wstat 32512, 0x7f00)
No subtests run
Cygwin runtime failure: /usr/bin/perl.exe: Invalid relocation. Offset
0xfffffffb71bb4df2 at address 0x48e4a139a doesn't fit into 32 bits
t/01constants.t .....
Dubious, test returned 127 (wstat 32512, 0x7f00)
No subtests run
Cygwin runtime failure: /usr/bin/perl.exe: Invalid relocation. Offset
0xfffffffb71bb4df2 at address 0x48e4a139a doesn't fit into 32 bits
t/02attribs.t .......
Dubious, test returned 127 (wstat 32512, 0x7f00)
No subtests run
Cygwin runtime failure: /usr/bin/perl.exe: Invalid relocation. Offset
0xfffffffb71bb4df2 at address 0x48e4a139a doesn't fit into 32 bits
t/03dbmethod.t ......
Dubious, test returned 127 (wstat 32512, 0x7f00)
No subtests run
Cygwin runtime failure: /usr/bin/perl.exe: Invalid relocation. Offset
0xfffffffb71bb4df2 at address 0x48e4a139a doesn't fit into 32 bits
t/03smethod.t .......
Dubious, test returned 127 (wstat 32512, 0x7f00)
No subtests run
Cygwin runtime failure: /usr/bin/perl.exe: Invalid relocation. Offset
0xfffffffb71cb4df2 at address 0x48e4a139a doesn't fit into 32 bits
t/04misc.t ..........
Dubious, test returned 127 (wstat 32512, 0x7f00)
No subtests run
Cygwin runtime failure: /usr/bin/perl.exe: Invalid relocation. Offset
0xfffffffb71cb4df2 at address 0x48e4a139a doesn't fit into 32 bits
t/06bytea.t .........
Dubious, test returned 127 (wstat 32512, 0x7f00)
No subtests run
Cygwin runtime failure: /usr/bin/perl.exe: Invalid relocation. Offset
0xfffffffb71cb4df2 at address 0x48e4a139a doesn't fit into 32 bits
t/07copy.t ..........
Dubious, test returned 127 (wstat 32512, 0x7f00)
No subtests run
Cygwin runtime failure: /usr/bin/perl.exe: Invalid relocation. Offset
0xfffffffb71ce4df2 at address 0x48e4a139a doesn't fit into 32 bits
t/08async.t .........
Dubious, test returned 127 (wstat 32512, 0x7f00)
No subtests run
Cygwin runtime failure: /usr/bin/perl.exe: Invalid relocation. Offset
0xfffffffb71cb4df2 at address 0x48e4a139a doesn't fit into 32 bits
t/09arrays.t ........
Dubious, test returned 127 (wstat 32512, 0x7f00)
No subtests run
Cygwin runtime failure: /usr/bin/perl.exe: Invalid relocation. Offset
0xfffffffb71ce4df2 at address 0x48e4a139a doesn't fit into 32 bits
t/12placeholders.t ..
Dubious, test returned 127 (wstat 32512, 0x7f00)
No subtests run
Cygwin runtime failure: /usr/bin/perl.exe: Invalid relocation. Offset
0xfffffffb71bb4df2 at address 0x48e4a139a doesn't fit into 32 bits
t/20savepoints.t ....
Dubious, test returned 127 (wstat 32512, 0x7f00)
No subtests run
Cygwin runtime failure: /usr/bin/perl.exe: Invalid relocation. Offset
0xfffffffb71cb4df2 at address 0x48e4a139a doesn't fit into 32 bits
t/30unicode.t .......
Dubious, test returned 127 (wstat 32512, 0x7f00)
No subtests run
Cygwin runtime failure: /usr/bin/perl.exe: Invalid relocation. Offset
0xfffffffb71bb4df2 at address 0x48e4a139a doesn't fit into 32 bits
t/99cleanup.t .......
Dubious, test returned 127 (wstat 32512, 0x7f00)
Failed 1/1 subtests
Test Summary Report
-------------------
t/00basic.t (Wstat: 32512 Tests: 1 Failed: 0)
Non-zero exit status: 127
Parse errors: Bad plan. You planned 3 tests but ran 1.
t/01connect.t (Wstat: 32512 Tests: 0 Failed: 0)
Non-zero exit status: 127
Parse errors: No plan found in TAP output
t/01constants.t (Wstat: 32512 Tests: 0 Failed: 0)
Non-zero exit status: 127
Parse errors: No plan found in TAP output
t/02attribs.t (Wstat: 32512 Tests: 0 Failed: 0)
Non-zero exit status: 127
Parse errors: No plan found in TAP output
t/03dbmethod.t (Wstat: 32512 Tests: 0 Failed: 0)
Non-zero exit status: 127
Parse errors: No plan found in TAP output
t/03smethod.t (Wstat: 32512 Tests: 0 Failed: 0)
Non-zero exit status: 127
Parse errors: No plan found in TAP output
t/04misc.t (Wstat: 32512 Tests: 0 Failed: 0)
Non-zero exit status: 127
Parse errors: No plan found in TAP output
t/06bytea.t (Wstat: 32512 Tests: 0 Failed: 0)
Non-zero exit status: 127
Parse errors: No plan found in TAP output
t/07copy.t (Wstat: 32512 Tests: 0 Failed: 0)
Non-zero exit status: 127
Parse errors: No plan found in TAP output
t/08async.t (Wstat: 32512 Tests: 0 Failed: 0)
Non-zero exit status: 127
Parse errors: No plan found in TAP output
t/09arrays.t (Wstat: 32512 Tests: 0 Failed: 0)
Non-zero exit status: 127
Parse errors: No plan found in TAP output
t/12placeholders.t (Wstat: 32512 Tests: 0 Failed: 0)
Non-zero exit status: 127
Parse errors: No plan found in TAP output
t/20savepoints.t (Wstat: 32512 Tests: 0 Failed: 0)
Non-zero exit status: 127
Parse errors: No plan found in TAP output
t/30unicode.t (Wstat: 32512 Tests: 0 Failed: 0)
Non-zero exit status: 127
Parse errors: No plan found in TAP output
t/99cleanup.t (Wstat: 32512 Tests: 0 Failed: 0)
Non-zero exit status: 127
Parse errors: Bad plan. You planned 1 tests but ran 0.
Files=16, Tests=1, 2 wallclock secs ( 0.09 usr 0.06 sys + 0.04 cusr 0.17
csys = 0.36 CPU)
Result: FAIL
Failed 15/16 test programs. 0/1 subtests failed.
make: *** [Makefile:966: test_dynamic] Error 127
TURNSTEP/DBD-Pg-3.5.3.tar.gz
make test -- NOT OK
//hint// to see the cpan-testers results for installing this module, try:
reports TURNSTEP/DBD-Pg-3.5.3.tar.gz
