Message-ID: <000501c6cb7f$fa2bfdf0$92dc100a@pchenry>
From: "Henry Jaentschke" <hjaentschke@dgi.gob.ni>
To: <pgsql-interfaces@postgresql.org>
Subject: Hello I have problem with the interface of pgsql for perl.
Date: Tue, 29 Aug 2006 09:29:54 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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=define use5005threads=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