Hello I have problem with the interface of pgsql for perl.

From: "Henry Jaentschke" <hjaentschke(at)dgi(dot)gob(dot)ni>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: Hello I have problem with the interface of pgsql for perl.
Date: 2006-08-29 15:29:54
Message-ID: 000501c6cb7f$fa2bfdf0$92dc100a@pchenry
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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=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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bijay Singh Bisht 2006-09-04 11:18:34 ODBC Issue
Previous Message Francisco Figueiredo Jr. 2006-08-29 04:13:28 Re: .Net support for Visual Studio