You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Norris Shelton <no...@yahoo.com> on 2004/11/18 20:05:02 UTC
Realm using LOTS of DB connections
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
Re: Realm using LOTS of DB connections
Posted by Norris Shelton <no...@yahoo.com>.
I would like to, but we are not "allowed" to use pooling yet.
--- Seth Ladd <se...@ehawaii.gov> wrote:
> Norris Shelton 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"
>
> You might want to try to DataSourceRealm, which would pull its
>
> connection from a pool.
>
> Seth
>
>
---------------------------------------------------------------------
> 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!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: Realm using LOTS of DB connections
Posted by Seth Ladd <se...@ehawaii.gov>.
Norris Shelton 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"
You might want to try to DataSourceRealm, which would pull its
connection from a pool.
Seth
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: Realm using LOTS of DB connections
Posted by Gabriel Belingueres <be...@gmail.com>.
May be you should try using a DataSourceRealm, so that connections
could be pooled by DBCP.
On Thu, 18 Nov 2004 11:05:02 -0800 (PST), Norris Shelton
<no...@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
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: Realm using LOTS of DB connections
Posted by Norris Shelton <no...@yahoo.com>.
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 <no...@yahoo.com> wrote:
> Sorry, I forgot to specify the version.
>
> TC 4.1.12
>
> --- Norris Shelton <no...@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
Re: Realm using LOTS of DB connections
Posted by Norris Shelton <no...@yahoo.com>.
Sorry, I forgot to specify the version.
TC 4.1.12
--- Norris Shelton <no...@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