RE: Sybase freetds Solaris 10 CGI
"Baby, Binu" <[email protected]> Fri, 2 Jan 2009 19:22:09 -0600
| Newsgroups | gmane.comp.lang.perl.modules.dbi.sybase |
|---|---|
| Message-ID | <64F4496592800F4FB0D528763CB01BA2036971C2@ITOMAE2KM01.AD.QINTRA.COM> |
This is a multi-part message in MIME format.
------_=_NextPart_001_01C96D41.B4B50602
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
When I comment off the use DBD:Sybase and just have use DBI in my cgi
script
I get the following error.
-------
install_driver(Sybase) failed: Can't load
'/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/Sybase/Sybase.so
' for modu
le DBD::Sybase: ld.so.1: perl: fatal: libct.so.3: open failed: No such
file or directory at /usr/perl5/5.8.4/lib/sun4-solari
s-64int/DynaLoader.pm line 230.
at (eval 4) line 3
Compilation failed in require at (eval 4) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /export/home/netcool/connectOS.pl line 37
--------
The file does exist and below is the ldd O/P
ldd
/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/Sybase/Sybase.so
libct.so.3 =3D> /usr/local/lib/libct.so.3
libintl.so.1 =3D> /lib/libintl.so.1
libtds.so.4 =3D> /usr/local/lib/libtds.so.4
libdl.so.1 =3D> /lib/libdl.so.1
libm.so.2 =3D> /lib/libm.so.2
libc.so.1 =3D> /lib/libc.so.1
libnsl.so.1 =3D> /lib/libnsl.so.1
libsocket.so.1 =3D> /lib/libsocket.so.1
libiconv.so.2 =3D> /usr/local/lib/libiconv.so.2
libgcc_s.so.1 =3D> /usr/local/lib/libgcc_s.so.1
libmp.so.2 =3D> /lib/libmp.so.2
libmd.so.1 =3D> /lib/libmd.so.1
libscf.so.1 =3D> /lib/libscf.so.1
libdoor.so.1 =3D> /lib/libdoor.so.1
libuutil.so.1 =3D> /lib/libuutil.so.1
libgen.so.1 =3D> /lib/libgen.so.1
/platform/SUNW,Sun-Fire-V240/lib/libc_psr.so.1
/platform/SUNW,Sun-Fire-V240/lib/libmd_psr.so.1
=20
The program always works fine when I run it form command prompt
=20
Regards
Binu
=20
From: [email protected] [mailto:[email protected]]
On Behalf Of Baby, Binu
Sent: Friday, January 02, 2009 5:01 PM
To: [email protected]
Subject: RE: Sybase freetds Solaris 10 CGI
=20
I have the below entries in tomcat web.xml file.
=20
<servlet>
<servlet-name>cgi</servlet-name>
=20
<servlet-class>org.apache.catalina.servlets.CGIServlet</servlet-class>
<init-param>
<param-name>clientInputTimeout</param-name>
<param-value>100</param-value>
</init-param>
<init-param>
<param-name>debug</param-name>
<param-value>6</param-value>
</init-param>
<init-param>
<param-name>cgiPathPrefix</param-name>
<param-value>WEB-INF/cgi</param-value>
</init-param>
=20
<init-param>
<param-name>passShellEnvironment</param-name>
<param-value>true</param-value>
</init-param>
=20
<load-on-startup>5</load-on-startup>
</servlet>
=20
Below is the @INC and modules that gets loaded.
=20
@INC =3D /usr/local/lib /usr/perl5/5.8.4/lib/sun4-solaris-64int
/usr/perl5/5.8.4/lib /usr/perl5/site_perl/5.8.4/sun4-solaris-64int
/usr/perl5/site_perl/5.8.4 /usr/perl5/site_perl
/usr/perl5/vendor_perl/5.8.4/sun4-solaris-64int
/usr/perl5/vendor_perl/5.8.4 /usr/perl5/vendor_perl .=20
=20
AutoLoader.pm =3D> /usr/perl5/5.8.4/lib/AutoLoader.pm --------------
--------------
Carp.pm =3D> /usr/perl5/5.8.4/lib/Carp.pm --------------
--------------
Config.pm =3D> /usr/perl5/5.8.4/lib/sun4-solaris-64int/Config.pm
--------------
--------------
DBI.pm =3D> /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBI.pm
--------------
--------------
DynaLoader.pm =3D> /usr/perl5/5.8.4/lib/sun4-solaris-64int/DynaLoader.pm
--------------
--------------
Exporter.pm =3D> /usr/perl5/5.8.4/lib/Exporter.pm --------------
--------------
Exporter/Heavy.pm =3D> /usr/perl5/5.8.4/lib/Exporter/Heavy.pm
--------------
--------------
List/Util.pm =3D> /usr/perl5/5.8.4/lib/List/Util.pm --------------
--------------
Scalar/Util.pm =3D> /usr/perl5/5.8.4/lib/Scalar/Util.pm --------------
--------------
lib.pm =3D> /usr/perl5/5.8.4/lib/sun4-solaris-64int/lib.pm =
--------------
--------------
strict.pm =3D> /usr/perl5/5.8.4/lib/strict.pm --------------
--------------
vars.pm =3D> /usr/perl5/5.8.4/lib/vars.pm --------------
--------------
warnings.pm =3D> /usr/perl5/5.8.4/lib/warnings.pm --------------
--------------
warnings/register.pm =3D> /usr/perl5/5.8.4/lib/warnings/register.pm
=20
Use DBD:Sybase is where it fails
=20
Binu
=20
=20
From: Rearick, Kenneth [mailto:[email protected]]=20
Sent: Friday, January 02, 2009 4:29 PM
To: Baby, Binu; [email protected]
Subject: RE: Sybase freetds Solaris 10 CGI
=20
Make sure the you are coping the environment variables in the apache. In
the htppd.conf you need something like this.
=20
<IfModule mod_env.c>
=20
# PassEnv Directive
# Description: Passes environment variables from the shell
# Syntax: PassEnv env-variable [env-variable] ...
# Context: server config, virtual host, directory, .htaccess
# Override: FileInfo
# Status: Base
# Module: mod_env
#
# Specifies one or more environment variables to pass to CGI scripts
and SSI pages from the environment of the shell which invoked the httpd
process.
#
# Example
# PassEnv LD_LIBRARY_PATH
#
#
# SetEnv Directive
# Description: Sets environment variables
# Syntax: SetEnv env-variable value
# Context: server config, virtual host, directory, .htaccess
# Override: FileInfo
# Status: Base
# Module: mod_env
#
# Sets an environment variable, which is then passed on to CGI
scripts and SSI pages.
#
# Example
# SetEnv SPECIAL_PATH /foo/bin
#
#
# UnsetEnv Directive
# Description: Removes variables from the environment
# Syntax: UnsetEnv env-variable [env-variable] ...
# Context: server config, virtual host, directory, .htaccess
# Override: FileInfo
# Status: Base
# Module: mod_env
#
# Removes one or more environment variables from those passed on to
CGI scripts and SSI pages.
#
# Example
# UnsetEnv LD_LIBRARY_PATH
#
=20
PassEnv LD_LIBRARY_PATH
PassEnv SYBASE
PassEnv SYBASE_OCS
PassEnv DSQUERY
PassEnv PERL5LIB
=20
Kenneth N Rearick=20
Xylo Technologies=20
Information Services=20
Sybase Database Group=20
Phone: (507) 538-1214=20
Pager: (507) 270-0735=20
OC 1-03-5=20
[email protected]=20
=20
________________________________
From: [email protected] [mailto:[email protected]]
On Behalf Of Baby, Binu
Sent: Friday, January 02, 2009 4:55 PM
To: [email protected]
Subject: DBD:Sybase freetds Solaris 10 CGI
=20
I am using Freetds, DBD:Sybase on solaris 10 connect to Syabase
databse.
The program is able to connect and access data when I run it from
command prompt
=20
But the same script fails if I run it as CGI from apache/tomcat.
=20
The script fails at line
Use DBD::Sybase
=20
Any suggestions?
=20
Regards
Binu
This communication is the property of Qwest and may contain confidential
or privileged information. Unauthorized use of this communication is
strictly prohibited and may be unlawful. If you have received this
communication in error, please immediately notify the sender by reply
e-mail and destroy all copies of the communication and any attachments.
------_=_NextPart_001_01C96D41.B4B50602
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Edwardian Script ITC";
panose-1:3 3 3 2 4 7 7 13 8 4;}
@font-face
{font-family:Euclid;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Arial","sans-serif";
color:navy;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>When I comment off =
the use DBD:Sybase
and just have use DBI in my cgi script<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>I get the following =
error.<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>-------<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>install_driver(Sybase) failed:
Can't load
'/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/Sybase/Sybase.so'=
for
modu<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>le DBD::Sybase: =
ld.so.1: perl: fatal:
libct.so.3: open failed: No such file or directory at
/usr/perl5/5.8.4/lib/sun4-solari<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>s-64int/DynaLoader.pm =
line 230.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'> at (eval 4) =
line 3<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>Compilation failed in =
require at
(eval 4) line 3.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>Perhaps a required =
shared
library or dll isn't installed where expected<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'> at
/export/home/netcool/connectOS.pl line 37<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>--------<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>The file does exist =
and below is
the ldd O/P<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>ldd
/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/Sybase/Sybase.so<o=
:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> =
libct.so.3 =3D>
/usr/local/lib/libct.so.3<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> =
libintl.so.1 =3D>
/lib/libintl.so.1<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> =
libtds.so.4 =3D> =
/usr/local/lib/libtds.so.4<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> =
libdl.so.1 =3D>
/lib/libdl.so.1<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> =
libm.so.2 =3D>
/lib/libm.so.2<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> =
libc.so.1 =3D>
/lib/libc.so.1<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> =
libnsl.so.1 =3D>
/lib/libnsl.so.1<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> =
libsocket.so.1
=3D> =
/lib/libsocket.so.1<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> =
libiconv.so.2
=3D> =
/usr/local/lib/libiconv.so.2<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> =
libgcc_s.so.1
=3D> =
/usr/local/lib/libgcc_s.so.1<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> =
libmp.so.2 =3D>
/lib/libmp.so.2<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> =
libmd.so.1 =3D>
/lib/libmd.so.1<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> =
libscf.so.1 =3D>
/lib/libscf.so.1<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> =
libdoor.so.1 =3D>
/lib/libdoor.so.1<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> =
libuutil.so.1
=3D> =
/lib/libuutil.so.1<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> =
libgen.so.1 =3D>
/lib/libgen.so.1<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>
/platform/SUNW,Sun-Fire-V240/lib/libc_psr.so.1<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>
/platform/SUNW,Sun-Fire-V240/lib/libmd_psr.so.1<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>The program always =
works fine
when I run it form command prompt<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>Regards<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>Binu<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt =
0in 0in 0in'>
<p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span>=
</b><span
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
[email protected] [mailto:[email protected]] <b>On =
Behalf
Of </b>Baby, Binu<br>
<b>Sent:</b> Friday, January 02, 2009 5:01 PM<br>
<b>To:</b> [email protected]<br>
<b>Subject:</b> RE: Sybase freetds Solaris 10 CGI<o:p></o:p></span></p>
</div>
</div>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>I have the below =
entries in
tomcat web.xml file.<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>
<servlet><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>
<servlet-name>cgi</servlet-name><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>
<servlet-class>org.apache.catalina.servlets.CGIServlet</servlet-=
class><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>
<init-param><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> &=
nbsp;
<param-name>clientInputTimeout</param-name><o:p></o:p></span>=
</p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> &=
nbsp;
<param-value>100</param-value><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>
</init-param><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>
<init-param><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> &=
nbsp;
<param-name>debug</param-name><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> &=
nbsp;
<param-value>6</param-value><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>
</init-param><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>
<init-param><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> &=
nbsp;
<param-name>cgiPathPrefix</param-name><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> &=
nbsp;
<param-value>WEB-INF/cgi</param-value><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>
</init-param><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> &=
nbsp;
<init-param><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> &=
nbsp;
<param-name>passShellEnvironment</param-name><o:p></o:p></spa=
n></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'> &=
nbsp;
<param-value>true</param-value><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>
</init-param><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>
<load-on-startup>5</load-on-startup><o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>
</servlet><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>Below is the @INC and =
modules
that gets loaded.<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal>@INC =3D /usr/local/lib
/usr/perl5/5.8.4/lib/sun4-solaris-64int /usr/perl5/5.8.4/lib
/usr/perl5/site_perl/5.8.4/sun4-solaris-64int /usr/perl5/site_perl/5.8.4
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.8.4/sun4-solaris-64int
/usr/perl5/vendor_perl/5.8.4 /usr/perl5/vendor_perl . <o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>AutoLoader.pm =3D> =
/usr/perl5/5.8.4/lib/AutoLoader.pm
--------------<br>
--------------<br>
Carp.pm =3D> /usr/perl5/5.8.4/lib/Carp.pm --------------<br>
--------------<br>
Config.pm =3D> /usr/perl5/5.8.4/lib/sun4-solaris-64int/Config.pm
--------------<br>
--------------<br>
DBI.pm =3D> /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBI.pm
--------------<br>
--------------<br>
DynaLoader.pm =3D> =
/usr/perl5/5.8.4/lib/sun4-solaris-64int/DynaLoader.pm --------------<br>
--------------<br>
Exporter.pm =3D> /usr/perl5/5.8.4/lib/Exporter.pm --------------<br>
--------------<br>
Exporter/Heavy.pm =3D> /usr/perl5/5.8.4/lib/Exporter/Heavy.pm =
--------------<br>
--------------<br>
List/Util.pm =3D> /usr/perl5/5.8.4/lib/List/Util.pm =
--------------<br>
--------------<br>
Scalar/Util.pm =3D> /usr/perl5/5.8.4/lib/Scalar/Util.pm =
--------------<br>
--------------<br>
lib.pm =3D> /usr/perl5/5.8.4/lib/sun4-solaris-64int/lib.pm =
--------------<br>
--------------<br>
strict.pm =3D> /usr/perl5/5.8.4/lib/strict.pm --------------<br>
--------------<br>
vars.pm =3D> /usr/perl5/5.8.4/lib/vars.pm --------------<br>
--------------<br>
warnings.pm =3D> /usr/perl5/5.8.4/lib/warnings.pm --------------<br>
--------------<br>
warnings/register.pm =3D> =
/usr/perl5/5.8.4/lib/warnings/register.pm<o:p></o:p></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>Use DBD:Sybase is =
where it fails<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>Binu<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt =
0in 0in 0in'>
<p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span>=
</b><span
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Rearick, =
Kenneth
[mailto:[email protected]] <br>
<b>Sent:</b> Friday, January 02, 2009 4:29 PM<br>
<b>To:</b> Baby, Binu; [email protected]<br>
<b>Subject:</b> RE: Sybase freetds Solaris 10 CGI<o:p></o:p></span></p>
</div>
</div>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Make sure the you are coping the environment variables in =
the apache.
In the htppd.conf you need something like this.<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><IfModule mod_env.c><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # PassEnv Directive<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Description: Passes environment =
variables from
the shell<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Syntax: PassEnv env-variable =
[env-variable]
...<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Context: server config, virtual host,
directory, .htaccess<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Override: =
FileInfo<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Status: Base<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Module: mod_env<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> #<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Specifies one or more environment =
variables to
pass to CGI scripts and SSI pages from the environment of the shell =
which
invoked the httpd process.<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> #<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Example<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # PassEnv =
LD_LIBRARY_PATH<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> #<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> #<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # SetEnv Directive<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Description: Sets environment =
variables<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Syntax: SetEnv env-variable =
value<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Context: server config, virtual host,
directory, .htaccess<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Override: =
FileInfo<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Status: Base<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Module: mod_env<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> #<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Sets an environment variable, which is =
then
passed on to CGI scripts and SSI pages.<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> #<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Example<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # SetEnv SPECIAL_PATH =
/foo/bin<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> #<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> #<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # UnsetEnv =
Directive<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Description: Removes variables from the
environment<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Syntax: UnsetEnv env-variable =
[env-variable]
...<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Context: server config, virtual host,
directory, .htaccess<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Override: =
FileInfo<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Status: Base<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Module: mod_env<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> #<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Removes one or more environment =
variables from
those passed on to CGI scripts and SSI pages.<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> #<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # Example<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> # UnsetEnv =
LD_LIBRARY_PATH<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> #<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> PassEnv =
LD_LIBRARY_PATH<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> PassEnv SYBASE<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> PassEnv SYBASE_OCS<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> PassEnv DSQUERY<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> PassEnv PERL5LIB<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<div>
<p><b><span style=3D'font-size:18.0pt;font-family:"Edwardian Script =
ITC";
color:blue'>Kenneth N Rearick</span></b><span style=3D'color:navy'> <br>
</span><b><span style=3D'font-family:Euclid;color:navy'>Xylo =
Technologies</span></b><span
style=3D'color:navy'> <br>
</span><b><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Information Services</span></b><span style=3D'color:navy'> =
<br>
</span><b><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Sybase Database Group</span></b><span style=3D'color:navy'> =
<br>
</span><span style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Phone: (507) 538-1214</span><span style=3D'color:navy'> <br>
</span><span style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Pager: (507) 270-0735</span><span =
style=3D'color:navy'> <br>
</span><span style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>OC 1-03-5</span><span style=3D'color:navy'> <br>
</span><b><i><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:#993366'>[email protected]</span></i></b><span =
style=3D'color:navy'>
<o:p></o:p></span></p>
</div>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<div>
<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><span
style=3D'font-size:12.0pt;font-family:"Times New Roman","serif"'>
<hr size=3D2 width=3D"100%" align=3Dcenter>
</span></div>
<p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span>=
</b><span
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
[email protected] [mailto:[email protected]] <b>On =
Behalf
Of </b>Baby, Binu<br>
<b>Sent:</b> Friday, January 02, 2009 4:55 PM<br>
<b>To:</b> [email protected]<br>
<b>Subject:</b> DBD:Sybase freetds Solaris 10 CGI</span><span =
style=3D'font-size:
12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>I am using Freetds, DBD:Sybase on solaris 10 =
connect to
Syabase databse.<o:p></o:p></p>
<p class=3DMsoNormal>The program is able to connect and access data when =
I run it
from command prompt<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>But the same script fails if I run it as CGI from
apache/tomcat.<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>The script fails at line<o:p></o:p></p>
<p class=3DMsoNormal>Use DBD::Sybase<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Any suggestions?<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Regards<o:p></o:p></p>
<p class=3DMsoNormal>Binu<o:p></o:p></p>
<p class=3DMsoNormal><span style=3D'font-size:12.0pt;font-family:"Times =
New Roman","serif"'><br>
<br>
This communication is the property of Qwest and may contain confidential =
or
privileged information. Unauthorized use of this communication is =
strictly
prohibited and may be unlawful. If you have received this communication =
in
error, please immediately notify the sender by reply e-mail and destroy =
all
copies of the communication and any attachments.<o:p></o:p></span></p>
</div>
</body>
</html>
------_=_NextPart_001_01C96D41.B4B50602--