[users@httpd] DBD::Pg Problem or Apache config or environment problem ?

["Swafford, Scott" <Sw...@ndu.edu>]

All,
	Interesting (OK, frustrating) problem. I've installed DBI & DBD::Pg
(1.22) on a Solaris 9 machine w/ perl 5.6.1 (all details below). The basic
problem is I can connect to Postgres just fine from the command line, but it
craps out when I try from a CGI with the below error message:

[Fri Apr 11 18:24:02 2003] [error] [client 198.76.88.44] install_driver(Pg)
failed: Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/Pg/Pg.so' for
module DBD::Pg: ld.so.1: /usr/local/bin/perl: fatal: libgcc_s.so.1: open
failed: No such file or directory at
/usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm line 206., referer:
http://mymerln.ndu.edu/apache.cgi
[Fri Apr 11 18:24:02 2003] [error] [client 198.76.88.44]  at (eval 19) line
3, referer: http://mymerln.ndu.edu/apache.cgi
[Fri Apr 11 18:24:02 2003] [error] [client 198.76.88.44] Compilation failed
in require at (eval 19) line 3., referer: http://mymerln.ndu.edu/apache.cgi
[Fri Apr 11 18:24:02 2003] [error] [client 198.76.88.44] Perhaps a required
shared library or dll isn't installed where expected, referer:
http://mymerln.ndu.edu/apache.cgi

	OK, Apache is configured correctly for CGI, that's not the problem.
	I've tried running Apache as multiple users (nobody, postgres, www)
with various environment variables (making sure the lib files are in their
respective paths), and even reinforced LD_LIBRARY_PATH & PGLIB/POSTGRES_LIB
in both the /etc/init.d startup for apache (as suggested
http://archives.postgresql.org/pgsql-general/1999-01/msg00157.php) and also
the httpd.conf (as suggested
http://otrs.org/docu/problems-with-apache.html).
	I have tried changing the versions of perl (5.8.0 - same), DBI/DBD
modules, all to no avail. 
	It's Solaris, so there's no ldconfig to work on the fly's of
libraries.
Please please please this is driving me insane !
Details below....

Postgres 7.3
Server version: Apache/2.0.44
perl -V is below

Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
  Platform:
    osname=solaris, osvers=2.9, archname=sun4-solaris
    uname='sunos mymerln 5.9 generic_112233-04 sun4u sparc
sunw,sun-blade-100 '
    config_args='-d'
    hint=previous, useposix=true, d_sigaction=define
    usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
    useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
    use64bitint=undef use64bitall=undef uselongdouble=undef
  Compiler:
    cc='gcc', ccflags ='-fno-strict-aliasing -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
    optimize='-O',
    cppflags='-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64'
    ccversion='', gccversion='2.95.3 20010315 (release)',
gccosandvers='solaris2.9'
    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
    alignbytes=8, usemymalloc=y, prototype=define
  Linker and Libraries:
    ld='gcc', ldflags =' -L/usr/local/lib '
    libpth=/usr/local/lib /usr/lib /usr/ccs/lib
    libs=-lsocket -lnsl -ldl -lm -lc
    perllibs=-lsocket -lnsl -ldl -lm -lc
    libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
    cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib'


Characteristics of this binary (from libperl):
  Compile-time options: USE_LARGE_FILES
  Built under solaris
  Compiled at Apr 10 2003 14:47:42
  @INC:
    /usr/local/lib/perl5/5.6.1/sun4-solaris
    /usr/local/lib/perl5/5.6.1
    /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris
    /usr/local/lib/perl5/site_perl/5.6.1
    /usr/local/lib/perl5/site_perl

---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org