Skip to Content.
Sympa Menu

freetds - [freetds] Freetds and CGI

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Beth Woods <agentbeckett186 AT yahoo.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Freetds and CGI
  • Date: Wed, 25 Apr 2007 06:51:02 -0700 (PDT)

Hi all,
I'm not sure if this issue is appropriate for this list, so if it's not
please let me know.

I am running Freetds on a Red Hat Linux server and using DBD::Sybase to
connect to MS SQL Server 2005 from Perl. I have configured Freetds and
DBD::Sybase. Everything works fine when I'm running stand alone Perl scripts
and Perl modules. But when I try to use this method within a CGI script. I
get the following error in the Apache log.

stderr: install_driver(Sybase) failed: Can't load
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Sybase/Sybase.so'
for module DBD::Sybase: libct.so.4: cannot open shared object file: No such
file or directory at
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230

I was getting this error before, and found that it was because I had not
exported the enviornment variable LD_LIBRARY_PATH. I have tried numerous
ways of exporting this variable, but CGI will not pick it up. This is what I
have done so far without success.

Added the variable to /root/profile
Added the variable to /home/user/.profile (the owner of the CGI script's home
directory)
Exported the variable directly from the CGI script via `export
LD_LIBRARY_PATH=/usr/local/lib
Exported the variable directly form the CGI script via
$ENV{LD_LIBRARY_PATH}=/usr/local/lib
Added the path to the /etc/ld.so.conf file

Any suggestions are welcome. Thanks in advance.

Beth



__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com



  • [freetds] Freetds and CGI, Beth Woods, 04/25/2007

Archive powered by MHonArc 2.6.24.

Top of Page