Return-Path: 
 <users-return-194102-apmail-tomcat-users-archive=tomcat.apache.org@tomcat.apache.org>
Delivered-To: apmail-tomcat-users-archive@www.apache.org
Received: (qmail 67291 invoked from network); 1 Apr 2009 11:58:08 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 1 Apr 2009 11:58:08 -0000
Received: (qmail 49215 invoked by uid 500); 1 Apr 2009 11:58:04 -0000
Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org
Received: (qmail 49129 invoked by uid 500); 1 Apr 2009 11:58:04 -0000
Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@tomcat.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@tomcat.apache.org>
List-Post: <mailto:users@tomcat.apache.org>
List-Id: <users.tomcat.apache.org>
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Delivered-To: mailing list users@tomcat.apache.org
Received: (qmail 49118 invoked by uid 99); 1 Apr 2009 11:58:04 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Apr 2009 11:58:04 +0000
X-ASF-Spam-Status: No, hits=2.6 required=10.0
	tests=DNS_FROM_OPENWHOIS,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Apr 2009 11:57:56 +0000
Received: from isper.nabble.com ([192.168.236.156])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <lists@nabble.com>)
	id 1Loz4Z-0001nu-1d
	for users@tomcat.apache.org; Wed, 01 Apr 2009 04:57:35 -0700
Message-ID: <22824933.post@talk.nabble.com>
Date: Wed, 1 Apr 2009 04:57:34 -0700 (PDT)
From: HARI17785 <hariharan.thirumeni@wipro.com>
To: users@tomcat.apache.org
Subject: Re: Tomcat 5.5 and Mysql 5.0 connectivity
In-Reply-To: <22717981.post@talk.nabble.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: hariharan.thirumeni@wipro.com
References: <22717981.post@talk.nabble.com>
X-Virus-Checked: Checked by ClamAV on apache.org


Hi i got the solution,
 to connect ur cgi script from Apache to MySql db u hav to do the following
things.

1.Open ur Tomcat home directory and go to conf and open web.xml.
2.uncomment the following things..

         - <servlet>
  <servlet-name>cgi</servlet-name> 
  <servlet-class>org.apache.catalina.servlets.CGIServlet</servlet-class> 
- <init-param>
  <param-name>debug</param-name> 
  <param-value>0</param-value> 
  </init-param>
- <init-param>
  <param-name>cgiPathPrefix</param-name> 
  <param-value>WEB-INF/cgi</param-value> 
  </init-param>
- <init-param>
  <param-name>passShellEnvironment</param-name> 
  <param-value>false</param-value> 
  </init-param>
  <load-on-startup>5</load-on-startup> 
  </servlet>
               
           and   change the <param-value>false</param-value> to
true(<param-value>true</param-value> )

           and change the <param-name>debug</param-name> 
  <param-value>0</param-value> value to 6


Uncomment the following

- <servlet-mapping>
  <servlet-name>cgi</servlet-name> 
  <url-pattern>/cgi-bin/*</url-pattern> if ur cgi bin name is cgi-bin dont
change this otherwise      give the exact name of ur cgi folder
  </servlet-mapping>

Now go to server\lib
there will be jar file named
servlets-cgi.renametojarservlets-cgi.renametojar change the name to
servlets-cgi.jar

Now ur CGI script will  work on .


Regards,
Hari17785







HARI17785 wrote:
> 
> Hi,
>  i m using tomcat 5.5  and Mysql 5.0. I hav written a CGI script which
> retrives some infn from database.Now i want to run my CGI script in
> tomcat5.5 and queries the MySQL db.I m very much new to tomcat 5.5.So pls
> somebody help me out.Do i need  any jar files for this connectivity?
> 
> Thanks,
> Hari
> 

-- 
View this message in context: http://www.nabble.com/Tomcat-5.5-and-Mysql-5.0-connectivity-tp22717981p22824933.html
Sent from the Tomcat - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org