RE: Sybase freetds Solaris 10 CGI
"Baby, Binu" <[email protected]> Fri, 2 Jan 2009 18:00:31 -0600
| Newsgroups | gmane.comp.lang.perl.modules.dbi.sybase |
|---|---|
| Message-ID | <64F4496592800F4FB0D528763CB01BA2036971C1@ITOMAE2KM01.AD.QINTRA.COM> |
This is a multi-part message in MIME format.
------_=_NextPart_001_01C96D36.4AC43070
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
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_01C96D36.4AC43070
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-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'>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_01C96D36.4AC43070--