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" <[EMAIL PROTECTED]> > 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&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] >> >> > > > --------------------------------------------------------------------- > 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#a10322637 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]
