Hello I have problem with the interface of pgsql for perl. - Mailing list pgsql-interfaces

Hello.

I have problem with postgres and perl I can not connect to the database, I
had running perl in another computer on suse 9.1 but now I have to migrate
to suse 9.0 Enterprise Server and I installed perl the ones who come with
the distribution, and postgres I installed postgres 8.1.4 the last one, but
I have errors when I try to run a script, at the buttom of this email I
attached the apache error log, if you can give me an advice  to solve this
situation it will be great, thanks.

Atte.
Henry Jaentschke

****************************************************************************
*********************************
Postgres:  PostgreSQL 8.1.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
3.3.3 (SuSE Li
nux)

****************************************************************************
**********************************
pgsql_perl5-1.9.0

****************************************************************************
***********************************

# perl -v

This is perl, v5.8.3 built for i586-linux-thread-multi

Copyright 1987-2003, 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 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.

****************************************************************************
**************************************

# perl -V

Summary of my perl5 (revision 5.0 version 8 subversion 3) configuration: Platform:   osname=linux, osvers=2.6.5,
archname=i586-linux-thread-multi  uname='linux delen 2.6.5 #1 smp wed dec 22 11:54:27 utc 2004 i686 i686
 
i386
gnulinux '




config_args='-ds -e -Dprefix=/usr -Dvendorprefix=/usr -Dinstallusrbinperl -D
usethreads -Di_db -Di_dbm -Di_ndbm -Di_gdbm -Duseshrplib=true -Doptimize=-O2-ma
rch=i586 -mcpu=i686 -fmessage-length=0 -Wall -Wall -pipe'   hint=recommended, useposix=true, d_sigaction=define
usethreads=defineuse5005threads=undef useithreads=define
 
usemultiplicity=de
fine   useperlio=define d_sfio=undef uselargefiles=define usesocks=undef   use64bitint=undef use64bitall=undef
uselongdouble=undef  usemymalloc=n, bincompat5005=undef Compiler:   cc='cc', ccflags
 
='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -fno-stric
t-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',


optimize='-O2 -march=i586 -mcpu=i686 -fmessage-length=0 -Wall -Wall -pipe',




cppflags='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -fno-strict-aliasin
g'   ccversion='', gccversion='3.3.3 (SuSE Linux)', gccosandvers=''   intsize=4, longsize=4, ptrsize=4, doublesize=8,
byteorder=1234  d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12   ivtype='long', ivsize=4,
nvtype='double',nvsize=8, Off_t='off_t',
 
lseeksize
=8   alignbytes=4, prototype=define Linker and Libraries:   ld='cc', ldflags =''   libpth=/lib /usr/lib /usr/local/lib
libs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc   perllibs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc   libc=, so=so,
useshrplib=true,libperl=libperl.so   gnulibc_version='2.3.3' Dynamic Linking:   dlsrc=dl_dlopen.xs, dlext=so,
d_dlsymun=undef,
ccdlflags='-rdynamic -Wl,-rpa
th,/usr/lib/perl5/5.8.3/i586-linux-thread-multi/CORE'   cccdlflags='-fPIC', lddlflags='-shared'

Characteristics of this binary (from libperl): Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES
PERL_IMPLICIT_
CONTEXT Built under linux Compiled at Feb  5 2005 12:21:19 @INC:
/usr/lib/perl5/5.8.3/i586-linux-thread-multi/usr/lib/perl5/site_perl/5.8.3/usr/lib/perl5/site_perl/usr/lib/perl5/vendor_perl/5.8.3/i586-linux-thread-multi/usr/lib/perl5/vendor_perl/5.8.3/usr/lib/perl5/vendor_perl.
****************************************************************************
************************************

APACHE ERROR LOG

ed: Can't locate DBD/Pg.pm in @INC (@INC contains:
/usr/lib/perl5/5.8.3/i586-lin
ux-thread-multi /usr/lib/perl5/5.8.3
/usr/lib/perl5/site_perl/5.8.3/i586-linux-t
hread-multi /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl
/usr/lib/per
l5/vendor_perl/5.8.3/i586-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3 /u
sr/lib/perl5/vendor_perl .) at (eval 22) line 3., referer:
http://sairi.dgi.gob.
ni/sairi/sairi.php?uid=dmFsdGFtaXJhbm8=
[Tue Aug 29 07:23:37 2006] [error] [client 10.16.212.41] Perhaps the DBD::Pg
per
l module hasn't been fully installed,, referer:
http://sairi.dgi.gob.ni/sairi/sa
iri.php?uid=dmFsdGFtaXJhbm8=
[Tue Aug 29 07:23:37 2006] [error] [client 10.16.212.41] or perhaps the
capitali
sation of 'Pg' isn't right., referer:
http://sairi.dgi.gob.ni/sairi/sairi.php?ui
d=dmFsdGFtaXJhbm8=
[Tue Aug 29 07:23:37 2006] [error] [client 10.16.212.41] Available drivers:
Exam
pleP, Proxy, Sponge, mysql., referer:
http://sairi.dgi.gob.ni/sairi/sairi.php?ui
d=dmFsdGFtaXJhbm8=
[Tue Aug 29 07:23:37 2006] [error] [client 10.16.212.41]  at
/webproduccion/dgi-
intra/sairi/scripts/upload.cgi line 95, referer:
http://sairi.dgi.gob.ni/sairi/s
airi.php?uid=dmFsdGFtaXJhbm8=
[Tue Aug 29 07:40:28 2006] [error] [client 10.16.212.41] File does not
exist: /w
ebproduccion/pbancos/images/pto.gif, referer:
http://online.dgi.gob.ni/index.php
[Tue Aug 29 07:40:28 2006] [error] [client 10.16.212.41] File does not
exist: /w
ebproduccion/pbancos/Templates/interna.php_files, referer:
http://online.dgi.gob
.ni/index.php