Message-Id: <200005022241.PAA04772@ns1.cheetah.net>
Date: Tue, 2 May 2000 15:51:17 -0800
From: jim <info@online411.com>
Reply-To: info@online411.com
To: "pgsql-interfaces@postgresql.org" <pgsql-interfaces@postgresql.org>
Subject: DBI and Pg error
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

Some friends said this list is the best place to ask my questions regarding
BSDI/postgresql/DBI because some of you are BSDI expertises.

Basically, I installed postgresql, DBI and Pg and test it. My script works fine
locally and doesn't work as a CGI. I already asked several lists but so far I 
can not fix it.

I run as root user in my BSDI 4.1/Apache 1.3.9 server.  My perl is 5.005_03 
My postgresql 6.5.3 was installed  in the default location: /usr/local/pgsql 
I run postmaster with -i option. Actually I use  su - postgres in my rc.local file 
to run postmaster automatically when the server startup. I also setup .bashrc 
.bash_profile with the required env variables setup in both  postgres and 
root home.

For the database access, I include following several line in my pg_hba.conf 
file to make it works with every one.

host        all                                                 trust
host        all        127.0.0.1        255.255.255.255         trust 
host         all        0.0.0.0                0.0.0.0                        trust

I install DBI 1.13 and DBD:Pg 0.93 with no error message follow exactly the 
README.  All test was passed.

I created a testing database, a testing table and insert some records.
I use some perl scripts to test it. The script works locally and retrieve all the 
records from the table. When I run it as a cgi, it doesn't work. When I didn't 
set the required env variables, locally I get the same error message. That's 
why I guess it could be an env variable problem.  (If the DBI/DBD is not installed
correct, why it works locally??? !!!) I have tried to set the ENV with CGI, the 
problem is still. The error message is always the same as below:

install_driver(Pg) failed" Can't load '/usr/libdata/perl5/site_perl/i386-bsdos/auto/DBD/Pg/Pg.so'
for module DBD::Pg: File not found at /usr/libdata/perl5/5.00503/i386-bsdos/DynaLoader.pm line 169. 

I checked the two files, they all exist! 

I got confused here. I can not figure out what's wrong. Some friend from the list said this 
may be a installation problem and I need to reinstall perl. But  why the DBI works fine locally 
but not cgi.

Sorry for post so long here. But it's really important to me and I have to fix it ASAP!!!. 

 Any repsonse is very thankful.

Jim