I'm using Postgresql 7.3.4, FreeBSD 4.7, & Apache 2.0.47. I have a
perl script which uses the DBI module and it works great from the
command line as long as I have '/usr/local/pgsgl/lib' in
LD_LIBRARY_PATH or else it would give me an 'libpq.so.3 not found'
error.
Now, I've turned that perl script into a cgi and from the apache error
log I see the 'libpq.so.3 not found' message. My own user's
LD_LIBRARY_PATH is set correctly of course but could it be because the
apache user's LD_LIBRARY_PATH isn't set properly that this is
occurring? I believe I've used the ldconfig and other tools to set
the library path but I'm not getting anywhere. Can anyone help?
- Jake