tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Martin Gainty" <mgai...@hotmail.com>
Subject Re: JDBCRealm
Date Fri, 04 May 2007 00:02:48 GMT
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


Mime
View raw message