Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f43EmSA71604 for ; Thu, 3 May 2001 10:48:28 -0400 (EDT) (envelope-from pgsql-docs-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3SMuB300267 for ; Sat, 28 Apr 2001 18:56:11 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f3SMsoT43071 for pgsql-docs@postgresql.org; Sat, 28 Apr 2001 18:54:50 -0400 (EDT) (envelope-from news) User-Agent: Microsoft-Entourage/9.0.1.3108 Subject: perlDBD::pg error! Please help (have all details in post) From: Raoul Callaghan X-Newsgroups: comp.databases.postgresql.docs Message-ID: Mime-version: 1.0 Content-type: multipart/alternative; boundary="B_3071378952_2907587" Lines: 1146 Date: Sat, 28 Apr 2001 22:54:47 GMT X-Complaints-To: news@bigpond.net.au Organization: BigPond Internet Services (http://www.bigpond.net.au) To: pgsql-docs@postgresql.org X-Archive-Number: 200105/17 X-Sequence-Number: 698 > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3071378952_2907587 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: 8bit Have attempted to install DBI and DBD, but DBD ³make test² fails. Below is my complete procedure , starting from: Accessing PostgreSQL from the command line, (successful) creating a database, populating. (successful) Expanding DBI and DBD. (successful) Installing DBI (seemingly successful) Set environments. (successful) Install DBD. (error occur on ³test²) So now Iım hoping someone can help me out.... I think I have included all the version information throughout the procedure. if not please let me know. Any assistance would be greatly appreciated. #############LOG OF TELNET SESSION############## Linux/PPC 2000 Q4 Packages current to December 25 2000 Kernel 2.2.18-4hpmac on a ppc login: ausit Password: Last login: Sun Apr 29 06:15:07 from 192.168.168.50 [ausit@pivot ausit]$ su Password: #############ACCESSING POSTGRES############## [root@pivot ausit]# su postgres bash-2.04$ psql -V psql (PostgreSQL) 7.0.3 contains readline, history, multibyte support Portions Copyright (c) 1996-2000, PostgreSQL, Inc Portions Copyright (c) 1996 Regents of the University of California Read the file COPYRIGHT or use the command \copyright to see the usage and distribution terms. bash-2.04$ createdb post_demo CREATE DATABASE bash-2.04$ psql post_demo Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit post_demo=# \d No relations found. post_demo=# create table test_class (yeh int4, nah text); CREATE post_demo=# insert into test_class (yeh, nah) values (123,'one_two_three'); INSERT 19082 1 post_demo=# select * from test_class ; yeh | nah -----+--------------- 123 | one_two_three (1 row) post_demo=# \q bash-2.04$ exit exit [root@pivot ausit]# exit exit #############EXPANDING DBI AND DBD############## [ausit@pivot ausit]$ ls Desktop src [ausit@pivot ausit]$ cd src [ausit@pivot src]$ ll total 3208 -rwxr-xr-x 1 ausit ausit 174080 Apr 29 02:26 DBD-Pg-0.98.tar -rwxr-xr-x 1 ausit ausit 632320 Apr 29 02:26 DBI-1.15.tar -rwxr-xr-x 1 ausit ausit 456331 Apr 29 02:26 apache-1.3.14-2.6.2.ppc.rpm -rwxr-xr-x 1 ausit ausit 110724 Apr 29 02:26 apache-devel-1.3.14-2.6.2.ppc.r -rwxr-xr-x 1 ausit ausit 473057 Apr 29 02:26 apache-manual-1.3.14-2.6.2.ppc. -rwxr-xr-x 1 ausit ausit 1083848 Apr 29 02:26 apache-ssl-1.3.12_1.40-1.ppc.rp -rwxr-xr-x 1 ausit ausit 18089 Apr 29 02:26 perl-Mail-Sendmail-0.77-6.ppc.r drwxr-xr-x 4 ausit ausit 4096 Apr 29 08:07 pg -rw-r--r-- 1 ausit ausit 284204 Apr 29 02:52 tar-1.13.17-5.ppc.rpm [ausit@pivot src]$ tar xvf DBD-Pg-0.98.tar DBD-Pg-0.98/ DBD-Pg-0.98/eg/ DBD-Pg-0.98/eg/ApacheDBI.pl DBD-Pg-0.98/Changes DBD-Pg-0.98/MANIFEST DBD-Pg-0.98/Makefile.PL DBD-Pg-0.98/Pg.h DBD-Pg-0.98/Pg.pm DBD-Pg-0.98/Pg.xs DBD-Pg-0.98/README DBD-Pg-0.98/README.win32 DBD-Pg-0.98/dbd-pg.pod DBD-Pg-0.98/dbdimp.c DBD-Pg-0.98/dbdimp.h DBD-Pg-0.98/test.pl [ausit@pivot src]$ tar xvf DBI-1.15.tar DBI-1.15/ DBI-1.15/lib/ DBI-1.15/lib/DBD/ DBI-1.15/lib/DBD/ExampleP.pm DBI-1.15/lib/DBD/Proxy.pm DBI-1.15/lib/DBD/NullP.pm DBI-1.15/lib/DBD/Sponge.pm DBI-1.15/lib/DBD/Multiplex.pm DBI-1.15/lib/DBD/ADO.pm DBI-1.15/lib/DBI/ DBI-1.15/lib/DBI/Shell.pm DBI-1.15/lib/DBI/FAQ.pm DBI-1.15/lib/DBI/ProxyServer.pm DBI-1.15/lib/DBI/DBD.pm DBI-1.15/lib/DBI/W32ODBC.pm DBI-1.15/lib/DBI/Format.pm DBI-1.15/lib/Bundle/ DBI-1.15/lib/Bundle/DBI.pm DBI-1.15/lib/Win32/ DBI-1.15/lib/Win32/DBIODBC.pm DBI-1.15/DBI.xs DBI-1.15/t/ DBI-1.15/t/meta.t DBI-1.15/t/dbidrv.t DBI-1.15/t/examp.t DBI-1.15/t/subclass.t DBI-1.15/t/proxy.t DBI-1.15/t/basics.t DBI-1.15/t/shell.t DBI-1.15/Perl.xs DBI-1.15/DBIXS.h DBI-1.15/MANIFEST DBI-1.15/Driver.xst DBI-1.15/Changes DBI-1.15/dbipport.h DBI-1.15/Makefile.PL DBI-1.15/test.pl DBI-1.15/README DBI-1.15/dbd_xsh.h DBI-1.15/dbish.PL DBI-1.15/dbi_sql.h DBI-1.15/ToDo DBI-1.15/DBI.pm DBI-1.15/dbiproxy.PL [ausit@pivot src]$ ll total 3216 drwxr-xr-x 3 ausit ausit 4096 Apr 25 21:50 DBD-Pg-0.98 -rwxr-xr-x 1 ausit ausit 174080 Apr 29 02:26 DBD-Pg-0.98.tar drwxr-xr-x 4 ausit ausit 4096 Mar 31 00:57 DBI-1.15 -rwxr-xr-x 1 ausit ausit 632320 Apr 29 02:26 DBI-1.15.tar -rwxr-xr-x 1 ausit ausit 456331 Apr 29 02:26 apache-1.3.14-2.6.2.ppc.rpm -rwxr-xr-x 1 ausit ausit 110724 Apr 29 02:26 apache-devel-1.3.14-2.6.2.ppc.r -rwxr-xr-x 1 ausit ausit 473057 Apr 29 02:26 apache-manual-1.3.14-2.6.2.ppc. -rwxr-xr-x 1 ausit ausit 1083848 Apr 29 02:26 apache-ssl-1.3.12_1.40-1.ppc.rp -rwxr-xr-x 1 ausit ausit 18089 Apr 29 02:26 perl-Mail-Sendmail-0.77-6.ppc.r drwxr-xr-x 4 ausit ausit 4096 Apr 29 08:07 pg -rw-r--r-- 1 ausit ausit 284204 Apr 29 02:52 tar-1.13.17-5.ppc.rpm #############INSTALLING DBI ############## [ausit@pivot src]$ cd DBI-1.15 [ausit@pivot DBI-1.15]$ su Password: [root@pivot DBI-1.15]# perl Makefile.PL *** Note: The optional PlRPC-modules (RPC::PlServer etc) are not installed. If you want to use the DBD::Proxy driver and DBI::ProxyServer modules, then you'll need to install the RPC::PlServer, RPC::PlClient, Storable and Net::Daemon modules. The CPAN Bundle::DBI may help you. You can install them any time after installing the DBI. You do *not* need these modules for typical DBI usage. Optional modules are available from any CPAN mirror, in particular http://www.perl.com/CPAN/modules/by-module http://www.perl.org/CPAN/modules/by-module ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module Checking if your kit is complete... Looks good Writing Makefile for DBI Remember to actually *read* the README file! Use 'make' to build the software (dmake or nmake on Windows). Then 'make test' to execute self tests. Then 'make install' to install the DBI and then delete this working directory before unpacking and building any DBD::* drivers. [root@pivot DBI-1.15]# make mkdir blib mkdir blib/lib mkdir blib/arch mkdir blib/arch/auto mkdir blib/arch/auto/DBI mkdir blib/lib/auto mkdir blib/lib/auto/DBI mkdir blib/man1 mkdir blib/man3 cp lib/DBI/W32ODBC.pm blib/lib/DBI/W32ODBC.pm cp lib/DBD/ExampleP.pm blib/lib/DBD/ExampleP.pm cp lib/DBI/Shell.pm blib/lib/DBI/Shell.pm cp lib/DBI/FAQ.pm blib/lib/DBI/FAQ.pm cp lib/DBI/ProxyServer.pm blib/lib/DBI/ProxyServer.pm cp lib/Bundle/DBI.pm blib/lib/Bundle/DBI.pm cp lib/DBD/Proxy.pm blib/lib/DBD/Proxy.pm cp lib/DBD/Multiplex.pm blib/lib/DBD/Multiplex.pm cp DBIXS.h blib/arch/auto/DBI/DBIXS.h cp dbd_xsh.h blib/arch/auto/DBI/dbd_xsh.h cp dbi_sql.h blib/arch/auto/DBI/dbi_sql.h cp lib/DBD/NullP.pm blib/lib/DBD/NullP.pm cp lib/DBD/Sponge.pm blib/lib/DBD/Sponge.pm cp lib/DBI/Format.pm blib/lib/DBI/Format.pm cp Driver.xst blib/arch/auto/DBI/Driver.xst cp lib/DBI/DBD.pm blib/lib/DBI/DBD.pm cp lib/Win32/DBIODBC.pm blib/lib/Win32/DBIODBC.pm cp DBI.pm blib/lib/DBI.pm cp dbipport.h blib/arch/auto/DBI/dbipport.h cp lib/DBD/ADO.pm blib/lib/DBD/ADO.pm /usr/bin/perl -p -e "s/~DRIVER~/Perl/g" < blib/arch/auto/DBI/Driver.xst > Perl.xsi /usr/bin/perl -I/usr/lib/perl5/5.00503/ppc-linux -I/usr/lib/perl5/5.00503 /usr/lib/perl5/5.00503/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.00503/ExtUtils/typemap Perl.xs >xst mp.c && mv xstmp.c Perl.c cc -c -Dbool=char -DHAS_BOOL -O2 -fsigned-char -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" -fpic -I/usr/lib/perl5/5.00503/ppc-linux/CORE -DDBI_NO_THREADS Perl.c make test/usr/bin/perl -I/usr/lib/perl5/5.00503/ppc-linux -I/usr/lib/perl5/5.00503 /usr/lib/perl5/5.00503/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.00503/ExtUtils/typemap DBI .xs >xstmp.c && mv xstmp.c DBI.c cc -c -Dbool=char -DHAS_BOOL -O2 -fsigned-char -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" -fpic -I/usr/lib/perl5/5.00503/ppc-linux/CORE -DDBI_NO_THREADS DBI.c Running Mkbootstrap for DBI () chmod 644 DBI.bs LD_RUN_PATH="" cc -o blib/arch/auto/DBI/DBI.so -shared -L/usr/local/lib DBI.o chmod 755 blib/arch/auto/DBI/DBI.so cp DBI.bs blib/arch/auto/DBI/DBI.bs chmod 644 blib/arch/auto/DBI/DBI.bs /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/ppc-linux -I/usr/lib/perl5/5.00503 dbiproxy.PL dbiproxy Extracted dbiproxy from dbiproxy.PL with variable substitutions. mkdir blib/script cp dbiproxy blib/script/dbiproxy /usr/bin/perl -I/usr/lib/perl5/5.00503/ppc-linux -I/usr/lib/perl5/5.00503 -MExtUtils::MakeMaker -e "MY->fixin(shift)" blib/script/dbiproxy /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/ppc-linux -I/usr/lib/perl5/5.00503 dbish.PL dbish Extracted dbish from dbish.PL with variable substitutions. cp dbish blib/script/dbish /usr/bin/perl -I/usr/lib/perl5/5.00503/ppc-linux -I/usr/lib/perl5/5.00503 -MExtUtils::MakeMaker -e "MY->fixin(shift)" blib/script/dbish Manifying blib/man1/dbiproxy.1 Manifying blib/man3/DBI::W32ODBC.3 Manifying blib/man3/DBI::FAQ.3 Manifying blib/man3/DBI::Shell.3 Manifying blib/man3/DBI::Format.3 Manifying blib/man3/DBI::ProxyServer.3 Manifying blib/man3/Bundle::DBI.3 Manifying blib/man3/DBI::DBD.3 Manifying blib/man1/dbish.1 Manifying blib/man3/DBI.3 Manifying blib/man3/Win32::DBIODBC.3 Manifying blib/man3/DBD::Proxy.3 Manifying blib/man3/DBD::Multiplex.3 Manifying blib/man3/DBD::ADO.3 [root@pivot DBI-1.15]# make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/ppc-linux -I/usr/lib/perl5/5.00503 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; ru ntests @ARGV;' t/*.t t/basics............ok t/dbidrv............ok t/examp.............ok t/meta..............ok t/proxy.............skipping test on this platform t/shell.............ok t/subclass..........ok All tests successful, 1 test skipped. Files=7, Tests=183, 4 wallclock secs ( 3.28 cusr + 0.39 csys = 3.67 CPU) PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/ppc-linux -I/usr/lib/perl5/5.00503 test.pl test.pl DBI test application $Revision: 10.5 $ Using /home/ausit/src/DBI-1.15/blib Switch: DBI 1.15 by Tim Bunce, 1.15 Available Drivers: ADO, ExampleP, Multiplex, Pg, Proxy dbi:ExampleP:: testing 5 sets of 20 connections: Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Made 100 connections in 0 wallclock secs ( 0.12 usr + 0.00 sys = 0.12 CPU) Testing handle creation speed... 5000 NullP statement handles cycled in 3.6 cpu+sys seconds (1388 per sec) test.pl done [root@pivot DBI-1.15]# make install Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/auto/DBI/DBIXS.h (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/auto/DBI/dbd_xsh.h (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/auto/DBI/dbi_sql.h (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/auto/DBI/Driver.xst (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/auto/DBI/dbipport.h (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/auto/DBI/DBI.so (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/auto/DBI/DBI.bs (unchanged) Files found in blib/arch --> Installing files in blib/lib into architecture dependend library tree! Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBI/W32ODBC.pm (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBI/Shell.pm (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBI/FAQ.pm (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBI/ProxyServer.pm (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBI/Format.pm (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBI/DBD.pm (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBD/ExampleP.pm (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBD/Proxy.pm (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBD/Multiplex.pm (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBD/NullP.pm (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBD/Sponge.pm (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBD/ADO.pm (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/Bundle/DBI.pm (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/Win32/DBIODBC.pm (unchanged) Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBI.pm (unchanged) Skipping /usr/man/man1/dbiproxy.1 (unchanged) Skipping /usr/man/man1/dbish.1 (unchanged) Installing /usr/lib/perl5/man/man3/DBI::W32ODBC.3 Installing /usr/lib/perl5/man/man3/DBI::FAQ.3 Installing /usr/lib/perl5/man/man3/DBI::Shell.3 Installing /usr/lib/perl5/man/man3/DBI::Format.3 Installing /usr/lib/perl5/man/man3/DBI::ProxyServer.3 Installing /usr/lib/perl5/man/man3/Bundle::DBI.3 Installing /usr/lib/perl5/man/man3/DBI::DBD.3 Installing /usr/lib/perl5/man/man3/DBI.3 Installing /usr/lib/perl5/man/man3/Win32::DBIODBC.3 Installing /usr/lib/perl5/man/man3/DBD::Proxy.3 Installing /usr/lib/perl5/man/man3/DBD::Multiplex.3 Installing /usr/lib/perl5/man/man3/DBD::ADO.3 Skipping /usr/bin/dbiproxy (unchanged) Skipping /usr/bin/dbish (unchanged) Writing /usr/lib/perl5/site_perl/5.005/ppc-linux/auto/DBI/.packlist Appending installation info to /usr/lib/perl5/5.00503/ppc-linux/perllocal.pod [root@pivot DBI-1.15]# cd ../DBD-Pg-0.98 [root@pivot DBD-Pg-0.98]# su ausit [ausit@pivot DBD-Pg-0.98]$ ll total 184 -rw-r--r-- 1 ausit ausit 9877 Apr 25 21:29 Changes -rw-r--r-- 1 ausit ausit 119 Sep 30 1999 MANIFEST -rw-r--r-- 1 ausit ausit 1594 Sep 30 1999 Makefile.PL -rw-r--r-- 1 ausit ausit 895 Jul 11 2000 Pg.h -rw-r--r-- 1 ausit ausit 35704 Apr 25 21:29 Pg.pm -rw-r--r-- 1 ausit ausit 14525 Jul 11 2000 Pg.xs -rw-r--r-- 1 ausit ausit 5591 Apr 25 21:29 README -rw-r--r-- 1 ausit ausit 2400 Jul 11 2000 README.win32 -rw-r--r-- 1 ausit ausit 13810 Sep 30 1999 dbd-pg.pod -rw-r--r-- 1 ausit ausit 50355 Apr 25 21:29 dbdimp.c -rw-r--r-- 1 ausit ausit 2164 Apr 10 03:44 dbdimp.h drwxr-xr-x 2 ausit ausit 4096 Apr 25 21:29 eg -rwxr-xr-x 1 ausit ausit 14402 Apr 21 07:01 test.pl #############SETTING POSTGRES ENVIRONMENTS ############## [ausit@pivot DBD-Pg-0.98]$ POSTGRES_INCLUDE=/usr/local/pgsql/include [ausit@pivot DBD-Pg-0.98]$ POSTGRES_LIB=/usr/local/pgsql/lib [ausit@pivot DBD-Pg-0.98]$ export POSTGRES_INCLUDE POSTGRES_LIB [ausit@pivot DBD-Pg-0.98]$ env PWD=/home/ausit/src/DBD-Pg-0.98 POSTGRES_INCLUDE=/usr/local/pgsql/include REMOTEHOST=192.168.168.50 HOSTNAME=pivot QTDIR=/usr/lib/qt-2.2.1 LESSOPEN=|/usr/bin/lesspipe.sh %s KDEDIR=/opt/kde2 USER=ausit LS_COLORS= MACHTYPE=powerpc-redhat-linux-gnu POSTGRES_LIB=/usr/local/pgsql/lib MAIL=/var/spool/mail/ausit INPUTRC=/etc/inputrc BASH_ENV=/home/ausit/.bashrc LOGNAME=ausit SHLVL=3 SHELL=/bin/bash USERNAME= HOSTTYPE=powerpc OSTYPE=linux-gnu HISTSIZE=1000 TERM=vt220 HOME=/home/ausit PATH=/sbin:/usr/sbin:/sbin:/usr/sbin:/usr/kerberos/sbin:/sbin:/usr/sbin:/usr /kerberos/bin:/opt/kde2/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/usr /local/pgsql/bin:/usr/l ib/qt-2.2.1/bin:/home/ausit/bin _=/usr/bin/env #############INSTALLING DBD ############## [ausit@pivot DBD-Pg-0.98]$ perl Makefile.PL Configuring Pg Remember to actually read the README file ! OS: linux Using DBI 1.15 installed in /usr/lib/perl5/site_perl/5.005/ppc-linux/auto/DBI Checking if your kit is complete... Looks good Writing Makefile for DBD::Pg [ausit@pivot DBD-Pg-0.98]$ make mkdir blib mkdir blib/lib mkdir blib/lib/DBD mkdir blib/arch mkdir blib/arch/auto mkdir blib/arch/auto/DBD mkdir blib/arch/auto/DBD/Pg mkdir blib/lib/auto mkdir blib/lib/auto/DBD mkdir blib/lib/auto/DBD/Pg mkdir blib/man3 cp Pg.pm blib/lib/DBD/Pg.pm cp dbd-pg.pod blib/lib/DBD/dbd-pg.pod /usr/bin/perl -I/usr/lib/perl5/5.00503/ppc-linux -I/usr/lib/perl5/5.00503 /usr/lib/perl5/5.00503/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.00503/ExtUtils/typemap Pg.xs >xstmp .c && mv xstmp.c Pg.c cc -c -I/usr/local/pgsql/include -I/usr/lib/perl5/site_perl/5.005/ppc-linux/auto/DBI -Dbool=char -DHAS_BOOL -O2 -fsigned-char -DVERSION=\"0.98\" -DXS_VERSION=\"0.98\" -fpic -I/usr/lib/perl5/5.00503/ppc-linux/CORE Pg.c cc -c -I/usr/local/pgsql/include -I/usr/lib/perl5/site_perl/5.005/ppc-linux/auto/DBI -Dbool=char -DHAS_BOOL -O2 -fsigned-char -DVERSION=\"0.98\" -DXS_VERSION=\"0.98\" -fpic -I/usr/lib/perl5/5.00503/ppc-linux/CORE dbdimp.c Running Mkbootstrap for DBD::Pg () chmod 644 Pg.bs LD_RUN_PATH="/usr/local/pgsql/lib" cc -o blib/arch/auto/DBD/Pg/Pg.so -shared -L/usr/local/lib Pg.o dbdimp.o -L/usr/local/pgsql/lib -lpq chmod 755 blib/arch/auto/DBD/Pg/Pg.so cp Pg.bs blib/arch/auto/DBD/Pg/Pg.bs chmod 644 blib/arch/auto/DBD/Pg/Pg.bs Manifying blib/man3/DBD::Pg.3 Manifying blib/man3/DBD::dbd-pg.3 [ausit@pivot DBD-Pg-0.98]$ make test #############DBD INSTALL FAILURE LOG ############## PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/ppc-linux -I/usr/lib/perl5/5.00503 test.pl OS: linux Use of uninitialized value at test.pl line 53. DBI->data_sources .......... not ok: DBI->connect(dbname=template1) failed: FATAL 1: at test.pl line 59 DBI->connect ............... not ok: FATAL 1: at test.pl line 59. make: *** [test_dynamic] Error 255 #############DBD INSTALL FAILURE LOG ############## ############# PERL VERSION ############## [ausit@pivot DBD-Pg-0.98]$ perl -v This is perl, version 5.005_03 built for ppc-linux Copyright 1987-1999, Larry Wall Perl may be copied only under the terms of either the Artistic License or the GNU General Public License, which may be found in the Perl 5.0 source kit. Complete documentation for Perl, including FAQ lists, should be found on this system using `man perl' or `perldoc perl'. If you have access to the Internet, point your browser at http://www.perl.com/, the Perl Home Page. [ausit@pivot DBD-Pg-0.98]$ #############END OF TELNET SESSION ############## I have tried different users (including root) I have used different path ot envıs. (/usr/lib/pgsql/ & /usr/include/pgsql) Again, if anyone can help me out here, as Iım not having too much luck finding the problem. --B_3071378952_2907587 Content-type: text/html; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable perlDBD::pg error! Please help (have all details in  post)</TIT= LE> </HEAD> <BODY> <FONT FACE=3D"Monaco"><TT>Have attempted  to install DBI and DBD, but = DBD “make test” fails.<BR> Below is my complete  procedure , starting from:<BR> <BR> Accessing  PostgreSQL from the command line, (successful)<BR>  creating  a database, populating. (successful)<BR> Expanding  DBI and DBD. (successful)<BR> Installing  DBI  (seemingly successful)<BR> Set environments. (successful)<BR> Install DBD.  (error occur on “test”)<BR> <BR> So now I’m hoping someone can help me out....<BR> <BR> I think I have included all the version information throughout the procedur= e.  <BR> if not please let me know.<BR> <BR> <BR> Any assistance  would be greatly appreciated.<BR> <BR> <BR> <BR> <BR> #############LOG  OF TELNET SESSION##############<BR> <BR> Linux/PPC 2000 Q4<BR> Packages current to December 25 2000<BR> Kernel 2.2.18-4hpmac on a ppc<BR> login: ausit<BR> Password:<BR> Last login: Sun Apr 29 06:15:07 from 192.168.168.50<BR> [ausit@pivot ausit]$ su<BR> Password:<BR> <BR> #############ACCESSING  POSTGRES##############<BR> <BR> [root@pivot ausit]# su postgres<BR> bash-2.04$ psql -V<BR> psql (PostgreSQL) 7.0.3<BR> contains readline, history, multibyte support<BR> Portions Copyright (c) 1996-2000, PostgreSQL, Inc<BR> Portions Copyright (c) 1996 Regents of the University of California<BR> Read the file COPYRIGHT or use the command \copyright to see the<BR> usage and distribution terms.<BR> bash-2.04$ createdb post_demo<BR> CREATE DATABASE<BR> bash-2.04$ psql post_demo<BR> Welcome to psql, the PostgreSQL interactive terminal.<BR> <BR> Type:  \copyright for distribution terms<BR>        \h for help with SQL commands<BR>        \? for help on internal slash com= mands<BR>        \g or terminate with semicolon to= execute query<BR>        \q to quit<BR> <BR> post_demo=3D# \d<BR> No relations found.<BR> post_demo=3D# create table test_class (yeh int4, nah text);<BR> CREATE<BR> post_demo=3D# insert into test_class (yeh, nah) values (123,'one_two_three'= );<BR> INSERT 19082 1<BR> post_demo=3D# select * from test_class ;<BR>  yeh |      nah<BR> -----+---------------<BR>  123 | one_two_three<BR> (1 row)<BR> <BR> post_demo=3D# \q<BR> bash-2.04$ exit<BR> exit<BR> [root@pivot ausit]# exit<BR> exit<BR> <BR> #############EXPANDING    DBI AND   DBD###########= ###<BR> <BR> [ausit@pivot ausit]$ ls<BR> Desktop  src<BR> [ausit@pivot ausit]$ cd src<BR> [ausit@pivot src]$ ll<BR> total 3208<BR> -rwxr-xr-x    1 ausit    ausit   &n= bsp;  174080 Apr 29 02:26 DBD-Pg-0.98.tar<BR> -rwxr-xr-x    1 ausit    ausit   &n= bsp;  632320 Apr 29 02:26 DBI-1.15.tar<BR> -rwxr-xr-x    1 ausit    ausit   &n= bsp;  456331 Apr 29 02:26 apache-1.3.14-2.6.2.ppc.rpm<BR> -rwxr-xr-x    1 ausit    ausit   &n= bsp;  110724 Apr 29 02:26 apache-devel-1.3.14-2.6.2.ppc.r<BR> -rwxr-xr-x    1 ausit    ausit   &n= bsp;  473057 Apr 29 02:26 apache-manual-1.3.14-2.6.2.ppc.<BR> -rwxr-xr-x    1 ausit    ausit   &n= bsp; 1083848 Apr 29 02:26 apache-ssl-1.3.12_1.40-1.ppc.rp<BR> -rwxr-xr-x    1 ausit    ausit   &n= bsp;   18089 Apr 29 02:26 perl-Mail-Sendmail-0.77-6.ppc.r<BR> drwxr-xr-x    4 ausit    ausit   &n= bsp;    4096 Apr 29 08:07 pg<BR> -rw-r--r--    1 ausit    ausit   &n= bsp;  284204 Apr 29 02:52 tar-1.13.17-5.ppc.rpm<BR> [ausit@pivot src]$ tar xvf DBD-Pg-0.98.tar<BR> DBD-Pg-0.98/<BR> DBD-Pg-0.98/eg/<BR> DBD-Pg-0.98/eg/ApacheDBI.pl<BR> DBD-Pg-0.98/Changes<BR> DBD-Pg-0.98/MANIFEST<BR> DBD-Pg-0.98/Makefile.PL<BR> DBD-Pg-0.98/Pg.h<BR> DBD-Pg-0.98/Pg.pm<BR> DBD-Pg-0.98/Pg.xs<BR> DBD-Pg-0.98/README<BR> DBD-Pg-0.98/README.win32<BR> DBD-Pg-0.98/dbd-pg.pod<BR> DBD-Pg-0.98/dbdimp.c<BR> DBD-Pg-0.98/dbdimp.h<BR> DBD-Pg-0.98/test.pl<BR> [ausit@pivot src]$ tar xvf DBI-1.15.tar<BR> DBI-1.15/<BR> DBI-1.15/lib/<BR> DBI-1.15/lib/DBD/<BR> DBI-1.15/lib/DBD/ExampleP.pm<BR> DBI-1.15/lib/DBD/Proxy.pm<BR> DBI-1.15/lib/DBD/NullP.pm<BR> DBI-1.15/lib/DBD/Sponge.pm<BR> DBI-1.15/lib/DBD/Multiplex.pm<BR> DBI-1.15/lib/DBD/ADO.pm<BR> DBI-1.15/lib/DBI/<BR> DBI-1.15/lib/DBI/Shell.pm<BR> DBI-1.15/lib/DBI/FAQ.pm<BR> DBI-1.15/lib/DBI/ProxyServer.pm<BR> DBI-1.15/lib/DBI/DBD.pm<BR> DBI-1.15/lib/DBI/W32ODBC.pm<BR> DBI-1.15/lib/DBI/Format.pm<BR> DBI-1.15/lib/Bundle/<BR> DBI-1.15/lib/Bundle/DBI.pm<BR> DBI-1.15/lib/Win32/<BR> DBI-1.15/lib/Win32/DBIODBC.pm<BR> DBI-1.15/DBI.xs<BR> DBI-1.15/t/<BR> DBI-1.15/t/meta.t<BR> DBI-1.15/t/dbidrv.t<BR> DBI-1.15/t/examp.t<BR> DBI-1.15/t/subclass.t<BR> DBI-1.15/t/proxy.t<BR> DBI-1.15/t/basics.t<BR> DBI-1.15/t/shell.t<BR> DBI-1.15/Perl.xs<BR> DBI-1.15/DBIXS.h<BR> DBI-1.15/MANIFEST<BR> DBI-1.15/Driver.xst<BR> DBI-1.15/Changes<BR> DBI-1.15/dbipport.h<BR> DBI-1.15/Makefile.PL<BR> DBI-1.15/test.pl<BR> DBI-1.15/README<BR> DBI-1.15/dbd_xsh.h<BR> DBI-1.15/dbish.PL<BR> DBI-1.15/dbi_sql.h<BR> DBI-1.15/ToDo<BR> DBI-1.15/DBI.pm<BR> DBI-1.15/dbiproxy.PL<BR> [ausit@pivot src]$ ll<BR> total 3216<BR> drwxr-xr-x    3 ausit    ausit   &n= bsp;    4096 Apr 25 21:50 DBD-Pg-0.98<BR> -rwxr-xr-x    1 ausit    ausit   &n= bsp;  174080 Apr 29 02:26 DBD-Pg-0.98.tar<BR> drwxr-xr-x    4 ausit    ausit   &n= bsp;    4096 Mar 31 00:57 DBI-1.15<BR> -rwxr-xr-x    1 ausit    ausit   &n= bsp;  632320 Apr 29 02:26 DBI-1.15.tar<BR> -rwxr-xr-x    1 ausit    ausit   &n= bsp;  456331 Apr 29 02:26 apache-1.3.14-2.6.2.ppc.rpm<BR> -rwxr-xr-x    1 ausit    ausit   &n= bsp;  110724 Apr 29 02:26 apache-devel-1.3.14-2.6.2.ppc.r<BR> -rwxr-xr-x    1 ausit    ausit   &n= bsp;  473057 Apr 29 02:26 apache-manual-1.3.14-2.6.2.ppc.<BR> -rwxr-xr-x    1 ausit    ausit   &n= bsp; 1083848 Apr 29 02:26 apache-ssl-1.3.12_1.40-1.ppc.rp<BR> -rwxr-xr-x    1 ausit    ausit   &n= bsp;   18089 Apr 29 02:26 perl-Mail-Sendmail-0.77-6.ppc.r<BR> drwxr-xr-x    4 ausit    ausit   &n= bsp;    4096 Apr 29 08:07 pg<BR> -rw-r--r--    1 ausit    ausit   &n= bsp;  284204 Apr 29 02:52 tar-1.13.17-5.ppc.rpm<BR> <BR> #############INSTALLING    DBI  ##############<BR> <BR> [ausit@pivot src]$ cd DBI-1.15<BR> [ausit@pivot DBI-1.15]$ su<BR> Password:<BR> [root@pivot DBI-1.15]# perl Makefile.PL<BR> *** Note:<BR>     The optional PlRPC-modules (RPC::PlServer etc) are = not installed.<BR>     If you want to use the DBD::Proxy driver and DBI::P= roxyServer<BR>     modules, then you'll need to install the RPC::PlSer= ver, RPC::PlClient,<BR>     Storable and Net::Daemon modules. The CPAN Bundle::= DBI may help you.<BR>     You can install them any time after installing the = DBI.<BR>     You do *not* need these modules for typical DBI usa= ge.<BR> <BR> Optional modules are available from any CPAN mirror, in particular<BR>     http://www.perl.com/CPAN/modules/by-module<BR>     http://www.perl.org/CPAN/modules/by-module<BR>     ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/= by-module<BR> <BR> Checking if your kit is complete...<BR> Looks good<BR> Writing Makefile for DBI<BR> <BR>     Remember to actually *read* the README file!<BR>     Use  'make' to build the software (dmake or nm= ake on Windows).<BR>     Then 'make test' to execute self tests.<BR>     Then 'make install' to install the DBI and then del= ete this working<BR>     directory before unpacking and building any DBD::* = drivers.<BR> <BR> [root@pivot DBI-1.15]# make<BR> mkdir blib<BR> mkdir blib/lib<BR> mkdir blib/arch<BR> mkdir blib/arch/auto<BR> mkdir blib/arch/auto/DBI<BR> mkdir blib/lib/auto<BR> mkdir blib/lib/auto/DBI<BR> mkdir blib/man1<BR> mkdir blib/man3<BR> cp lib/DBI/W32ODBC.pm blib/lib/DBI/W32ODBC.pm<BR> cp lib/DBD/ExampleP.pm blib/lib/DBD/ExampleP.pm<BR> cp lib/DBI/Shell.pm blib/lib/DBI/Shell.pm<BR> cp lib/DBI/FAQ.pm blib/lib/DBI/FAQ.pm<BR> cp lib/DBI/ProxyServer.pm blib/lib/DBI/ProxyServer.pm<BR> cp lib/Bundle/DBI.pm blib/lib/Bundle/DBI.pm<BR> cp lib/DBD/Proxy.pm blib/lib/DBD/Proxy.pm<BR> cp lib/DBD/Multiplex.pm blib/lib/DBD/Multiplex.pm<BR> cp DBIXS.h blib/arch/auto/DBI/DBIXS.h<BR> cp dbd_xsh.h blib/arch/auto/DBI/dbd_xsh.h<BR> cp dbi_sql.h blib/arch/auto/DBI/dbi_sql.h<BR> cp lib/DBD/NullP.pm blib/lib/DBD/NullP.pm<BR> cp lib/DBD/Sponge.pm blib/lib/DBD/Sponge.pm<BR> cp lib/DBI/Format.pm blib/lib/DBI/Format.pm<BR> cp Driver.xst blib/arch/auto/DBI/Driver.xst<BR> cp lib/DBI/DBD.pm blib/lib/DBI/DBD.pm<BR> cp lib/Win32/DBIODBC.pm blib/lib/Win32/DBIODBC.pm<BR> cp DBI.pm blib/lib/DBI.pm<BR> cp dbipport.h blib/arch/auto/DBI/dbipport.h<BR> cp lib/DBD/ADO.pm blib/lib/DBD/ADO.pm<BR> /usr/bin/perl -p -e "s/~DRIVER~/Perl/g" < blib/arch/auto/DBI/D= river.xst > Perl.xsi<BR> /usr/bin/perl -I/usr/lib/perl5/5.00503/ppc-linux -I/usr/lib/perl5/5.00503 /= usr/lib/perl5/5.00503/ExtUtils/xsubpp  -typemap /usr/lib/perl5/5.00503= /ExtUtils/typemap Perl.xs >xst<BR> mp.c && mv xstmp.c Perl.c<BR> cc -c  -Dbool=3Dchar -DHAS_BOOL -O2 -fsigned-char    -D= VERSION=3D\"1.15\" -DXS_VERSION=3D\"1.15\" -fpic -I/usr= /lib/perl5/5.00503/ppc-linux/CORE -DDBI_NO_THREADS Perl.c<BR> make test/usr/bin/perl -I/usr/lib/perl5/5.00503/ppc-linux -I/usr/lib/perl5/= 5.00503 /usr/lib/perl5/5.00503/ExtUtils/xsubpp  -typemap /usr/lib/perl= 5/5.00503/ExtUtils/typemap DBI<BR> .xs >xstmp.c && mv xstmp.c DBI.c<BR> cc -c  -Dbool=3Dchar -DHAS_BOOL -O2 -fsigned-char    -D= VERSION=3D\"1.15\" -DXS_VERSION=3D\"1.15\" -fpic -I/usr= /lib/perl5/5.00503/ppc-linux/CORE -DDBI_NO_THREADS DBI.c<BR> Running Mkbootstrap for DBI ()<BR> chmod 644 DBI.bs<BR> LD_RUN_PATH=3D"" cc -o blib/arch/auto/DBI/DBI.so  -shared -L= /usr/local/lib DBI.o<BR> chmod 755 blib/arch/auto/DBI/DBI.so<BR> cp DBI.bs blib/arch/auto/DBI/DBI.bs<BR> chmod 644 blib/arch/auto/DBI/DBI.bs<BR> /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/ppc-linux -I/= usr/lib/perl5/5.00503 dbiproxy.PL dbiproxy<BR> Extracted dbiproxy from dbiproxy.PL with variable substitutions.<BR> mkdir blib/script<BR> cp dbiproxy blib/script/dbiproxy<BR> /usr/bin/perl -I/usr/lib/perl5/5.00503/ppc-linux -I/usr/lib/perl5/5.00503 -= MExtUtils::MakeMaker -e "MY->fixin(shift)" blib/script/dbiprox= y<BR> /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/ppc-linux -I/= usr/lib/perl5/5.00503 dbish.PL dbish<BR> Extracted dbish from dbish.PL with variable substitutions.<BR> cp dbish blib/script/dbish<BR> /usr/bin/perl -I/usr/lib/perl5/5.00503/ppc-linux -I/usr/lib/perl5/5.00503 -= MExtUtils::MakeMaker -e "MY->fixin(shift)" blib/script/dbish<B= R> Manifying blib/man1/dbiproxy.1<BR> Manifying blib/man3/DBI::W32ODBC.3<BR> Manifying blib/man3/DBI::FAQ.3<BR> Manifying blib/man3/DBI::Shell.3<BR> Manifying blib/man3/DBI::Format.3<BR> Manifying blib/man3/DBI::ProxyServer.3<BR> Manifying blib/man3/Bundle::DBI.3<BR> Manifying blib/man3/DBI::DBD.3<BR> Manifying blib/man1/dbish.1<BR> Manifying blib/man3/DBI.3<BR> Manifying blib/man3/Win32::DBIODBC.3<BR> Manifying blib/man3/DBD::Proxy.3<BR> Manifying blib/man3/DBD::Multiplex.3<BR> Manifying blib/man3/DBD::ADO.3<BR> [root@pivot DBI-1.15]# make test<BR> PERL_DL_NONLAZY=3D1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5= .00503/ppc-linux -I/usr/lib/perl5/5.00503 -e 'use Test::Harness qw(&run= tests $verbose); $verbose=3D0; ru<BR> ntests @ARGV;' t/*.t<BR> t/basics............ok<BR> t/dbidrv............ok<BR> t/examp.............ok<BR> t/meta..............ok<BR> t/proxy.............skipping test on this platform<BR> t/shell.............ok<BR> t/subclass..........ok<BR> All tests successful, 1 test skipped.<BR> Files=3D7,  Tests=3D183,  4 wallclock secs ( 3.28 cusr +  0.= 39 csys =3D  3.67 CPU)<BR> PERL_DL_NONLAZY=3D1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5= .00503/ppc-linux -I/usr/lib/perl5/5.00503 test.pl<BR> test.pl<BR> DBI test application $Revision: 10.5 $<BR> Using /home/ausit/src/DBI-1.15/blib<BR> Switch: DBI 1.15 by Tim Bunce, 1.15<BR> Available Drivers: ADO, ExampleP, Multiplex, Pg, Proxy<BR> dbi:ExampleP:: testing 5 sets of 20 connections:<BR> Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20<BR> Disconnecting...<BR> Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20<BR> Disconnecting...<BR> Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20<BR> Disconnecting...<BR> Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20<BR> Disconnecting...<BR> Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20<BR> Disconnecting...<BR> Made 100 connections in  0 wallclock secs ( 0.12 usr +  0.00 sys = =3D  0.12 CPU)<BR> <BR> Testing handle creation speed...<BR> 5000 NullP statement handles cycled in 3.6 cpu+sys seconds (1388 per sec)<B= R> <BR> test.pl done<BR> [root@pivot DBI-1.15]# make install<BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/auto/DBI/DBIXS.h (unchang= ed)<BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/auto/DBI/dbd_xsh.h (uncha= nged)<BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/auto/DBI/dbi_sql.h (uncha= nged)<BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/auto/DBI/Driver.xst (unch= anged)<BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/auto/DBI/dbipport.h (unch= anged)<BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/auto/DBI/DBI.so (unchange= d)<BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/auto/DBI/DBI.bs (unchange= d)<BR> Files found in blib/arch --> Installing files in blib/lib into architect= ure dependend library tree!<BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBI/W32ODBC.pm (unchanged= )<BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBI/Shell.pm (unchanged)<= BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBI/FAQ.pm (unchanged)<BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBI/ProxyServer.pm (uncha= nged)<BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBI/Format.pm (unchanged)= <BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBI/DBD.pm (unchanged)<BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBD/ExampleP.pm (unchange= d)<BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBD/Proxy.pm (unchanged)<= BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBD/Multiplex.pm (unchang= ed)<BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBD/NullP.pm (unchanged)<= BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBD/Sponge.pm (unchanged)= <BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBD/ADO.pm (unchanged)<BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/Bundle/DBI.pm (unchanged)= <BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/Win32/DBIODBC.pm (unchang= ed)<BR> Skipping /usr/lib/perl5/site_perl/5.005/ppc-linux/DBI.pm (unchanged)<BR> Skipping /usr/man/man1/dbiproxy.1 (unchanged)<BR> Skipping /usr/man/man1/dbish.1 (unchanged)<BR> Installing /usr/lib/perl5/man/man3/DBI::W32ODBC.3<BR> Installing /usr/lib/perl5/man/man3/DBI::FAQ.3<BR> Installing /usr/lib/perl5/man/man3/DBI::Shell.3<BR> Installing /usr/lib/perl5/man/man3/DBI::Format.3<BR> Installing /usr/lib/perl5/man/man3/DBI::ProxyServer.3<BR> Installing /usr/lib/perl5/man/man3/Bundle::DBI.3<BR> Installing /usr/lib/perl5/man/man3/DBI::DBD.3<BR> Installing /usr/lib/perl5/man/man3/DBI.3<BR> Installing /usr/lib/perl5/man/man3/Win32::DBIODBC.3<BR> Installing /usr/lib/perl5/man/man3/DBD::Proxy.3<BR> Installing /usr/lib/perl5/man/man3/DBD::Multiplex.3<BR> Installing /usr/lib/perl5/man/man3/DBD::ADO.3<BR> Skipping /usr/bin/dbiproxy (unchanged)<BR> Skipping /usr/bin/dbish (unchanged)<BR> Writing /usr/lib/perl5/site_perl/5.005/ppc-linux/auto/DBI/.packlist<BR> Appending installation info to /usr/lib/perl5/5.00503/ppc-linux/perllocal.p= od<BR> <BR> [root@pivot DBI-1.15]# cd ../DBD-Pg-0.98<BR> [root@pivot DBD-Pg-0.98]# su  ausit<BR> [ausit@pivot DBD-Pg-0.98]$ ll<BR> total 184<BR> -rw-r--r--    1 ausit    ausit   &n= bsp;    9877 Apr 25 21:29 Changes<BR> -rw-r--r--    1 ausit    ausit   &n= bsp;     119 Sep 30  1999 MANIFEST<BR> -rw-r--r--    1 ausit    ausit   &n= bsp;    1594 Sep 30  1999 Makefile.PL<BR> -rw-r--r--    1 ausit    ausit   &n= bsp;     895 Jul 11  2000 Pg.h<BR> -rw-r--r--    1 ausit    ausit   &n= bsp;   35704 Apr 25 21:29 Pg.pm<BR> -rw-r--r--    1 ausit    ausit   &n= bsp;   14525 Jul 11  2000 Pg.xs<BR> -rw-r--r--    1 ausit    ausit   &n= bsp;    5591 Apr 25 21:29 README<BR> -rw-r--r--    1 ausit    ausit   &n= bsp;    2400 Jul 11  2000 README.win32<BR> -rw-r--r--    1 ausit    ausit   &n= bsp;   13810 Sep 30  1999 dbd-pg.pod<BR> -rw-r--r--    1 ausit    ausit   &n= bsp;   50355 Apr 25 21:29 dbdimp.c<BR> -rw-r--r--    1 ausit    ausit   &n= bsp;    2164 Apr 10 03:44 dbdimp.h<BR> drwxr-xr-x    2 ausit    ausit   &n= bsp;    4096 Apr 25 21:29 eg<BR> -rwxr-xr-x    1 ausit    ausit   &n= bsp;   14402 Apr 21 07:01 test.pl<BR> <BR> #############SETTING   POSTGRES    ENVIRONMENTS &n= bsp;##############<BR> <BR> <BR> [ausit@pivot DBD-Pg-0.98]$ POSTGRES_INCLUDE=3D/usr/local/pgsql/include<BR> [ausit@pivot DBD-Pg-0.98]$ POSTGRES_LIB=3D/usr/local/pgsql/lib<BR> [ausit@pivot DBD-Pg-0.98]$ export POSTGRES_INCLUDE POSTGRES_LIB<BR> [ausit@pivot DBD-Pg-0.98]$ env<BR> PWD=3D/home/ausit/src/DBD-Pg-0.98<BR> POSTGRES_INCLUDE=3D/usr/local/pgsql/include<BR> REMOTEHOST=3D192.168.168.50<BR> HOSTNAME=3Dpivot<BR> QTDIR=3D/usr/lib/qt-2.2.1<BR> LESSOPEN=3D|/usr/bin/lesspipe.sh %s<BR> KDEDIR=3D/opt/kde2<BR> USER=3Dausit<BR> LS_COLORS=3D<BR> MACHTYPE=3Dpowerpc-redhat-linux-gnu<BR> POSTGRES_LIB=3D/usr/local/pgsql/lib<BR> MAIL=3D/var/spool/mail/ausit<BR> INPUTRC=3D/etc/inputrc<BR> BASH_ENV=3D/home/ausit/.bashrc<BR> LOGNAME=3Dausit<BR> SHLVL=3D3<BR> SHELL=3D/bin/bash<BR> USERNAME=3D<BR> HOSTTYPE=3Dpowerpc<BR> OSTYPE=3Dlinux-gnu<BR> HISTSIZE=3D1000<BR> TERM=3Dvt220<BR> HOME=3D/home/ausit<BR> PATH=3D/sbin:/usr/sbin:/sbin:/usr/sbin:/usr/kerberos/sbin:/sbin:/usr/sbin:/= usr/kerberos/bin:/opt/kde2/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:= /usr/local/pgsql/bin:/usr/l<BR> ib/qt-2.2.1/bin:/home/ausit/bin<BR> _=3D/usr/bin/env<BR> <BR> #############INSTALLING    DBD  ##############<BR> <BR> <BR> [ausit@pivot DBD-Pg-0.98]$ perl Makefile.PL<BR> Configuring Pg<BR> Remember to actually read the README file !<BR> OS: linux<BR> Using DBI 1.15 installed in /usr/lib/perl5/site_perl/5.005/ppc-linux/auto/D= BI<BR> Checking if your kit is complete...<BR> Looks good<BR> Writing Makefile for DBD::Pg<BR> [ausit@pivot DBD-Pg-0.98]$ make<BR> mkdir blib<BR> mkdir blib/lib<BR> mkdir blib/lib/DBD<BR> mkdir blib/arch<BR> mkdir blib/arch/auto<BR> mkdir blib/arch/auto/DBD<BR> mkdir blib/arch/auto/DBD/Pg<BR> mkdir blib/lib/auto<BR> mkdir blib/lib/auto/DBD<BR> mkdir blib/lib/auto/DBD/Pg<BR> mkdir blib/man3<BR> cp Pg.pm blib/lib/DBD/Pg.pm<BR> cp dbd-pg.pod blib/lib/DBD/dbd-pg.pod<BR> /usr/bin/perl -I/usr/lib/perl5/5.00503/ppc-linux -I/usr/lib/perl5/5.00503 /= usr/lib/perl5/5.00503/ExtUtils/xsubpp  -typemap /usr/lib/perl5/5.00503= /ExtUtils/typemap Pg.xs >xstmp<BR> .c && mv xstmp.c Pg.c<BR> cc -c -I/usr/local/pgsql/include -I/usr/lib/perl5/site_perl/5.005/ppc-linux= /auto/DBI -Dbool=3Dchar -DHAS_BOOL -O2 -fsigned-char    -DVE= RSION=3D\"0.98\" -DXS_VERSION=3D\"0.98\" -fpic<BR>  -I/usr/lib/perl5/5.00503/ppc-linux/CORE  Pg.c<BR> cc -c -I/usr/local/pgsql/include -I/usr/lib/perl5/site_perl/5.005/ppc-linux= /auto/DBI -Dbool=3Dchar -DHAS_BOOL -O2 -fsigned-char    -DVE= RSION=3D\"0.98\" -DXS_VERSION=3D\"0.98\" -fpic<BR>  -I/usr/lib/perl5/5.00503/ppc-linux/CORE  dbdimp.c<BR> Running Mkbootstrap for DBD::Pg ()<BR> chmod 644 Pg.bs<BR> LD_RUN_PATH=3D"/usr/local/pgsql/lib" cc -o blib/arch/auto/DBD/Pg/= Pg.so  -shared -L/usr/local/lib Pg.o dbdimp.o    -L/usr= /local/pgsql/lib -lpq<BR> chmod 755 blib/arch/auto/DBD/Pg/Pg.so<BR> cp Pg.bs blib/arch/auto/DBD/Pg/Pg.bs<BR> chmod 644 blib/arch/auto/DBD/Pg/Pg.bs<BR> Manifying blib/man3/DBD::Pg.3<BR> Manifying blib/man3/DBD::dbd-pg.3<BR> [ausit@pivot DBD-Pg-0.98]$ make test<BR> <BR> <BR> #############DBD INSTALL FAILURE LOG  ##############<BR> <BR> <BR> <BR> PERL_DL_NONLAZY=3D1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5= .00503/ppc-linux -I/usr/lib/perl5/5.00503 test.pl<BR> OS: linux<BR> Use of uninitialized value at test.pl line 53.<BR> DBI->data_sources .......... not ok:<BR> DBI->connect(dbname=3Dtemplate1) failed: FATAL 1: at test.pl line 59<BR> DBI->connect ............... not ok: FATAL 1: at test.pl line 59.<BR> make: *** [test_dynamic] Error 255<BR> <BR> #############DBD INSTALL FAILURE LOG  ##############<BR> <BR> <BR> #############   PERL  VERSION  ##############<BR> <BR> <BR> <BR> [ausit@pivot DBD-Pg-0.98]$ perl -v<BR> <BR> This is perl, version 5.005_03 built for ppc-linux<BR> <BR> Copyright 1987-1999, Larry Wall<BR> <BR> Perl may be copied only under the terms of either the Artistic License or t= he<BR> GNU General Public License, which may be found in the Perl 5.0 source kit.<= BR> <BR> Complete documentation for Perl, including FAQ lists, should be found on<BR> this system using `man perl' or `perldoc perl'.  If you have access to= the<BR> Internet, point your browser at http://www.perl.com/, the Perl Home Page.<B= R> <BR> [ausit@pivot DBD-Pg-0.98]$<BR> <BR> <BR> #############END    OF   TELNET SESSION  ####= ##########<BR> <BR> <BR> <BR> I have tried different users (including  root)<BR> I have used different path ot env’s. (/usr/lib/pgsql/ & /usr/incl= ude/pgsql)<BR> <BR> <BR> <BR> Again, if anyone can help me out here, as I’m not having too much luc= k finding the problem.<BR> </TT></FONT> </BODY> </HTML> --B_3071378952_2907587--