JDBCRealm Problem - Connected to DB but not authenticating
I'm using a JDBCRealm with Tomcat 5.0. I have created the tables, configured the Realm and can see the database connection in Oracle. When I try to log onto the web application I see the following request in Oracle SELECT user_pass FROM users WHERE user_name = :1 but the login fails. I have tried both plaintext and SHA encrypted passwords, both of which work fine when using the memory realm and tomcat-users.xml. Any thoughts? Thanks in advance. -- Sent from the Tomcat - User forum at Nabble.com: http://www.nabble.com/JDBCRealm-Problem---Connected-to-DB-but-not-authenticating-t335080.html#a932223
Re: 5.5.x JDBCRealm problem - wasn't this fixed?
On Sun, 27 Mar 2005 16:57:53 -0800, Michael Mehrle [EMAIL PROTECTED] wrote: Sorry for reposting this, but I'm really desperate - anyone?? In 5.5.9 (see the changelog). We recommend using the data source realm, BTW, which does everything much better. I just switched from 5.0.28 to 5.5.8 on my Fedora server. The app works fine but after some inactivity of approx 7 hours I try to log in and get the following error: at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) [tdx] WARN [http-8080-Processor23] JDBCRealm.getPassword(555) | Exception retrieving password for molecool If I recycle tomcat it works fine and as long as I keep hitting the server I don't get this problem. However, if I am gone for a few hours and come back I encounter this problem. Now, I did some digging online and others have encountered this as well. But I was under the impression that this bug was fixed and that 5.5.8 wasn't leaking connections anymore. Just for sh...ts and giggles I tried 5.5.7 and it's got the same problem. Here's my cofiguration: Context path= docBase=ROOT debug=99 reloadable=true antiJARLocking=true antiResourceLocking=true Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=@DB-DRIVERNAME@ connectionURL=@DB-URL@ connectionName=@DB-USERNAME@ connectionPassword=@DB-PASSWORD@ userTable=app_user userNameCol=username userCredCol=password userRoleTable=user_role roleNameCol=role_name / Resource name=jdbc/tdx auth=Container type=javax.sql.DataSource maxActive=100 maxIdle=30 maxWait=1 driverClassName=@DB-DRIVERNAME@ username=@DB-USERNAME@ password=@DB-PASSWORD@ url=@DB-URL@ defaultAutoCommit=true removeAbandoned=true removeAbandonedTimeout=60 logAbandoned=true/ /Context I would really appreciate some help here. There appears to be some jakarta-.jar file that fixes this, but I was unable to dig it up. I also tried to get tomcat out of cvs, but the build process seems to be more than I can handle at this point (missing references). This site needs to be up and running by Tuesday - ANY pointers would be very welcome ;-) Michael -- x Rémy Maucherat Developer Consultant JBoss Group (Europe) SàRL x - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: 5.5.x JDBCRealm problem - wasn't this fixed?
Fixed indeed - I was up late yesterday and jumped on that 5.5.9 release like it was manna from heaven (best analogy I could think of - I'm not religious). Logged in this morning after a night of inactivity and everything seems to be working :-) Thanks for taking care of this, guys - please forward my regards to the person who fixed this. I also must point out that everything seems to be a bit snappier now - have there been any performance increases? I'm running an image gallery all through tomcat, so it's hosting *everything* - looks a lot faster than before. Good job. Michael - Original Message - From: Remy Maucherat [EMAIL PROTECTED] To: Tomcat Users List tomcat-user@jakarta.apache.org Sent: Monday, March 28, 2005 12:34 AM Subject: Re: 5.5.x JDBCRealm problem - wasn't this fixed? On Sun, 27 Mar 2005 16:57:53 -0800, Michael Mehrle [EMAIL PROTECTED] wrote: Sorry for reposting this, but I'm really desperate - anyone?? In 5.5.9 (see the changelog). We recommend using the data source realm, BTW, which does everything much better. I just switched from 5.0.28 to 5.5.8 on my Fedora server. The app works fine but after some inactivity of approx 7 hours I try to log in and get the following error: at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) [tdx] WARN [http-8080-Processor23] JDBCRealm.getPassword(555) | Exception retrieving password for molecool If I recycle tomcat it works fine and as long as I keep hitting the server I don't get this problem. However, if I am gone for a few hours and come back I encounter this problem. Now, I did some digging online and others have encountered this as well. But I was under the impression that this bug was fixed and that 5.5.8 wasn't leaking connections anymore. Just for sh...ts and giggles I tried 5.5.7 and it's got the same problem. Here's my cofiguration: Context path= docBase=ROOT debug=99 reloadable=true antiJARLocking=true antiResourceLocking=true Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=@DB-DRIVERNAME@ connectionURL=@DB-URL@ connectionName=@DB-USERNAME@ connectionPassword=@DB-PASSWORD@ userTable=app_user userNameCol=username userCredCol=password userRoleTable=user_role roleNameCol=role_name / Resource name=jdbc/tdx auth=Container type=javax.sql.DataSource maxActive=100 maxIdle=30 maxWait=1 driverClassName=@DB-DRIVERNAME@ username=@DB-USERNAME@ password=@DB-PASSWORD@ url=@DB-URL@ defaultAutoCommit=true removeAbandoned=true removeAbandonedTimeout=60 logAbandoned=true/ /Context I would really appreciate some help here. There appears to be some jakarta-.jar file that fixes this, but I was unable to dig it up. I also tried to get tomcat out of cvs, but the build process seems to be more than I can handle at this point (missing references). This site needs to be up and running by Tuesday - ANY pointers would be very welcome ;-) Michael -- x Rémy Maucherat Developer Consultant JBoss Group (Europe) SàRL x - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
AutoReply: Re: 5.5.x JDBCRealm problem - wasn't this fixed?
Hello Tomcat Users List tomcat-user@jakarta.apache.org, This refers to your mail with subject as Re: 5.5.x JDBCRealm problem - wasn't this fixed?. Thank you for sending your CV and registering with A.S. Consultancy Services. Our team will review your CV and match it against current requirements. If your profile matches with any ongoing opening, we will contact you by telephone / email. We recommend that you update your profile and send us an updated CV whenever your contact details or your career path changes, so that your record is up-to-date with us. Please be assured that your CV will remain confidential with us and we will submit your profile to our clients only after due consultation with you. In case you require any further information please do contact us. with warm regards, Staffing Team A.S. Consultancy Services #1205, 2nd Main, 2nd Cross, Vijayanagar, Bangalore - 560040, India Tele - 91 80 2310 9012, Telefax - 91 80 2330 5364, Email - [EMAIL PROTECTED] URL: www.asconsultancy.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: 5.5.x JDBCRealm problem - wasn't this fixed?
On Mon, 28 Mar 2005 09:28:24 -0800, Michael Mehrle [EMAIL PROTECTED] wrote: Fixed indeed - I was up late yesterday and jumped on that 5.5.9 release like it was manna from heaven (best analogy I could think of - I'm not religious). Logged in this morning after a night of inactivity and everything seems to be working :-) Good. Thanks for taking care of this, guys - please forward my regards to the person who fixed this. I also must point out that everything seems to be a bit snappier now - have there been any performance increases? I'm running an image gallery all through tomcat, so it's hosting *everything* - looks a lot faster than before. Good job. There were no performance improvements since 5.5.4, so Ithere should not be any difference with the new build. -- x Rémy Maucherat Developer Consultant JBoss Group (Europe) SàRL x - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
5.5.x JDBCRealm problem - wasn't this fixed?
Sorry for reposting this, but I'm really desperate - anyone?? - Original Message - I just switched from 5.0.28 to 5.5.8 on my Fedora server. The app works fine but after some inactivity of approx 7 hours I try to log in and get the following error: at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) [tdx] WARN [http-8080-Processor23] JDBCRealm.getPassword(555) | Exception retrieving password for molecool If I recycle tomcat it works fine and as long as I keep hitting the server I don't get this problem. However, if I am gone for a few hours and come back I encounter this problem. Now, I did some digging online and others have encountered this as well. But I was under the impression that this bug was fixed and that 5.5.8 wasn't leaking connections anymore. Just for sh...ts and giggles I tried 5.5.7 and it's got the same problem. Here's my cofiguration: Context path= docBase=ROOT debug=99 reloadable=true antiJARLocking=true antiResourceLocking=true Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=@DB-DRIVERNAME@ connectionURL=@DB-URL@ connectionName=@DB-USERNAME@ connectionPassword=@DB-PASSWORD@ userTable=app_user userNameCol=username userCredCol=password userRoleTable=user_role roleNameCol=role_name / Resource name=jdbc/tdx auth=Container type=javax.sql.DataSource maxActive=100 maxIdle=30 maxWait=1 driverClassName=@DB-DRIVERNAME@ username=@DB-USERNAME@ password=@DB-PASSWORD@ url=@DB-URL@ defaultAutoCommit=true removeAbandoned=true removeAbandonedTimeout=60 logAbandoned=true/ /Context I would really appreciate some help here. There appears to be some jakarta-.jar file that fixes this, but I was unable to dig it up. I also tried to get tomcat out of cvs, but the build process seems to be more than I can handle at this point (missing references). This site needs to be up and running by Tuesday - ANY pointers would be very welcome ;-) Michael - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
5.5.x JDBCRealm problem - wasn't this fixed?
I just switched from 5.0.28 to 5.5.8 on my Fedora server. The app works fine but after some inactivity of approx 7 hours I try to log in and get the following error: at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) [tdx] WARN [http-8080-Processor23] JDBCRealm.getPassword(555) | Exception retrieving password for molecool If I recycle tomcat it works fine and as long as I keep hitting the server I don't get this problem. However, if I am gone for a few hours and come back I encounter this problem. Now, I did some digging online and others have encountered this as well. But I was under the impression that this bug was fixed and that 5.5.8 wasn't leaking connections anymore. Just for sh...ts and giggles I tried 5.5.7 and it's got the same problem. Here's my cofiguration: Context path= docBase=ROOT debug=99 reloadable=true antiJARLocking=true antiResourceLocking=true Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=@DB-DRIVERNAME@ connectionURL=@DB-URL@ connectionName=@DB-USERNAME@ connectionPassword=@DB-PASSWORD@ userTable=app_user userNameCol=username userCredCol=password userRoleTable=user_role roleNameCol=role_name / Resource name=jdbc/tdx auth=Container type=javax.sql.DataSource maxActive=100 maxIdle=30 maxWait=1 driverClassName=@DB-DRIVERNAME@ username=@DB-USERNAME@ password=@DB-PASSWORD@ url=@DB-URL@ defaultAutoCommit=true removeAbandoned=true removeAbandonedTimeout=60 logAbandoned=true/ /Context I would really appreciate some help here. There appears to be some jakarta-.jar file that fixes this, but I was unable to dig it up. I also tried to get tomcat out of cvs, but the build process seems to be more than I can handle at this point (missing references). This site needs to be up and running by Tuesday - ANY pointers would be very welcome ;-) Michael
JDBCRealm problem (invalid port number)
Hi, I'm trying to use JDBCRealm and MySQL to authenticate user in tomcat 4.1. I followed the steps described on http://jakarta.apache.org/tomcat/tomcat-4.1-doc/realm- howto.html#JDBCRealm: I added a user table and a user_roles table in my database (ABCDatabase); I made all necessary columns (user, password, role_name); I downloaded the MySQL driver (mysql-connector-java-3.0.14- production.zip) and put the .jar file into $CATALINA/common/lib; I replaced the realm definition of the server.xml by follow code snippet : Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost_IP/ABCDatabase !-- * -- connectionName=root connectionPassword= userTable=user userNameCol=login userCredCol=password userRoleTable=user_roles roleNameCol=role_name / I created the new user in slide/users/ with the same name and password as in my user table in the mysql server. I can login in http://localhost:8080/admin with this user (he's not in tomcat-users.xml) using IE, but when I use a terminal as jakarta-slide- webdavclient-2.0, I got the follow error message: org.apache.commons.httpclient.URIException: invalid port number I replaced the connectionURL (the line with !-- * -- ) by lines below, but I got the same error. connectionURL=jdbc:mysql://localhost_IP:3306/ABCDatabase connectionURL=jdbc:mysql://localhost/ABCDatabase connectionURL=jdbc:mysql://localhost:3306/ABCDatabase I remark that there's nothing about JDBCRealm neither JDBC in the login file (/logs/localhost_log.txt). Does someone know what's wrong in my program? Thx and regards - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: JDBCRealm problem
Hi, Thanks for the info. Apparently, the database was not set correctly. After correcting the previous problem, I am able to login. The log shows the correct authentication with no errors. Yet, I not getting anything after the login. the web page is clear, in stead of taking me to the next page, by design. the top url address is like: http://localhost/login/j_security_check any help, suggestion, or comment would be nice. Thanks, James -Original Message- From: Jon Wingfield [mailto:[EMAIL PROTECTED] Sent: Thursday, November 27, 2003 5:01 AM To: Tomcat Users List Subject: Re: JDBCRealm problem The JDBCRealm does two things: 1) Authenticates the user (by checking password) 2) Authorizes the user (by checking roles) The logs would seem to imply the JDBC driver is blowing up creating the prepared statement in the second step (ie reading from the roles table). I think Tim is right - he usually is - that there is a config problem with the db or the connection to the db. A quick google later: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B313181 HTH, Jon Ostad, James wrote: The line above the line you mentioned in the error log indicates that the connection was established at one point: 2003-11-26 11:53:19 JDBCRealm[localhost]: Username admin successfully authenticated 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication So, I don't think that the parameters are wrong, neither the database setup. The web application functions with form base authentication without usage of realm. It is my next step to implement the realm, which I having problem. but, I will double check my settings and configuration to make sure that I didn't miss anything. thanks, James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 4:00 PM To: Tomcat Users List Subject: Re: JDBCRealm problem The problem is this: 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode. Since I don't use SQL server and Java, I can't be of more help, but my guess is - Database setup - Driver parameter missing -Tim Ostad, James wrote: Hi everyone, Hope everyone will have a great TG Day. Problem: I am not able to login successfully. It keeps failing. Structure: using JDBCRealm + form authentication database property: match exactly as explained in tomcat documentation for setting up JDBCRealm I am including three things: 1-server.xml part for realm setup 2-web.xml of the web apps 3-errorlog file is the error log I get when I attempt to use jdbcrealm. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ---In (14) Out--- (3) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ---In (14) Out--- (3) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: JDBCRealm problem
I just noticed this errors in the following files under tomcat log directory: catalina_log.2003-12-03.txt 2003-12-03 09:59:06 CoyoteAdapter An exception or error occurred in the container during the request processing java.lang.NullPointerException at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:478) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:394) at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAut henticator.java:263) localhost_log.2003-11-26.txt 2003-12-03 09:58:53 StandardManager[/webdav]: Seeding of random number generator has been completed 2003-12-03 09:58:53 StandardManager[/webdav] IOException while loading persisted sessions: java.io.EOFException java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.ja va:2150) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStre am.java:2619) Any help would be appreciated thanks, James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 9:51 AM To: Tomcat Users List Subject: RE: JDBCRealm problem Hi, Thanks for the info. Apparently, the database was not set correctly. After correcting the previous problem, I am able to login. The log shows the correct authentication with no errors. Yet, I not getting anything after the login. the web page is clear, in stead of taking me to the next page, by design. the top url address is like: http://localhost/login/j_security_check any help, suggestion, or comment would be nice. Thanks, James -Original Message- From: Jon Wingfield [mailto:[EMAIL PROTECTED] Sent: Thursday, November 27, 2003 5:01 AM To: Tomcat Users List Subject: Re: JDBCRealm problem The JDBCRealm does two things: 1) Authenticates the user (by checking password) 2) Authorizes the user (by checking roles) The logs would seem to imply the JDBC driver is blowing up creating the prepared statement in the second step (ie reading from the roles table). I think Tim is right - he usually is - that there is a config problem with the db or the connection to the db. A quick google later: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B313181 HTH, Jon Ostad, James wrote: The line above the line you mentioned in the error log indicates that the connection was established at one point: 2003-11-26 11:53:19 JDBCRealm[localhost]: Username admin successfully authenticated 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication So, I don't think that the parameters are wrong, neither the database setup. The web application functions with form base authentication without usage of realm. It is my next step to implement the realm, which I having problem. but, I will double check my settings and configuration to make sure that I didn't miss anything. thanks, James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 4:00 PM To: Tomcat Users List Subject: Re: JDBCRealm problem The problem is this: 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode. Since I don't use SQL server and Java, I can't be of more help, but my guess is - Database setup - Driver parameter missing -Tim Ostad, James wrote: Hi everyone, Hope everyone will have a great TG Day. Problem: I am not able to login successfully. It keeps failing. Structure: using JDBCRealm + form authentication database property: match exactly as explained in tomcat documentation for setting up JDBCRealm I am including three things: 1-server.xml part for realm setup 2-web.xml of the web apps 3-errorlog file is the error log I get when I attempt to use jdbcrealm. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ---In (14) Out--- (3) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ---In (14) Out--- (3) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ---In (14) Out--- (3) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: JDBCRealm problem
One more thing, when I commented out the realm section in server.xml, the program does work with the default realm. James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 10:08 AM To: Tomcat Users List Subject: RE: JDBCRealm problem I just noticed this errors in the following files under tomcat log directory: catalina_log.2003-12-03.txt 2003-12-03 09:59:06 CoyoteAdapter An exception or error occurred in the container during the request processing java.lang.NullPointerException at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:478) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:394) at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAut henticator.java:263) localhost_log.2003-11-26.txt 2003-12-03 09:58:53 StandardManager[/webdav]: Seeding of random number generator has been completed 2003-12-03 09:58:53 StandardManager[/webdav] IOException while loading persisted sessions: java.io.EOFException java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.ja va:2150) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStre am.java:2619) Any help would be appreciated thanks, James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 9:51 AM To: Tomcat Users List Subject: RE: JDBCRealm problem Hi, Thanks for the info. Apparently, the database was not set correctly. After correcting the previous problem, I am able to login. The log shows the correct authentication with no errors. Yet, I not getting anything after the login. the web page is clear, in stead of taking me to the next page, by design. the top url address is like: http://localhost/login/j_security_check any help, suggestion, or comment would be nice. Thanks, James -Original Message- From: Jon Wingfield [mailto:[EMAIL PROTECTED] Sent: Thursday, November 27, 2003 5:01 AM To: Tomcat Users List Subject: Re: JDBCRealm problem The JDBCRealm does two things: 1) Authenticates the user (by checking password) 2) Authorizes the user (by checking roles) The logs would seem to imply the JDBC driver is blowing up creating the prepared statement in the second step (ie reading from the roles table). I think Tim is right - he usually is - that there is a config problem with the db or the connection to the db. A quick google later: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B313181 HTH, Jon Ostad, James wrote: The line above the line you mentioned in the error log indicates that the connection was established at one point: 2003-11-26 11:53:19 JDBCRealm[localhost]: Username admin successfully authenticated 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication So, I don't think that the parameters are wrong, neither the database setup. The web application functions with form base authentication without usage of realm. It is my next step to implement the realm, which I having problem. but, I will double check my settings and configuration to make sure that I didn't miss anything. thanks, James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 4:00 PM To: Tomcat Users List Subject: Re: JDBCRealm problem The problem is this: 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode. Since I don't use SQL server and Java, I can't be of more help, but my guess is - Database setup - Driver parameter missing -Tim Ostad, James wrote: Hi everyone, Hope everyone will have a great TG Day. Problem: I am not able to login successfully. It keeps failing. Structure: using JDBCRealm + form authentication database property: match exactly as explained in tomcat documentation for setting up JDBCRealm I am including three things: 1-server.xml part for realm setup 2-web.xml of the web apps 3-errorlog file is the error log I get when I attempt to use jdbcrealm. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ---In (14) Out--- (3) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ---In (14) Out--- (3) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ---In (14) Out--- (3
Re: JDBCRealm problem
If you have a NPE, it might being thrown by the Realm. This can happen when there is a null role or similar. This has since been patched. You can test it by getting the latest JDBCRealm from source, compiling it and placing it in the appropriate nested dir in server/classes. (Which has a higher precedence than the lib dir) -Tim Ostad, James wrote: One more thing, when I commented out the realm section in server.xml, the program does work with the default realm. James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 10:08 AM To: Tomcat Users List Subject: RE: JDBCRealm problem I just noticed this errors in the following files under tomcat log directory: catalina_log.2003-12-03.txt 2003-12-03 09:59:06 CoyoteAdapter An exception or error occurred in the container during the request processing java.lang.NullPointerException at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:478) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:394) at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAut henticator.java:263) localhost_log.2003-11-26.txt 2003-12-03 09:58:53 StandardManager[/webdav]: Seeding of random number generator has been completed 2003-12-03 09:58:53 StandardManager[/webdav] IOException while loading persisted sessions: java.io.EOFException java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.ja va:2150) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStre am.java:2619) Any help would be appreciated thanks, James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 9:51 AM To: Tomcat Users List Subject: RE: JDBCRealm problem Hi, Thanks for the info. Apparently, the database was not set correctly. After correcting the previous problem, I am able to login. The log shows the correct authentication with no errors. Yet, I not getting anything after the login. the web page is clear, in stead of taking me to the next page, by design. the top url address is like: http://localhost/login/j_security_check any help, suggestion, or comment would be nice. Thanks, James -Original Message- From: Jon Wingfield [mailto:[EMAIL PROTECTED] Sent: Thursday, November 27, 2003 5:01 AM To: Tomcat Users List Subject: Re: JDBCRealm problem The JDBCRealm does two things: 1) Authenticates the user (by checking password) 2) Authorizes the user (by checking roles) The logs would seem to imply the JDBC driver is blowing up creating the prepared statement in the second step (ie reading from the roles table). I think Tim is right - he usually is - that there is a config problem with the db or the connection to the db. A quick google later: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B313181 HTH, Jon Ostad, James wrote: The line above the line you mentioned in the error log indicates that the connection was established at one point: 2003-11-26 11:53:19 JDBCRealm[localhost]: Username admin successfully authenticated 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication So, I don't think that the parameters are wrong, neither the database setup. The web application functions with form base authentication without usage of realm. It is my next step to implement the realm, which I having problem. but, I will double check my settings and configuration to make sure that I didn't miss anything. thanks, James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 4:00 PM To: Tomcat Users List Subject: Re: JDBCRealm problem The problem is this: 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode. Since I don't use SQL server and Java, I can't be of more help, but my guess is - Database setup - Driver parameter missing -Tim Ostad, James wrote: Hi everyone, Hope everyone will have a great TG Day. Problem: I am not able to login successfully. It keeps failing. Structure: using JDBCRealm + form authentication database property: match exactly as explained in tomcat documentation for setting up JDBCRealm I am including three things: 1-server.xml part for realm setup 2-web.xml of the web apps 3-errorlog file is the error log I get when I attempt to use jdbcrealm. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ---In (14) Out--- (3) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e
RE: JDBCRealm problem
I am new in tomcat. I am looking in tomcat site for source file for JDBCRealm. Is this part of the tomcat source files? or it is separate? thanks James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 10:20 AM To: Tomcat Users List Subject: Re: JDBCRealm problem If you have a NPE, it might being thrown by the Realm. This can happen when there is a null role or similar. This has since been patched. You can test it by getting the latest JDBCRealm from source, compiling it and placing it in the appropriate nested dir in server/classes. (Which has a higher precedence than the lib dir) -Tim Ostad, James wrote: One more thing, when I commented out the realm section in server.xml, the program does work with the default realm. James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 10:08 AM To: Tomcat Users List Subject: RE: JDBCRealm problem I just noticed this errors in the following files under tomcat log directory: catalina_log.2003-12-03.txt 2003-12-03 09:59:06 CoyoteAdapter An exception or error occurred in the container during the request processing java.lang.NullPointerException at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:478) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:394) at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAut henticator.java:263) localhost_log.2003-11-26.txt 2003-12-03 09:58:53 StandardManager[/webdav]: Seeding of random number generator has been completed 2003-12-03 09:58:53 StandardManager[/webdav] IOException while loading persisted sessions: java.io.EOFException java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.ja va:2150) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStre am.java:2619) Any help would be appreciated thanks, James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 9:51 AM To: Tomcat Users List Subject: RE: JDBCRealm problem Hi, Thanks for the info. Apparently, the database was not set correctly. After correcting the previous problem, I am able to login. The log shows the correct authentication with no errors. Yet, I not getting anything after the login. the web page is clear, in stead of taking me to the next page, by design. the top url address is like: http://localhost/login/j_security_check any help, suggestion, or comment would be nice. Thanks, James -Original Message- From: Jon Wingfield [mailto:[EMAIL PROTECTED] Sent: Thursday, November 27, 2003 5:01 AM To: Tomcat Users List Subject: Re: JDBCRealm problem The JDBCRealm does two things: 1) Authenticates the user (by checking password) 2) Authorizes the user (by checking roles) The logs would seem to imply the JDBC driver is blowing up creating the prepared statement in the second step (ie reading from the roles table). I think Tim is right - he usually is - that there is a config problem with the db or the connection to the db. A quick google later: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B313181 HTH, Jon Ostad, James wrote: The line above the line you mentioned in the error log indicates that the connection was established at one point: 2003-11-26 11:53:19 JDBCRealm[localhost]: Username admin successfully authenticated 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication So, I don't think that the parameters are wrong, neither the database setup. The web application functions with form base authentication without usage of realm. It is my next step to implement the realm, which I having problem. but, I will double check my settings and configuration to make sure that I didn't miss anything. thanks, James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 4:00 PM To: Tomcat Users List Subject: Re: JDBCRealm problem The problem is this: 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode. Since I don't use SQL server and Java, I can't be of more help, but my guess is - Database setup - Driver parameter missing -Tim Ostad, James wrote: Hi everyone, Hope everyone will have a great TG Day. Problem: I am not able to login successfully. It keeps failing. Structure: using JDBCRealm + form authentication database property: match exactly as explained in tomcat documentation for setting up JDBCRealm I am including three things: 1-server.xml part for realm setup 2-web.xml of the web apps 3-errorlog file is the error log I get when I attempt to use jdbcrealm
Re: JDBCRealm problem
http://cvs.apache.org/viewcvs.cgi/jakarta-tomcat-4.0/catalina/src/share/org/apache/catalina/realm/JNDIRealm.java The easiest way to compile in this case: CP=*All jars in $CATALINA/common/lib,All jars in $CATALINA/server/lib* javac -classpath $CP -d $CATALINA_HOME/server/classes JNDIRealm.java -Tim Ostad, James wrote: I am new in tomcat. I am looking in tomcat site for source file for JDBCRealm. Is this part of the tomcat source files? or it is separate? thanks James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 10:20 AM To: Tomcat Users List Subject: Re: JDBCRealm problem If you have a NPE, it might being thrown by the Realm. This can happen when there is a null role or similar. This has since been patched. You can test it by getting the latest JDBCRealm from source, compiling it and placing it in the appropriate nested dir in server/classes. (Which has a higher precedence than the lib dir) -Tim Ostad, James wrote: One more thing, when I commented out the realm section in server.xml, the program does work with the default realm. James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 10:08 AM To: Tomcat Users List Subject: RE: JDBCRealm problem I just noticed this errors in the following files under tomcat log directory: catalina_log.2003-12-03.txt 2003-12-03 09:59:06 CoyoteAdapter An exception or error occurred in the container during the request processing java.lang.NullPointerException at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:478) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:394) at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAut henticator.java:263) localhost_log.2003-11-26.txt 2003-12-03 09:58:53 StandardManager[/webdav]: Seeding of random number generator has been completed 2003-12-03 09:58:53 StandardManager[/webdav] IOException while loading persisted sessions: java.io.EOFException java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.ja va:2150) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStre am.java:2619) Any help would be appreciated thanks, James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 9:51 AM To: Tomcat Users List Subject: RE: JDBCRealm problem Hi, Thanks for the info. Apparently, the database was not set correctly. After correcting the previous problem, I am able to login. The log shows the correct authentication with no errors. Yet, I not getting anything after the login. the web page is clear, in stead of taking me to the next page, by design. the top url address is like: http://localhost/login/j_security_check any help, suggestion, or comment would be nice. Thanks, James -Original Message- From: Jon Wingfield [mailto:[EMAIL PROTECTED] Sent: Thursday, November 27, 2003 5:01 AM To: Tomcat Users List Subject: Re: JDBCRealm problem The JDBCRealm does two things: 1) Authenticates the user (by checking password) 2) Authorizes the user (by checking roles) The logs would seem to imply the JDBC driver is blowing up creating the prepared statement in the second step (ie reading from the roles table). I think Tim is right - he usually is - that there is a config problem with the db or the connection to the db. A quick google later: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B313181 HTH, Jon Ostad, James wrote: The line above the line you mentioned in the error log indicates that the connection was established at one point: 2003-11-26 11:53:19 JDBCRealm[localhost]: Username admin successfully authenticated 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication So, I don't think that the parameters are wrong, neither the database setup. The web application functions with form base authentication without usage of realm. It is my next step to implement the realm, which I having problem. but, I will double check my settings and configuration to make sure that I didn't miss anything. thanks, James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 4:00 PM To: Tomcat Users List Subject: Re: JDBCRealm problem The problem is this: 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode. Since I don't use SQL server and Java, I can't be of more help, but my guess is - Database setup - Driver parameter missing -Tim Ostad, James wrote: Hi everyone, Hope everyone will have a great TG Day. Problem: I am not able to login successfully. It keeps failing. Structure: using JDBCRealm + form authentication database property: match exactly as explained in tomcat documentation for setting up JDBCRealm I am
RE: JDBCRealm problem
Tim, I got the source files. Now there are three jdbcrealm files: jdbcrealm.java jdbcrealmform.java do I need to compile them all, or just the first one? thanks, james -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 10:20 AM To: Tomcat Users List Subject: Re: JDBCRealm problem If you have a NPE, it might being thrown by the Realm. This can happen when there is a null role or similar. This has since been patched. You can test it by getting the latest JDBCRealm from source, compiling it and placing it in the appropriate nested dir in server/classes. (Which has a higher precedence than the lib dir) -Tim Ostad, James wrote: One more thing, when I commented out the realm section in server.xml, the program does work with the default realm. James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 10:08 AM To: Tomcat Users List Subject: RE: JDBCRealm problem I just noticed this errors in the following files under tomcat log directory: catalina_log.2003-12-03.txt 2003-12-03 09:59:06 CoyoteAdapter An exception or error occurred in the container during the request processing java.lang.NullPointerException at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:478) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:394) at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAut henticator.java:263) localhost_log.2003-11-26.txt 2003-12-03 09:58:53 StandardManager[/webdav]: Seeding of random number generator has been completed 2003-12-03 09:58:53 StandardManager[/webdav] IOException while loading persisted sessions: java.io.EOFException java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.ja va:2150) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStre am.java:2619) Any help would be appreciated thanks, James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 9:51 AM To: Tomcat Users List Subject: RE: JDBCRealm problem Hi, Thanks for the info. Apparently, the database was not set correctly. After correcting the previous problem, I am able to login. The log shows the correct authentication with no errors. Yet, I not getting anything after the login. the web page is clear, in stead of taking me to the next page, by design. the top url address is like: http://localhost/login/j_security_check any help, suggestion, or comment would be nice. Thanks, James -Original Message- From: Jon Wingfield [mailto:[EMAIL PROTECTED] Sent: Thursday, November 27, 2003 5:01 AM To: Tomcat Users List Subject: Re: JDBCRealm problem The JDBCRealm does two things: 1) Authenticates the user (by checking password) 2) Authorizes the user (by checking roles) The logs would seem to imply the JDBC driver is blowing up creating the prepared statement in the second step (ie reading from the roles table). I think Tim is right - he usually is - that there is a config problem with the db or the connection to the db. A quick google later: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B313181 HTH, Jon Ostad, James wrote: The line above the line you mentioned in the error log indicates that the connection was established at one point: 2003-11-26 11:53:19 JDBCRealm[localhost]: Username admin successfully authenticated 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication So, I don't think that the parameters are wrong, neither the database setup. The web application functions with form base authentication without usage of realm. It is my next step to implement the realm, which I having problem. but, I will double check my settings and configuration to make sure that I didn't miss anything. thanks, James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 4:00 PM To: Tomcat Users List Subject: Re: JDBCRealm problem The problem is this: 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode. Since I don't use SQL server and Java, I can't be of more help, but my guess is - Database setup - Driver parameter missing -Tim Ostad, James wrote: Hi everyone, Hope everyone will have a great TG Day. Problem: I am not able to login successfully. It keeps failing. Structure: using JDBCRealm + form authentication database property: match exactly as explained in tomcat documentation for setting up JDBCRealm I am including three things: 1-server.xml part for realm setup 2-web.xml of the web apps 3-errorlog file is the error log I get when I attempt to use jdbcrealm
Re: JDBCRealm problem
Oops, wrong file: http://cvs.apache.org/viewcvs.cgi/jakarta-tomcat-4.0/catalina/src/share/org/apache/catalina/realm/JDBCRealm.java -Tim Tim Funk wrote: http://cvs.apache.org/viewcvs.cgi/jakarta-tomcat-4.0/catalina/src/share/org/apache/catalina/realm/JNDIRealm.java The easiest way to compile in this case: CP=*All jars in $CATALINA/common/lib,All jars in $CATALINA/server/lib* javac -classpath $CP -d $CATALINA_HOME/server/classes JNDIRealm.java -Tim Ostad, James wrote: I am new in tomcat. I am looking in tomcat site for source file for JDBCRealm. Is this part of the tomcat source files? or it is separate? thanks James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 10:20 AM To: Tomcat Users List Subject: Re: JDBCRealm problem If you have a NPE, it might being thrown by the Realm. This can happen when there is a null role or similar. This has since been patched. You can test it by getting the latest JDBCRealm from source, compiling it and placing it in the appropriate nested dir in server/classes. (Which has a higher precedence than the lib dir) -Tim Ostad, James wrote: One more thing, when I commented out the realm section in server.xml, the program does work with the default realm. James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 10:08 AM To: Tomcat Users List Subject: RE: JDBCRealm problem I just noticed this errors in the following files under tomcat log directory: catalina_log.2003-12-03.txt 2003-12-03 09:59:06 CoyoteAdapter An exception or error occurred in the container during the request processing java.lang.NullPointerException at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:478) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:394) at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAut henticator.java:263) localhost_log.2003-11-26.txt 2003-12-03 09:58:53 StandardManager[/webdav]: Seeding of random number generator has been completed 2003-12-03 09:58:53 StandardManager[/webdav] IOException while loading persisted sessions: java.io.EOFException java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.ja va:2150) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStre am.java:2619) Any help would be appreciated thanks, James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 9:51 AM To: Tomcat Users List Subject: RE: JDBCRealm problem Hi, Thanks for the info. Apparently, the database was not set correctly. After correcting the previous problem, I am able to login. The log shows the correct authentication with no errors. Yet, I not getting anything after the login. the web page is clear, in stead of taking me to the next page, by design. the top url address is like: http://localhost/login/j_security_check any help, suggestion, or comment would be nice. Thanks, James -Original Message- From: Jon Wingfield [mailto:[EMAIL PROTECTED] Sent: Thursday, November 27, 2003 5:01 AM To: Tomcat Users List Subject: Re: JDBCRealm problem The JDBCRealm does two things: 1) Authenticates the user (by checking password) 2) Authorizes the user (by checking roles) The logs would seem to imply the JDBC driver is blowing up creating the prepared statement in the second step (ie reading from the roles table). I think Tim is right - he usually is - that there is a config problem with the db or the connection to the db. A quick google later: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B313181 HTH, Jon Ostad, James wrote: The line above the line you mentioned in the error log indicates that the connection was established at one point: 2003-11-26 11:53:19 JDBCRealm[localhost]: Username admin successfully authenticated 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication So, I don't think that the parameters are wrong, neither the database setup. The web application functions with form base authentication without usage of realm. It is my next step to implement the realm, which I having problem. but, I will double check my settings and configuration to make sure that I didn't miss anything. thanks, James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 4:00 PM To: Tomcat Users List Subject: Re: JDBCRealm problem The problem is this: 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode. Since I don't use SQL server and Java, I can't be of more help, but my guess is - Database setup - Driver parameter missing -Tim Ostad, James wrote: Hi everyone, Hope everyone will have a great TG Day. Problem: I am not able to login successfully. It keeps failing. Structure: using
RE: JDBCRealm problem
Tim, I am afraid that I am not familiar with the first line, CP=... is that a copy command on unix? thanks james -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 11:20 AM To: Tomcat Users List Subject: Re: JDBCRealm problem Oops, wrong file: http://cvs.apache.org/viewcvs.cgi/jakarta-tomcat-4.0/catalina/src/share/ org/apache/catalina/realm/JDBCRealm.java -Tim Tim Funk wrote: http://cvs.apache.org/viewcvs.cgi/jakarta-tomcat-4.0/catalina/src/share/ org/apache/catalina/realm/JNDIRealm.java The easiest way to compile in this case: CP=*All jars in $CATALINA/common/lib,All jars in $CATALINA/server/lib* javac -classpath $CP -d $CATALINA_HOME/server/classes JNDIRealm.java -Tim Ostad, James wrote: I am new in tomcat. I am looking in tomcat site for source file for JDBCRealm. Is this part of the tomcat source files? or it is separate? thanks James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 10:20 AM To: Tomcat Users List Subject: Re: JDBCRealm problem If you have a NPE, it might being thrown by the Realm. This can happen when there is a null role or similar. This has since been patched. You can test it by getting the latest JDBCRealm from source, compiling it and placing it in the appropriate nested dir in server/classes. (Which has a higher precedence than the lib dir) -Tim Ostad, James wrote: One more thing, when I commented out the realm section in server.xml, the program does work with the default realm. James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 10:08 AM To: Tomcat Users List Subject: RE: JDBCRealm problem I just noticed this errors in the following files under tomcat log directory: catalina_log.2003-12-03.txt 2003-12-03 09:59:06 CoyoteAdapter An exception or error occurred in the container during the request processing java.lang.NullPointerException at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:478) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:394) at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAut henticator.java:263) localhost_log.2003-11-26.txt 2003-12-03 09:58:53 StandardManager[/webdav]: Seeding of random number generator has been completed 2003-12-03 09:58:53 StandardManager[/webdav] IOException while loading persisted sessions: java.io.EOFException java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.ja va:2150) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStre am.java:2619) Any help would be appreciated thanks, James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 9:51 AM To: Tomcat Users List Subject: RE: JDBCRealm problem Hi, Thanks for the info. Apparently, the database was not set correctly. After correcting the previous problem, I am able to login. The log shows the correct authentication with no errors. Yet, I not getting anything after the login. the web page is clear, in stead of taking me to the next page, by design. the top url address is like: http://localhost/login/j_security_check any help, suggestion, or comment would be nice. Thanks, James -Original Message- From: Jon Wingfield [mailto:[EMAIL PROTECTED] Sent: Thursday, November 27, 2003 5:01 AM To: Tomcat Users List Subject: Re: JDBCRealm problem The JDBCRealm does two things: 1) Authenticates the user (by checking password) 2) Authorizes the user (by checking roles) The logs would seem to imply the JDBC driver is blowing up creating the prepared statement in the second step (ie reading from the roles table). I think Tim is right - he usually is - that there is a config problem with the db or the connection to the db. A quick google later: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B313181 HTH, Jon Ostad, James wrote: The line above the line you mentioned in the error log indicates that the connection was established at one point: 2003-11-26 11:53:19 JDBCRealm[localhost]: Username admin successfully authenticated 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication So, I don't think that the parameters are wrong, neither the database setup. The web application functions with form base authentication without usage of realm. It is my next step to implement the realm, which I having problem. but, I will double check my settings and configuration to make sure that I didn't miss anything. thanks, James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 4:00 PM To: Tomcat Users List Subject: Re: JDBCRealm problem The problem is this: 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing
Re: JDBCRealm problem
It was a lazy way to set environment variables in unix. Here is a simple way in ant: (just the relevant snippets, not a lesson in ant) ... path id=classpath pathelement location=${catalina.home}/common/classes/ fileset dir=${catalina.home}/common/lib include name=**/*.jar/ /fileset pathelement location=${catalina.home}/server/classes/ fileset dir=${catalina.home}/server/lib include name=**/*.jar/ /fileset /path ... !-- Assuming java file is in a dir called src -- target name=compile javac srcdir=src deprecation=true debug=true destdir=${catalina.home}/server/classes classpath refid=classpath/ /javac /target ... -Tim Ostad, James wrote: Tim, I am afraid that I am not familiar with the first line, CP=... is that a copy command on unix? thanks james -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 11:20 AM To: Tomcat Users List Subject: Re: JDBCRealm problem Oops, wrong file: http://cvs.apache.org/viewcvs.cgi/jakarta-tomcat-4.0/catalina/src/share/ org/apache/catalina/realm/JDBCRealm.java -Tim Tim Funk wrote: http://cvs.apache.org/viewcvs.cgi/jakarta-tomcat-4.0/catalina/src/share/ org/apache/catalina/realm/JNDIRealm.java The easiest way to compile in this case: CP=*All jars in $CATALINA/common/lib,All jars in $CATALINA/server/lib* javac -classpath $CP -d $CATALINA_HOME/server/classes JNDIRealm.java -Tim Ostad, James wrote: I am new in tomcat. I am looking in tomcat site for source file for JDBCRealm. Is this part of the tomcat source files? or it is separate? thanks James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 10:20 AM To: Tomcat Users List Subject: Re: JDBCRealm problem If you have a NPE, it might being thrown by the Realm. This can happen when there is a null role or similar. This has since been patched. You can test it by getting the latest JDBCRealm from source, compiling it and placing it in the appropriate nested dir in server/classes. (Which has a higher precedence than the lib dir) -Tim Ostad, James wrote: One more thing, when I commented out the realm section in server.xml, the program does work with the default realm. James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 10:08 AM To: Tomcat Users List Subject: RE: JDBCRealm problem I just noticed this errors in the following files under tomcat log directory: catalina_log.2003-12-03.txt 2003-12-03 09:59:06 CoyoteAdapter An exception or error occurred in the container during the request processing java.lang.NullPointerException at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:478) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:394) at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAut henticator.java:263) localhost_log.2003-11-26.txt 2003-12-03 09:58:53 StandardManager[/webdav]: Seeding of random number generator has been completed 2003-12-03 09:58:53 StandardManager[/webdav] IOException while loading persisted sessions: java.io.EOFException java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.ja va:2150) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStre am.java:2619) Any help would be appreciated thanks, James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 9:51 AM To: Tomcat Users List Subject: RE: JDBCRealm problem Hi, Thanks for the info. Apparently, the database was not set correctly. After correcting the previous problem, I am able to login. The log shows the correct authentication with no errors. Yet, I not getting anything after the login. the web page is clear, in stead of taking me to the next page, by design. the top url address is like: http://localhost/login/j_security_check any help, suggestion, or comment would be nice. Thanks, James -Original Message- From: Jon Wingfield [mailto:[EMAIL PROTECTED] Sent: Thursday, November 27, 2003 5:01 AM To: Tomcat Users List Subject: Re: JDBCRealm problem The JDBCRealm does two things: 1) Authenticates the user (by checking password) 2) Authorizes the user (by checking roles) The logs would seem to imply the JDBC driver is blowing up creating the prepared statement in the second step (ie reading from the roles table). I think Tim is right - he usually is - that there is a config problem with the db or the connection to the db. A quick google later: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B313181 HTH, Jon Ostad, James wrote: The line above the line you mentioned in the error log indicates that the connection was established at one point: 2003-11-26 11:53:19 JDBCRealm[localhost]: Username admin successfully authenticated 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication So, I don't think that the parameters
RE: JDBCRealm problem
Thank you. What a educational ride. I did the compilation of the jdbcrealm.java Now I am getting the http status 403 !!! again, without this realm setup in server.xml, by just using the DD file, I don't have any restriction problem. any suggestion? thanks, James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 12:13 PM To: Tomcat Users List Subject: Re: JDBCRealm problem It was a lazy way to set environment variables in unix. Here is a simple way in ant: (just the relevant snippets, not a lesson in ant) ... path id=classpath pathelement location=${catalina.home}/common/classes/ fileset dir=${catalina.home}/common/lib include name=**/*.jar/ /fileset pathelement location=${catalina.home}/server/classes/ fileset dir=${catalina.home}/server/lib include name=**/*.jar/ /fileset /path ... !-- Assuming java file is in a dir called src -- target name=compile javac srcdir=src deprecation=true debug=true destdir=${catalina.home}/server/classes classpath refid=classpath/ /javac /target ... -Tim Ostad, James wrote: Tim, I am afraid that I am not familiar with the first line, CP=... is that a copy command on unix? thanks james -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 11:20 AM To: Tomcat Users List Subject: Re: JDBCRealm problem Oops, wrong file: http://cvs.apache.org/viewcvs.cgi/jakarta-tomcat-4.0/catalina/src/share/ org/apache/catalina/realm/JDBCRealm.java -Tim Tim Funk wrote: http://cvs.apache.org/viewcvs.cgi/jakarta-tomcat-4.0/catalina/src/share/ org/apache/catalina/realm/JNDIRealm.java The easiest way to compile in this case: CP=*All jars in $CATALINA/common/lib,All jars in $CATALINA/server/lib* javac -classpath $CP -d $CATALINA_HOME/server/classes JNDIRealm.java -Tim Ostad, James wrote: I am new in tomcat. I am looking in tomcat site for source file for JDBCRealm. Is this part of the tomcat source files? or it is separate? thanks James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 10:20 AM To: Tomcat Users List Subject: Re: JDBCRealm problem If you have a NPE, it might being thrown by the Realm. This can happen when there is a null role or similar. This has since been patched. You can test it by getting the latest JDBCRealm from source, compiling it and placing it in the appropriate nested dir in server/classes. (Which has a higher precedence than the lib dir) -Tim Ostad, James wrote: One more thing, when I commented out the realm section in server.xml, the program does work with the default realm. James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 10:08 AM To: Tomcat Users List Subject: RE: JDBCRealm problem I just noticed this errors in the following files under tomcat log directory: catalina_log.2003-12-03.txt 2003-12-03 09:59:06 CoyoteAdapter An exception or error occurred in the container during the request processing java.lang.NullPointerException at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:478) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:394) at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAut henticator.java:263) localhost_log.2003-11-26.txt 2003-12-03 09:58:53 StandardManager[/webdav]: Seeding of random number generator has been completed 2003-12-03 09:58:53 StandardManager[/webdav] IOException while loading persisted sessions: java.io.EOFException java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.ja va:2150) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStre am.java:2619) Any help would be appreciated thanks, James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 9:51 AM To: Tomcat Users List Subject: RE: JDBCRealm problem Hi, Thanks for the info. Apparently, the database was not set correctly. After correcting the previous problem, I am able to login. The log shows the correct authentication with no errors. Yet, I not getting anything after the login. the web page is clear, in stead of taking me to the next page, by design. the top url address is like: http://localhost/login/j_security_check any help, suggestion, or comment would be nice. Thanks, James -Original Message- From: Jon Wingfield [mailto:[EMAIL PROTECTED] Sent: Thursday, November 27, 2003 5:01 AM To: Tomcat Users List Subject: Re: JDBCRealm problem The JDBCRealm does two things: 1) Authenticates the user (by checking password) 2) Authorizes the user (by checking roles) The logs would seem to imply the JDBC driver is blowing up creating the prepared statement in the second step (ie reading from the roles table). I think
RE: JDBCRealm problem
I noticed in the log file that after authentication of admin user, another line indicates that the user admin does not have the role admin. I am checking database to make sure that the role and user have relationship. any suggestion? thanks, james -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 2:51 PM To: Tomcat Users List Subject: RE: JDBCRealm problem Thank you. What a educational ride. I did the compilation of the jdbcrealm.java Now I am getting the http status 403 !!! again, without this realm setup in server.xml, by just using the DD file, I don't have any restriction problem. any suggestion? thanks, James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 12:13 PM To: Tomcat Users List Subject: Re: JDBCRealm problem It was a lazy way to set environment variables in unix. Here is a simple way in ant: (just the relevant snippets, not a lesson in ant) ... path id=classpath pathelement location=${catalina.home}/common/classes/ fileset dir=${catalina.home}/common/lib include name=**/*.jar/ /fileset pathelement location=${catalina.home}/server/classes/ fileset dir=${catalina.home}/server/lib include name=**/*.jar/ /fileset /path ... !-- Assuming java file is in a dir called src -- target name=compile javac srcdir=src deprecation=true debug=true destdir=${catalina.home}/server/classes classpath refid=classpath/ /javac /target ... -Tim Ostad, James wrote: Tim, I am afraid that I am not familiar with the first line, CP=... is that a copy command on unix? thanks james -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 11:20 AM To: Tomcat Users List Subject: Re: JDBCRealm problem Oops, wrong file: http://cvs.apache.org/viewcvs.cgi/jakarta-tomcat-4.0/catalina/src/share/ org/apache/catalina/realm/JDBCRealm.java -Tim Tim Funk wrote: http://cvs.apache.org/viewcvs.cgi/jakarta-tomcat-4.0/catalina/src/share/ org/apache/catalina/realm/JNDIRealm.java The easiest way to compile in this case: CP=*All jars in $CATALINA/common/lib,All jars in $CATALINA/server/lib* javac -classpath $CP -d $CATALINA_HOME/server/classes JNDIRealm.java -Tim Ostad, James wrote: I am new in tomcat. I am looking in tomcat site for source file for JDBCRealm. Is this part of the tomcat source files? or it is separate? thanks James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 10:20 AM To: Tomcat Users List Subject: Re: JDBCRealm problem If you have a NPE, it might being thrown by the Realm. This can happen when there is a null role or similar. This has since been patched. You can test it by getting the latest JDBCRealm from source, compiling it and placing it in the appropriate nested dir in server/classes. (Which has a higher precedence than the lib dir) -Tim Ostad, James wrote: One more thing, when I commented out the realm section in server.xml, the program does work with the default realm. James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 10:08 AM To: Tomcat Users List Subject: RE: JDBCRealm problem I just noticed this errors in the following files under tomcat log directory: catalina_log.2003-12-03.txt 2003-12-03 09:59:06 CoyoteAdapter An exception or error occurred in the container during the request processing java.lang.NullPointerException at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:478) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:394) at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAut henticator.java:263) localhost_log.2003-11-26.txt 2003-12-03 09:58:53 StandardManager[/webdav]: Seeding of random number generator has been completed 2003-12-03 09:58:53 StandardManager[/webdav] IOException while loading persisted sessions: java.io.EOFException java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.ja va:2150) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStre am.java:2619) Any help would be appreciated thanks, James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 9:51 AM To: Tomcat Users List Subject: RE: JDBCRealm problem Hi, Thanks for the info. Apparently, the database was not set correctly. After correcting the previous problem, I am able to login. The log shows the correct authentication with no errors. Yet, I not getting anything after the login. the web page is clear, in stead of taking me to the next page, by design. the top url address is like: http://localhost/login/j_security_check any help, suggestion, or comment would be nice. Thanks, James -Original Message- From: Jon Wingfield [mailto
Re: JDBCRealm problem
Turn debugging up to 99. -Tim Ostad, James wrote: I noticed in the log file that after authentication of admin user, another line indicates that the user admin does not have the role admin. I am checking database to make sure that the role and user have relationship. any suggestion? thanks, james -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 2:51 PM To: Tomcat Users List Subject: RE: JDBCRealm problem Thank you. What a educational ride. I did the compilation of the jdbcrealm.java Now I am getting the http status 403 !!! again, without this realm setup in server.xml, by just using the DD file, I don't have any restriction problem. any suggestion? thanks, James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 12:13 PM To: Tomcat Users List Subject: Re: JDBCRealm problem It was a lazy way to set environment variables in unix. Here is a simple way in ant: (just the relevant snippets, not a lesson in ant) ... path id=classpath pathelement location=${catalina.home}/common/classes/ fileset dir=${catalina.home}/common/lib include name=**/*.jar/ /fileset pathelement location=${catalina.home}/server/classes/ fileset dir=${catalina.home}/server/lib include name=**/*.jar/ /fileset /path ... !-- Assuming java file is in a dir called src -- target name=compile javac srcdir=src deprecation=true debug=true destdir=${catalina.home}/server/classes classpath refid=classpath/ /javac /target ... -Tim Ostad, James wrote: Tim, I am afraid that I am not familiar with the first line, CP=... is that a copy command on unix? thanks james -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 11:20 AM To: Tomcat Users List Subject: Re: JDBCRealm problem Oops, wrong file: http://cvs.apache.org/viewcvs.cgi/jakarta-tomcat-4.0/catalina/src/share/ org/apache/catalina/realm/JDBCRealm.java -Tim Tim Funk wrote: http://cvs.apache.org/viewcvs.cgi/jakarta-tomcat-4.0/catalina/src/share/ org/apache/catalina/realm/JNDIRealm.java The easiest way to compile in this case: CP=*All jars in $CATALINA/common/lib,All jars in $CATALINA/server/lib* javac -classpath $CP -d $CATALINA_HOME/server/classes JNDIRealm.java -Tim Ostad, James wrote: I am new in tomcat. I am looking in tomcat site for source file for JDBCRealm. Is this part of the tomcat source files? or it is separate? thanks James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 10:20 AM To: Tomcat Users List Subject: Re: JDBCRealm problem If you have a NPE, it might being thrown by the Realm. This can happen when there is a null role or similar. This has since been patched. You can test it by getting the latest JDBCRealm from source, compiling it and placing it in the appropriate nested dir in server/classes. (Which has a higher precedence than the lib dir) -Tim Ostad, James wrote: One more thing, when I commented out the realm section in server.xml, the program does work with the default realm. James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 10:08 AM To: Tomcat Users List Subject: RE: JDBCRealm problem I just noticed this errors in the following files under tomcat log directory: catalina_log.2003-12-03.txt 2003-12-03 09:59:06 CoyoteAdapter An exception or error occurred in the container during the request processing java.lang.NullPointerException at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:478) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:394) at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAut henticator.java:263) localhost_log.2003-11-26.txt 2003-12-03 09:58:53 StandardManager[/webdav]: Seeding of random number generator has been completed 2003-12-03 09:58:53 StandardManager[/webdav] IOException while loading persisted sessions: java.io.EOFException java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.ja va:2150) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStre am.java:2619) Any help would be appreciated thanks, James -Original Message- From: Ostad, James Sent: Wednesday, December 03, 2003 9:51 AM To: Tomcat Users List Subject: RE: JDBCRealm problem Hi, Thanks for the info. Apparently, the database was not set correctly. After correcting the previous problem, I am able to login. The log shows the correct authentication with no errors. Yet, I not getting anything after the login. the web page is clear, in stead of taking me to the next page, by design. the top url address is like: http://localhost/login/j_security_check any help, suggestion, or comment would be nice. Thanks, James -Original Message- From: Jon Wingfield [mailto:[EMAIL PROTECTED] Sent: Thursday
Re: JDBCRealm problem
The JDBCRealm does two things: 1) Authenticates the user (by checking password) 2) Authorizes the user (by checking roles) The logs would seem to imply the JDBC driver is blowing up creating the prepared statement in the second step (ie reading from the roles table). I think Tim is right - he usually is - that there is a config problem with the db or the connection to the db. A quick google later: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B313181 HTH, Jon Ostad, James wrote: The line above the line you mentioned in the error log indicates that the connection was established at one point: 2003-11-26 11:53:19 JDBCRealm[localhost]: Username admin successfully authenticated 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication So, I don't think that the parameters are wrong, neither the database setup. The web application functions with form base authentication without usage of realm. It is my next step to implement the realm, which I having problem. but, I will double check my settings and configuration to make sure that I didn't miss anything. thanks, James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 4:00 PM To: Tomcat Users List Subject: Re: JDBCRealm problem The problem is this: 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode. Since I don't use SQL server and Java, I can't be of more help, but my guess is - Database setup - Driver parameter missing -Tim Ostad, James wrote: Hi everyone, Hope everyone will have a great TG Day. Problem: I am not able to login successfully. It keeps failing. Structure: using JDBCRealm + form authentication database property: match exactly as explained in tomcat documentation for setting up JDBCRealm I am including three things: 1-server.xml part for realm setup 2-web.xml of the web apps 3-errorlog file is the error log I get when I attempt to use jdbcrealm. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ---In (14) Out--- (3) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
JDBCRealm problem
Hi everyone, Hope everyone will have a great TG Day. Problem: I am not able to login successfully. It keeps failing. Structure: using JDBCRealm + form authentication database property: match exactly as explained in tomcat documentation for setting up JDBCRealm I am including three things: 1-server.xml part for realm setup 2-web.xml of the web apps 3-errorlog file is the error log I get when I attempt to use jdbcrealm. you will find them in this email accordingly. Any help will be appreciated. server.xml** Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=com.microsoft.jdbc.sqlserver.SQLServerDriver connectionURL=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=us ers;User=image;Password=image userTable=users userNameCol=username userCredCol=userpass userRoleTable=userroles roleNameCole=rolename / web.xml* web-app context-param param-namejdbcDriver/param-name param-valuecom.microsoft.jdbc.sqlserver.SQLServerDriver/param-value /context-param context-param param-namejdbcURL/param-name param-valuejdbc:microsoft:sqlserver://localhost:1433;DatabaseName=imag e/param-value /context-param context-param param-namejdbcUserName/param-name param-valueimage/param-value !-- no user name -- /context-param context-param param-namejdbcPassword/param-name param-valueimage/param-value !-- no password -- /context-param context-param param-nameminimumConnections/param-name param-value1/param-value /context-param context-param param-namemaximumConnections/param-name param-value5/param-value /context-param listener listener-classweb.InitializeConnectionPool/listener-class /listener !-- END: Initialization of the WebApp Connection Pool -- servlet-namegateway/servlet-name display-nameGateway/display-name descriptionEntry to CRC/description jsp-file/Gateway.jsp/jsp-file /servlet servlet servlet-namecrcForm/servlet-name display-namecrcForm/display-name descriptionForm to request data/description jsp-file/Forms/crcForm.jsp/jsp-file /servlet servlet-mapping servlet-namegateway/servlet-name url-pattern/Gateway/url-pattern /servlet-mapping servlet-mapping servlet-namecrcForm/servlet-name url-pattern/form/url-pattern /servlet-mapping session-config session-timeout 20 /session-timeout /session-config error-page exception-typeutil.sql.ConnNotAvailException/exception-type location/error/server_busy.html/location /error-page error-page exception-typeutil.sql.ShuttingDownException/exception-type location/error/server_shutdown.html/location /error-page security-constraint web-resource-collection web-resource-nameRestrictedResources/web-resource-name url-pattern/form/url-pattern http-methodPOST/http-method http-methodGET/http-method /web-resource-collection auth-constraint role-nameadmin/role-name /auth-constraint /security-constraint login-config auth-methodFORM/auth-method form-login-config form-login-page/login/login.jsp/form-login-page form-error-page/login/error.jsp/form-error-page /form-login-config /login-config security-role descriptionA simple restricted-access user role./description role-nameadmin/role-name /security-role /web-app errorlogfile* some of you would like to have all errors, some don't. So I attached the error logfile. Thanks, James Ostad Application Developer/Analyst TMS Department Ex. 4457 E-mail: [EMAIL PROTECTED] Out--- (3) 2003-11-26 11:51:17 HostConfig[localhost]: Deploying configuration descriptor admin.xml 2003-11-26 11:51:26 HostConfig[localhost]: Deploying configuration descriptor manager.xml 2003-11-26 11:51:26 WebappLoader[/manager]: Deploying class repositories to work directory D:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\manager 2003-11-26 11:51:26 ContextConfig[/manager]: Configured an authenticator for method BASIC 2003-11-26 11:51:26 StandardManager[/manager]: Seeding random number generator class java.security.SecureRandom 2003-11-26 11:51:26 StandardManager[/manager]: Seeding of random number generator has been completed 2003-11-26 11:51:26 StandardManager[/manager] IOException while loading persisted sessions: java.io.EOFException java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2150) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.java:2619) at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:726) at java.io.ObjectInputStream.init(ObjectInputStream.java:251) at
RE: JDBCRealm problem
one more thing, you might have notice by my first email, I am initializing the database connection within the web.xml. I am not sure that has to do with the problem. The initialization in web.xml is for internal bean usage. thanks, James -Original Message- From: Ostad, James Sent: Wednesday, November 26, 2003 12:23 PM To: Tom (E-mail) Subject: JDBCRealm problem Hi everyone, Hope everyone will have a great TG Day. Problem: I am not able to login successfully. It keeps failing. Structure: using JDBCRealm + form authentication database property: match exactly as explained in tomcat documentation for setting up JDBCRealm I am including three things: 1-server.xml part for realm setup 2-web.xml of the web apps 3-errorlog file is the error log I get when I attempt to use jdbcrealm. you will find them in this email accordingly. Any help will be appreciated. server.xml** Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=com.microsoft.jdbc.sqlserver.SQLServerDriver connectionURL=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=us ers;User=image;Password=image userTable=users userNameCol=username userCredCol=userpass userRoleTable=userroles roleNameCole=rolename / web.xml* web-app context-param param-namejdbcDriver/param-name param-valuecom.microsoft.jdbc.sqlserver.SQLServerDriver/param-value /context-param context-param param-namejdbcURL/param-name param-valuejdbc:microsoft:sqlserver://localhost:1433;DatabaseName=imag e/param-value /context-param context-param param-namejdbcUserName/param-name param-valueimage/param-value !-- no user name -- /context-param context-param param-namejdbcPassword/param-name param-valueimage/param-value !-- no password -- /context-param context-param param-nameminimumConnections/param-name param-value1/param-value /context-param context-param param-namemaximumConnections/param-name param-value5/param-value /context-param listener listener-classweb.InitializeConnectionPool/listener-class /listener !-- END: Initialization of the WebApp Connection Pool -- servlet-namegateway/servlet-name display-nameGateway/display-name descriptionEntry to CRC/description jsp-file/Gateway.jsp/jsp-file /servlet servlet servlet-namecrcForm/servlet-name display-namecrcForm/display-name descriptionForm to request data/description jsp-file/Forms/crcForm.jsp/jsp-file /servlet servlet-mapping servlet-namegateway/servlet-name url-pattern/Gateway/url-pattern /servlet-mapping servlet-mapping servlet-namecrcForm/servlet-name url-pattern/form/url-pattern /servlet-mapping session-config session-timeout 20 /session-timeout /session-config error-page exception-typeutil.sql.ConnNotAvailException/exception-type location/error/server_busy.html/location /error-page error-page exception-typeutil.sql.ShuttingDownException/exception-type location/error/server_shutdown.html/location /error-page security-constraint web-resource-collection web-resource-nameRestrictedResources/web-resource-name url-pattern/form/url-pattern http-methodPOST/http-method http-methodGET/http-method /web-resource-collection auth-constraint role-nameadmin/role-name /auth-constraint /security-constraint login-config auth-methodFORM/auth-method form-login-config form-login-page/login/login.jsp/form-login-page form-error-page/login/error.jsp/form-error-page /form-login-config /login-config security-role descriptionA simple restricted-access user role./description role-nameadmin/role-name /security-role /web-app errorlogfile* some of you would like to have all errors, some don't. So I attached the error logfile. Thanks, James Ostad Application Developer/Analyst TMS Department Ex. 4457 E-mail: [EMAIL PROTECTED] Out--- (3) ---In (14) Out--- (3) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: JDBCRealm problem
The problem is this: 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode. Since I don't use SQL server and Java, I can't be of more help, but my guess is - Database setup - Driver parameter missing -Tim Ostad, James wrote: Hi everyone, Hope everyone will have a great TG Day. Problem: I am not able to login successfully. It keeps failing. Structure: using JDBCRealm + form authentication database property: match exactly as explained in tomcat documentation for setting up JDBCRealm I am including three things: 1-server.xml part for realm setup 2-web.xml of the web apps 3-errorlog file is the error log I get when I attempt to use jdbcrealm. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: JDBCRealm problem
The line above the line you mentioned in the error log indicates that the connection was established at one point: 2003-11-26 11:53:19 JDBCRealm[localhost]: Username admin successfully authenticated 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication So, I don't think that the parameters are wrong, neither the database setup. The web application functions with form base authentication without usage of realm. It is my next step to implement the realm, which I having problem. but, I will double check my settings and configuration to make sure that I didn't miss anything. thanks, James -Original Message- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 4:00 PM To: Tomcat Users List Subject: Re: JDBCRealm problem The problem is this: 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode. Since I don't use SQL server and Java, I can't be of more help, but my guess is - Database setup - Driver parameter missing -Tim Ostad, James wrote: Hi everyone, Hope everyone will have a great TG Day. Problem: I am not able to login successfully. It keeps failing. Structure: using JDBCRealm + form authentication database property: match exactly as explained in tomcat documentation for setting up JDBCRealm I am including three things: 1-server.xml part for realm setup 2-web.xml of the web apps 3-errorlog file is the error log I get when I attempt to use jdbcrealm. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ---In (14) Out--- (3) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
JDBCRealm problem with MySQL after adding password and changing user account
Hi, I have a problem with my Tomcat 4.1.18 JDBCRealm setup on Solaris in server.xml Previously I had this in my context definition in server.xml and it works fine: Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=com.mysql.jdbc.Driver connectionURL=jdbc:mysql://localhost:3307/praksis?user=root userTable=benutzer userNameCol=email userCredCol=passwort userRoleTable=rollen roleNameCol=rollenname digest=SHA-1/ Then I added a new user in MySQL named praksis to replace the root access and tried to change to this setup: Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=com.mysql.jdbc.Driver connectionURL=jdbc:mysql://localhost:3307/praksis?user=praksispassword =siskarp userTable=benutzer userNameCol=email userCredCol=passwort userRoleTable=rollen roleNameCol=rollenname digest=SHA-1/ Now I only get weird error messages from the xml parser: org.xml.sax.SAXParseException: The reference to entity password must end with the ';' delimiter. Thus I tried jdbc:mysql://localhost:3307/praksis?user=praksispassword=siskarp; but this didn't do the trick... Does it mean anything else? I use mysql-connector-java-2.0.14.jar in common/lib (for tomcat) and webapps/praksis/WEB-INF/libs (for struts) But I believe the connectionURL is correct because I looked it up in the tomcat doc under jdbc realms. The MySQL setup/user setup should be okay aswell, because my Struts connection pool works with: data-sources data-source set-property property=driverClass value=com.mysql.jdbc.Driver/ set-property property=url value=jdbc:mysql://localhost:3307/praksis/ set-property property=maxCount value=25/ set-property property=minCount value=5/ set-property property=user value=praksis/ set-property property=password value=siskarp/ /data-source /data-sources So right now, I'm using a root access without password for my JDBC Realm, because the different JDBC Realm prohibits Tomcat from starting up. But my webapp itself can utilize the struts connection pool with above user account setup without any problems. Actually I don't know what I did wrong and was hoping for help that I can use the praksis user for both purposes. Thanks! Michael -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: JDBCRealm problem with MySQL after adding password and changing user account (bug, unclear tomcat documentation or my stupidity?)
Sorry, for the post... Solved it myself. The trick was that you should NOT put your password into the connectionURL instead one can use: Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=com.mysql.jdbc.Driver connectionURL=jdbc:mysql://localhost:3307/praksis connectionName=praksis connectionPassword=siskarp userTable=benutzer userNameCol=email userCredCol=passwort userRoleTable=rollen roleNameCol=rollenname digest=SHA-1/ Although I have no idea why the tomcat documentation offers an example for exactly the case where you put username and password into the connectionURL. For some reason it works unless you only specify a user in the URL, but for more one has to split the data into connectionURL, connectionName and connectionPassword Did anybody have similar experiences? Is this a bug while parsing the server.xml? At least it doesn't seem to be very consistent, if connectionURL works with jdbc:mysql://localhost:3307/praksis?user=root but not with jdbc:mysql://localhost:3307/praksis?user=rootpassword=test So I start using ONLY connectionName and connectionPassword as I might get gray hairs soon enough anyway... ;-) Michael -Original Message- From: mech [mailto:[EMAIL PROTECTED]] Sent: Dienstag, 14. Januar 2003 14:06 To: [EMAIL PROTECTED] Subject: JDBCRealm problem with MySQL after adding password and changing user account Hi, I have a problem with my Tomcat 4.1.18 JDBCRealm setup on Solaris in server.xml Previously I had this in my context definition in server.xml and it works fine: Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=com.mysql.jdbc.Driver connectionURL=jdbc:mysql://localhost:3307/praksis?user=root userTable=benutzer userNameCol=email userCredCol=passwort userRoleTable=rollen roleNameCol=rollenname digest=SHA-1/ Then I added a new user in MySQL named praksis to replace the root access and tried to change to this setup: Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=com.mysql.jdbc.Driver connectionURL=jdbc:mysql://localhost:3307/praksis?user=praksi spassword =siskarp userTable=benutzer userNameCol=email userCredCol=passwort userRoleTable=rollen roleNameCol=rollenname digest=SHA-1/ Now I only get weird error messages from the xml parser: org.xml.sax.SAXParseException: The reference to entity password must end with the ';' delimiter. Thus I tried jdbc:mysql://localhost:3307/praksis?user=praksispassword=sis karp; but this didn't do the trick... Does it mean anything else? I use mysql-connector-java-2.0.14.jar in common/lib (for tomcat) and webapps/praksis/WEB-INF/libs (for struts) But I believe the connectionURL is correct because I looked it up in the tomcat doc under jdbc realms. The MySQL setup/user setup should be okay aswell, because my Struts connection pool works with: data-sources data-source set-property property=driverClass value=com.mysql.jdbc.Driver/ set-property property=url value=jdbc:mysql://localhost:3307/praksis/ set-property property=maxCount value=25/ set-property property=minCount value=5/ set-property property=user value=praksis/ set-property property=password value=siskarp/ /data-source /data-sources So right now, I'm using a root access without password for my JDBC Realm, because the different JDBC Realm prohibits Tomcat from starting up. But my webapp itself can utilize the struts connection pool with above user account setup without any problems. Actually I don't know what I did wrong and was hoping for help that I can use the praksis user for both purposes. Thanks! Michael -- To unsubscribe, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: JDBCRealm problem with MySQL after adding password and changing user account
If you want to use inside xml you have to encode it. ?user=praksispassword=foo should be changed to ?user=praksisamp;password=foo BTW: In the JDBCRealm-howto they use ; to seperate the password from the user. ?user=praksis;password=foo As I'm not using mysql I'm not shure if that is correct. -Original Message- From: mech [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 2:06 PM To: [EMAIL PROTECTED] Subject: JDBCRealm problem with MySQL after adding password and changing user account connectionURL=jdbc:mysql://localhost:3307/praksis?user=praksi spassword =siskarp userTable=benutzer userNameCol=email userCredCol=passwort userRoleTable=rollen roleNameCol=rollenname digest=SHA-1/ Now I only get weird error messages from the xml parser: org.xml.sax.SAXParseException: The reference to entity password must end with the ';' delimiter. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: JDBCRealm problem with MySQL after adding password and changing user account
Strange, I found this non-;-separated example in: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/realm-howto.html#JDBCRea lm Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost/authority?user=dbuserpassword=dbp ass userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name/ Your note for the in xml is true, but shouldn't matter in a quoted string, or do I mix something up now? Anyway... Using the connectionName, connectionPassword attributes and you are on the safe side... Michael -Original Message- From: Ralph Einfeldt [mailto:[EMAIL PROTECTED]] Sent: Dienstag, 14. Januar 2003 14:25 To: Tomcat Users List; [EMAIL PROTECTED] Subject: RE: JDBCRealm problem with MySQL after adding password and changing user account If you want to use inside xml you have to encode it. ?user=praksispassword=foo should be changed to ?user=praksisamp;password=foo BTW: In the JDBCRealm-howto they use ; to seperate the password from the user. ?user=praksis;password=foo As I'm not using mysql I'm not shure if that is correct. -Original Message- From: mech [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 2:06 PM To: [EMAIL PROTECTED] Subject: JDBCRealm problem with MySQL after adding password and changing user account connectionURL=jdbc:mysql://localhost:3307/praksis?user=praksi spassword =siskarp userTable=benutzer userNameCol=email userCredCol=passwort userRoleTable=rollen roleNameCol=rollenname digest=SHA-1/ Now I only get weird error messages from the xml parser: org.xml.sax.SAXParseException: The reference to entity password must end with the ';' delimiter. -- To unsubscribe, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
JDBCRealm problem (EMPTY page after login)
Hi! I am using JDBCRealm in Tomcat to setup the user authentication. For example if the user want to access abc.html, Tomcat will first display the login.jsp page. However, after the user logs in, it shows an EMPTY page. The user has to refresh the browser to see the content of abc.html Can any guru tell me how to fix this? Thanks! Alvin -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: tomcat4 and JDBCRealm problem
Craig, Thanks for the advice. For grins I wrote a quickie program in java that connected to the database and listed the users. It worked fine using the same parameters that were in the server.xml for Tomcat. So, I started to scratch my head some more and took a harder look at catalina.bat. Even though I had my NT classpath pointing to the mysql.jar, I decided to add the mysql.jar path to the following line in catalina.bat: --- set CP=%CATALINA_HOME%\bin\bootstrap.jar;%JAVA_HOME%\lib\tools.jar;c:\javali b\mysql.jar Voila!...it worked. Can you tell me why it didn't pick up the jar file from my NT classpath or from the lib directory in the TOMCAT_HOME? Maybe the instructions for setting up a JDBCRealm need to be modified to add this little tidbit of info. Thanks for the help, Bob Epling -Original Message- From: Craig R. McClanahan [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 8:52 PM To: [EMAIL PROTECTED] Subject: Re: tomcat4 and JDBCRealm problem The fact that you are getting a SQLException (rather than a ClassNotFoundException) implies that the problem is *not* in locating the driver - it is in the parameters you are specifying to establish the database connection. Double (and triple) check your values for the connectionName, connectionPassword, and connectionURL parameters, as well as the security permissions you have set up in the MySQL database itself. Craig McClanahan On Mon, 1 Oct 2001, Epling, Bob wrote: Date: Mon, 1 Oct 2001 16:50:41 -0600 From: Epling, Bob [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: tomcat4 and JDBCRealm problem Hi all, I have tomcat4 set up on my winnt machine and it works fine with basic Memory realm authentication. I followed the steps in setting up a JDBCRealm using mysql and I get the following error when starting Tomcat: Starting service Tomcat-Standalone Apache Tomcat/4.0 Catalina.start: LifecycleException: Exception opening database connection: java.sql.SQLException: org.gjt.mm.mysql.Dri ver LifecycleException: Exception opening database connection: java.sql.SQLException: org.gjt.mm.mysql.Driver at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:505) at org.apache.catalina.startup.Catalina.start(Catalina.java:776) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) at java.lang.reflect.Method.invoke(Native Method) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:218) - Root Cause - java.sql.SQLException: org.gjt.mm.mysql.Driver at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:538) at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:505) at org.apache.catalina.startup.Catalina.start(Catalina.java:776) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) at java.lang.reflect.Method.invoke(Native Method) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:218) I've tried putting the mysql jar in c:\javalib and also under c:\tomcat4.0\lib but no luck. This is my server.xml file currently: !-- Because this Realm is here, an instance will be shared globally -- !-- Realm className=org.apache.catalina.realm.MemoryRealm / -- !-- Replace the above Realm with one of the following to get a Realm stored in a database and accessed via JDBC -- Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost:3306/tomcatusers?user=root userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name / I can see the tables I have setup on my nt box in mysql. I can query those tables using mysql. Any help is appreciated. Thanks, Bob
RE: tomcat4 and JDBCRealm problem
On Tue, 2 Oct 2001, Epling, Bob wrote: Date: Tue, 2 Oct 2001 08:35:18 -0600 From: Epling, Bob [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: tomcat4 and JDBCRealm problem Craig, Thanks for the advice. For grins I wrote a quickie program in java that connected to the database and listed the users. It worked fine using the same parameters that were in the server.xml for Tomcat. So, I started to scratch my head some more and took a harder look at catalina.bat. Even though I had my NT classpath pointing to the mysql.jar, I decided to add the mysql.jar path to the following line in catalina.bat: --- set CP=%CATALINA_HOME%\bin\bootstrap.jar;%JAVA_HOME%\lib\tools.jar;c:\javali b\mysql.jar Voila!...it worked. Can you tell me why it didn't pick up the jar file from my NT classpath or from the lib directory in the TOMCAT_HOME? That's really simple - the standard startup scripts for Tomcat 4.0 totally ignore whatever CLASSPATH variable you might have installed before starting Tomcat. Classpaths get more users in more trouble than anything I have ever seen, so Tomcat uses a different technique: * If you need a JAR file available to a particular webapp, put it in the /WEB-INF/lib directory of that webapp. * If you need a JAR file available to all web apps (but not to the internal classes of Tomcat), put it in $CATALINA_HOME/lib. * If you need a JAR file available to Tomcat internal classes (as is the case with the driver required by JDBCRealm), but it in $CATALINA_HOME/server/lib. * If you need a JAR file available to *both* applications and Tomcat internal classes, put it in $CATALINA_HOME/common/lib. Maybe the instructions for setting up a JDBCRealm need to be modified to add this little tidbit of info. It's already there. The online version of the docs included with Tomcat is at: http://jakarta.apache.org/tomcat/tomcat-4.0-doc/realm-howto.html#JDBCRealm see step 3 under the Quick Start instructions. More info on the class loading architecture is also available: http://jakarta.apache.org/tomcat/tomcat-4.0-doc/class-loader-howto.html Thanks for the help, Bob Epling Craig
Re: tomcat4 and JDBCRealm problem
If you are using Tomcat 4 put it in CATALINA_HOME\common\lib - Original Message - From: Epling, Bob [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 10:35 AM Subject: RE: tomcat4 and JDBCRealm problem Craig, Thanks for the advice. For grins I wrote a quickie program in java that connected to the database and listed the users. It worked fine using the same parameters that were in the server.xml for Tomcat. So, I started to scratch my head some more and took a harder look at catalina.bat. Even though I had my NT classpath pointing to the mysql.jar, I decided to add the mysql.jar path to the following line in catalina.bat: --- set CP=%CATALINA_HOME%\bin\bootstrap.jar;%JAVA_HOME%\lib\tools.jar;c:\javali b\mysql.jar Voila!...it worked. Can you tell me why it didn't pick up the jar file from my NT classpath or from the lib directory in the TOMCAT_HOME? Maybe the instructions for setting up a JDBCRealm need to be modified to add this little tidbit of info. Thanks for the help, Bob Epling -Original Message- From: Craig R. McClanahan [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 8:52 PM To: [EMAIL PROTECTED] Subject: Re: tomcat4 and JDBCRealm problem The fact that you are getting a SQLException (rather than a ClassNotFoundException) implies that the problem is *not* in locating the driver - it is in the parameters you are specifying to establish the database connection. Double (and triple) check your values for the connectionName, connectionPassword, and connectionURL parameters, as well as the security permissions you have set up in the MySQL database itself. Craig McClanahan On Mon, 1 Oct 2001, Epling, Bob wrote: Date: Mon, 1 Oct 2001 16:50:41 -0600 From: Epling, Bob [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: tomcat4 and JDBCRealm problem Hi all, I have tomcat4 set up on my winnt machine and it works fine with basic Memory realm authentication. I followed the steps in setting up a JDBCRealm using mysql and I get the following error when starting Tomcat: Starting service Tomcat-Standalone Apache Tomcat/4.0 Catalina.start: LifecycleException: Exception opening database connection: java.sql.SQLException: org.gjt.mm.mysql.Dri ver LifecycleException: Exception opening database connection: java.sql.SQLException: org.gjt.mm.mysql.Driver at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:505) at org.apache.catalina.startup.Catalina.start(Catalina.java:776) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) at java.lang.reflect.Method.invoke(Native Method) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:218) - Root Cause - java.sql.SQLException: org.gjt.mm.mysql.Driver at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:538) at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:505) at org.apache.catalina.startup.Catalina.start(Catalina.java:776) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) at java.lang.reflect.Method.invoke(Native Method) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:218) I've tried putting the mysql jar in c:\javalib and also under c:\tomcat4.0\lib but no luck. This is my server.xml file currently: !-- Because this Realm is here, an instance will be shared globally -- !-- Realm className=org.apache.catalina.realm.MemoryRealm / -- !-- Replace the above Realm with one of the following to get a Realm stored in a database and accessed via JDBC -- Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost:3306/tomcatusers?user=root userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name / I can see the tables I have setup on my nt box in mysql. I can query those tables using mysql. Any help is appreciated. Thanks, Bob
RE: tomcat4 and JDBCRealm problem
Craig, Thanks for the help... I guess I need to get my glasses checked... When I read step 3 I read it as $CATALINA_HOME/lib without the server... I will read more carefully next time... Thanks again, Bob Epling -Original Message- From: Craig R. McClanahan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 10:25 AM To: [EMAIL PROTECTED] Subject: RE: tomcat4 and JDBCRealm problem On Tue, 2 Oct 2001, Epling, Bob wrote: Date: Tue, 2 Oct 2001 08:35:18 -0600 From: Epling, Bob [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: tomcat4 and JDBCRealm problem Craig, Thanks for the advice. For grins I wrote a quickie program in java that connected to the database and listed the users. It worked fine using the same parameters that were in the server.xml for Tomcat. So, I started to scratch my head some more and took a harder look at catalina.bat. Even though I had my NT classpath pointing to the mysql.jar, I decided to add the mysql.jar path to the following line in catalina.bat: --- set CP=%CATALINA_HOME%\bin\bootstrap.jar;%JAVA_HOME%\lib\tools.jar;c:\javali b\mysql.jar Voila!...it worked. Can you tell me why it didn't pick up the jar file from my NT classpath or from the lib directory in the TOMCAT_HOME? That's really simple - the standard startup scripts for Tomcat 4.0 totally ignore whatever CLASSPATH variable you might have installed before starting Tomcat. Classpaths get more users in more trouble than anything I have ever seen, so Tomcat uses a different technique: * If you need a JAR file available to a particular webapp, put it in the /WEB-INF/lib directory of that webapp. * If you need a JAR file available to all web apps (but not to the internal classes of Tomcat), put it in $CATALINA_HOME/lib. * If you need a JAR file available to Tomcat internal classes (as is the case with the driver required by JDBCRealm), but it in $CATALINA_HOME/server/lib. * If you need a JAR file available to *both* applications and Tomcat internal classes, put it in $CATALINA_HOME/common/lib. Maybe the instructions for setting up a JDBCRealm need to be modified to add this little tidbit of info. It's already there. The online version of the docs included with Tomcat is at: http://jakarta.apache.org/tomcat/tomcat-4.0-doc/realm-howto.html#JDBCRea lm see step 3 under the Quick Start instructions. More info on the class loading architecture is also available: http://jakarta.apache.org/tomcat/tomcat-4.0-doc/class-loader-howto.html Thanks for the help, Bob Epling Craig
tomcat4 and JDBCRealm problem
Hi all, I have tomcat4 set up on my winnt machine and it works fine with basic Memory realm authentication. I followed the steps in setting up a JDBCRealm using mysql and I get the following error when starting Tomcat: Starting service Tomcat-Standalone Apache Tomcat/4.0 Catalina.start: LifecycleException: Exception opening database connection: java.sql.SQLException: org.gjt.mm.mysql.Dri ver LifecycleException: Exception opening database connection: java.sql.SQLException: org.gjt.mm.mysql.Driver at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:505) at org.apache.catalina.startup.Catalina.start(Catalina.java:776) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) at java.lang.reflect.Method.invoke(Native Method) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:218) - Root Cause - java.sql.SQLException: org.gjt.mm.mysql.Driver at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:538) at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:505) at org.apache.catalina.startup.Catalina.start(Catalina.java:776) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) at java.lang.reflect.Method.invoke(Native Method) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:218) I've tried putting the mysql jar in c:\javalib and also under c:\tomcat4.0\lib but no luck. This is my server.xml file currently: !-- Because this Realm is here, an instance will be shared globally -- !-- Realm className=org.apache.catalina.realm.MemoryRealm / -- !-- Replace the above Realm with one of the following to get a Realm stored in a database and accessed via JDBC -- Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost:3306/tomcatusers?user=root userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name / I can see the tables I have setup on my nt box in mysql. I can query those tables using mysql. Any help is appreciated. Thanks, Bob
Re: tomcat4 and JDBCRealm problem
The fact that you are getting a SQLException (rather than a ClassNotFoundException) implies that the problem is *not* in locating the driver - it is in the parameters you are specifying to establish the database connection. Double (and triple) check your values for the connectionName, connectionPassword, and connectionURL parameters, as well as the security permissions you have set up in the MySQL database itself. Craig McClanahan On Mon, 1 Oct 2001, Epling, Bob wrote: Date: Mon, 1 Oct 2001 16:50:41 -0600 From: Epling, Bob [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: tomcat4 and JDBCRealm problem Hi all, I have tomcat4 set up on my winnt machine and it works fine with basic Memory realm authentication. I followed the steps in setting up a JDBCRealm using mysql and I get the following error when starting Tomcat: Starting service Tomcat-Standalone Apache Tomcat/4.0 Catalina.start: LifecycleException: Exception opening database connection: java.sql.SQLException: org.gjt.mm.mysql.Dri ver LifecycleException: Exception opening database connection: java.sql.SQLException: org.gjt.mm.mysql.Driver at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:505) at org.apache.catalina.startup.Catalina.start(Catalina.java:776) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) at java.lang.reflect.Method.invoke(Native Method) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:218) - Root Cause - java.sql.SQLException: org.gjt.mm.mysql.Driver at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:538) at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:505) at org.apache.catalina.startup.Catalina.start(Catalina.java:776) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) at java.lang.reflect.Method.invoke(Native Method) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:218) I've tried putting the mysql jar in c:\javalib and also under c:\tomcat4.0\lib but no luck. This is my server.xml file currently: !-- Because this Realm is here, an instance will be shared globally -- !-- Realm className=org.apache.catalina.realm.MemoryRealm / -- !-- Replace the above Realm with one of the following to get a Realm stored in a database and accessed via JDBC -- Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost:3306/tomcatusers?user=root userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name / I can see the tables I have setup on my nt box in mysql. I can query those tables using mysql. Any help is appreciated. Thanks, Bob
Re: jdbcRealm problem
From: Francois Bronsard ... The trace of the session state that authetication was successful, yet, the system keeps asking for username and password and finally fails. Any idea what could be wrong? Make sure you comment out SimpleRealm interceptor if you use JDBCRealm. I accidentally left in both interceptors on one server and it did the very same thing... JDBCRealm log messages said that authentication was successful but it still displayed an error page. Did it help? with best wishes, Taavi
jdbcRealm problem
Hi everyone, I'm trying to use JDBCRealm for authetication and I'm having some problems. The trace of the session state that authetication was successful, yet, the system keeps asking for username and password and finally fails. Any idea what could be wrong? Here is the server.xml setting: (I checked the database connection and it works fine with that driver and URL) RequestInterceptor className=org.apache.tomcat.request.JDBCRealm debug=99 driverName=com.thinweb.tds.Driver connectionURL=jdbc:twtds:sqlserver://intrigue/PPSDB connectionName=ppsdb connectionPassword=ppsdb userTable=account userNameCol=userid userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name / The trace in the tomcat windows is: 2001-08-06 10:37:24 - ContextManager: JDBCRealm: The database connection is null or was found to be closed. Trying to re-open it. 2001-08-06 10:37:24 - ContextManager: JDBCRealm: JDBCRealm.authenticate: SELECT user_pass FROM account WHERE userid = ? 2001-08-06 10:37:24 - ContextManager: JDBCRealm: Authentication successful for u ser j2ee 2001-08-06 10:37:24 - ContextManager: JDBCRealm: Auth ok, user=j2ee and yet, the system keeps asking me to login! Help greatly appreciated, Francois Bronsard
RE: jdbcRealm problem
Check your Remote User, User Principal and Auth Type header values and see if they are getting set after the authorization call. If not this could be the problem. If this is the case I would suggest putting some additional debug code in JDBCRealm and recompiling it (or using a debugger) to figure out where everything's going wrong. Also, do you have any roles set up or are your constraints global? --- Michael Wentzel Software Developer Software As We Think - http://www.aswethink.com