tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Murtuza <khanmurt...@gmail.com>
Subject Re: JDBCRealm
Date Fri, 04 May 2007 16:37:26 GMT

well I think it changed in tomcat 6.0, its now in catalina_home/lib.

the stack trace was from log files, from the user side it just failes
autherization.



David Smith-2 wrote:
> 
> tomcat/lib??  That directory doesn't exist in the default distribution 
> from tomcat.  Can you offer some details?  In a normal distribution of 
> tomcat, database drivers go in the common/lib directory under tomcat.  
> Also it looks like the stack trace in your original message wasn't 
> complete.  Was a root cause listed?
> 
> --David
> 
> Murtuza wrote:
> 
>>thanks but i am already using it & thats wat i copied into my tomcat/lib
>>directory....this jdbc driver works fine from my java class but not with
>>tomcat jdbcrealm, i think its not picking up the mysql-jdbc.jar files from
>>tomcat/lib dir. although i copied it there.
>>
>>
>>
>>
>>Martin Gainty wrote:
>>  
>>
>>>this is a lightweight type 4 driver for MySQL which you can download at
>>>http://dev.mysql.com/downloads/connector/j/5.0.html
>>>
>>>Be sure to Read the GPL beforehand!
>>>M--
>>>This email message and any files transmitted with it contain confidential
>>>information intended only for the person(s) to whom this email message is
>>>addressed.  If you have received this email message in error, please
>>>notify
>>>the sender immediately by telephone or email and destroy the original
>>>message without making a copy.  Thank you.
>>>
>>>----- Original Message ----- 
>>>From: "Murtuza" <khanmurtuza@gmail.com>
>>>To: <users@tomcat.apache.org>
>>>Sent: Friday, May 04, 2007 9:00 AM
>>>Subject: Re: JDBCRealm
>>>
>>>
>>>    
>>>
>>>>doesn't work if I change the server.xml also, I am providing the same
>>>>information ic context.xml. the same code works fine on my windows
>>>>machine
>>>>but not on linux. I think tomcat is not picking up the jdbc driver for 
>>>>mysql
>>>>that I copied in the /catalina_home/lib directory, any one knows y its
>>>>not
>>>>picking up this driver.
>>>>
>>>>-
>>>>
>>>>
>>>>Martin Gainty wrote:
>>>>      
>>>>
>>>>>Murtuza
>>>>>
>>>>>here is server.xml example from Tomcat 5.5 docs where test is name of
db
>>>>>user=testr and password=testr
>>>>>
>>>>><Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
>>>>>      driverName="org.gjt.mm.mysql.Driver"
>>>>>
>>>>>connectionURL="jdbc:mysql://localhost/test?user=testr&amp;password=testr"
>>>>>       userTable="logins" userNameCol="loginName"
>>>>> userCredCol="password"
>>>>>   userRoleTable="new_user_roles" roleNameCol="role_name"/>
>>>>>
>>>>>HTH
>>>>>Martin--
>>>>>This email message and any files transmitted with it contain
>>>>>confidential
>>>>>information intended only for the person(s) to whom this email message
>>>>>is
>>>>>addressed.  If you have received this email message in error, please
>>>>>notify
>>>>>the sender immediately by telephone or email and destroy the original
>>>>>message without making a copy.  Thank you.
>>>>>
>>>>>----- Original Message ----- 
>>>>>From: "Murtuza" <khanmurtuza@gmail.com>
>>>>>To: <users@tomcat.apache.org>
>>>>>Sent: Thursday, May 03, 2007 6:37 PM
>>>>>Subject: Re: JDBCRealm
>>>>>
>>>>>
>>>>>        
>>>>>
>>>>>>below is my context.xml file. I can connect to the mysql database
from
>>>>>>a
>>>>>>java
>>>>>>class with the same username/pass.
>>>>>>
>>>>>><?xml version="1.0" encoding="UTF-8"?>
>>>>>><Context path="/security"
>>>>>>        docBase="security"
>>>>>>        debug="99">
>>>>>> <Realm className="org.apache.catalina.realm.JDBCRealm"
>>>>>> digest="MD5"
>>>>>>        connectionName="testr"
>>>>>>        connectionPassword="testr"
>>>>>>        connectionURL="jdbc:mysql://localhost:3306/test"
>>>>>>        debug="99"
>>>>>>        driverName="com.mysql.jdbc.Driver"
>>>>>>        roleNameCol="role_name"
>>>>>>        userCredCol="password"
>>>>>>        userNameCol="loginName"
>>>>>>        userRoleTable="new_user_roles"
>>>>>>        userTable="logins"
>>>>>> />
>>>>>></Context>
>>>>>>
>>>>>>
>>>>>>
>>>>>>Martin Gainty wrote:
>>>>>>          
>>>>>>
>>>>>>>Have you verified the mysql listener is listening?
>>>>>>>Have you verified the JDBCRealm is configured using the parameters

