re: install problems

I just thought I would let people know that I solved my various problems.

Turns out the most basic issue was with the ³SHOW backslash_quote² command
in the testfiles.

I had version 8.1 of postgres, which did not include that command ­ it was
included in later versions in order to protect against SQL injection
attacks.

Once I updated postgresql, I was able to install DBD:Pg no problem.

There should be a better check in the testing for the driver, I would think,
but lord knows that kind of thing is a little beyond my pay grade.

Thanks so much for the assistance.

Nick Landess wrote:
> I have had a hell of a time trying to install the dbd:pg module.
> 
> Don¹t have a lot of experience installing perl modules, so I beg your
> patience and forgiveness if this turns out to be a stupid problem.
> 
> Below is the text returned by my last attempt at installing via the bundle.
> 
> Sorry for the size of the cut and paste:
> 
>> Nicholas-Landess-Computer:/volumes/wonder/downloads/DBD-Pg-2.7.2 nick$ perl

>> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>> ERROR: Can't create '/Library/Perl/5.8.6/darwin-thread-multi-2level'
>> Do not have write permissions on
>> '/Library/Perl/5.8.6/darwin-thread-multi-2level'
>> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>>  at -e line 1
>> make: *** [pure_site_install] Error 255
>>   JPEACOCK/version-0.74.tar.gz
>>   /usr/bin/make install  -- NOT OK

You need root privileges to install - try 'sudo make install'

It looks like you were missing version.pm also, but that looked like a
non critical issue.


