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: <[email protected]>
> 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: [email protected]
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>>
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: [email protected]
> 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: [email protected]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
