tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Norris Shelton <norrisshel...@yahoo.com>
Subject Re: Realm using LOTS of DB connections
Date Fri, 19 Nov 2004 15:43:34 GMT
OK, we figured it out.  Someone was using the connection to
monitoring.  This monitoring took 24 hits every 3 seconds across
all of our websites.

Thx for your assistance.

--- Norris Shelton <norrisshelton@yahoo.com> wrote:

> Sorry, I forgot to specify the version.  
> 
> TC 4.1.12
> 
> --- Norris Shelton <norrisshelton@yahoo.com> wrote:
> 
> > We have the manager app for each of our contexts set-up to
> use
> > the DB to authenticate users.  Unfortunately, it is using
> TONS
> > of connections.  Over an 8 min period, it used 1200
> > connections.
> >  We have 2 boxes, each with 16 contexts with their own
> manager
> > context.  Here is what the manager context of each of them
> > looks
> > like:
> >           <Context docBase="../../server/webapps/manager"
> > path="/manager"
> >                 privileged="true">
> > 
> >               <Realm 
> > className="org.apache.catalina.realm.JDBCRealm"
> >                          digest="MD5"
> >                     
> > driverName="oracle.jdbc.driver.OracleDriver"
> >                  
> > connectionURL="jdbc:oracle:thin:@myhost.com:myport:mydb"
> >                  connectionName="tomcatmgr"
> > connectionPassword="password"
> >                       userTable="user_table"
> > userNameCol="ss_user_id" userCredCol="ss_password"
> >                   userRoleTable="role_table"
> > roleNameCol="tomcat_role" />
> > 
> >               <Valve
> > className="org.apache.catalina.valves.RemoteAddrValve"
> >                         
> > allow="10\.11\.\d+\.\d+,127\.0\.0\.1"/>
> >           </Context>
> > 
> > 
> > Is this normal?  Is there a way to throttle it?
> > 
> > =====
> > 
> > Norris Shelton
> > Software Engineer
> > Sun Certified Java 1.1 Programmer
> > Appriss, Inc.
> > ICQ# 26487421
> > AIM NorrisEShelton
> > YIM norrisshelton
> > 
> > 
> > 
> > 		
> > __________________________________ 
> > Do you Yahoo!? 
> > Meet the all-new My Yahoo! - Try it today! 
> > http://my.yahoo.com 
> >  
> > 
> > 
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> > tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> > tomcat-user-help@jakarta.apache.org
> > 
> > 
> 
> 
> =====
> 
> Norris Shelton
> Software Engineer
> Sun Certified Java 1.1 Programmer
> Appriss, Inc.
> ICQ# 26487421
> AIM NorrisEShelton
> YIM norrisshelton
> 
> 
> 
> 		
> __________________________________ 
> Do you Yahoo!? 
> Meet the all-new My Yahoo! - Try it today! 
> http://my.yahoo.com 
>  
> 
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> tomcat-user-help@jakarta.apache.org
> 
> 


=====

Norris Shelton
Software Engineer
Sun Certified Java 1.1 Programmer
Appriss, Inc.
ICQ# 26487421
AIM NorrisEShelton
YIM norrisshelton



		
__________________________________ 
Do you Yahoo!? 
Meet the all-new My Yahoo! - Try it today! 
http://my.yahoo.com 
 


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


Mime
View raw message