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