'cpan DBD::Pg' install fails


Problems? Is your data what you think it is?
	PerlMonks

'cpan DBD::Pg' install fails

by perlygapes (Sexton)

on Feb 10, 2020 at 03:43 UTC ( [id://11112712]=perlquestion: print w/replies, xml )

Need Help??

perlygapes has asked for the wisdom of the Perl Monks concerning the following question:

Monastic Greetings

StackOverflow Ticket	https://stackoverflow.com/questions/60133484/perl-cpan-module-install-fails-dbdpg-postgresql-driver-on-windows7-64-bit-s
CPAN Ticket	https://rt.cpan.org/Public/Bug/Display.html?id=131708
Github Ticket (orig.)	https://github.com/metacpan/metacpan-web/issues/2266

I have been unable to install the updated version 3.10.4 of DBD::Pg using either:
C:\>cpan DBD::Pg
cpan>install DBD::Pg

I followed the README instructions for Strawberry Perl regarding setting Windows ENVVARS for PostgreSQL and exporting DLL symbols from 'libpq.dll', but it still fails with the following errors:

dbdimp.o:dbdimp.c:(.text+0x479): undefined reference to 'PQstatus'<br>
<...etc...etc...>
[download]

as per the StackOverflow ticket details.

Doeth anyone carry in their habit a shucking knife?

Your grace is humble sought,
One who possesseth knowledge gaps.

Comment on 'cpan DBD::Pg' install fails Select or Download Code

Replies are listed 'Best First'.
Re: 'cpan DBD::Pg' install fails by syphilis (Archbishop) on Feb 10, 2020 at 08:42 UTC
I followed the README instructions for Strawberry Perl ... I didn't follow those instructions - I merely ran `cpan -i DBD::Pg` (Sorry - I didn't pay heed to the significance of that sentence first time round.) I would expect that's the reason that my attempt succeeded, but yours didn't. Those instructions are apparently old, obsolete and wrong. Cheers, Rob	[reply] [d/l]
Re: 'cpan DBD::Pg' install fails by syphilis (Archbishop) on Feb 10, 2020 at 04:20 UTC
I have been unable to install the updated version 3.10.4 of DBD::Pg using either: C:\>cpan DBD::Pg cpan>install DBD::Pg On my Windows 7 box, with 64-bit Strawberry Perl perl-5.30.0, DBD-Pg-3.10.4 installed without issue (albeit somewhat noisily) with `cpan -i DBD::Pg` Loading internal logger. Log::Log4perl recommended for better logging Reading 'C:\Users\sisyphus\.cpan\Metadata' Database was generated on Mon, 10 Feb 2020 03:55:09 GMT CPAN: Module::CoreList loaded ok (v5.20190522) Running install for module 'DBD::Pg' CPAN: Digest::SHA loaded ok (v6.02) CPAN: Compress::Zlib loaded ok (v2.086) Checksum for C:\Users\sisyphus\.cpan\sources\authors\id\T\TU\TURNSTEP\ +DBD-Pg-3.10.4.tar.gz ok CPAN: Archive::Tar loaded ok (v2.32) CPAN: YAML loaded ok (v1.29) 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.10.4.tar.gz with Makefile.PL Configuring DBD::Pg 3.10.4 PostgreSQL version: 110003 (default port: 5432) POSTGRES_HOME: (not set) POSTGRES_INCLUDE: C:/_64/ST2A67~1.0/c/include POSTGRES_LIB: C:/_64/ST2A67~1.0/c/lib OS: MSWin32 Checking if your kit is complete... Looks good Using DBI 1.642 (for perl 5.030000 on MSWin32-x64-multi-thread) instal +led in C:/_64/strawberry-vanilla-5.30.0/perl/vendor/lib/auto/DBI/ Generating a gmake-style Makefile Writing Makefile for DBD::Pg Writing MYMETA.yml and MYMETA.json TURNSTEP/DBD-Pg-3.10.4.tar.gz C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe Makefile.PL -- OK Running make for T/TU/TURNSTEP/DBD-Pg-3.10.4.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 Pg () "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" -MExtUtils::Comma +nd -e chmod -- 644 "Pg.bs" "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" -MExtUtils::Comma +nd::MM -e cp_nonempty -- Pg.bs blib\arch\auto\DBD\Pg\Pg.bs 644 "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" -p -e "s/~DRIVER~ +/Pg/g; s/^do\(/dontdo\(/" C:\_64\strawberry-vanilla-5.30.0\perl\vendo +r\lib\auto\DBI\Driver.xst > Pg.xsi "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" "C:\_64\strawberr +y-vanilla-5.30.0\perl\lib\ExtUtils/xsubpp" -typemap C:\_64\strawberr +y-vanilla-5.30.0\perl\lib\ExtUtils\typemap Pg.xs > Pg.xsc "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" -MExtUtils::Comma +nd -e mv -- Pg.xsc Pg.c gcc -c -I"C:/_64/ST2A67~1.0/c/include" -IC:\_64\strawberry-vanilla-5. +30.0\perl\vendor\lib\auto\DBI -s -O2 -DWIN32 -DWIN64 -DCONSERVATIVE - +D__USE_MINGW_ANSI_STDIO -DPERL_TEXTMODE_SCRIPTS -DPERL_IMPLICIT_CONTE +XT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -fwrapv -fno-strict-aliasing -fdi +agnostics-color=never -mms-bitfields -DPGLIBVERSION=110003 -DPGDEFPOR +T=5432 -s -O2 -DVERSION=\"3.10.4\" -DXS_VERSION=\"3.10.4\" "-IC:\_ +64\strawberry-vanilla-5.30.0\perl\lib\CORE" Pg.c In file included from C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib +\auto\DBI/DBIXS.h:38, from Pg.h:56, from Pg.xs:14: C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib\auto\DBI/dbipport.h:4 +471: warning: "WIDEST_UTYPE" redefined # define WIDEST_UTYPE U64TYPE In file included from C:\_64\strawberry-vanilla-5.30.0\perl\lib\CORE/p +erl.h:2508, from C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib +\auto\DBI/DBIXS.h:23, from Pg.h:56, from Pg.xs:14: C:\_64\strawberry-vanilla-5.30.0\perl\lib\CORE/handy.h:1072: note: thi +s is the location of the previous definition # define WIDEST_UTYPE U64 gcc -c -I"C:/_64/ST2A67~1.0/c/include" -IC:\_64\strawberry-vanilla-5. +30.0\perl\vendor\lib\auto\DBI -s -O2 -DWIN32 -DWIN64 -DCONSERVATIVE - +D__USE_MINGW_ANSI_STDIO -DPERL_TEXTMODE_SCRIPTS -DPERL_IMPLICIT_CONTE +XT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -fwrapv -fno-strict-aliasing -fdi +agnostics-color=never -mms-bitfields -DPGLIBVERSION=110003 -DPGDEFPOR +T=5432 -s -O2 -DVERSION=\"3.10.4\" -DXS_VERSION=\"3.10.4\" "-IC:\_ +64\strawberry-vanilla-5.30.0\perl\lib\CORE" dbdimp.c In file included from C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib +\auto\DBI/DBIXS.h:38, from Pg.h:56, from dbdimp.c:14: C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib\auto\DBI/dbipport.h:4 +471: warning: "WIDEST_UTYPE" redefined # define WIDEST_UTYPE U64TYPE In file included from C:\_64\strawberry-vanilla-5.30.0\perl\lib\CORE/p +erl.h:2508, from C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib +\auto\DBI/DBIXS.h:23, from Pg.h:56, from dbdimp.c:14: C:\_64\strawberry-vanilla-5.30.0\perl\lib\CORE/handy.h:1072: note: thi +s is the location of the previous definition # define WIDEST_UTYPE U64 dbdimp.c: In function 'pg_st_prepare_statement': dbdimp.c:2368:44: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] if ((0 == imp_dbh->sth_result_owner \|\| (long int)imp_sth == imp_d +bh->sth_result_owner) ^ dbdimp.c:2383:33: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] imp_dbh->sth_result_owner = (long int)imp_sth; ^ dbdimp.c: In function 'pg_st_execute': dbdimp.c:3404:52: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] if ((0 == imp_dbh->sth_result_owner \|\| (long int)imp_sth +== imp_dbh->sth_result_owner) ^ dbdimp.c:3419:41: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] imp_dbh->sth_result_owner = (long int)imp_sth; ^ dbdimp.c:3498:52: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] if ((0 == imp_dbh->sth_result_owner \|\| (long int)imp_sth +== imp_dbh->sth_result_owner) ^ dbdimp.c:3515:41: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] imp_dbh->sth_result_owner = (long int)imp_sth; ^ dbdimp.c:3575:52: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] if ((0 == imp_dbh->sth_result_owner \|\| (long int)imp_sth +== imp_dbh->sth_result_owner) ^ dbdimp.c:3592:41: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] imp_dbh->sth_result_owner = (long int)imp_sth; ^ dbdimp.c: In function 'pg_st_finish': dbdimp.c:3899:42: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] if (imp_dbh->sth_result_owner == (long int)imp_sth) { ^ dbdimp.c: In function 'pg_st_destroy': dbdimp.c:4070:10: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] if ( (long int)imp_sth == imp_dbh->sth_result_owner ) { ^ dbdimp.c: In function 'pg_db_result': dbdimp.c:5233:52: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] if ((0 == imp_dbh->sth_result_owner \|\| (long int)imp_dbh- +>async_sth == imp_dbh->sth_result_owner) ^ dbdimp.c:5247:41: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] imp_dbh->sth_result_owner = (long int)imp_dbh->async_sth; ^ dbdimp.c: In function 'pg_st_deallocate_statement.isra.4': dbdimp.c:3965:17: warning: 'strncpy' specified bound depends on the le +ngth of the source argument [-Wstringop-overflow=] strncpy(tempsqlstate, imp_dbh->sqlstate, strlen(imp_d +bh->sqlstate)+1); ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ +~~~~~~~~~~~~~~~~ dbdimp.c:3965:58: note: length computed here strncpy(tempsqlstate, imp_dbh->sqlstate, strlen(imp_d +bh->sqlstate)+1); ^~~~~~~~~~~~ +~~~~~~~~~~~~~ dbdimp.c:4001:9: warning: 'strncpy' specified bound depends on the len +gth of the source argument [-Wstringop-overflow=] strncpy(imp_dbh->sqlstate, tempsqlstate, strlen(tempsqlstate) ++1); ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ +~~~ dbdimp.c:4001:50: note: length computed here strncpy(imp_dbh->sqlstate, tempsqlstate, strlen(tempsqlstate) ++1); ^~~~~~~~~~~~~~~~~~~~ gcc -c -I"C:/_64/ST2A67~1.0/c/include" -IC:\_64\strawberry-vanilla-5. +30.0\perl\vendor\lib\auto\DBI -s -O2 -DWIN32 -DWIN64 -DCONSERVATIVE - +D__USE_MINGW_ANSI_STDIO -DPERL_TEXTMODE_SCRIPTS -DPERL_IMPLICIT_CONTE +XT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -fwrapv -fno-strict-aliasing -fdi +agnostics-color=never -mms-bitfields -DPGLIBVERSION=110003 -DPGDEFPOR +T=5432 -s -O2 -DVERSION=\"3.10.4\" -DXS_VERSION=\"3.10.4\" "-IC:\_ +64\strawberry-vanilla-5.30.0\perl\lib\CORE" quote.c In file included from C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib +\auto\DBI/DBIXS.h:38, from Pg.h:56, from quote.c:10: C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib\auto\DBI/dbipport.h:4 +471: warning: "WIDEST_UTYPE" redefined # define WIDEST_UTYPE U64TYPE In file included from C:\_64\strawberry-vanilla-5.30.0\perl\lib\CORE/p +erl.h:2508, from C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib +\auto\DBI/DBIXS.h:23, from Pg.h:56, from quote.c:10: C:\_64\strawberry-vanilla-5.30.0\perl\lib\CORE/handy.h:1072: note: thi +s is the location of the previous definition # define WIDEST_UTYPE U64 gcc -c -I"C:/_64/ST2A67~1.0/c/include" -IC:\_64\strawberry-vanilla-5. +30.0\perl\vendor\lib\auto\DBI -s -O2 -DWIN32 -DWIN64 -DCONSERVATIVE - +D__USE_MINGW_ANSI_STDIO -DPERL_TEXTMODE_SCRIPTS -DPERL_IMPLICIT_CONTE +XT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -fwrapv -fno-strict-aliasing -fdi +agnostics-color=never -mms-bitfields -DPGLIBVERSION=110003 -DPGDEFPOR +T=5432 -s -O2 -DVERSION=\"3.10.4\" -DXS_VERSION=\"3.10.4\" "-IC:\_ +64\strawberry-vanilla-5.30.0\perl\lib\CORE" types.c In file included from C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib +\auto\DBI/DBIXS.h:38, from Pg.h:56, from types.c:15: C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib\auto\DBI/dbipport.h:4 +471: warning: "WIDEST_UTYPE" redefined # define WIDEST_UTYPE U64TYPE In file included from C:\_64\strawberry-vanilla-5.30.0\perl\lib\CORE/p +erl.h:2508, from C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib +\auto\DBI/DBIXS.h:23, from Pg.h:56, from types.c:15: C:\_64\strawberry-vanilla-5.30.0\perl\lib\CORE/handy.h:1072: note: thi +s is the location of the previous definition # define WIDEST_UTYPE U64 "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" -MExtUtils::Mksym +lists \ -e "Mksymlists('NAME'=>\"DBD::Pg\", 'DLBASE' => 'Pg', 'DL_FUNCS' +=> { }, 'FUNCLIST' => [], 'IMPORTS' => { }, 'DL_VARS' => []);" g++.exe Pg.def -o blib\arch\auto\DBD\Pg\Pg.xs.dll -mdll -s -L"C:\_64\s +trawberry-vanilla-5.30.0\perl\lib\CORE" -L"C:\_64\strawberry-vanilla- +5.30.0\c\lib" Pg.o dbdimp.o quote.o types.o "C:\_64\strawberry-vani +lla-5.30.0\perl\lib\CORE\libperl530.a" "C:\_64\ST2A67~1.0\c\lib\libpq +.a" "C:\_64\strawberry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libm.a +" "C:\_64\strawberry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libsecur +32.a" "C:\_64\strawberry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libm +oldname.a" "C:\_64\strawberry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib +\libkernel32.a" "C:\_64\strawberry-vanilla-5.30.0\c\x86_64-w64-mingw3 +2\lib\libuser32.a" "C:\_64\strawberry-vanilla-5.30.0\c\x86_64-w64-min +gw32\lib\libgdi32.a" "C:\_64\strawberry-vanilla-5.30.0\c\x86_64-w64-m +ingw32\lib\libwinspool.a" "C:\_64\strawberry-vanilla-5.30.0\c\x86_64- +w64-mingw32\lib\libcomdlg32.a" "C:\_64\strawberry-vanilla-5.30.0\c\x8 +6_64-w64-mingw32\lib\libadvapi32.a" "C:\_64\strawberry-vanilla-5.30.0 +\c\x86_64-w64-mingw32\lib\libshell32.a" "C:\_64\strawberry-vanilla-5. +30.0\c\x86_64-w64-mingw32\lib\libole32.a" "C:\_64\strawberry-vanilla- +5.30.0\c\x86_64-w64-mingw32\lib\liboleaut32.a" "C:\_64\strawberry-van +illa-5.30.0\c\x86_64-w64-mingw32\lib\libnetapi32.a" "C:\_64\strawberr +y-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libuuid.a" "C:\_64\strawber +ry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libws2_32.a" "C:\_64\straw +berry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libmpr.a" "C:\_64\straw +berry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libwinmm.a" "C:\_64\str +awberry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libversion.a" "C:\_64 +\strawberry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libodbc32.a" "C:\ +_64\strawberry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libodbccp32.a" + "C:\_64\strawberry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libcomctl +32.a" -Wl,--enable-auto-image-base "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" -MExtUtils::Comma +nd -e chmod -- 755 blib\arch\auto\DBD\Pg\Pg.xs.dll TURNSTEP/DBD-Pg-3.10.4.tar.gz gmake -- OK Running make test for TURNSTEP/DBD-Pg-3.10.4.tar.gz "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" -MExtUtils::Comma +nd::MM -e cp_nonempty -- Pg.bs blib\arch\auto\DBD\Pg\Pg.bs 644 "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" "-MExtUtils::Comm +and::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_SI +GNATURE to enable this test t/00basic.t ............ ok # # DBI Version 1.642 # DBD::Pg Version 3.10.4 # Perl Version 5.30.0 # OS MSWin32 # PostgreSQL (compiled) ? # PostgreSQL (target) ? # PostgreSQL (reported) ? # Default port ? # DBI_DSN ? # DBI_USER <not set> # Test schema dbd_pg_testschema # LANG C # Adjusted: initdb # Error was: Bad initdb output: 'initdb' is not recognized as an inter +nal or external command, # operable program or batch file. # t/01connect.t .......... skipped: Connection to database failed, canno +t continue testing t/01constants.t ........ ok t/02attribs.t .......... skipped: Connection to database failed, canno +t continue testing t/03dbmethod.t ......... skipped: Connection to database failed, canno +t continue testing t/03smethod.t .......... skipped: Connection to database failed, canno +t continue testing t/04misc.t ............. skipped: Connection to database failed, canno +t continue testing t/06bytea.t ............ skipped: Connection to database failed, canno +t continue testing t/07copy.t ............. skipped: Connection to database failed, canno +t continue testing t/08async.t ............ skipped: Connection to database failed, canno +t continue testing t/09arrays.t ........... skipped: Connection to database failed, canno +t continue testing t/10_pg_error_field.t .. skipped: Connection to database failed, canno +t continue testing t/12placeholders.t ..... skipped: Connection to database failed, canno +t continue testing t/20savepoints.t ....... skipped: Connection to database failed, canno +t continue testing t/30unicode.t .......... skipped: Connection to database failed, canno +t continue testing t/99cleanup.t .......... ok All tests successful. Files=17, Tests=168, 9 wallclock secs ( 0.05 usr + 0.01 sys = 0.06 +CPU) Result: PASS TURNSTEP/DBD-Pg-3.10.4.tar.gz gmake test -- OK Running make install for TURNSTEP/DBD-Pg-3.10.4.tar.gz "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" -MExtUtils::Comma +nd::MM -e cp_nonempty -- Pg.bs blib\arch\auto\DBD\Pg\Pg.bs 644 Files found in blib\arch: installing files in blib\lib into architectu +re dependent library tree Installing C:\_64\strawberry-vanilla-5.30.0\perl\site\lib\auto\DBD\Pg\ +Pg.xs.dll Appending installation info to C:\_64\strawberry-vanilla-5.30.0\perl\l +ib/perllocal.pod TURNSTEP/DBD-Pg-3.10.4.tar.gz gmake install -- OK [download] Absolutely no "undefined reference" at all. Cheers, Rob	[reply] [d/l] [select]
Re: 'cpan DBD::Pg' install fails ( undefined reference to 'PQstatus' , objdump ) by Anonymous Monk on Feb 10, 2020 at 04:19 UTC
Re: 'cpan DBD::Pg' install fails ( undefined reference to 'PQstatus' , objdump ) use "objdump" to find it out https://www.postgresql.org/docs/8.1/libpq-build.html This means you forgot .. This means you forgot the -L option or did not specify the right directory.	[reply]
Re^2: 'cpan DBD::Pg' install fails ( undefined reference to 'PQstatus' , objdump ) by perlygapes (Sexton) on Feb 10, 2020 at 06:04 UTC
Thank you for your supplication. Dark forces are shielding mine eyes from the truth. I do not know how to use objdump (I can run it in Cygwin, but there are many switches). I can do simple tasks, like lookup scripture verse, like this: $ find . -type f -name "libpq.dll" -o -name "libpq.def" -o -name "libp +q.[ha]" ./12/bin/libpq.def ./12/bin/libpq.dll ./12/include/server/libpq/libpq.h ./12/lib/libpq.a ./12/lib/libpq.dll ./12/pgAdmin 4/bin/libpq.dll $ [download] linpq.def and libpq.a were created using pexports and dllname in MinGW, as per my Github Ticket details. Of the files listed above, is it simply a case of copying or moving one or more of these to another PostgreSQL folder? A virtual candle has been lit in Thanksgiving.	[reply] [d/l]
Re^3: 'cpan DBD::Pg' install fails ( undefined reference to 'PQstatus' , objdump ) by Anonymous Monk on Feb 10, 2020 at 06:58 UTC
Dark forces are shielding mine eyes from the truth. Here you Re: 'cpan DBD::Pg' install fails Otherwise the dots were linked :\|	[reply]
Re^3: 'cpan DBD::Pg' install fails ( undefined reference to 'PQstatus' , objdump ) by perlygapes (Sexton) on Feb 13, 2020 at 02:19 UTC
Finding myself down a dark alley and at a dead end, I decided to return to my First Love and go back to the start, back to Genesis. I ran pexports and dllname again, as advised in the README, however this time I did it within the directory as recommended. This time, though it still failed, it solved the `undefined symbol...` issue. Now, however, some of the tests are failing. One appears due to a function name cAsE mIsMaTcH: user @ computer c:\Program Files\PostgreSQL\12\bin >pexports libpq.dll > libpq.def user @ computer c:\Program Files\PostgreSQL\12\bin >dlltool -dllname libpq.dll --def libpq.def --output-lib ..\lib\libpq. +a user @ computer c:\Program Files\PostgreSQL\12\bin >cpan DBD::Pg Loading internal logger. Log::Log4perl recommended for better logging CPAN: Term::ANSIColor loaded ok (v4.06) Reading 'C:\Perl64\cpan\Metadata' Database was generated on Wed, 12 Feb 2020 06:55:27 GMT Running install for module 'DBD::Pg' CPAN: Digest::SHA loaded ok (v5.98) CPAN: Compress::Zlib loaded ok (v2.074) Checksum for C:\Perl64\cpan\sources\authors\id\T\TU\TURNSTEP\DBD-Pg-3. +10.4.tar.gz ok CPAN: Archive::Tar loaded ok (v2.26) DBD-Pg-3.10.4/ DBD-Pg-3.10.4/MANIFEST DBD-Pg-3.10.4/quote.c DBD-Pg-3.10.4/dbivport.h DBD-Pg-3.10.4/README.win32 DBD-Pg-3.10.4/Makefile.PL DBD-Pg-3.10.4/Pg.xs DBD-Pg-3.10.4/types.h DBD-Pg-3.10.4/t/ DBD-Pg-3.10.4/t/dbdpg_test_setup.pl DBD-Pg-3.10.4/t/01connect.t DBD-Pg-3.10.4/t/06bytea.t DBD-Pg-3.10.4/t/00basic.t DBD-Pg-3.10.4/t/99cleanup.t DBD-Pg-3.10.4/t/02attribs.t DBD-Pg-3.10.4/t/10_pg_error_field.t DBD-Pg-3.10.4/t/03dbmethod.t DBD-Pg-3.10.4/t/lib/ DBD-Pg-3.10.4/t/lib/App/ DBD-Pg-3.10.4/t/lib/App/Info.pm DBD-Pg-3.10.4/t/lib/App/Info/ DBD-Pg-3.10.4/t/lib/App/Info/Handler.pm DBD-Pg-3.10.4/t/lib/App/Info/Request.pm DBD-Pg-3.10.4/t/lib/App/Info/RDBMS/ DBD-Pg-3.10.4/t/lib/App/Info/RDBMS/PostgreSQL.pm DBD-Pg-3.10.4/t/lib/App/Info/RDBMS.pm DBD-Pg-3.10.4/t/lib/App/Info/Handler/ DBD-Pg-3.10.4/t/lib/App/Info/Handler/Print.pm DBD-Pg-3.10.4/t/lib/App/Info/Handler/Prompt.pm DBD-Pg-3.10.4/t/lib/App/Info/Util.pm DBD-Pg-3.10.4/t/08async.t DBD-Pg-3.10.4/t/30unicode.t DBD-Pg-3.10.4/t/04misc.t DBD-Pg-3.10.4/t/12placeholders.t DBD-Pg-3.10.4/t/01constants.t DBD-Pg-3.10.4/t/00_signature.t DBD-Pg-3.10.4/t/09arrays.t DBD-Pg-3.10.4/t/07copy.t DBD-Pg-3.10.4/t/20savepoints.t DBD-Pg-3.10.4/t/03smethod.t DBD-Pg-3.10.4/LICENSES/ DBD-Pg-3.10.4/LICENSES/artistic.txt DBD-Pg-3.10.4/LICENSES/gpl-2.0.txt DBD-Pg-3.10.4/testme.tmp.pl DBD-Pg-3.10.4/win32.mak DBD-Pg-3.10.4/dbdimp.c DBD-Pg-3.10.4/types.c DBD-Pg-3.10.4/TODO DBD-Pg-3.10.4/lib/ DBD-Pg-3.10.4/lib/Bundle/ DBD-Pg-3.10.4/lib/Bundle/DBD/ DBD-Pg-3.10.4/lib/Bundle/DBD/Pg.pm DBD-Pg-3.10.4/Pg.pm DBD-Pg-3.10.4/META.yml DBD-Pg-3.10.4/Changes DBD-Pg-3.10.4/README.dev DBD-Pg-3.10.4/README DBD-Pg-3.10.4/Pg.h DBD-Pg-3.10.4/dbdimp.h DBD-Pg-3.10.4/.perlcriticrc DBD-Pg-3.10.4/MANIFEST.SKIP DBD-Pg-3.10.4/SIGNATURE DBD-Pg-3.10.4/quote.h CPAN: YAML::XS loaded ok (v0.66) CPAN: CPAN::Meta::Requirements loaded ok (v2.140) CPAN: Parse::CPAN::Meta loaded ok (v2.150010) CPAN: CPAN::Meta loaded ok (v2.150010) CPAN: Module::CoreList loaded ok (v5.20171120) Configuring T/TU/TURNSTEP/DBD-Pg-3.10.4.tar.gz with Makefile.PL Configuring DBD::Pg 3.10.4 PostgreSQL version: 120001 (default port: 5432) POSTGRES_HOME: C:\Program Files\PostgreSQL\12 POSTGRES_INCLUDE: C:\Program Files\PostgreSQL\12\include POSTGRES_LIB: C:\Program Files\PostgreSQL\12\lib OS: MSWin32 Multiple copies of Driver.xst found in: C:/Perl64/site/lib/auto/DBI/ C +:/Perl64/lib/auto/DBI/ at Makefile.PL line 182. Checking if your kit is complete... Looks good Warning (mostly harmless): No library found for -lm Warning (mostly harmless): No library found for -lsecur32 Warning (mostly harmless): No library found for -lmoldname Warning (mostly harmless): No library found for -lkernel32 Warning (mostly harmless): No library found for -luser32 Warning (mostly harmless): No library found for -lgdi32 Warning (mostly harmless): No library found for -lwinspool Warning (mostly harmless): No library found for -lcomdlg32 Warning (mostly harmless): No library found for -ladvapi32 Warning (mostly harmless): No library found for -lshell32 Warning (mostly harmless): No library found for -lole32 Warning (mostly harmless): No library found for -loleaut32 Warning (mostly harmless): No library found for -lnetapi32 Warning (mostly harmless): No library found for -luuid Warning (mostly harmless): No library found for -lws2_32 Warning (mostly harmless): No library found for -lmpr Warning (mostly harmless): No library found for -lwinmm Warning (mostly harmless): No library found for -lversion Warning (mostly harmless): No library found for -lodbc32 Warning (mostly harmless): No library found for -lodbccp32 Warning (mostly harmless): No library found for -lcomctl32 Multiple copies of Driver.xst found in: C:/Perl64/site/lib/auto/DBI/ C +:/Perl64/lib/auto/DBI/ at Makefile.PL line 284. Using DBI 1.643 (for perl 5.026001 on MSWin32-x64-multi-thread) instal +led in C:/Perl64/site/lib/auto/DBI/ Generating a dmake-style Makefile Writing Makefile for DBD::Pg Writing MYMETA.yml and MYMETA.json TURNSTEP/DBD-Pg-3.10.4.tar.gz C:\Perl64\bin\perl.exe Makefile.PL INSTALLDIRS=site -- OK Running make for T/TU/TURNSTEP/DBD-Pg-3.10.4.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 Pg () "C:\Perl64\bin\perl.exe" -MExtUtils::Command -e chmod -- 644 "Pg.bs" "C:\Perl64\bin\perl.exe" -MExtUtils::Command::MM -e cp_nonempty -- Pg. +bs blib\arch\auto\DBD\Pg\Pg.bs 644 "C:\Perl64\bin\perl.exe" -p -e "s/~DRIVER~/Pg/g; s/^do\(/dontdo\(/" C: +\Perl64\site\lib\auto\DBI\Driver.xst > Pg.xsi "C:\Perl64\bin\perl.exe" "C:\Perl64\lib\ExtUtils\xsubpp" -typemap C:\ +Perl64\lib\ExtUtils\typemap Pg.xs > Pg.xsc "C:\Perl64\bin\perl.exe" -MExtUtils::Command -e mv -- Pg.xsc Pg.c C:\Perl64\site\bin\gcc.exe -c -I"C:\Program Files\PostgreSQL\12\inclu +de" -IC:\Perl64\site\lib\auto\DBI -s -O2 -DWIN32 -DWIN64 -DCO +NSERVATIVE -DPERL_TEX TMODE_SCRIPTS -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLI +CIT_SYS -fwrapv -fno-strict-aliasing -mms-bitfields -DPGLIBVERSION=12 +0001 -DPGDEFPORT=5432 -s -O2 -DVERSION=\"3.10.4\" -DXS_VERSION=\"3.10.4\" "-IC: +\Perl64\lib\CORE" Pg.c C:\Perl64\site\bin\gcc.exe -c -I"C:\Program Files\PostgreSQL\12\inclu +de" -IC:\Perl64\site\lib\auto\DBI -s -O2 -DWIN32 -DWIN64 -DCO +NSERVATIVE -DPERL_TEX TMODE_SCRIPTS -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLI +CIT_SYS -fwrapv -fno-strict-aliasing -mms-bitfields -DPGLIBVERSION=12 +0001 -DPGDEFPORT=5432 -s -O2 -DVERSION=\"3.10.4\" -DXS_VERSION=\"3.10.4\" "-IC: +\Perl64\lib\CORE" dbdimp.c dbdimp.c: In function 'pg_st_prepare_statement': dbdimp.c:2368:44: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c:2383:33: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c: In function 'pg_st_execute': dbdimp.c:3404:52: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c:3419:41: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c:3498:52: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c:3515:41: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c:3575:52: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c:3592:41: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c: In function 'pg_st_finish': dbdimp.c:3899:42: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c: In function 'pg_st_destroy': dbdimp.c:4070:10: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c: In function 'pg_db_result': dbdimp.c:5233:52: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c:5247:41: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] C:\Perl64\site\bin\gcc.exe -c -I"C:\Program Files\PostgreSQL\12\inclu +de" -IC:\Perl64\site\lib\auto\DBI -s -O2 -DWIN32 -DWIN64 -DCO +NSERVATIVE -DPERL_TEX TMODE_SCRIPTS -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLI +CIT_SYS -fwrapv -fno-strict-aliasing -mms-bitfields -DPGLIBVERSION=12 +0001 -DPGDEFPORT=5432 -s -O2 -DVERSION=\"3.10.4\" -DXS_VERSION=\"3.10.4\" "-IC: +\Perl64\lib\CORE" quote.c C:\Perl64\site\bin\gcc.exe -c -I"C:\Program Files\PostgreSQL\12\inclu +de" -IC:\Perl64\site\lib\auto\DBI -s -O2 -DWIN32 -DWIN64 -DCO +NSERVATIVE -DPERL_TEX TMODE_SCRIPTS -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLI +CIT_SYS -fwrapv -fno-strict-aliasing -mms-bitfields -DPGLIBVERSION=12 +0001 -DPGDEFPORT=5432 -s -O2 -DVERSION=\"3.10.4\" -DXS_VERSION=\"3.10.4\" "-IC: +\Perl64\lib\CORE" types.c "C:\Perl64\bin\perl.exe" -MExtUtils::Mksymlists \ -e "Mksymlists('NAME'=>\"DBD::Pg\", 'DLBASE' => 'Pg', 'DL_FUNCS' +=> { }, 'FUNCLIST' => [], 'IMPORTS' => { }, 'DL_VARS' => []);" C:\Perl64\site\bin\g++.exe Pg.def -o blib\arch\auto\DBD\Pg\Pg.dll -mdl +l -s -static-libgcc -static-libstdc++ -L"C:\Perl64\lib\CORE" -L"C:\Mi +nGW\x86_64-w64-mingw3 2\lib" Pg.o dbdimp.o quote.o types.o "C:\Perl64\lib\CORE\libperl526. +a" "C:\Program Files\PostgreSQL\12\lib\libpq.a" -Wl,--enable-auto-ima +ge-base "C:\Perl64\bin\perl.exe" -MExtUtils::Command -e chmod -- 755 blib\arch +\auto\DBD\Pg\Pg.dll TURNSTEP/DBD-Pg-3.10.4.tar.gz C:\Perl64\site\bin\dmake.exe -- OK CPAN: CPAN::DistnameInfo loaded ok (v0.12) Running make test for TURNSTEP/DBD-Pg-3.10.4.tar.gz "C:\Perl64\bin\perl.exe" -MExtUtils::Command::MM -e cp_nonempty -- Pg. +bs blib\arch\auto\DBD\Pg\Pg.bs 644 "C:\Perl64\bin\perl.exe" "-MExtUtils::Command::MM" "-MTest::Harness" " +-e" "undef Test::Harness::Switches; test_harness(0, 'blib\lib', 'bli +b\arch')" t/.t t/00_signature.t ....... skipped: Set the environment variable TEST_SI +GNATURE to enable this test t/00basic.t ............ ok t/01connect.t .......... 11/15 # # DBI Version 1.643 # DBD::Pg Version 3.10.4 # Perl Version 5.26.1 # OS MSWin32 # PostgreSQL (compiled) 120001 # PostgreSQL (target) 120001 # PostgreSQL (reported) PostgreSQL 12.1, compiled by Visual C++ +build 1914, 64-bit # Default port 5432 # DBI_DSN dbi:Pg:db="testdb" # DBI_USER postgres # Test schema dbd_pg_testschema # PGPORT 5432 # PGUSER postgres # array_nulls on # backslash_quote safe_encoding # client_encoding UTF8 # server_encoding UTF8 # standard_conforming_strings on t/01connect.t .......... ok t/01constants.t ........ ok t/02attribs.t .......... ok [download] `t/03dbmethod.t ......... 108/580 Issuing rollback() due to DESTROY wit +hout explicit disconnect() of DBD::Pg::db handle dbname=testdb at t/0 +3dbmethod.t line 2103 .` [download] `t/03dbmethod.t ......... ok t/03smethod.t .......... ok` [download] t/04misc.t ............. 81/95 DBD::Pg::db do failed: ERROR: invalid +value for parameter "max_stack_depth": 4096 DETAIL: "max_stack_depth" must not exceed 3584kB. HINT: Increase the platform's stack depth limit via "ulimit -s" or lo +cal equivalent. at t/04misc.t line 531, <$fh> line 8. Issuing rollback() due to DESTROY without explicit disconnect() of DBD +::Pg::db handle dbname=testdb at t/04misc.t line 531, <$fh> line 8. Error removing C:\Perl64\cpan\build\DBD-Pg-3.10.4-11\dbdpg_test_gBvnuZ +tst at C:/Perl64/lib/File/Temp.pm line 762. # Looks like your test exited with 255 just after 81. t/04misc.t ............. Dubious, test returned 255 (wstat 65280, 0xff +00) Failed 14/95 subtests [download] `t/06bytea.t ............ ok t/07copy.t ............. ok t/08async.t ............ ok t/09arrays.t ........... ok` [download] t/10_pg_error_field.t .. 1/? # Failed test '(query 4) Calling pg_error_field returns expected val +ue for field pg_diag_source_file' # at t/10_pg_error_field.t line 92. # 'd:\pginstaller_12.auto\postgres.windows-x64\src\b +ackend\executor\execmain.c' # doesn't match '(?^:execMain.c)' # Failed test '(query 4) Calling pg_error_field returns expected val +ue for field PG_DIAG_SOURCE_FILE' # at t/10_pg_error_field.t line 97. # 'd:\pginstaller_12.auto\postgres.windows-x64\src\b +ackend\executor\execmain.c' # doesn't match '(?^:execMain.c)' t/10_pg_error_field.t .. 286/? # Failed test '(query 4) Calling pg_e +rror_field returns expected value for field SOURCE_FILE' # at t/10_pg_error_field.t line 102. # 'd:\pginstaller_12.auto\postgres.windows-x64\src\b +ackend\executor\execmain.c' # doesn't match '(?^:execMain.c)' # Failed test '(query 5) Calling pg_error_field returns expected val +ue for field pg_diag_source_file' # at t/10_pg_error_field.t line 92. # 'd:\pginstaller_12.auto\postgres.windows-x64\src\b +ackend\executor\execmain.c' # doesn't match '(?^:execMain.c)' # Failed test '(query 5) Calling pg_error_field returns expected val +ue for field PG_DIAG_SOURCE_FILE' # at t/10_pg_error_field.t line 97. # 'd:\pginstaller_12.auto\postgres.windows-x64\src\b +ackend\executor\execmain.c' # doesn't match '(?^:execMain.c)' t/10_pg_error_field.t .. 358/? # Failed test '(query 5) Calling pg_e +rror_field returns expected value for field SOURCE_FILE' # at t/10_pg_error_field.t line 102. # 'd:\pginstaller_12.auto\postgres.windows-x64\src\b +ackend\executor\execmain.c' # doesn't match '(?^:execMain.c)' # Looks like you failed 6 tests of 364. t/10_pg_error_field.t .. Dubious, test returned 6 (wstat 1536, 0x600) Failed 6/364 subtests [download] `t/12placeholders.t ..... ok t/20savepoints.t ....... ok t/30unicode.t .......... ok t/99cleanup.t .......... ok` [download] Test Summary Report ------------------- t/04misc.t (Wstat: 65280 Tests: 81 Failed: 0) Non-zero exit status: 255 Parse errors: Bad plan. You planned 95 tests but ran 81. t/10_pg_error_field.t (Wstat: 1536 Tests: 364 Failed: 6) Failed tests: 284-286, 356-358 Non-zero exit status: 6 Files=17, Tests=2846, 24 wallclock secs ( 0.09 usr + 0.02 sys = 0.11 + CPU) Result: FAIL Failed 2/17 test programs. 6/2846 subtests failed. dmake.exe: Error code 255, while making 'test_dynamic' TURNSTEP/DBD-Pg-3.10.4.tar.gz C:\Perl64\site\bin\dmake.exe test -- NOT OK //hint// to see the cpan-testers results for installing this module, t +ry: reports TURNSTEP/DBD-Pg-3.10.4.tar.gz [download] `user @ computer c:\Program Files\PostgreSQL\12\bin >` [download]	[reply] [d/l] [select]
Re^4: 'cpan DBD::Pg' install fails ( undefined reference to 'PQstatus' , objdump ) by Anonymous Monk on Feb 13, 2020 at 03:35 UTC
Re^4: 'cpan DBD::Pg' install fails ( undefined reference to 'PQstatus' , objdump ) by perlygapes (Sexton) on Feb 14, 2020 at 00:56 UTC

Back to Seekers of Perl Wisdom

Log In^?

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: perlquestion [id://11112712]
Approved by beech
Front-paged by Corion
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others avoiding work at the Monastery: (3)

As of 2024-04-24 06:20 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Today I Learned

Voting Booth^?

No recent polls found