>>>>>>>which
>>>>>>>will allow you to connect?
>>>>>>>If you are able to confirm both please post your JDBCRealm parameters
>>>>>>>here
>>>>>>>
>>>>>>>Martin
>>>>>>>This email message and any files transmitted with it contain
>>>>>>>confidential
>>>>>>>information intended only for the person(s) to whom this email
message
>>>>>>>is
>>>>>>>addressed.  If you have received this email message in error,
please
>>>>>>>notify
>>>>>>>the sender immediately by telephone or email and destroy the original
>>>>>>>message without making a copy.  Thank you.
>>>>>>>
>>>>>>>----- Original Message ----- 
>>>>>>>From: "Murtuza" <khanmurtuza@gmail.com>
>>>>>>>To: <users@tomcat.apache.org>
>>>>>>>Sent: Thursday, May 03, 2007 5:22 PM
>>>>>>>Subject: JDBCRealm
>>>>>>>
>>>>>>>
>>>>>>>            
>>>>>>>
>>>>>>>>-I am using mysql as database..
>>>>>>>>-I have mysql-connector-java-5.0.5 jdbc driver in my tomcat/lib
>>>>>>>>directory
>>>>>>>>-I am using JDBCRealm for authentication
>>>>>>>>-On my windows machine it works fine
>>>>>>>>-when I deployed it on linux box it does't work
>>>>>>>>-I get the foloowing error message from my localhost log file
>>>>>>>>
>>>>>>>>....any idea
>>>>>>>>
>>>>>>>>
>>>>>>>>May 3, 2007 4:52:38 PM org.apache.catalina.realm.JDBCRealm
start
>>>>>>>>SEVERE: Exception opening database connection
>>>>>>>>java.sql.SQLException: com.mysql.jdbc.Driver
>>>>>>>>       at
>>>>>>>>org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:691)
>>>>>>>>       at 
>>>>>>>>org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:769)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:761)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:741)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1023)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1015)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.core.StandardService.start(StandardService.java:448)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
>>>>>>>>       at 
>>>>>>>>org.apache.catalina.startup.Catalina.start(Catalina.java:552)
>>>>>>>>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
>>>>>>>> Method)
>>>>>>>>       at
>>>>>>>>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>>>>>>>       at
>>>>>>>>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>>>>>>>       at java.lang.reflect.Method.invoke(Method.java:585)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
>>>>>>>>
>>>>>>>>---
>>>>>>>>
>>>>>>>>May 3, 2007 4:55:44 PM org.apache.catalina.realm.JDBCRealm

>>>>>>>>authenticate
>>>>>>>>SEVERE: Exception performing authentication
>>>>>>>>java.sql.SQLException: com.mysql.jdbc.Driver
>>>>>>>>       at
>>>>>>>>org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:691)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:346)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:181)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:491)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>>>>>>>>       at
>>>>>>>>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:216)
>>>>>>>>       at
>>>>>>>>org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
>>>>>>>>       at
>>>>>>>>org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634)
>>>>>>>>       at
>>>>>>>>org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)
>>>>>>>>       at java.lang.Thread.run(Thread.java:595)
>>>>>>>>
>>>>>>>>-- 
>>>>>>>>View this message in context:
>>>>>>>>http://www.nabble.com/JDBCRealm-tf3689024.html#a10313417
>>>>>>>>Sent from the Tomcat - User mailing list archive at Nabble.com.
>>>>>>>>
>>>>>>>>
>>>>>>>>---------------------------------------------------------------------
>>>>>>>>To start a new topic, e-mail: users@tomcat.apache.org
>>>>>>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>>>>>>For additional commands, e-mail: users-help@tomcat.apache.org
>>>>>>>>
>>>>>>>>
>>>>>>>>              
>>>>>>>>
>>>>>>>---------------------------------------------------------------------
>>>>>>>To start a new topic, e-mail: users@tomcat.apache.org
>>>>>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>>>>>For additional commands, e-mail: users-help@tomcat.apache.org
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>            
>>>>>>>
>>>>>>-- 
>>>>>>View this message in context:
>>>>>>http://www.nabble.com/JDBCRealm-tf3689024.html#a10314414
>>>>>>Sent from the Tomcat - User mailing list archive at Nabble.com.
>>>>>>
>>>>>>
>>>>>>---------------------------------------------------------------------
>>>>>>To start a new topic, e-mail: users@tomcat.apache.org
>>>>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>>>>For additional commands, e-mail: users-help@tomcat.apache.org
>>>>>>
>>>>>>
>>>>>>          
>>>>>>
>>>>>---------------------------------------------------------------------
>>>>>To start a new topic, e-mail: users@tomcat.apache.org
>>>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>>>For additional commands, e-mail: users-help@tomcat.apache.org
>>>>>
>>>>>
>>>>>
>>>>>        
>>>>>
>>>>-- 
>>>>View this message in context: 
>>>>http://www.nabble.com/JDBCRealm-tf3689024.html#a10322242
>>>>Sent from the Tomcat - User mailing list archive at Nabble.com.
>>>>
>>>>
>>>>---------------------------------------------------------------------
>>>>To start a new topic, e-mail: users@tomcat.apache.org
>>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>>For additional commands, e-mail: users-help@tomcat.apache.org
>>>>
>>>>
>>>>      
>>>>
>>>---------------------------------------------------------------------
>>>To start a new topic, e-mail: users@tomcat.apache.org
>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>For additional commands, e-mail: users-help@tomcat.apache.org
>>>
>>>
>>>
>>>    
>>>
>>
>>  
>>
> 
> 
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/JDBCRealm-tf3689024.html#a10324561
Sent from the Tomcat - User mailing list archive at Nabble.com.


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


Mime
View raw message