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" <[EMAIL PROTECTED]>
> 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: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>> 
> 
> 
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 
> 

-- 
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to