problem in pgsql_perl5 module

Hi ,

Please help me to debug the following error :

I am connecting Postgres using perl module Pg , everything is
working when i am executing perl program from command line.

But when the same thing i am trying to execute from web page i am
getting the following error in error_log :

My simple program :
--------------

#!/Env/perl/digital/bin/perl
require "gensrmspg.pl";
require "cgi-lib.pl";
require "rms_db_call.pl";

file : rms_db_call.pl
---------------
#!/Env/perl/digital/bin/perl

sub get_latest_class
{
use Pg;
my ($base_rel) = @_;
.............
....
...

}

Message in error log of server :
---------------------

Can't load
'/Env/perl/digital/lib/site_perl/5.6.0/alpha-dec_osf/auto/Pg/Pg.so' for
module Pg: dlopen: cannot load
/Env/perl/digital/lib/site_perl/5.6.0/alpha-dec_osf/auto/Pg/Pg.so at
/Env/perl/digital/lib/5.6.0/alpha-dec_osf/DynaLoader.pm line 200.
at rms_db_call.pl line 5
Compilation failed in require at rms_db_call.pl line 5.
BEGIN failed--compilation aborted at rms_db_call.pl line 5.
Compilation failed in require at
/export/home3/web/cgi-bin/srms/login.cgi line 4.
[Sat Feb 2 12:16:50 2002] [error] [client 192.168.50.246] Premature end
of script headers: /export/home3/web/cgi-bin/srms/login.cgi

My make test is seems to be okay
also checked wether the files
that appears in the error message
exist. They exist !!!

perl -v

This is perl, v5.6.0 built for alpha-dec_osf

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

perl -V
Summary of my perl5 (revision 5.0 version 6 subversion 0) configuration:

Platform:
osname=dec_osf, osvers=4.0, archname=alpha-dec_osf
uname='osf1 ws51 v4.0 878 alpha '
config_args=''
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=undef d_sfio=undef uselargefiles=define
use64bitint=define use64bitall=define uselongdouble=undef
usesocks=undef
Compiler:
cc='cc', optimize='-O4', gccversion=
cppflags='-std -ieee -D_INTRINSICS -I/usr/local/include
-DLANGUAGE_C'
ccflags ='-std -fprm d -ieee -D_INTRINSICS -I/usr/local/include
-DLANGUAGE_C'
stdchar='unsigned char', d_stdstdio=define, usevfork=false
intsize=4, longsize=8, ptrsize=8, doublesize=8
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8
ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=8, usemymalloc=y, prototype=define
Linker and Libraries:
ld='ld', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /usr/shlib /usr/ccs/lib /usr/lib/cmplrs/cc
/usr/lib /var/shlib
libs=-lgdbm -ldbm -ldb -lm -liconv
libc=/usr/shlib/libc.so, so=so, useshrplib=true, libperl=libperl.so
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='
-Wl,-rpath,/Env/perl/digital/lib/5.6.0/alpha-dec_osf/CORE'
cccdlflags=' ', lddlflags='-shared -expect_unresolved "*" -msym -std
-s -L/usr/local/lib'

Characteristics of this binary (from libperl):
Compile-time options: USE_64_BIT_INT USE_64_BIT_ALL USE_LARGE_FILES
Built under dec_osf
Compiled at Dec 17 2001 17:30:43
@INC:
/Env/perl/digital/lib/5.6.0/alpha-dec_osf
/Env/perl/digital/lib/5.6.0
/Env/perl/digital/lib/site_perl/5.6.0/alpha-dec_osf
/Env/perl/digital/lib/site_perl/5.6.0
/Env/perl/digital/lib/site_perl
.

postgres 7.1
pgsql_perl5-1.9.0
GNU Make version 3.78.1, by Richard Stallman and Roland McGrath

In httpd
------

suresh_v(at)ws51:~$ httpd -l

Compiled-in modules:
http_core.c
mod_env.c
mod_log_config.c
mod_mime.c
mod_negotiation.c
mod_status.c
mod_include.c
mod_autoindex.c
mod_dir.c
mod_cgi.c
mod_asis.c
mod_imap.c
mod_actions.c
mod_userdir.c
mod_alias.c
mod_access.c
mod_auth.c
mod_setenvif.c

Thanks in anticipation !!!
suresh

_______________________________
| |
|Suresh .V |
|Research Engineer |
|Switching BI |
| |
|Tel: 080-2250300 |
| 080-2263399 Ext.241/373 |
| |
|Email: suresh_v(at)cdotb(dot)ernet(dot)in |
| suresh_78in(at)yahoo(dot)com |
| |
|_______________________________|