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/
