Re: Configuring Tomcat to use a JDBC Realm
Isn't mysql a client program? If so, I can connect with the user/pw. Tarun Ramakrishna Elankath wrote: Seems like an access problem to me. Dean, did you try connecting to the server from a mysql client with the given username/password to check whether you are able to connect ? On Sat, 2003-03-29 at 07:50, Dean A. Hoover wrote: Can you be a little more specific? I'm not a mysql expert. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Configuring Tomcat to use a JDBC Realm
I am attempting to use JDBC Realm as described in the Apress book by James Goodwill. My os is RH 8.0. I'm using MySQL 4.0.12 and Connector/J 3.06. I am using Tomcat 4.0.6. I set up a tomcatusers database and a test user as per the book. I dropped mysql-connector-java-3.0.6-stable-bin.jar into $TOMCAT_HOME/common/lib I modified the server.xml file as follows: !-- Realm className=org.apache.catalina.realm.MemoryRealm / -- !-- Replace the above Realm with one of the following to get a Realm stored in a database and accessed via JDBC -- Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=com.mysql.jdbc.Driver connectionURL=jdbc:mysql://localhost/tomcatusers?user=test;password=test userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name I then attempt to go to http://localhost:8080/apress/login.jsp in my mozilla browser. Nothing happens. I go to check for a clue in the logs. This is what I get: - Root Cause - java.sql.SQLException: Server configuration denies access to data source at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:392) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1511) at com.mysql.jdbc.Connection.init(Connection.java:485) at com.mysql.jdbc.Driver.connect(Driver.java:341) at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:548) at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:506) at org.apache.catalina.startup.Catalina.start(Catalina.java:781) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) 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:324) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243) Anyone got any ideas how I can fix this? Thanks. Dean Hoover - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Configuring Tomcat to use a JDBC Realm
check mysql port -Original Message- From: Dean A. Hoover [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 9:20 AM To: [EMAIL PROTECTED] Subject: Configuring Tomcat to use a JDBC Realm I am attempting to use JDBC Realm as described in the Apress book by James Goodwill. My os is RH 8.0. I'm using MySQL 4.0.12 and Connector/J 3.06. I am using Tomcat 4.0.6. I set up a tomcatusers database and a test user as per the book. I dropped mysql-connector-java-3.0.6-stable-bin.jar into $TOMCAT_HOME/common/lib I modified the server.xml file as follows: !-- Realm className=org.apache.catalina.realm.MemoryRealm / -- !-- Replace the above Realm with one of the following to get a Realm stored in a database and accessed via JDBC -- Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=com.mysql.jdbc.Driver connectionURL=jdbc:mysql://localhost/tomcatusers?user=test;password=test userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name I then attempt to go to http://localhost:8080/apress/login.jsp in my mozilla browser. Nothing happens. I go to check for a clue in the logs. This is what I get: - Root Cause - java.sql.SQLException: Server configuration denies access to data source at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:392) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1511) at com.mysql.jdbc.Connection.init(Connection.java:485) at com.mysql.jdbc.Driver.connect(Driver.java:341) at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:548) at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:506) at org.apache.catalina.startup.Catalina.start(Catalina.java:781) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) 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:324) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243) Anyone got any ideas how I can fix this? Thanks. Dean Hoover - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Configuring Tomcat to use a JDBC Realm
Can you be a little more specific? I'm not a mysql expert. Galbayar Dorjgotov wrote: check mysql port -Original Message- From: Dean A. Hoover [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 9:20 AM To: [EMAIL PROTECTED] Subject: Configuring Tomcat to use a JDBC Realm I am attempting to use JDBC Realm as described in the Apress book by James Goodwill. My os is RH 8.0. I'm using MySQL 4.0.12 and Connector/J 3.06. I am using Tomcat 4.0.6. I set up a tomcatusers database and a test user as per the book. I dropped mysql-connector-java-3.0.6-stable-bin.jar into $TOMCAT_HOME/common/lib I modified the server.xml file as follows: !-- Realm className=org.apache.catalina.realm.MemoryRealm / -- !-- Replace the above Realm with one of the following to get a Realm stored in a database and accessed via JDBC -- Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=com.mysql.jdbc.Driver connectionURL=jdbc:mysql://localhost/tomcatusers?user=test;password=test userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name I then attempt to go to http://localhost:8080/apress/login.jsp in my mozilla browser. Nothing happens. I go to check for a clue in the logs. This is what I get: - Root Cause - java.sql.SQLException: Server configuration denies access to data source at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:392) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1511) at com.mysql.jdbc.Connection.init(Connection.java:485) at com.mysql.jdbc.Driver.connect(Driver.java:341) at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:548) at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:506) at org.apache.catalina.startup.Catalina.start(Catalina.java:781) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) 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:324) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243) Anyone got any ideas how I can fix this? Thanks. Dean Hoover - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Configuring Tomcat to use a JDBC Realm
Seems like an access problem to me. Dean, did you try connecting to the server from a mysql client with the given username/password to check whether you are able to connect ? On Sat, 2003-03-29 at 07:50, Dean A. Hoover wrote: Can you be a little more specific? I'm not a mysql expert. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