>> ----
>>   You may have to su to root to install the package
>>   (Or you may want to run something like
>>     o conf make_install_make_command 'sudo make'
>>   to raise your permissions.Warning (usually harmless): 'YAML' not installed,
>> will not store persistent state
>> Running make for T/TU/TURNSTEP/DBD-Pg-2.7.2.tar.gz
>> Prepending /Users/nick/.cpan/build/version-0.74/blib/arch
>> /Users/nick/.cpan/build/version-0.74/blib/lib to PERL5LIB for 'get'
>>   Has already been unwrapped into directory
>> /Users/nick/.cpan/build/DBD-Pg-2.7.2
>> Prepending /Users/nick/.cpan/build/version-0.74/blib/arch
>> /Users/nick/.cpan/build/version-0.74/blib/lib to PERL5LIB for 'make'
>>
>>   CPAN.pm: Going to build T/TU/TURNSTEP/DBD-Pg-2.7.2.tar.gz
>>
>> cp lib/Bundle/DBD/Pg.pm blib/lib/Bundle/DBD/Pg.pm
>> cp Pg.pm blib/lib/DBD/Pg.pm
>> /usr/bin/perl -p -e "s/~DRIVER~/Pg/g; s/^do\(/dontdo\(/"
>> /Library/Perl/5.8.6/darwin-thread-multi-2level/auto/DBI/Driver.xst > Pg.xsi
>> /usr/bin/perl /System/Library/Perl/5.8.6/ExtUtils/xsubpp  -typemap
>> /System/Library/Perl/5.8.6/ExtUtils/typemap  Pg.xs > Pg.xsc && mv Pg.xsc Pg.c
>> cc -c  -I/usr/local/pgsql/include
>> -I/Library/Perl/5.8.6/darwin-thread-multi-2level/auto/DBI -g -pipe
-fno-common
>> -DPERL_DARWIN -no-cpp-precomp -fno-strict-aliasing -I/usr/local/include
>> -DPGLIBVERSION=80103 -DPGDEFPORT=5432 -Os  -DPERL_EXTMALLOC_DEF
>> -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc
>> -Dcalloc=Perl_calloc -DVERSION=\"undef\" -DXS_VERSION=\"undef\"
>> "-I/System/Library/Perl/5.8.6/darwin-thread-multi-2level/CORE"   Pg.c
>> cc -c  -I/usr/local/pgsql/include
>> -I/Library/Perl/5.8.6/darwin-thread-multi-2level/auto/DBI -g -pipe
-fno-common
>> -DPERL_DARWIN -no-cpp-precomp -fno-strict-aliasing -I/usr/local/include
>> -DPGLIBVERSION=80103 -DPGDEFPORT=5432 -Os  -DPERL_EXTMALLOC_DEF
>> -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc
>> -Dcalloc=Perl_calloc -DVERSION=\"undef\" -DXS_VERSION=\"undef\"
>> "-I/System/Library/Perl/5.8.6/darwin-thread-multi-2level/CORE"   dbdimp.c
>> cc -c  -I/usr/local/pgsql/include
>> -I/Library/Perl/5.8.6/darwin-thread-multi-2level/auto/DBI -g -pipe
-fno-common
>> -DPERL_DARWIN -no-cpp-precomp -fno-strict-aliasing -I/usr/local/include
>> -DPGLIBVERSION=80103 -DPGDEFPORT=5432 -Os  -DPERL_EXTMALLOC_DEF
>> -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc
>> -Dcalloc=Perl_calloc -DVERSION=\"undef\" -DXS_VERSION=\"undef\"
>> "-I/System/Library/Perl/5.8.6/darwin-thread-multi-2level/CORE"   quote.c
>> cc -c  -I/usr/local/pgsql/include
>> -I/Library/Perl/5.8.6/darwin-thread-multi-2level/auto/DBI -g -pipe
-fno-common
>> -DPERL_DARWIN -no-cpp-precomp -fno-strict-aliasing -I/usr/local/include
>> -DPGLIBVERSION=80103 -DPGDEFPORT=5432 -Os  -DPERL_EXTMALLOC_DEF
>> -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc
>> -Dcalloc=Perl_calloc -DVERSION=\"undef\" -DXS_VERSION=\"undef\"
>> "-I/System/Library/Perl/5.8.6/darwin-thread-multi-2level/CORE"   types.c
>> Running Mkbootstrap for DBD::Pg ()
>> chmod 644 Pg.bs
>> rm -f blib/arch/auto/DBD/Pg/Pg.bundle
>> LD_RUN_PATH="/usr/local/pgsql/lib" env MACOSX_DEPLOYMENT_TARGET=10.3 cc
>> -bundle -undefined dynamic_lookup -L/usr/local/lib Pg.o dbdimp.o quote.o
>> types.o  -o blib/arch/auto/DBD/Pg/Pg.bundle   \
>>    -L/usr/local/pgsql/lib -lpq          \
>>   
>> chmod 755 blib/arch/auto/DBD/Pg/Pg.bundle
>> cp Pg.bs blib/arch/auto/DBD/Pg/Pg.bs
>> chmod 644 blib/arch/auto/DBD/Pg/Pg.bs
>> Manifying blib/man3/Bundle::DBD::Pg.3pm
>> Manifying blib/man3/DBD::Pg.3pm
>>   TURNSTEP/DBD-Pg-2.7.2.tar.gz
>>   /usr/bin/make -- OK
>> Warning (usually harmless): 'YAML' not installed, will not store persistent
>> state
>> Prepending /Users/nick/.cpan/build/version-0.74/blib/arch
>> /Users/nick/.cpan/build/version-0.74/blib/lib to PERL5LIB for 'test'
>> Running make test
>> PGINITDB="/usr/local/pgsql/bin/initdb" PERL_DL_NONLAZY=1 /usr/bin/perl
>> "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')"
>> t/*.t
>> t/00-signature........skipped: Set the environment variable TEST_SIGNATURE to
>> enable this test
>> t/00basic.............1/3 Bailout called.  Further testing stopped:  Cannot
>> continue without DBD::Pg
>>
>> #   Failed test 'use DBD::Pg;'
>> #   at t/00basic.t line 13.
>> #     Tried to use 'DBD::Pg'.
>> #     Error:  DBD::Pg object version undef does not match bootstrap parameter
>> 2.7.2 at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/DynaLoader.pm
>> line 253.
>> # Compilation failed in require at (eval 5) line 2.
>> # BEGIN failed--compilation aborted at (eval 5) line 2.
>> make: *** [test_dynamic] Error 1
>>   TURNSTEP/DBD-Pg-2.7.2.tar.gz
>>   /usr/bin/make test -- NOT OK
>> //hint// to see the cpan-testers results for installing this module, try:
>>   reports TURNSTEP/DBD-Pg-2.7.2.tar.gz
>> Warning (usually harmless): 'YAML' not installed, will not store persistent
>> state
>> Running make install
>>   make test had returned bad status, won't install without force
>> Nicholas-Landess-Computer:/volumes/wonder/downloads/DBD-Pg-2.7.2 nick$
> 
> 
> Any suggestions/assistance greatly appreciated
> 
> Thanks
> 
> Nick Landess
> [email protected]
> 


-- 
Red Hot Penguin Consulting LLC
mod_perl/PostgreSQL consulting and implementation
http://www.redhotpenguin.com/