tomcat4.0.4 and Apache using port 7000
Thanks if someone can help... I'm having trouble getting Apache(2.0.39) to recognize Tomcat(4.0.4) applications using port 7000. In my Apache httpd.conf file I have set: Listen 7000 and also have the servername set : ServerName afs.obs.outback.com Everything works fine when just dealing on the actual machine that Apache and Tomcat is on using localhost. In other words http://localhost:7000/ --- brings up Apache main page http://localhost:7000/myTomcatAppName/index.jsp --- serves up the jsp struts application no problem However when I try to access http://afs.obs.outback.com:7000/myTomcatAppName/index.jsp I get an Apache 404 url does not exist error (going straight to Tomcat does work however http://afs.obs.outback.com:8080/myTomcatAppName/index.jsp ) Please someone help..this is driving me nuts:) Thanks For setting up Tomcat to work with Apache I followed the instructions at this link: http://mpcon.org/temp/how2install_apache_w_php_jsp_support.doc -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: tomcat4.0.4 and Apache using port 7000
If it helps, I'm also noticing this error in the mod_jk.log file: [jk_ajp_common.c (599)]: In jk_endpoint_t::ajp_connect_to_endpoint, failed errno = 61 [jk_connect.c (151)]: jk_open_socket, connect() failed errno = 61 Thanks for any help with below: On Monday, July 22, 2002, 5:29:13 PM, Rick wrote: RR Thanks if someone can help... RR I'm having trouble getting Apache(2.0.39) to recognize Tomcat(4.0.4) RR applications using port 7000. In my Apache httpd.conf file I have set: RR Listen 7000 RR and also have the servername set RR : RR ServerName afs.obs.outback.com RR Everything works fine when just dealing on the actual machine that RR Apache and Tomcat is on using localhost. In other words RR http://localhost:7000/ --- brings up Apache main page RR http://localhost:7000/myTomcatAppName/index.jsp --- serves up the RR jsp struts application no problem RR However when I try to access RR http://afs.obs.outback.com:7000/myTomcatAppName/index.jsp I get an RR Apache 404 url does not exist error RR (going straight to Tomcat does work however RR http://afs.obs.outback.com:8080/myTomcatAppName/index.jsp ) RR Please someone help..this is driving me nuts:) Thanks RR For setting up Tomcat to work with Apache I followed the instructions RR at this link: RR http://mpcon.org/temp/how2install_apache_w_php_jsp_support.doc -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Apache 2.0.39 and Tomcat 4.1.7b and W2K
On Monday, July 22, 2002, 6:56:19 PM, Short, Dave wrote: SD Does anyone have Apache 2.0.39 and Tomcat 4.1.7b working on W2K? SD Am I the only one who can't get these two to work together? It SD shouldn't be this hard, should it? I'm trying all the same but with 4.0.4 of Tomcat and can't seem to get it work just right yet either. I have it working fine under localhost but that's about it. If anyone could shed light on the question below I'd much appreciate it. Also, is anyone as frustrated as I am with the poor documentation from jakarta??? I just don't get it..you have two great open source products and yet nothing explaining how the latest versions fit together. I just don't get it. I know the documentation is the last to come from open source stuff but this is very frustrating. Question: Thanks if someone can help... I'm having trouble getting Apache(2.0.39) to recognize Tomcat(4.0.4) applications using port 7000. In my Apache httpd.conf file I have set: Listen 7000 and also have the servername set : ServerName afs.obs.outback.com Everything works fine when just dealing on the actual machine that Apache and Tomcat is on using localhost. In other words http://localhost:7000/ --- brings up Apache main page http://localhost:7000/myTomcatAppName/index.jsp --- serves up the jsp struts application no problem However when I try to access http://afs.obs.outback.com:7000/myTomcatAppName/index.jsp I get an Apache 404 url does not exist error (going straight to Tomcat does work however http://afs.obs.outback.com:8080/myTomcatAppName/index.jsp ) Please someone help..this is driving me nuts:) Thanks For setting up Tomcat to work with Apache I followed the instructions at this link: http://mpcon.org/temp/how2install_apache_w_php_jsp_support.doc -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Integrating Apache 2.0.36 and Tomcat 4.0.4 on Win32
I basically did the install like you did below and everything works fine for me when I just use 'localhost' and try the stuff on the particular machine where everything resides. However no matter what I try I can not get apache2.0.39 to pick up any Tomcat applications when typing in the url from another machine. I'm tyring to set up under a different port 7000... and http://afs.outback.com:7000/ brings up apache fine http://afs.outback.com:8080/myApp/ brings up tomcat fine http://afs.outback.com:7000/myApp/ no good doesn't serve up my tomcat app However running on the machine where the server is and use localhost above and everything is fine. Very frustrating that I can't find documentation on this. If anyone has ideas let me know. Aleksandr, double check your set up with this doc http://mpcon.org/temp/how2install_apache_w_php_jsp_support.doc It worked fine for mine under localhost but still having problems above. On Wednesday, July 24, 2002, 8:40:32 AM, Aleksandr wrote: AJ Hi all, AJ My name is Aleksandr Jones. Greetings to all Apache of the open source AJ community. AJ I am attempting to get Apache 2.0.36 and Tomcat 4.0.4 connected, so that AJ static AJ content is served by the former and dynamic by the latter. I am running AJ Windows AJ 2000 SP2 on an Intel Machine. I mainly used the galatea.com flash guide for AJ integrating Apache 2.0.36 and Tomcat 4.04 as a guideline for this. AJ I have done the following steps: AJ I downloaded the JDK 1.4 installation file -- AJ j2sdk-1_4_0_01-windows-i586.exe AJ My JDK 1.4 is installed in C:\j2sdk14 AJ My environment variables are set as follows: AJ %JAVA_HOME% = C:\j2sdk14\ %PATH% = %PATH% -- append C:\j2sdk14\; C:\j2sdk14\bin AJ That's my Java stuff. AJ I downloaded and ran the windows installer (MSI) installation for Tomcat AJ 4.0. I AJ ran the installation and put tomcat in C:\Tomcat4\ AJ My environment variables are thusly set: AJ %Catalina_Home% = C:\Tomcat4\ AJ %Tomcat_Home% = C:\Tomcat4\ AJ Tomcat is installed as a service, so I start the sucker up and check it out: AJ http://localhost:8080/ -- and I immediately see the Tomcat page: AJ If you're seeing this page via a web browser, AJ it means you've setup Tomcat successfully. Congratulations! AJ There's my Tomcat stuff for now. AJ I downloaded the source code for Apache HTTP Server 2.0.36. AJ My environment variables are thusly set: AJ %Apache2_Home% = C:\Apache2\ AJ %Apache_Home% = C:\Apache\ AJ I built the INSTALLBIN configuration in my *ahem* Microsoft Visual Studio, AJ and it produced my Apache2 configuration. AJ I run Apache from the command line, and test http://localhost:80 AJ For which it responds: AJ If you can see this, it means that the installation of the Apache web AJ server AJ software on this system was successful etc. AJ Next, I downloaded Apache Ant 1.5, and extract it to C:\JakartaAnt\bin; AJ My environment variables are thusly set: %PATH% = %PATH% -- append C:\JakartaAnt\bin; AJ There goes Ant. AJ Next I downloaded jakarta-tomcat-connectors-4.0.2.01-src.zip. I extracted AJ to the directory C:\JKConnectors\ AJ Here is a dump of the file C:\JKConnectors\jk\build.properties AJ # AJ # sample build.properties for ajp connector. AJ # edit to taste... AJ # AJ # $Id: build.properties.sample,v 1.2 2001/05/29 23:05:52 seguin Exp $ AJ # AJ tomcat40.home=c:/Tomcat4 AJ apache2.home=c:/Apache2 AJ apr.include=${apache2.home}/include AJ apr.lib=${apache2.home}/lib AJ so.debug=true AJ so.optimize=false AJ so.profile=false AJ Looks good, I think. AJ I decided to futz with Build.xml in exactly this one way: AJproperty name=tomcat40.home AJ location=C:/tomcat4 / AJ I ran ANT in the directory C:\JKConnectors\jk\. That produces this output: AJ Buildfile: build.xml AJ detect: AJ [echo] jakarta-tomcat-connectors AJ guess_catalina40: AJ guess_catalina41: AJ cpath: AJ prepare: AJ report: AJ [echo] Tomcat33: ${tomcat33.detect} ${tomcat33.home} AJ [echo] Tomcat40: true c:/Tomcat4 AJ [echo] Tomcat41: ${tomcat41.detect} ${tomcat41.home} AJ [echo] Apache13: ${apache13.detect} ${apache13.home} AJ [echo] Apache2: true c:/Apache2 AJ [echo] iPlanet: ${iplanet.detect} ${iplanet.home} AJ [echo] IIS: ${iis.detect} ${iis.home} AJ [echo] Using catalina.home: C:\Tomcat4 AJ jkutil: AJ jkjava: AJ jkant: AJ build-main: AJ BUILD SUCCESSFUL AJ Total time: 2 seconds AJ I ran ANT INSTALL in the directory C:\JKConnectors\jk\. AJ That produces this simliar output: AJ Buildfile: build.xml AJ detect: AJ [echo] jakarta-tomcat-connectors AJ guess_catalina40: AJ guess_catalina41: AJ cpath: AJ prepare: AJ report: AJ [echo] Tomcat33: ${tomcat33.detect} ${tomcat33.home} AJ [echo] Tomcat40: true c:/Tomcat4 AJ [echo] Tomcat41: ${tomcat41.detect} ${tomcat41.home} AJ [echo] Apache13: ${apache13.detect} ${apache13.home} AJ [echo]
Survey question for any Tomcat or Apache users out there
*Question:*: Is there ANYONE out there that has managed to get Apache2.0.39 and Tomcat4.x working on a Windows2K/NT machine? Don't worry I won't even bother e-mailing you for help(unless you say I can). I've gotten to the point now that I'm just wondering if anyone is even using the combination since I can't find anything about it. I'm just so frustrated, people are constantly asking these questions and yet I see no documentation anywhere on any jakarata site how to set this stuff up. Tomcat 4.0.4 is great I love it. Shouldn't it work with another jakarta open source project - Apache web server? This best documentation I found was in this doc: http://mpcon.org/temp/how2install_apache_w_php_jsp_support.doc But even the author just realized this install isn't perfect (it only seems to be working from localhost). In the meantime I'm just using Tomcat as the only server. I've never installed Apache1.3 and things are almost perfect with Apache2.0.39 so I really don't want to uninstall it yet and try to tackle 1.3, if someone has the above set up working correctly. Even if you don't have the above working e-mail back bitching. Maybe I could keep track of the e-mail addresses and when someone does provide a solution or help I can let every else know. If anyone is interested in my original question/post it is below: --- I'm having trouble getting Apache(2.0.39) to recognize Tomcat(4.0.4) applications using port 7000. In my Apache httpd.conf file I have set: Listen 7000 and also have the servername set: ServerName afs.obs.outback.com Everything works fine when just dealing on the actual machine that Apache and Tomcat is on using localhost. In other words http://localhost:7000/ --- brings up Apache main page http://localhost:7000/myTomcatAppName/index.jsp --- serves up the jsp struts application fine However when I try to access http://afs.obs.outback.com:7000/myTomcatAppName/index.jsp I get an Apache 404 url does not exist error (going straight to Tomcat does work fine: http://afs.obs.outback.com:8080/myTomcatAppName/index.jsp ) Please someone help..this is driving me nuts:) Thanks -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re[2]: Survey question for any Tomcat or Apache users out there
On Wednesday, July 24, 2002, 11:52:49 AM, Dave wrote: SD Yesterday, I finally got Apache 2.0.39 and Tomcat 4.1.8 (mod_jk2) SD to work on W2K. Tomcat is started by the Apache service and SD actually works in-process like the IIS/Tomcat redirector. If SD anyone in interested, I can post the configuration steps. PLEASE! (I'll pay ya:) -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re[2]: Survey question for any Tomcat or Apache users out there
On Wednesday, July 24, 2002, 11:35:21 AM, John wrote: TJ I took a quick look at the doc at the link you posted. One thing I can say TJ from experience: if you have any pathnames anywhere in your TJ apache+mod_jk+tomcat config, get rid of them. Don't use Program TJ Files/Apache Group etc. Use Apache/Apache and C:\tomcat, etc. While TJ the apache installer probably lets you specify paths with spaces, and TJ probably even recommends them by default, and probably works with them, the TJ Apache HTTP developers don't co-ordinate with anyone else. I made sure none of my paths have spaces in them, but thanks for the tip though. -- Rick -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re[2]: Apache-tomcat integration
On Friday, July 26, 2002, 4:24:52 PM, Turner, John wrote: TJ Where can I get documentation on how to integrate tomcat with apache? I TJ looked on the site, but I can't find a definitive answer (at least in my TJ opinion). If your concern is with a windows system and it's Apache2.0.39 and Tomcat 4.x use this doc: http://mpcon.org/temp/how2install_apache_w_php_jsp_support.doc It's just been updated as well with some help from those on this list. -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Raising Context Manager from the dead
Me, being the idiot I am I accidentally deleted the manager directory under webapps on Tomcat4.0.4 on winNT running Tomcat as a service. I had another version of Tomcat4.0.4 running with the same directory structure so I copied that manager over into this directory on the machine where I deleted it. Unfortunately I still can't bring up the context manager (Page not found error comes up.. no prompt or anything). I even reinstalled 4.0.4 but didn't do an uninstall first. Any ideas how to get the context manager to come back up without uninstalling everything and starting over? Thanks -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re[2]: Raising Context Manager from the dead
On Wednesday, July 31, 2002, 10:19:13 AM, Nikolas wrote: NAR Did you reload it? What happens if you try to access NAR http://yourhost/manager/list ? When you say 'reload it' what exactly do you mean? When I go to http://localhost:8080/manger/list I get the nice page can not be displayed error as if I'm typing in a bad URL. NAR Rick Reumann wrote: Me, being the idiot I am I accidentally deleted the manager directory under webapps on Tomcat4.0.4 on winNT running Tomcat as a service. I had another version of Tomcat4.0.4 running with the same directory structure so I copied that manager over into this directory on the machine where I deleted it. Unfortunately I still can't bring up the context manager (Page not found error comes up.. no prompt or anything). I even reinstalled 4.0.4 but didn't do an uninstall first. Any ideas how to get the context manager to come back up without uninstalling everything and starting over? -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re[2]: Raising Context Manager from the dead
On Wednesday, July 31, 2002, 10:35:52 AM, Nikolas wrote: NAR So, your copied your manager folder. There is just a WEB-INF with NAR a web.xml in it, right? Yes that's all that is in the manager folder. NAR And you did not delete any of the entries NAR in server.xml concerning /manager (context path for manager). I don't think I did. I did a search for manager in my server.xml and there is this path still in there: Context path=/manager docBase=manager debug=0 privileged=true/ NAR Your server is running and you are able to see the port 8080 NAR examples, right? Yup, all the applications are running as well. Just can't do anything with /manager NAR So as there does not seem to be other NAR configuration it should work. Reload is only possible if the NAR manager application works. Right, can't do any reloads since can't even bring up /manager/list or anything. NAR I have no idea right now. Thanks for trying I'm just going to reinstall and see how that goes. NAR cheers, NAR Nick NAR Rick Reumann wrote: On Wednesday, July 31, 2002, 10:19:13 AM, Nikolas wrote: NAR Did you reload it? What happens if you try to access NAR http://yourhost/manager/list ? When you say 'reload it' what exactly do you mean? When I go to http://localhost:8080/manger/list I get the nice page can not be displayed error as if I'm typing in a bad URL. NAR Rick Reumann wrote: Me, being the idiot I am I accidentally deleted the manager directory under webapps on Tomcat4.0.4 on winNT running Tomcat as a service. I had another version of Tomcat4.0.4 running with the same directory structure so I copied that manager over into this directory on the machine where I deleted it. Unfortunately I still can't bring up the context manager (Page not found error comes up.. no prompt or anything). I even reinstalled 4.0.4 but didn't do an uninstall first. Any ideas how to get the context manager to come back up without uninstalling everything and starting over? NAR -- NAR To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] NAR For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re[2]: Raising Context Manager from the dead
It's fixed. Thanks for the help. {blushing} I found the problem AFTER I removed all the webapps and did an uninstall and then a reinstall. On this dev box I noticed the tomcat-users.xml had user username=xxx password=xxx .../ Obviously that was messed up and needed to be user name=. Sadly I looked over this file a few times and it just never caught my eye. Sort of like asking people to read the following statement: / PARIS \ / IN THE \ / THE SPRING \ -- and mostly people don't catch that there are two THEs Anyway thanks for the help. Sorry to waste your time, but I appreciate it. On Wednesday, July 31, 2002, 10:58:06 AM, Nikolas wrote: NAR You also restarted your server and put something like that: NAR user name=root password=root roles=manager/ NAR in tomcat-users.xml? NAR I don't know what else could be. NAR :) NAR Rick Reumann wrote: On Wednesday, July 31, 2002, 10:35:52 AM, Nikolas wrote: NAR So, your copied your manager folder. There is just a WEB-INF with NAR a web.xml in it, right? Yes that's all that is in the manager folder. NAR And you did not delete any of the entries NAR in server.xml concerning /manager (context path for manager). I don't think I did. I did a search for manager in my server.xml and there is this path still in there: Context path=/manager docBase=manager debug=0 privileged=true/ NAR Your server is running and you are able to see the port 8080 NAR examples, right? Yup, all the applications are running as well. Just can't do anything with /manager NAR So as there does not seem to be other NAR configuration it should work. Reload is only possible if the NAR manager application works. Right, can't do any reloads since can't even bring up /manager/list or anything. NAR I have no idea right now. Thanks for trying I'm just going to reinstall and see how that goes. NAR cheers, NAR Nick NAR Rick Reumann wrote: On Wednesday, July 31, 2002, 10:19:13 AM, Nikolas wrote: NAR Did you reload it? What happens if you try to access NAR http://yourhost/manager/list ? When you say 'reload it' what exactly do you mean? When I go to http://localhost:8080/manger/list I get the nice page can not be displayed error as if I'm typing in a bad URL. NAR Rick Reumann wrote: Me, being the idiot I am I accidentally deleted the manager directory under webapps on Tomcat4.0.4 on winNT running Tomcat as a service. I had another version of Tomcat4.0.4 running with the same directory structure so I copied that manager over into this directory on the machine where I deleted it. Unfortunately I still can't bring up the context manager (Page not found error comes up.. no prompt or anything). I even reinstalled 4.0.4 but didn't do an uninstall first. Any ideas how to get the context manager to come back up without uninstalling everything and starting over? NAR -- NAR To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] NAR For additional commands, e-mail: mailto:[EMAIL PROTECTED] NAR -- NAR To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] NAR For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
connection pooling on tomcat
I have connection pooling set up on Tomcat. In my server.xml file I have added to the ResourceParams: parameter namevalidationQuery/name valueSELECT 'CRAP' FROM DUAL/value /parameter The connection pooling seems to work fine, UNLESS the connections are manually killed (which are DBA ends up doing each morning for some reason when she comes ..just because she hates some of us:). When the connections are killed no one is able to do anything because the following error comes up: java.sql.SQLException: ORA-01012: not logged on Is there some way I can get this pooling to still work even if the connections are manually killed? I thought by adding the validationQuery param this would fix the problem, but it didn't. Thanks for any help. -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re[2]: connection pooling on tomcat
On Tuesday, August 27, 2002, 8:24:02 PM, Glenn Nielsen wrote: GN What connection pool are you using, DBCP? Not sure what DBCP is. I just followed the example in the Tomcat documentation under JDBC Data Sources at http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-resources-howto.html and it works fine except for that problem of killed connections cause the application to not pick up valid new ones thus breaking the application to a halt. Thanks for any more information/suggestions you could provide. GN Rick Reumann wrote: I have connection pooling set up on Tomcat. In my server.xml file I have added to the ResourceParams: parameter namevalidationQuery/name valueSELECT 'CRAP' FROM DUAL/value /parameter The connection pooling seems to work fine, UNLESS the connections are manually killed (which are DBA ends up doing each morning for some reason when she comes ..just because she hates some of us:). When the connections are killed no one is able to do anything because the following error comes up: java.sql.SQLException: ORA-01012: not logged on Is there some way I can get this pooling to still work even if the connections are manually killed? I thought by adding the validationQuery param this would fix the problem, but it didn't. Thanks for any help. -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
tomcat conn pooling question
Sorry if this is a repeat post. (I'm not sure if I posted this question here or not as I was trying to switch from digest mode to regular list mode on this list and I ended up unsubscribing from the list so didn't get messages for a while). QUESTION: I've configured Tomcat's connection pooling according to Tomcat's docs http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-resources-howto.html any everything seems to work fine unless someone manually kills the open connections (or something else causes the connections to go down). When the connections are manually killed the connection pooling ceases to work and the application breaks since it gets sql errors from the conn pool of java.sql.SQLException: ORA-01012: not logged on Is there a way to make sure the connection pooling goes back to working if the app somehow has it's open connections killed? I thought adding the validationQuery to the ResourceParams configured in the server.xml file would help, but it doesn't. parameter namevalidationQuery/name valueSELECT 'CRAP' FROM DUAL/value /parameter Thanks for any help. -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re[2]: tomcat conn pooling question
On Wednesday, August 28, 2002, 9:51:29 AM, John wrote: TJ As far as I know, there is no connection pooling built-in to tomcat that TJ actually works. The traffic I have seen on this list has people rolling TJ their own, using open source pooling solutions like poolman or DBCP, or TJ using the pooling that comes from third-party driver vendors. Which one are TJ you using? That might give the list a better indicator of what's wrong. I apologize for not being more clear. I see that now looking at the documentation that DBCP is not Tomcat's pooling, which is the one I am now trying to use. I've also tried http://connpool.jensn.de/index.html which I saw recommended on the list and ran into the same problems when connections get killed. I also tried this one with the same results: http://www.bitmechanic.com/ Thanks for any more information. I do appreciate it. -Original Message- From: Rick Reumann [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 9:37 AM To: Tomcat Users List Subject: tomcat conn pooling question Sorry if this is a repeat post. (I'm not sure if I posted this question here or not as I was trying to switch from digest mode to regular list mode on this list and I ended up unsubscribing from the list so didn't get messages for a while). QUESTION: I've configured Tomcat's connection pooling according to Tomcat's docs http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-resources -howto.html any everything seems to work fine unless someone manually kills the open connections (or something else causes the connections to go down). When the connections are manually killed the connection pooling ceases to work and the application breaks since it gets sql errors from the conn pool of java.sql.SQLException: ORA-01012: not logged on Is there a way to make sure the connection pooling goes back to working if the app somehow has it's open connections killed? I thought adding the validationQuery to the ResourceParams configured in the server.xml file would help, but it doesn't. parameter namevalidationQuery/name valueSELECT 'CRAP' FROM DUAL/value /parameter Thanks for any help. -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re[2]: tomcat conn pooling question
On Wednesday, August 28, 2002, 12:24:32 PM, Craig R. McClanahan wrote: CRM In answer to Rick's original question, the standard connection pool CRM includes a validationQuery configuration property. This is an SQL query CRM that the pool will execute before it hands you back a requested CRM connection (so it should be something that executes very quickly). Craig, Am I doing something wrong with the way I have this added to my ResourceParams? parameter namevalidationQuery/name valueSELECT 'boguz' FROM DUAL/value /parameter CRM If the connection was closed externally (your scenario), this CRM query will fail and the pool will throw that connection away and CRM give you another one instead. That's what I thought should happen as well, but I either I have something configured wrong or it's not working correctly, because I have the above added validationQuery and yet if the connections are killed I no longer am able to get a connection. (I get a java.sql.SQLException: ORA-01012: not logged on in my error log) Thanks so much again -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Bringing up DBCP pooling again
Just bringing up a question I had a while ago since I know how lists go and it's easy to miss/delete messages over time (especially as busy a list as this is:) Anyway... Was wondering if anyone had any further input in the apparent problem using DBCP pooling with Tomcat. If for some reason the connections are killed (whether on purpose or if a DB goes down and comes back up), any applications that use the DBCP pool break and give the error: java.sql.SQLException: ORA-01012: not logged on I even made sure to provide a validation query in my ResourceParams. Has anyone else encountered this? Is there a work around or some other pool that this will not happen with? Thanks for any help. -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re[2]: Bringing up DBCP pooling again
On Thursday, September 5, 2002, 5:09:00 PM, Cindy wrote: CB I had this same problem and would love to hear a solution. Actually I had the same problem with some other pools I've tried as well. It's very frustrating to say the least. CB At 04:37 PM 9/5/02 -0400, Rick Reumann wrote: Just bringing up a question I had a while ago since I know how lists go and it's easy to miss/delete messages over time (especially as busy a list as this is:) Anyway... Was wondering if anyone had any further input in the apparent problem using DBCP pooling with Tomcat. If for some reason the connections are killed (whether on purpose or if a DB goes down and comes back up), any applications that use the DBCP pool break and give the error: java.sql.SQLException: ORA-01012: not logged on I even made sure to provide a validation query in my ResourceParams. Has anyone else encountered this? Is there a work around or some other pool that this will not happen with? -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re[2]: Bringing up DBCP pooling again
On Thursday, September 5, 2002, 5:09:00 PM, Cindy Ballreich wrote: SNIP CB Here's to hoping a DBCP guru is listening.) Guess, no luck so far with the gurus out there:) CB At 04:37 PM 9/5/02 -0400, Rick Reumann wrote: Just bringing up a question I had a while ago since I know how lists go and it's easy to miss/delete messages over time (especially as busy a list as this is:) Anyway... Was wondering if anyone had any further input in the apparent problem using DBCP pooling with Tomcat. If for some reason the connections are killed (whether on purpose or if a DB goes down and comes back up), any applications that use the DBCP pool break and give the error: java.sql.SQLException: ORA-01012: not logged on I even made sure to provide a validation query in my ResourceParams. Has anyone else encountered this? Is there a work around or some other pool that this will not happen with? Thanks for any help. -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] CB -- CB To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] CB For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Help with the boss..pleas help
Without getting into the long soap opera here at work, can someone point to me any information regarding a comparison between Tomcat and Oracle's OC4J. We had all kinds of problems with OC4J here at work and I was running Tomcat fine locally on my machine, so when the crap hit the fan, I was told to install Tomcat for our apps and everything has been working fine. This new boss comes in though and says we definitely need to go back to getting OC4J set up correctly since it's 'so much better.' (Mind you we aren't an amazon.com shop here nor will we ever be using EJBs). All of this started up again because on the same box as Tomcat is the Oracles Reports server that I know was eating up CPU time and Tomcat on the same box started crawling. Boss thinks OC4J will solve this problem. Are there any good links comparing the performance of Tomcat vs other servers? Thanks -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
any way to get just two days of logger files?
If I set the timestamp value to false in the logger settings like below: Logger className=org.apache.catalina.logger.FileLogger directory=logs prefix=localhost_log. suffix=.txt timestamp=false/ Will this only keep one day of log files or will it just be one file that gets keeps getting larger? Ideally what I would like is the logger fields in the server.xml to only log the current day and keep a one day previous log. Is the only way to accomplish this is to have some thread or script run that will delete older files as they are no longer needed? Thanks for any help. -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re[2]: Bringing up DBCP pooling again
On Saturday, September 7, 2002, 10:15:04 AM, Nikola Milutinovic wrote: NM Andrew Conrad wrote: You might get more responses if you post it to [EMAIL PROTECTED] I posted my question there. Not a very active list. Only received like 3 e-mails over the past two days. Of course no answer to my question:) NM If anyone gets an answer to this question, could it be circulated here, as well? NM Most of us would like to know. A DB server rebooting scenario is not all that NM impossible. And if it happens on Saturday night, who's gonna fix it and when, NM unles the pool automagically re-connects? Exactly. The problem is compounded more when your DBA doesn't have a clue about the Tomcat server running on a different box, so if even the DBA is called in to make sure the database is all up and ok, it would be nice of any pooling would take care of itself without having to restart the Tomcat server. -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: How to set tomcat to use port 80...
On Saturday, September 7, 2002, 11:19:41 PM, Keith Pemberton wrote: KP I keep getting Permission Denied messages KP when I type tomcat4 run as the root user. That command does KP work, though, if I change the port back to 8080. Any insights KP would be much appreciated! Thanks! Could it be that there is something else also running on port 80 that you aren't aware of. I 'think' I had that problem at work when some other program was using port 80.. I'm not certain that was the error had, but just thought I'd throw out the possibility. -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
does this mean anything..
I'm wondering if this has anything to do with Tomcat (maybe crashing?) or something else going on on the box. About 1pm today I was told none of the applications were working under Tomcat. I don't administer the machine were tomcat is, but I looked at the catalina log and when the problems occurred of apps not coming up was around 1pm when you notice the No processor available information. Does it look like maybe some threads aren't getting cleaned up? Sorry I'm not the brightest bulb on the block when it comes to this administration stuff. Thanks for any info. 2002-09-10 12:49:25 HttpProcessor[8080][69] Starting background thread 2002-09-10 12:52:39 HttpProcessor[8080][70] Starting background thread 2002-09-10 12:53:33 HttpProcessor[8080][71] Starting background thread 2002-09-10 12:54:18 HttpProcessor[8080][72] Starting background thread 2002-09-10 12:55:32 HttpProcessor[8080][73] Starting background thread 2002-09-10 12:56:34 HttpProcessor[8080][74] Starting background thread 2002-09-10 12:56:57 HttpConnector[8080] No processor available, rejecting this connection 2002-09-10 12:57:35 HttpConnector[8080] No processor available, rejecting this connection 2002-09-10 12:57:40 HttpConnector[8080] No processor available, rejecting this connection 2002-09-10 12:57:52 HttpConnector[8080] No processor available, rejecting this connection 2002-09-10 12:57:52 HttpConnector[8080] No processor available, rejecting this connection -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: does this mean anything..
On Tuesday, September 10, 2002, 3:39:48 PM, Rick wrote: RR I'm wondering if this has anything to do with Tomcat (maybe RR crashing?) or something else going on on the box. Sorry this old post helped with the problem. http://archives2.real-time.com/pipermail/tomcat-devel/2002-March/029573.html My apologizes for not checking there first. Forgive me. RR About 1pm today I was told none of the applications were working under RR Tomcat. I don't administer the machine were tomcat is, but I looked at RR the catalina log and when the problems occurred of apps not coming up RR was around 1pm when you notice the No processor available RR information. Does it look like maybe some threads aren't getting RR cleaned up? Sorry I'm not the brightest bulb on the block when it RR comes to this administration stuff. RR Thanks for any info. RR RR 2002-09-10 12:49:25 HttpProcessor[8080][69] Starting background thread RR 2002-09-10 12:52:39 HttpProcessor[8080][70] Starting background thread RR 2002-09-10 12:53:33 HttpProcessor[8080][71] Starting background thread RR 2002-09-10 12:54:18 HttpProcessor[8080][72] Starting background thread RR 2002-09-10 12:55:32 HttpProcessor[8080][73] Starting background thread RR 2002-09-10 12:56:34 HttpProcessor[8080][74] Starting background thread RR 2002-09-10 12:56:57 HttpConnector[8080] No processor available, rejecting this connection RR 2002-09-10 12:57:35 HttpConnector[8080] No processor available, rejecting this connection RR 2002-09-10 12:57:40 HttpConnector[8080] No processor available, rejecting this connection RR 2002-09-10 12:57:52 HttpConnector[8080] No processor available, rejecting this connection RR 2002-09-10 12:57:52 HttpConnector[8080] No processor available, rejecting this connection RR -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
How to have less logs?
What do I need to configure so that Tomcat will not log a localhost_access, catalina_log, localhost_log for each date? Ideally I would just like the current date plus maybe one backup a day previous. Is that possible to set up? Thanks for any info. -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]