Re: tomcat windows / mysql linux
hi paul, yes, it has been configured the same way. all the machines are connected in a giga network. yes, its the log in that takes the most time and every time we log. our production server is older version of tomcat. when we tried to run production server on jdk 1.5.03, we have the same problem. could it be problem with jdk? we run into the same problem of very slow login, only from windows to linux. we have another client who have app server on linux and database on another linux box and it is seems to work fine. any thoughts? any tests we can run? thanks dan. Paul [EMAIL PROTECTED] wrote: daniel steel wrote: hi all, i have an interesting problem. our app server(tomcat 5.5) on windows 2003 communicates with mySQl database on linux box. our client application is very slow each time we log in. when we moved the database to windows box, the application is super fast. does anybody have thoughts on this? thank you secc Is mysql configured the same way? Same cache sizes and the like? Are the network connections and equipment in between the severs the same? Lastly, are all types of data access affected or just the login process? -Paul - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Discover Yahoo! Have fun online with music videos, cool games, IM more. Check it out!
tomcat windows / mysql linux
hi all, i have an interesting problem. our app server(tomcat 5.5) on windows 2003 communicates with mySQl database on linux box. our client application is very slow each time we log in. when we moved the database to windows box, the application is super fast. does anybody have thoughts on this? thank you secc __ Discover Yahoo! Have fun online with music videos, cool games, IM and more. Check it out! http://discover.yahoo.com/online.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: tomcat windows / mysql linux
What is the speed of your network? Local access will almost always be faster than a call across the network. Even if you specify your ODBC to use a network address, the OS's are smart enough to not send local access through the network card. There could also be issues with the network physical setup. If you have daisy chained hubs instead of smart switches this could further degrade the performance due to the number of hops you request might take. You could expect a few second delay for network layer depending on the speed and topography of the network. This is one of the reason good network engineers get paid so well. Robert S. Harper Information Access Technology, Inc. -Original Message- From: daniel steel [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 08, 2005 10:36 AM To: tomcat-user@jakarta.apache.org Subject: tomcat windows / mysql linux hi all, i have an interesting problem. our app server(tomcat 5.5) on windows 2003 communicates with mySQl database on linux box. our client application is very slow each time we log in. when we moved the database to windows box, the application is super fast. does anybody have thoughts on this? thank you secc __ Discover Yahoo! Have fun online with music videos, cool games, IM and more. Check it out! http://discover.yahoo.com/online.html - 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: tomcat windows / mysql linux
daniel steel wrote: hi all, i have an interesting problem. our app server(tomcat 5.5) on windows 2003 communicates with mySQl database on linux box. our client application is very slow each time we log in. when we moved the database to windows box, the application is super fast. does anybody have thoughts on this? thank you secc Is mysql configured the same way? Same cache sizes and the like? Are the network connections and equipment in between the severs the same? Lastly, are all types of data access affected or just the login process? -Paul - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: tomcat+j2sdk+mysql-connecto+mysql
Hello Chris Williams,
Thanks for your guides. Now its working well.
Regards
Sathi
Try to isolate the problem. Check that you can get a Connection object by
doing something like the following:
String driver = ...;
String url = ...;
String userName = ...;
String pw = ...;
Connection conn = null;
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, userName, pw);
} catch (Exception e) {
e.printStackTrace();
}
// Do something with conn...
if (null != conn) {
...
try {
conn.close();
} catch (Exception e) {}
conn = null;
}
This will enable you to isolate where your problem lies. If you can get a
Connection object then your database and JDBC driver are set up correctly,
you have the correct URL for the data source, you have a valid user name
and
password and the problem lies with the Wrox ConnectionPool class.
Otherwise
some element of your database setup is incorrect.
Check that you are referencing the driver class correctly. When I need to
talk to MySQL I use the Connector /J driver available from the MySQL web
site:
http://www.mysql.com/downloads/api-jdbc-stable.html
The name of the driver is:
com.mysql.jdbc.Driver
Check that you have spelt it correctly.
Assume that you are accessing a MySQL database called my_db on
localhost.
The URL to the datasource takes the form:
jdbc:mysql://localhost:3306/im_audit
If MySQL is not listening on port 3306, you will need to change the port
value. I leave user name and password to you - you can always use root
during development.
Chris Williams.
-
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]
tomcat+j2sdk+mysql-connecto+mysql
Hello All, I am new to tomcat and java. I want to install ipstat-0.9.7 tool which is used for bandwidyh monitoring. I started intalling its requirements ...tomcat-4.1.27, j2sdk-1.4.2, mysql-connector-java-2.0.14, mysql-3.23.54 in Redhat-9 I installed mysql rpm and j2sdk as binary ans its in /usr/java/j2sdk1.4.2_01 i have installed tomcat, mysql connector and ipstat in /usr/local/src and copied com and org of mysql connector in the /usr/local/src/tomcat/shred/lib. I was to able to browse the example page but not the ipstat page. Is there any version porblem ...and how to oevrcome this problem The catalina.out shows following error Sep 1, 2003 5:51:39 PM org.apache.commons.modeler.Registry loadRegistry INFO: Loading registry information Sep 1, 2003 5:51:39 PM org.apache.commons.modeler.Registry getRegistry INFO: Creating new Registry instance Sep 1, 2003 5:51:40 PM org.apache.commons.modeler.Registry getServer INFO: Creating MBeanServer Sep 1, 2003 5:51:41 PM org.apache.coyote.http11.Http11Protocol init INFO: Initializing Coyote HTTP/1.1 on port 8080 Starting service Tomcat-Standalone Apache Tomcat/4.1.27 Sep 1, 2003 5:51:44 PM org.apache.struts.util.PropertyMessageResources init INFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true Sep 1, 2003 5:51:44 PM org.apache.struts.util.PropertyMessageResources init INFO: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true Sep 1, 2003 5:51:44 PM org.apache.struts.util.PropertyMessageResources init INFO: Initializing, config='org.apache.webapp.admin.ApplicationResources', returnNull=true Sep 1, 2003 5:51:48 PM org.apache.coyote.http11.Http11Protocol start INFO: Starting Coyote HTTP/1.1 on port 8080 Sep 1, 2003 5:51:48 PM org.apache.jk.common.ChannelSocket init INFO: JK2: ajp13 listening on /0.0.0.0:8009 Sep 1, 2003 5:51:48 PM org.apache.jk.server.JkMain start INFO: Jk running ID=0 time=1/462 config=/usr/local/src/jakarta-tomcat-4.1.27/conf/jk2.properties [Mon Sep 01 17:51:56 IST 2003] error: PoolManager: Can't register JDBC driver: org.gjt.mm.mysql.Driver : java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.jav a:1444) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.jav a:1289) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:141) at com.wrox.connectionpool.PoolManager.loadDrivers(PoolManager.java:82) at com.wrox.connectionpool.PoolManager.init(PoolManager.java:69) at com.wrox.connectionpool.PoolManager.init(PoolManager.java:23) at com.wrox.connectionpool.PoolManager.getInstance(PoolManager.java:31) at com.rsi.ipstat.DBManager.clinit(DBManager.java:20) at com.rsi.ipstat.LoginBean.validate(LoginBean.java:21) at org.apache.jsp.login_process_jsp._jspService(login_process_jsp.java:63) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 10) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 ) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext
Re: tomcat+j2sdk+mysql-connecto+mysql
Have you tried to put the mysql jdbc connector jar file under common/lib? The problem here is that the file is not found in the classpath. Hope this will help, Marco - Original Message - From: Sathyan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 7:30 AM Subject: tomcat+j2sdk+mysql-connecto+mysql Hello All, I am new to tomcat and java. I want to install ipstat-0.9.7 tool which is used for bandwidyh monitoring. I started intalling its requirements ...tomcat-4.1.27, j2sdk-1.4.2, mysql-connector-java-2.0.14, mysql-3.23.54 in Redhat-9 I installed mysql rpm and j2sdk as binary ans its in /usr/java/j2sdk1.4.2_01 i have installed tomcat, mysql connector and ipstat in /usr/local/src and copied com and org of mysql connector in the /usr/local/src/tomcat/shred/lib. I was to able to browse the example page but not the ipstat page. Is there any version porblem ...and how to oevrcome this problem The catalina.out shows following error Sep 1, 2003 5:51:39 PM org.apache.commons.modeler.Registry loadRegistry INFO: Loading registry information Sep 1, 2003 5:51:39 PM org.apache.commons.modeler.Registry getRegistry INFO: Creating new Registry instance Sep 1, 2003 5:51:40 PM org.apache.commons.modeler.Registry getServer INFO: Creating MBeanServer Sep 1, 2003 5:51:41 PM org.apache.coyote.http11.Http11Protocol init INFO: Initializing Coyote HTTP/1.1 on port 8080 Starting service Tomcat-Standalone Apache Tomcat/4.1.27 Sep 1, 2003 5:51:44 PM org.apache.struts.util.PropertyMessageResources init INFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true Sep 1, 2003 5:51:44 PM org.apache.struts.util.PropertyMessageResources init INFO: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true Sep 1, 2003 5:51:44 PM org.apache.struts.util.PropertyMessageResources init INFO: Initializing, config='org.apache.webapp.admin.ApplicationResources', returnNull=true Sep 1, 2003 5:51:48 PM org.apache.coyote.http11.Http11Protocol start INFO: Starting Coyote HTTP/1.1 on port 8080 Sep 1, 2003 5:51:48 PM org.apache.jk.common.ChannelSocket init INFO: JK2: ajp13 listening on /0.0.0.0:8009 Sep 1, 2003 5:51:48 PM org.apache.jk.server.JkMain start INFO: Jk running ID=0 time=1/462 config=/usr/local/src/jakarta-tomcat-4.1.27/conf/jk2.properties [Mon Sep 01 17:51:56 IST 2003] error: PoolManager: Can't register JDBC driver: org.gjt.mm.mysql.Driver : java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.jav a:1444) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.jav a:1289) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:141) at com.wrox.connectionpool.PoolManager.loadDrivers(PoolManager.java:82) at com.wrox.connectionpool.PoolManager.init(PoolManager.java:69) at com.wrox.connectionpool.PoolManager.init(PoolManager.java:23) at com.wrox.connectionpool.PoolManager.getInstance(PoolManager.java:31) at com.rsi.ipstat.DBManager.clinit(DBManager.java:20) at com.rsi.ipstat.LoginBean.validate(LoginBean.java:21) at org.apache.jsp.login_process_jsp._jspService(login_process_jsp.java:63) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 10) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke
Re: tomcat+j2sdk+mysql-connecto+mysql
Hello Marco, i copied the mysql-jdbc driver in common/lib and this time i am getting error as [Tue Sep 02 14:59:22 IST 2003] error: PoolManager: Exception getting connection from stat : java.sql.SQLException: getConnection() timed-out at com.wrox.connectionpool.ConnectionPool.getConnection(ConnectionPool.java:107 ) at com.wrox.connectionpool.ConnectionPool.getConnection(ConnectionPool.java:71) at com.wrox.connectionpool.PoolManager.getConnection(PoolManager.java:191) at com.rsi.ipstat.DBManager.getUser(DBManager.java:372) Regards, Sathi Have you tried to put the mysql jdbc connector jar file under common/lib? The problem here is that the file is not found in the classpath. Hope this will help, Marco - Original Message - From: Sathyan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 7:30 AM Subject: tomcat+j2sdk+mysql-connecto+mysql Hello All, I am new to tomcat and java. I want to install ipstat-0.9.7 tool which is used for bandwidyh monitoring. I started intalling its requirements ...tomcat-4.1.27, j2sdk-1.4.2, mysql-connector-java-2.0.14, mysql-3.23.54 in Redhat-9 I installed mysql rpm and j2sdk as binary ans its in /usr/java/j2sdk1.4.2_01 i have installed tomcat, mysql connector and ipstat in /usr/local/src and copied com and org of mysql connector in the /usr/local/src/tomcat/shred/lib. I was to able to browse the example page but not the ipstat page. Is there any version porblem ...and how to oevrcome this problem The catalina.out shows following error Sep 1, 2003 5:51:39 PM org.apache.commons.modeler.Registry loadRegistry INFO: Loading registry information Sep 1, 2003 5:51:39 PM org.apache.commons.modeler.Registry getRegistry INFO: Creating new Registry instance Sep 1, 2003 5:51:40 PM org.apache.commons.modeler.Registry getServer INFO: Creating MBeanServer Sep 1, 2003 5:51:41 PM org.apache.coyote.http11.Http11Protocol init INFO: Initializing Coyote HTTP/1.1 on port 8080 Starting service Tomcat-Standalone Apache Tomcat/4.1.27 Sep 1, 2003 5:51:44 PM org.apache.struts.util.PropertyMessageResources init INFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true Sep 1, 2003 5:51:44 PM org.apache.struts.util.PropertyMessageResources init INFO: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true Sep 1, 2003 5:51:44 PM org.apache.struts.util.PropertyMessageResources init INFO: Initializing, config='org.apache.webapp.admin.ApplicationResources', returnNull=true Sep 1, 2003 5:51:48 PM org.apache.coyote.http11.Http11Protocol start INFO: Starting Coyote HTTP/1.1 on port 8080 Sep 1, 2003 5:51:48 PM org.apache.jk.common.ChannelSocket init INFO: JK2: ajp13 listening on /0.0.0.0:8009 Sep 1, 2003 5:51:48 PM org.apache.jk.server.JkMain start INFO: Jk running ID=0 time=1/462 config=/usr/local/src/jakarta-tomcat-4.1.27/conf/jk2.properties [Mon Sep 01 17:51:56 IST 2003] error: PoolManager: Can't register JDBC driver: org.gjt.mm.mysql.Driver : java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.jav a:1444) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.jav a:1289) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:141) at com.wrox.connectionpool.PoolManager.loadDrivers(PoolManager.java:82) at com.wrox.connectionpool.PoolManager.init(PoolManager.java:69) at com.wrox.connectionpool.PoolManager.init(PoolManager.java:23) at com.wrox.connectionpool.PoolManager.getInstance(PoolManager.java:31) at com.rsi.ipstat.DBManager.clinit(DBManager.java:20) at com.rsi.ipstat.LoginBean.validate(LoginBean.java:21) at org.apache.jsp.login_process_jsp._jspService(login_process_jsp.java:63) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 10) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:256) at org.apache.catalina.core.StandardPipeline
Re: tomcat+j2sdk+mysql-connecto+mysql
Try to isolate the problem. Check that you can get a Connection object by
doing something like the following:
String driver = ...;
String url = ...;
String userName = ...;
String pw = ...;
Connection conn = null;
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, userName, pw);
} catch (Exception e) {
e.printStackTrace();
}
// Do something with conn...
if (null != conn) {
...
try {
conn.close();
} catch (Exception e) {}
conn = null;
}
This will enable you to isolate where your problem lies. If you can get a
Connection object then your database and JDBC driver are set up correctly,
you have the correct URL for the data source, you have a valid user name and
password and the problem lies with the Wrox ConnectionPool class. Otherwise
some element of your database setup is incorrect.
Check that you are referencing the driver class correctly. When I need to
talk to MySQL I use the Connector /J driver available from the MySQL web
site:
http://www.mysql.com/downloads/api-jdbc-stable.html
The name of the driver is:
com.mysql.jdbc.Driver
Check that you have spelt it correctly.
Assume that you are accessing a MySQL database called my_db on localhost.
The URL to the datasource takes the form:
jdbc:mysql://localhost:3306/im_audit
If MySQL is not listening on port 3306, you will need to change the port
value. I leave user name and password to you - you can always use root
during development.
Chris Williams.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: HELP!! TOMCAT and MYSQL
Hi Replace for amp; to get a valifd XML Bye El Dom 03 Ago 2003 06:39, engp0510 escribió: Thanks very much! Y, I have tried. But always throw org.xml.sax.SAXParseException said a ; is needed to end the quote of password. Any advice? - Original Message - From: Emmanuel G. Dialynas [EMAIL PROTECTED] To: engp0510 [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, August 03, 2003 6:07 PM Subject: Re: HELP!! TOMCAT and MYSQL Try: connectionURL=jdbc:mysql://localhost/authority?user=leesonpassword= At 04:32 ìì 03/08/03 +0800, engp0510 wrote: Hi, I am using Tomcat 4.0 and MySQL 4.0.14 on WIn2K Professional. In Server.XML of Tomcat, I use: Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost/authority?user=leeson;password= userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name / In MySQL, I set all user must access database with password and grant user 'leeson' with all privileges @ localhost. I can use leeson and password to log into MySQL. All setting of MySQL will work well when I login MySQL using CMD on Win2K But when I start tomcat-standalone, there is always : Catalina.start: LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorizatio n specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorization specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) ... So, it seem Parser regard user as leeson;password, not leeson. But if I grant leeson all privileges but without password, the tomcat could work. - 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]
HELP!! TOMCAT and MYSQL
Hi, I am using Tomcat 4.0 and MySQL 4.0.14 on WIn2K Professional. In Server.XML of Tomcat, I use: Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost/authority?user=leeson;password= userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name / In MySQL, I set all user must access database with password and grant user 'leeson' with all privileges @ localhost. I can use leeson and password to log into MySQL. All setting of MySQL will work well when I login MySQL using CMD on Win2K But when I start tomcat-standalone, there is always : Catalina.start: LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorizatio n specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorization specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) ... So, it seem Parser regard user as leeson;password, not leeson. But if I grant leeson all privileges but without password, the tomcat could work.
Re: HELP!! TOMCAT and MYSQL
Thanks very much! Y, I have tried. But always throw org.xml.sax.SAXParseException said a ; is needed to end the quote of password. Any advice? - Original Message - From: Emmanuel G. Dialynas [EMAIL PROTECTED] To: engp0510 [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, August 03, 2003 6:07 PM Subject: Re: HELP!! TOMCAT and MYSQL Try: connectionURL=jdbc:mysql://localhost/authority?user=leesonpassword= At 04:32 ìì 03/08/03 +0800, engp0510 wrote: Hi, I am using Tomcat 4.0 and MySQL 4.0.14 on WIn2K Professional. In Server.XML of Tomcat, I use: Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost/authority?user=leeson;password= userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name / In MySQL, I set all user must access database with password and grant user 'leeson' with all privileges @ localhost. I can use leeson and password to log into MySQL. All setting of MySQL will work well when I login MySQL using CMD on Win2K But when I start tomcat-standalone, there is always : Catalina.start: LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorizatio n specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorization specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) ... So, it seem Parser regard user as leeson;password, not leeson. But if I grant leeson all privileges but without password, the tomcat could work. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: HELP!! TOMCAT and MYSQL
Split the user and pass off of the URL, and into separate properties... stu -Original Message- From: engp0510 [mailto:[EMAIL PROTECTED] Sent: 03 August 2003 11:40 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Emmanuel G. Dialynas Subject: Re: HELP!! TOMCAT and MYSQL Thanks very much! Y, I have tried. But always throw org.xml.sax.SAXParseException said a ; is needed to end the quote of password. Any advice? - Original Message - From: Emmanuel G. Dialynas [EMAIL PROTECTED] To: engp0510 [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, August 03, 2003 6:07 PM Subject: Re: HELP!! TOMCAT and MYSQL Try: connectionURL=jdbc:mysql://localhost/authority?user=leesonpassword= At 04:32 ìì 03/08/03 +0800, engp0510 wrote: Hi, I am using Tomcat 4.0 and MySQL 4.0.14 on WIn2K Professional. In Server.XML of Tomcat, I use: Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost/authority?user=leeson;password= userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name / In MySQL, I set all user must access database with password and grant user 'leeson' with all privileges @ localhost. I can use leeson and password to log into MySQL. All setting of MySQL will work well when I login MySQL using CMD on Win2K But when I start tomcat-standalone, there is always : Catalina.start: LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorizatio n specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorization specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) ... So, it seem Parser regard user as leeson;password, not leeson. But if I grant leeson all privileges but without password, the tomcat could work. - 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: HELP!! TOMCAT and MYSQL
Thanks Stuart. I always do this when I use JDBC in normal application. But during configing the Tomcat Server.XML, there is no instruction about separated properties for this REALM. Regards - Original Message - From: Stuart MacPherson [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED]; [EMAIL PROTECTED]; 'Emmanuel G. Dialynas' [EMAIL PROTECTED] Sent: Sunday, August 03, 2003 7:12 PM Subject: RE: HELP!! TOMCAT and MYSQL Split the user and pass off of the URL, and into separate properties... stu -Original Message- From: engp0510 [mailto:[EMAIL PROTECTED] Sent: 03 August 2003 11:40 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Emmanuel G. Dialynas Subject: Re: HELP!! TOMCAT and MYSQL Thanks very much! Y, I have tried. But always throw org.xml.sax.SAXParseException said a ; is needed to end the quote of password. Any advice? - Original Message - From: Emmanuel G. Dialynas [EMAIL PROTECTED] To: engp0510 [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, August 03, 2003 6:07 PM Subject: Re: HELP!! TOMCAT and MYSQL Try: connectionURL=jdbc:mysql://localhost/authority?user=leesonpassword= At 04:32 ìì 03/08/03 +0800, engp0510 wrote: Hi, I am using Tomcat 4.0 and MySQL 4.0.14 on WIn2K Professional. In Server.XML of Tomcat, I use: Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost/authority?user=leeson;password= userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name / In MySQL, I set all user must access database with password and grant user 'leeson' with all privileges @ localhost. I can use leeson and password to log into MySQL. All setting of MySQL will work well when I login MySQL using CMD on Win2K But when I start tomcat-standalone, there is always : Catalina.start: LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorizatio n specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorization specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) ... So, it seem Parser regard user as leeson;password, not leeson. But if I grant leeson all privileges but without password, the tomcat could work. - 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: HELP!! TOMCAT and MYSQL
I have got the binaries for linux, does anyone know how do I install those binaries on linux workstation. I don't know much about linux and I need to know what the commands are and how to do it. There is nothing in the Readme File that lets me know how to install the Binaries on linux machines Zill-e-Hassan UMG-IT Tel: +966 2 6512111 Ext: 1219 Fax: + 966 2 6571171 United Matbouli Group-Matbouli Plaza-1st Floor-PO Box556 Jeddah 21421 -Original Message- From: Stuart MacPherson [mailto:[EMAIL PROTECTED] Sent: Sunday, August 03, 2003 2:13 PM To: 'Tomcat Users List'; [EMAIL PROTECTED]; 'Emmanuel G. Dialynas' Subject: RE: HELP!! TOMCAT and MYSQL Split the user and pass off of the URL, and into separate properties... stu -Original Message- From: engp0510 [mailto:[EMAIL PROTECTED] Sent: 03 August 2003 11:40 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Emmanuel G. Dialynas Subject: Re: HELP!! TOMCAT and MYSQL Thanks very much! Y, I have tried. But always throw org.xml.sax.SAXParseException said a ; is needed to end the quote of password. Any advice? - Original Message - From: Emmanuel G. Dialynas [EMAIL PROTECTED] To: engp0510 [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, August 03, 2003 6:07 PM Subject: Re: HELP!! TOMCAT and MYSQL Try: connectionURL=jdbc:mysql://localhost/authority?user=leesonpassword= At 04:32 ìì 03/08/03 +0800, engp0510 wrote: Hi, I am using Tomcat 4.0 and MySQL 4.0.14 on WIn2K Professional. In Server.XML of Tomcat, I use: Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost/authority?user=leeson;password= userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name / In MySQL, I set all user must access database with password and grant user 'leeson' with all privileges @ localhost. I can use leeson and password to log into MySQL. All setting of MySQL will work well when I login MySQL using CMD on Win2K But when I start tomcat-standalone, there is always : Catalina.start: LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorizatio n specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorization specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) ... So, it seem Parser regard user as leeson;password, not leeson. But if I grant leeson all privileges but without password, the tomcat could work. - 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: HELP!! TOMCAT and MYSQL
Try: connectionURL=jdbc:mysql://localhost/authority?user=leesonpassword= At 04:32 ìì 03/08/03 +0800, engp0510 wrote: Hi, I am using Tomcat 4.0 and MySQL 4.0.14 on WIn2K Professional. In Server.XML of Tomcat, I use: Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost/authority?user=leeson;password= userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name / In MySQL, I set all user must access database with password and grant user 'leeson' with all privileges @ localhost. I can use leeson and password to log into MySQL. All setting of MySQL will work well when I login MySQL using CMD on Win2K But when I start tomcat-standalone, there is always : Catalina.start: LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorizatio n specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorization specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) ... So, it seem Parser regard user as leeson;password, not leeson. But if I grant leeson all privileges but without password, the tomcat could work. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: HELP!! TOMCAT and MYSQL
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 engp0510 wrote: Thanks very much! Y, I have tried. But always throw org.xml.sax.SAXParseException said a ; is needed to end the quote of password. Any advice? Tomcat's config file is in XML. The 'XML way' to produce an ampersand () is to use the entity amp; So...Your connection URL would look like: connectionURL=jdbc:mysql://localhost/authority?user=leesonamp;password= Regards, -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 557 2388 www.mysql.com Are you MySQL Certified? http://www.mysql.com/certification/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQE/LSbhtvXNTca6JD8RAkYKAJ94rLovzLHUodq+n6vYwFBplig+GwCffI+h ESAxHAD4u1/gYfi5MTWvg58= =pqqc -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Tomcat and MySQL
Hi, I am using Tomcat 4.0 and MySQL 4.0.14 on WIn2K Professional. In Server.XML of Tomcat, I use: Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost/authority?user=leeson;password= userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name / In MySQL, I set all user must access database with password and grant user 'leeson' with all privileges. I can use leeson and password to log into MySQL. But when I start tomcat-standalone, there is always : Catalina.start: LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorizatio n specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorization specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:505) at org.apache.catalina.startup.Catalina.start(Catalina.java:776) 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:218) - Root Cause - java.sql.SQLException: Invalid authorization specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using p assword: NO) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:659) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562) at com.mysql.jdbc.Connection.init(Connection.java:491) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346) 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:307) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:505) at org.apache.catalina.startup.Catalina.start(Catalina.java:776) 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:218) Can anyone help me? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Tomcat and MySQL
Should be ?user=leesonpassword= Also you need to make sure that user leeson has access privileges to MySQL from localhost. http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#User_Account_Management John engp0510 wrote: Hi, I am using Tomcat 4.0 and MySQL 4.0.14 on WIn2K Professional. In Server.XML of Tomcat, I use: Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost/authority?user=leeson;password= userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name / In MySQL, I set all user must access database with password and grant user 'leeson' with all privileges. I can use leeson and password to log into MySQL. But when I start tomcat-standalone, there is always : Catalina.start: LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorizatio n specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorization specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:505) at org.apache.catalina.startup.Catalina.start(Catalina.java:776) 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:218) - Root Cause - java.sql.SQLException: Invalid authorization specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using p assword: NO) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:659) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562) at com.mysql.jdbc.Connection.init(Connection.java:491) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346) 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:307) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:505) at org.apache.catalina.startup.Catalina.start(Catalina.java:776) 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:218) Can anyone help me? - 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: Tomcat and MySQL
Look closely at your URL - it is malformed. it should read: connectionURL=jdbc:mysql://localhost/authority?user=leesonpassword= Thanks, Scott Stewart -Original Message- From: engp0510 [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 11:48 AM To: [EMAIL PROTECTED] Subject: Tomcat and MySQL Hi, I am using Tomcat 4.0 and MySQL 4.0.14 on WIn2K Professional. In Server.XML of Tomcat, I use: Realm className=org.apache.catalina.realm.JDBCRealm debug=99 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost/authority?user=leeson;password= userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name / In MySQL, I set all user must access database with password and grant user 'leeson' with all privileges. I can use leeson and password to log into MySQL. But when I start tomcat-standalone, there is always : Catalina.start: LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorizatio n specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) LifecycleException: Exception opening database connection: java.sql.SQLException: Invalid authorization specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:505) at org.apache.catalina.startup.Catalina.start(Catalina.java:776) 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:218) - Root Cause - java.sql.SQLException: Invalid authorization specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using p assword: NO) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:659) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562) at com.mysql.jdbc.Connection.init(Connection.java:491) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346) 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:307) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:505) at org.apache.catalina.startup.Catalina.start(Catalina.java:776) 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:218) Can anyone help me? - 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]
Tomcat ( JSP)+ MySql .. driver ?
hi guys , can anyone help me plz ! .. how can i make my jsp files working on Tomcat work with MySql database .. i download the java-module offered from MySql site .. but i dont know where / how to work with it ! thanks in advance , Walid - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Tomcat ( JSP)+ MySql .. driver ?
If you want all tomcat webapps to use MySQL, put the MySQL JDBC jar file to common/lib folder. If you want just a particular webapp to use MySQL, put the jar file to YOUR_WEBAPP/WEB-INF/lib. If you don't know how to use JDBC + JSP, you should go to SUN site to read their tutorials. Hope this get you started. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 2:08 PM To: [EMAIL PROTECTED] Subject: Tomcat ( JSP)+ MySql .. driver ? hi guys , can anyone help me plz ! .. how can i make my jsp files working on Tomcat work with MySql database .. i download the java-module offered from MySql site .. but i dont know where / how to work with it ! thanks in advance , Walid - 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]
Tomcat and mysql
Hello, I have installed a web application called xplanner. It is using mysql and it is integrated in tomcat for authentication. I got the following error when I startup the application. I susspect somehow tomcat doesn't work well with mysql database. I wonder if anyone has seen this problem and if anyone has configured tomcat to work with mysql database. Here is the error: A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: java/lang/reflect/InvocationHandler at java.lang.Throwable.fillInStackTrace(Native Method) at java.lang.Throwable.fillInStackTrace(Compiled Code) at java.lang.Throwable.(Compiled Code) at java.lang.Exception.(Compiled Code) at javax.servlet.ServletException.(ServletException.java:161) at org.apache.jasper.runtime.PageContextImpl.handlePageException(Unknown Source) at org.apache.jsp.projects$jsp._jspService(Compiled Code) at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source) at javax.servlet.http.HttpServlet.service(Compiled Code) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(Unknown Source) at org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown Source) at org.apache.jasper.servlet.JspServlet.service(Compiled Code) at javax.servlet.http.HttpServlet.service(Compiled Code) at org.apache.catalina.core.ApplicationDispatcher.invoke(Unknown Source) at org.apache.catalina.core.ApplicationDispatcher.doForward(Unknown Source) at org.apache.catalina.core.ApplicationDispatcher.forward(Unknown Source) at org.apache.struts.action.ActionServlet.processActionForward(ActionServlet.java:1759) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1596) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492) Thanks, Lihong -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Tomcat and mysql
Looking at the stack trace, I do not see anything related to mysql. What makes you think that is the source of the problem? Based on the org.apache.jsp.projects$jsp bit, I would look in the project.jsp file first... Larry [EMAIL PROTECTED] 01/22/03 15:47 PM Hello, I have installed a web application called xplanner. It is using mysql and it is integrated in tomcat for authentication. I got the following error when I startup the application. I susspect somehow tomcat doesn't work well with mysql database. I wonder if anyone has seen this problem and if anyone has configured tomcat to work with mysql database. Here is the error: A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: java/lang/reflect/InvocationHandler at java.lang.Throwable.fillInStackTrace(Native Method) at java.lang.Throwable.fillInStackTrace(Compiled Code) at java.lang.Throwable.(Compiled Code) at java.lang.Exception.(Compiled Code) at javax.servlet.ServletException.(ServletException.java:161) at org.apache.jasper.runtime.PageContextImpl.handlePageException(Unknown Source) at org.apache.jsp.projects$jsp._jspService(Compiled Code) at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source) at javax.servlet.http.HttpServlet.service(Compiled Code) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(Unknown Source) at org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown Source) at org.apache.jasper.servlet.JspServlet.service(Compiled Code) at javax.servlet.http.HttpServlet.service(Compiled Code) at org.apache.catalina.core.ApplicationDispatcher.invoke(Unknown Source) at org.apache.catalina.core.ApplicationDispatcher.doForward(Unknown Source) at org.apache.catalina.core.ApplicationDispatcher.forward(Unknown Source) at org.apache.struts.action.ActionServlet.processActionForward(ActionServlet.java:1759) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1596) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492) Thanks, Lihong -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
tomcat log4j mysql
I am trying to use log4j 1.2.5, mysql 3.0.23 adn tomcat 4.0.1.
1. I placed the mysql-connector-java-2.0.14-bin.jar in my
webapps/app/WEB-INF/lib dir.
2. This is my log4j properties file.
log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.appender.R=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.R.URL=jdbc:mysql://x.x.x.x/vdatabase01
log4j.appender.R.user=default
log4j.appender.R.password=default
log4j.appender.R.sql=INSERT INTO log4jTable VALUES ('%d', '%c', '%p', '%m')
3. On starting tomcat, within the webapps init method i try to retrieve the
above values. and i get this error.
log4j:ERROR Failed to excute sql
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at
org.apache.log4j.jdbc.JDBCAppender.getConnection(JDBCAppender.java:197)
at org.apache.log4j.jdbc.JDBCAppender.execute(JDBCAppender.java:160)
at
org.apache.log4j.jdbc.JDBCAppender.flushBuffer(JDBCAppender.java:235)
at org.apache.log4j.jdbc.JDBCAppender.append(JDBCAppender.java:131)
at
org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:221)
at
org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(Append
erAttachableImpl.java:57)
at org.apache.log4j.Category.callAppenders(Category.java:187)
at org.apache.log4j.Category.forcedLog(Category.java:372)
at org.apache.log4j.Category.info(Category.java:674)
at com.mantissa.servlets.RMSServlet.init(RMSServlet.java:886)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:91
6)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:808)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:
3266)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3395)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:785)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:454)
at
org.apache.catalina.core.StandardHost.install(StandardHost.java:714)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:300)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:389)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:232)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:155)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1131)
at
org.apache.catalina.core.StandardHost.start(StandardHost.java:614)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
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)
Please excuse me if this is not a tomcat specific question but which
application is self contained anyways.
Please let me know if i am doing something wrong.
Thanks.
B.
--
To unsubscribe, e-mail: mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: tomcat log4j mysql
Well the first thing is:
java.sql.SQLException: No suitable driver
Means there has been no driver specified to use to connect to the db.
Try adding this to your log4j config
log4j.appender.R.driver=driver
Regards,
Nicholas Orr
-Original Message-
From: B [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 17 October 2002 5:18 AM
To: Tomcat Users List
Subject: tomcat log4j mysql
I am trying to use log4j 1.2.5, mysql 3.0.23 adn tomcat 4.0.1.
1. I placed the mysql-connector-java-2.0.14-bin.jar in my
webapps/app/WEB-INF/lib dir. 2. This is my log4j properties file.
log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.appender.R=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.R.URL=jdbc:mysql://x.x.x.x/vdatabase01
log4j.appender.R.user=default
log4j.appender.R.password=default
log4j.appender.R.sql=INSERT INTO log4jTable VALUES ('%d', '%c', '%p', '%m')
3. On starting tomcat, within the webapps init method i try to retrieve the
above values. and i get this error. log4j:ERROR Failed to excute sql
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at
org.apache.log4j.jdbc.JDBCAppender.getConnection(JDBCAppender.java:197)
at org.apache.log4j.jdbc.JDBCAppender.execute(JDBCAppender.java:160)
at
org.apache.log4j.jdbc.JDBCAppender.flushBuffer(JDBCAppender.java:235)
at org.apache.log4j.jdbc.JDBCAppender.append(JDBCAppender.java:131)
at
org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:221)
at
org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(Append
erAttachableImpl.java:57)
at org.apache.log4j.Category.callAppenders(Category.java:187)
at org.apache.log4j.Category.forcedLog(Category.java:372)
at org.apache.log4j.Category.info(Category.java:674)
at com.mantissa.servlets.RMSServlet.init(RMSServlet.java:886)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:91
6)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:808)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:
3266)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3395)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:785)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:454)
at
org.apache.catalina.core.StandardHost.install(StandardHost.java:714)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:300)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:389)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:232)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:155)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1131)
at
org.apache.catalina.core.StandardHost.start(StandardHost.java:614)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
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)
Please excuse me if this is not a tomcat specific question but which
application is self contained anyways.
Please let me know if i am doing something wrong.
Thanks.
B.
--
To unsubscribe, e-mail:
mailto:[EMAIL PROTECTED]
For additional commands, e-mail:
mailto:[EMAIL PROTECTED]
**
The information contained in this e-mail is confidential and is
intended only for the use of the addressee(s).
If you receive this e-mail in error, any use, distribution or
copying of this e-mail is not permitted. You are requested to
forward unwanted e-mail and address any problems to the
MIM Holdings Limited Support Centre.
For general enquires: ++61 7 3833 8000
Support Centre e-mail: [EMAIL PROTECTED]
Support Centre phone: Australia 1800500646
International ++61 7 38338042
Re: Tomcat 4.1.9 + MySQL + jdbc driver
I have also seen this with the following setup. Solaris 8 on Sun Sparc Java 1.3.1_04 Tomcat 4.1.8/Jasper 1 mm.mysql 2.0.14 Apache 1.3.26 with mod_jk and Ajp13 connector. DBCP In my case from reviewing all of the tomcat logs I found that the Communication link failure looks like a symptom of some other failure. When reviewing my Engine logs for the ajp connector it looks like Tomcat was not completing requests for a period of 5 minutes. I saw a cascading of log entries like this in a 5 minute period where over 100 new Ajp13Processor's were started. 2002-08-25 10:20:11 Ajp13Processor[8009][184] Starting background thread I have seen this same behaviour a number of times, and each time the length of the problem is about 5 minutes long. I have also checked the CPU load stats for these time periods and I am seeing the load increase by a factor of 3 while this is happening. To a load 1 on a single CPU system. I checked the mysqld error logs, no errors reported. These weren't due to a spike in the number of requests. And there was no start/stop/reload of any Contexts which triggered this. No JSP pages were recompiled at the times this happened. Nothing was changed. I also start Tomcat with the java arg -verbose:gc so that garbage collection data is logged. I reviewed the GC times and I have several long Full GC's of 15 and 22 seconds which might explain some of the problems, but not a problem that seems to last 5 minutes. I bet a thread stack dump while this is going on would be very interesting reading. I don't know yet what the source of my problem is. The system Tomcat is running on will be upgraded to faster dual CPU's and another 512MB of ram in the next week or so. Perhaps that will help. I just thought the trouble shooting process I went through might help you do forensics on your logs so you can track down your problem. Regards, Glenn Paul Phillips wrote: I have used the Mark Matthews MySQL jdbc driver with Tomcat on three or four projects and never had any trouble. I recently started using the newest version of the driver, now called MySQL Connector/J version 3.0.0 beta. I am using it with Tomcat 4.1.9 on a Sun Ultra 5 with Solaris 9. I am also using the DBCP connection pool as described in the 4.1 docs. I have never used this combination (the particular machine, Sol 9, this new version of Tomcat and this driver) together to do database lookups before, so I'm not sure where to look for the trouble. However - the trouble is this... I just installed my webapp a couple of days ago, for use in low level production (meaning if there are problems, it is not the end of the world...) Each morning, when I come in, and fire up my webapp, the database connections don't work. The Tomcat logs report this: java.sql.SQLException: Communication link failure: java.net.SocketException at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:810) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1265) at com.mysql.jdbc.Connection.execSQL(Connection.java:1935) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1800) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:445) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:394) at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAuthen ticator.java:263) and etc back through the trace. So there is some problem with the socket. If I simply shutdown and restart Tomcat, the problem goes away and my app works fine and happily all day long. So, what would cause this to happen? Connection pool problem? Driver problem? I don't even know where to start looking... I would appreciate any ideas. Regards, Paul Phillips -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Mac OS X, Tomcat 4.0.4, MySql configuration denies access
Jack Park wrote: Thank you! I've now got even more food for thought. You used JDBCRealm. Here is what the Tomcat how-to on that says: This document describes how to configure Tomcat to support container managed security, by connecting to an existing database of usernames, passwords, and user roles. You only need to care about this if you are using a web application that includes one or more security-constraint elements, and a login-config element defining how users are required to authenticate themselves. If you are not utilizing these features, you can safely skip this document. I should say that I am doing this in a verbose fashion in the hopes that other OS X users will be able to find it with google when/if they need it. My similar query at http://forums.osxfaq.com/viewforum.php?forum=15 has had 3 hits (one of which is mine) in the same time span as this post here; here there have been responses of great value to this inquiry, there have been none elsewhere. Now, do I need container managed security? Did you? Or was that an approach that happened to get your installation working in absence of other considerations? In a reply here by Steve Ahlstrom, he does not appear to use JDBCRealm, but does use a greatly expanded Context... entry in server.xml, and additional information (compared to what I use) in his application's web.xml. Security in my program has, all along, been handled by authentication routines built into my code (though I can imagine handing that work over to something else in the future). I configured container managed security simply because the application requires it. I used it as an example because my application code accesses the database via a connection pool and JNDI, so it's more complicated to explain. In another (later) post, you describe your Unix accounts; mine are somewhat different. In case it helps, I'll describe them... First, I'm an old-time Unix guy (SVR4, Solaris, Linux), but I don't know the ins-and-outs of BSD, nor NextStep, so I didn't know about sudo when I started hacking about. I enabled root in NetInfo, and made sure that my user (martin) was a member of a group that root was also in. Hence, I was able to su root. I created a login account for mysql, and installed mysql as per instructions. I created a mysql user 'tomcat' which can only perform selects on one database. Also, tomcat can only connect from 'localhost' or 'macx'. I created another account which can do anything on the same single database when connecting from 'localhost', and this is the account that the application code uses. To run tomcat, I cd to the base directory, su root, and type bin/startup.sh - this is because I use tomcat in standalone mode, and use ports 80/443. I suggest (if you haven't already done so) setting debug=9 everywhere(!), and then post the logs, with any relevant server.xml, web.xml and code snippets. Martin -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Mac OS X, Tomcat 4.0.4, MySql configuration denies access
for increasing their traffic) has some excellent manual pages on line: http://www.openbsd.org/cgi-bin/man.cgi Plug sudoers into the search form. You'll need to remember that there will be some differences, since Darwin is derived from the freeBSD, but I find the discussions very helpful. Ok. That's going to take a while. Right now, mac autoboots to jackpark. I'll drop that when it's ready to get plugged into the web. Whatever user(s) you run mysql, tomcat, and whatever else as, make sure they are users that can't log on. Is there some hint that everything should be owned and run by one user? I don't think so. It may help you to keep track of things. It may not. I'm pretty sure I had a separate tomcat and mysql user in my set-up at home. I'm beginning to suspect that there are problems with this 'picture.' (mostly made by my ignorance), particularly since two different tomcat builds refuse to run their examples. Perhaps you'll see what's wrong with this picture. At first, it seemed you had some confusion between the mysql permissions system and the UNIX permissions system. But it looks like that isn't the problem, after all. Let's see. You said you had the driver in place. You said you were able to log into mysql, so your sockets must be okay. I guess I'm out of ideas, unless your contexts have got something in them that doesn't work on Mac OS X. How's the case sensitivity? No, if it's working on MSWindows, then you shouldn't be getting bit by case conflicts. Ok. It's going to take me a few hours to digest all this. Many thanks again to all who have responded to my problem (ignorance?) Cheers Jack -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Mac OS X, Tomcat 4.0.4, MySql configuration denies access
Jack Park wrote: I continue to get the sql exception using the above software and mm.mysql 2.0.8 drivers. MySql is 3.23.51 downloaded from entropy.ch I have granted permission to the program for both localhost (a guess) and localhost.localdomain (which I needed on wintel and linux). While roaming with google, someone (http://www.macosx.com/forums/showthread.php?s=threadid=7737highlight=mysq l+java) solved (I think) the same problem by making a new root user with host = % (I confess: I have no idea how to do that!). I tried making my program (the name I use to open a connection to mysql) a Mac User. Nothing changed. I see several candidate avenues of inquiry: tomcat 4.0.4 has problems with this configuration (I think very unlikely) mm.mysql 2.0.8 is the wrong driver for 3.23.51 3.23.51 (being a very recent release) has some problem my configuration of the database with permissions is not consistent with OS X needs (works fine on wintel and linux, however). Hi, I am successfully using mysql (3.23.46) Tomcat (4.1.4) with mm.mysql driver (2.0.14) on Mac OS X (10.1.5). My normal db connection is via JNDI/Datasource, but I also use JDBCRealm user authentication, which is a simpler configuration to show :-) I created a mysql user called 'tomcat' (no need to create a Unix account), with no password... mysql select * from user where user like 'tomcat'; +++--+-+-+-+-+-+---+-+---+--+---++-+++ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +++--+-+-+-+-+-+---+-+---+--+---++-+++ | localhost | tomcat | | Y | N | N | N | N | N | N | N | N| N | N | N | N | N | +++--+-+-+-+-+-+---+-+---+--+---++-+++ and then configured server.xml ... Realm className=org.apache.catalina.realm.JDBCRealm debug=0 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost/radiation?user=tomcat userTable=user userNameCol=user_id userCredCol=password userRoleTable=user_role roleNameCol=role_id / In fact, I'm lying :-) I (occasionally) had problems because mysql would refuse the connection with a message like user tomcat@macx has insufficient privileges (or something in that vein). To solve that, I simply added another line to the user table for tomcat, with macx as the hostname. I don't know why this happens - however, I use a Powerbook, both at home and at work, so I'm constantly changing my Location setting, with consequent change in IP address, and mysql may be getting confused. Although I'm using 4.1.4, this also worked on 4.0.4b3, so your Tomcat version is not an issue. I suspect that the problem can be solved by fiddling with mysql's privileges, which are (IMHO) somewhat arcane! Hope this helps, Martin. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Mac OS X, Tomcat 4.0.4, MySql configuration denies access
release) has some problem my configuration of the database with permissions is not consistent with OS X needs (works fine on wintel and linux, however). Hi, I am successfully using mysql (3.23.46) Tomcat (4.1.4) with mm.mysql driver (2.0.14) on Mac OS X (10.1.5). My normal db connection is via JNDI/Datasource, but I also use JDBCRealm user authentication, which is a simpler configuration to show :-) I created a mysql user called 'tomcat' (no need to create a Unix account), with no password... mysql select * from user where user like 'tomcat'; +++--+-+-+- +-+-+---+-+---+ --+---++-++ + | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +++--+-+-+- +-+-+---+-+---+ --+---++-++ + | localhost | tomcat | | Y | N | N| N | N | N | N | N | N| N | N | N | N | N | +++--+-+-+- +-+-+---+-+---+ --+---++-++ + and then configured server.xml ... Realm className=org.apache.catalina.realm.JDBCRealm debug=0 driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://localhost/radiation?user=tomcat userTable=user userNameCol=user_id userCredCol=password userRoleTable=user_role roleNameCol=role_id / In fact, I'm lying :-) I (occasionally) had problems because mysql would refuse the connection with a message like user tomcat@macx has insufficient privileges (or something in that vein). To solve that, I simply added another line to the user table for tomcat, with macx as the hostname. I don't know why this happens - however, I use a Powerbook, both at home and at work, so I'm constantly changing my Location setting, with consequent change in IP address, and mysql may be getting confused. Although I'm using 4.1.4, this also worked on 4.0.4b3, so your Tomcat version is not an issue. I suspect that the problem can be solved by fiddling with mysql's privileges, which are (IMHO) somewhat arcane! Hope this helps, Martin. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Mac OS X, Tomcat 4.0.4, MySql configuration denies access
Been wondering some things about this thread -- Jack, what UNIX user owns MySQL? Likewise, Tomcat? And what UNIX user are they each being run by? I continue to get the sql exception using the above software and mm.mysql 2.0.8 drivers. MySql is 3.23.51 downloaded from entropy.ch I have granted permission to the program for both localhost (a guess) and localhost.localdomain (which I needed on wintel and linux). While roaming with google, someone (http://www.macosx.com/forums/showthread.php?s=threadid=7737highlight=mysq l+java) solved (I think) the same problem by making a new root user with host = % (I confess: I have no idea how to do that!). I tried making my program (the name I use to open a connection to mysql) a Mac User. Nothing changed. Do you mean to say that you tried adding a UNIX user called mysql? Did use chown on the mysql distribution to change the user/group appropriately? Did you set up your sudoers and use sudo to run mysql? I see several candidate avenues of inquiry: tomcat 4.0.4 has problems with this configuration (I think very unlikely) mm.mysql 2.0.8 is the wrong driver for 3.23.51 3.23.51 (being a very recent release) has some problem my configuration of the database with permissions is not consistent with OS X needs (works fine on wintel and linux, however). Any thoughts would be greatly appreciated. Cheers, Jack -- Joel Rees [EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Mac OS X, Tomcat 4.0.4, MySql configuration denies access
Thanks, Joel. You're wondering about things I started wondering about myself, today. I suppose it's worse than that, however. I just found out that, while tomcat does seem to want to load my servlet, it will not load any of the examples. The404 message says the requested resource is not available, but the log says it's doing a class not found problem on a filter. I just downloaded tomcat 4.0.1 (because that's what I'm running on linux) and it's doing the same error on the mac. I found some stuff with google that suggests I not put anything specific to tomcat (except, perhaps, the specific servlet classes) in my CLASSPATH. There is, in fact only the path to the servlet classes themselves as a hedge. Perhaps that should be removed. Right now, I don't see the link. So back to owners. I followed the instructions from an OnJava article on installing tomcat. Tomcat is owned by Unix user 'jackpark', while mysql, also installed according to an OnJava article, is owned by (originally) Unix user 'mysql' and now Unix user 'wiki'. I'd like everything to be owned by 'wiki' (which has a password) because that's the user that a webmaster will have access to. chown -R is used on the mysql installation. the user 'jackpark' is running both. I'm not sure what subdoers means, but I almost always have to use sudo to do everything. Right now, mac autoboots to jackpark. I'll drop that when it's ready to get plugged into the web. Is there some hint that everything should be owned and run by one user? I'm beginning to suspect that there are problems with this 'picture.' (mostly made by my ignorance), particularly since two different tomcat builds refuse to run their examples. Perhaps you'll see what's wrong with this picture. Many thanks, again. Jack At 01:26 PM 7/9/2002 +0900, Joel Rees wrote: Been wondering some things about this thread -- Jack, what UNIX user owns MySQL? Likewise, Tomcat? And what UNIX user are they each being run by? I continue to get the sql exception using the above software and mm.mysql 2.0.8 drivers. MySql is 3.23.51 downloaded from entropy.ch I have granted permission to the program for both localhost (a guess) and localhost.localdomain (which I needed on wintel and linux). While roaming with google, someone (http://www.macosx.com/forums/showthread.php?s=threadid=7737highlight=mysq l+java) solved (I think) the same problem by making a new root user with host = % (I confess: I have no idea how to do that!). I tried making my program (the name I use to open a connection to mysql) a Mac User. Nothing changed. Do you mean to say that you tried adding a UNIX user called mysql? Did use chown on the mysql distribution to change the user/group appropriately? Did you set up your sudoers and use sudo to run mysql? I see several candidate avenues of inquiry: tomcat 4.0.4 has problems with this configuration (I think very unlikely) mm.mysql 2.0.8 is the wrong driver for 3.23.51 3.23.51 (being a very recent release) has some problem my configuration of the database with permissions is not consistent with OS X needs (works fine on wintel and linux, however). Any thoughts would be greatly appreciated. Cheers, Jack -- Joel Rees [EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Mac OS X, Tomcat 4.0.4, MySql configuration denies access
Thanks, Joel. You're wondering about things I started wondering about myself, today. I suppose it's worse than that, however. I just found out that, while tomcat does seem to want to load my servlet, it will not load any of the examples. If it doesn't load the examples, I'd be surprised if it really wanted to load your servlet. (I have been surprised before.) Usually, if it doesn't run the examples, it isn't running, and what you're really doing is serving the Tomcat example pages from apache. Is apache running? That could be getting in your way. Check the web sharing (ohwhatisthatcalledinEnglishMacOSX?) control panel (???). It's there with file sharing. Interpret web sharing as meaning apache. Even if you had no problems getting apache and Tomcat running together on the Linux and Windows set-ups, you probably want to shut it down while setting Tomcat up on the Mac. If apache is not running, and your servlet seems to be trying to run, have you perhaps edited the examples context instead of copying it and making a new context for your servlet to run in? The404 message says the requested resource is not available, but the log says it's doing a class not found problem on a filter. I just downloaded tomcat 4.0.1 (because that's what I'm running on linux) and it's doing the same error on the mac. I found some stuff with google that suggests I not put anything specific to tomcat (except, perhaps, the specific servlet classes) in my CLASSPATH. There is, in fact only the path to the servlet classes themselves as a hedge. Perhaps that should be removed. Right now, I don't see the link. I'm thinking I didn't mess with the CLASSPATH for Tomcat 3.3, but my memory may be wrong. I'll check when I get home tonight. (I've got it set up on my own iBook.) What's your server.xml look like? Have you set that (and the stuff it refers to) up properly? Read the comments and the XML declarations in there and check them against the docs again. So back to owners. I followed the instructions from an OnJava article on installing tomcat. Tomcat is owned by Unix user 'jackpark', while mysql, also installed according to an OnJava article, is owned by (originally) Unix user 'mysql' and now Unix user 'wiki'. I'd like everything to be owned by 'wiki' I think there should be no problem with that, although it isn't really necessary. You can control who can run as whom with your sudoers file. Are you setting the users up from the users control panel (???) or from the network administration app? The latter is the one you want to be using for users that are there just to run apps under. Remember to keep root login disabled as much as possible. (which has a password) because that's the user that a webmaster will have access to. chown -R is used on the mysql installation. the user 'jackpark' is running both. I'm not sure what subdoers means, sudoers is the file in /etc somewhere (my memory is bad today) that tells sudo which users are allowed to pretend to be whom. but I almost always have to use sudo to do everything. I hope that doesn't mean that you're doing sudo root to run this all. If you are, get your sudoers file set up so you can get away from that. I think there's a man entry on sudoers, but if not, read the entries on sudo and su very thoroughly. It may take an hour to understand, but it's definitely worth the effort. BTW, the openBSD site (and they'll say mean things at me for increasing their traffic) has some excellent manual pages on line: http://www.openbsd.org/cgi-bin/man.cgi Plug sudoers into the search form. You'll need to remember that there will be some differences, since Darwin is derived from the freeBSD, but I find the discussions very helpful. Right now, mac autoboots to jackpark. I'll drop that when it's ready to get plugged into the web. Whatever user(s) you run mysql, tomcat, and whatever else as, make sure they are users that can't log on. Is there some hint that everything should be owned and run by one user? I don't think so. It may help you to keep track of things. It may not. I'm pretty sure I had a separate tomcat and mysql user in my set-up at home. I'm beginning to suspect that there are problems with this 'picture.' (mostly made by my ignorance), particularly since two different tomcat builds refuse to run their examples. Perhaps you'll see what's wrong with this picture. At first, it seemed you had some confusion between the mysql permissions system and the UNIX permissions system. But it looks like that isn't the problem, after all. Let's see. You said you had the driver in place. You said you were able to log into mysql, so your sockets must be okay. I guess I'm out of ideas, unless your contexts have got something in them that doesn't work on Mac OS X. How's the case sensitivity? No, if it's working on MSWindows, then you shouldn't be getting bit by case conflicts. Many thanks, again. Jack At 01:26 PM 7/9
Mac OS X, Tomcat 4.0.4, MySql configuration denies access
I continue to get the sql exception using the above software and mm.mysql 2.0.8 drivers. MySql is 3.23.51 downloaded from entropy.ch I have granted permission to the program for both localhost (a guess) and localhost.localdomain (which I needed on wintel and linux). While roaming with google, someone (http://www.macosx.com/forums/showthread.php?s=threadid=7737highlight=mysq l+java) solved (I think) the same problem by making a new root user with host = % (I confess: I have no idea how to do that!). I tried making my program (the name I use to open a connection to mysql) a Mac User. Nothing changed. I see several candidate avenues of inquiry: tomcat 4.0.4 has problems with this configuration (I think very unlikely) mm.mysql 2.0.8 is the wrong driver for 3.23.51 3.23.51 (being a very recent release) has some problem my configuration of the database with permissions is not consistent with OS X needs (works fine on wintel and linux, however). Any thoughts would be greatly appreciated. Cheers, Jack -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Mac OS X, Tomcat 4.0.4, MySql configuration denies access
2.0.8 is a very old driver. The current version is 2.0.14 I don't know how you granted permissions, but do something like ... (assuming root for username and admin for password) ... start mysql, then grant all on *.* to [EMAIL PROTECTED] identified by admin; Then use mysql and select * on user, make sure your grant took effect. If everything looks cool and it still doesn't work, check that your server.xml is configured correctly for your context and datasource. -Original Message- From: Jack Park [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 07, 2002 4:24 PM To: [EMAIL PROTECTED] Subject: Mac OS X, Tomcat 4.0.4, MySql configuration denies access I continue to get the sql exception using the above software and mm.mysql 2.0.8 drivers. MySql is 3.23.51 downloaded from entropy.ch I have granted permission to the program for both localhost (a guess) and localhost.localdomain (which I needed on wintel and linux). While roaming with google, someone (http://www.macosx.com/forums/showthread.php?s=threadid=7737highlight=mysq l+java) solved (I think) the same problem by making a new root user with host = % (I confess: I have no idea how to do that!). I tried making my program (the name I use to open a connection to mysql) a Mac User. Nothing changed. I see several candidate avenues of inquiry: tomcat 4.0.4 has problems with this configuration (I think very unlikely) mm.mysql 2.0.8 is the wrong driver for 3.23.51 3.23.51 (being a very recent release) has some problem my configuration of the database with permissions is not consistent with OS X needs (works fine on wintel and linux, however). Any thoughts would be greatly appreciated. Cheers, Jack -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Mac OS X, Tomcat 4.0.4, MySql configuration denies access
Thank you! I just upgraded to 2.0.14 with no change in behavior. I suppose I am a bit confused, and perhaps a bit of detail on what I have done might help. I open mysql with DriverManager.getConnection(jdbc:mysql:///mydatabase,nexw,) where nexw is the username and there is no password. I have already used two different grants: grant all privileges on mydatabase/* to nexw@localhost; a guess because the next try didn't work grant all privileges on mydatabase/* to [EMAIL PROTECTED] which works on wintel and linux server.xml has this context for the program: Context path=/wiki docBase=wiki reloadable=true debug=0 trusted=false /Context I am not aware of anything else I need to tell tomcat, particularly since that context statement works on both WinME and Linux, and this is OS X. Among the things I have tried is to create a Mac User called nexw, with no password and no root privileges. Perhaps OS X requires that, which means this my problem is less a tomcat problem and more a Darwin-user (ignorance) problem. Looking at mysql:user and mysql:db, nexw is clearly a registered (with mysql) user with granted privileges, for both localhost and for localhost.localdomain. That summarizes the problem, thus far. Maybe that will animate more ideas. Thanks again. Jack At 05:46 PM 7/7/2002 -0600, you wrote: 2.0.8 is a very old driver. The current version is 2.0.14 I don't know how you granted permissions, but do something like ... (assuming root for username and admin for password) ... start mysql, then grant all on *.* to [EMAIL PROTECTED] identified by admin; Then use mysql and select * on user, make sure your grant took effect. If everything looks cool and it still doesn't work, check that your server.xml is configured correctly for your context and datasource. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Mac OS X, Tomcat 4.0.4, MySql configuration denies access
I'm using Linux, not OSX, so there will likely be differences, but shouldn't
be too much as OSX is Mach/BSD based.
I'm using connection pooling, so I've got commons-collections.jar,
commons-dbcp.jar, commons-pool.jar as well as mm.mysql-2.0.14-bin.jar
in $CATALINA_HOME/common/lib.
I connect to a datasource with the following code ...
public Connection getConn (String appl)
throws SQLException {
DataSource datasource = null;
try {
Context initialcontext = new InitialContext();
datasource =
(DataSource)initialcontext.lookup(java:comp/env/jdbc/ + appl);
}
catch (NamingException e) {
throw new SQLException(e.getMessage());
}
try {
conn = datasource.getConnection();
}
catch (SQLException e) {
throw new SQLException(newMsg, e.getSQLState(), e.getErrorCode());
}
return (conn);
}
My context for my app is ...
Context path=/site docBase=site debug=0 reloadable=true
Logger className=org.apache.catalina.logger.FileLogger
prefix=site. suffix=.log
timestamp=true/
Resource name=jdbc/thought auth=Container
type=javax.sql.DataSource/
ResourceParams name=jdbc/thought
parameter
namefactory/name
valueorg.apache.commons.dbcp.BasicDataSourceFactory/value
/parameter
parameter
nameusername/name
valueroot/value
/parameter
parameter
namepassword/name
valueadmin/value
/parameter
parameter
namedriverClassName/namevalueorg.gjt.mm.mysql.Driver/value
/parameter
parameter
nameurl/namevaluejdbc:mysql://10.0.0.4:3306/thought/value
/parameter
/ResourceParams
/Context
My database name is thought, my username is root and my password is
admin.
Substitute your own as required.
The appropriate section of my web.xml file is ...
resource-ref
res-ref-namejdbc/thought/res-ref-name
res-typejavax.sql.DataSource/res-type
res-authContainer/res-auth
/resource-ref
I'm not a MySQL expert. Your grant statement looks funny to me because
I'm not used to seeing the /* syntax. Not saying it's wrong. For all
of my MySQL questions I go to the New Riders book, MySQL, by Paul Dubois.
That's about all I can tell you other than my app's been running under
both Weblogic and HPAS for the last 9 months. I finally got it going
under Tomcat this weekend using the info above. Now if I can just figure
out how to front end Tomcat with Apache I'll be done with it.
Good luck
Steve
-Original Message-
From: Jack Park [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 07, 2002 8:09 PM
To: Tomcat Users List
Subject: RE: Mac OS X, Tomcat 4.0.4, MySql configuration denies access
Thank you!
I just upgraded to 2.0.14 with no change in behavior.
I suppose I am a bit confused, and perhaps a bit of detail on what I have
done might help.
I open mysql with
DriverManager.getConnection(jdbc:mysql:///mydatabase,nexw,)
where nexw is the username and there is no password.
I have already used two different grants:
grant all privileges on mydatabase/* to nexw@localhost; a
guess because the next try didn't work
grant all privileges on mydatabase/* to
[EMAIL PROTECTED] which works on wintel and linux
server.xml has this context for the program:
Context
path=/wiki
docBase=wiki
reloadable=true
debug=0
trusted=false
/Context
I am not aware of anything else I need to tell tomcat, particularly since
that context statement works on both WinME and Linux, and this is OS X.
Among the things I have tried is to create a Mac User called nexw, with
no password and no root privileges. Perhaps OS X requires that, which
means this my problem is less a tomcat problem and more a Darwin-user
(ignorance) problem.
Looking at mysql:user and mysql:db, nexw is clearly a registered (with
mysql) user with granted privileges, for both localhost and for
localhost.localdomain.
That summarizes the problem, thus far. Maybe that will animate more ideas.
Thanks again.
Jack
At 05:46 PM 7/7/2002 -0600, you wrote:
2.0.8 is a very old driver. The current version is 2.0.14
I don't know how you granted permissions, but do something like ...
(assuming root for username and admin for password) ...
start mysql, then
grant all on *.* to [EMAIL PROTECTED] identified by admin;
Then use mysql and select * on user, make sure your grant took
effect.
If everything looks cool and it still doesn't work, check that your
server.xml is configured correctly for your context and datasource.
--
To unsubscribe, e-mail:
mailto:[EMAIL PROTECTED]
For additional commands, e-mail:
mailto:[EMAIL PROTECTED]
--
To unsubscribe, e-mail: mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Tomcat 3.3.1 MySQL
I would like TOMCAT to server op the connections to MYSQL.. Can someone please send me the appropriate server.xml configuration and misc tidbits that can get me started!! Thank you, joseph
Re: Tomcat 4.0.2 - MySQL Connection Pooling
Hello Michael, Yesss, I just got it working this past evening! I've been on it for a few days and have tried everything I could think of.=O To install Tomcat 4.0.2 and get JNDI working, I used the RPM found in the standard download area named - tomcat4-4.0.2-2.noarch.rpm along with the dependent RPMs: - regexp-1.2-1.noarch.rpm - servletapi4-4.0.2-1.noarch.rpm - xerces-j-1.4.4-2.noarch.rpm This should create the proper user for you and install the proper init.d start/stop scripts. I then replaced the tomcat4/ directory that the RPM placed on my server with the jakarta-tomcat-4.0.2/ directory found in the GZip-TAR'd regular Tomcat install base file named jakarta-tomcat-4.0.2.tar.gz (e.g. non-RPM version) and configured JNDI as below and things worked!!! =) I'm thinking that the proper libraries weren't installed by the RPM or something in the install didn't go right??? Not sure what no-arch signifies in the RPMs above, but maybe I was just using the wrong install I tried adding and replacing JARs, but I couldn't find the right combo that would enable the JNDI resource. It was consistent as I couldn't create a mail JNDI resource either. If you replace the entire tomcat directory and thus the proper JARs, you should get it working. Best regards, ---Ross From: Michael Donaghy [EMAIL PROTECTED] To: Ross Fujii [EMAIL PROTECTED] Subject: Re: Tomcat 4.0.2 - MySQL Connection Pooling Date: 25 Feb 2002 23:31:02 -0500 By any chance do you have your problem working yet? I think I've got a problem very similar to yours that I've spent quite a few hours on. Thanks! Michael On Fri, 2002-02-22 at 17:14, Ross Fujii wrote: Hello, I'm trying to setup JNDI connection pooling in Tomcat 4.0.2 to a MySQL (v3.23.49) database. I'm also running an Apache 1.3.20 AJP13 connector (using mod_jk) if that makes a difference all on a RedHat Linux 7.2 server. The following is a snippet of the JNDI resource creation in server.xml: Host name=www.abc.com debug=0 appBase=webapps/abc.com unpackWARs=true Context path=/test docBase=test debug=1 reloadable=true privileged=true Resource name=jdbc/TestDB auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/TestDB parameternameuser/namevalueroot/value/parameter parameternamepassword/namevalueaseraser/value/parameter parameter namedriverClassName/name valueorg.gjt.mm.mysql.Driver/value /parameter parameter namedriverName/name valuejdbc:mysql://localhost/menagerie/value /parameter /ResourceParams The following is the corresponding web.xml:resource-ref res-ref-namejdbc/TestDB/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth/resource-ref The sample code that I'm using in a servlet to grab the connection is the following://Get the pooled DB connectionContext initCtx = new InitialContext();Context envCtx = (Context)initCtx.lookup(java:comp/env);DataSource ds = (DataSource)envCtx.lookup(jdbc/TestDB); //Connect to the DB data source and run a query The exception that is being thrown is: javax.naming.NamingException: Cannot create resource instance I was wondering if there is somemthing that I'm still missing??? Some other notes: -- Have setup connection pooling to SQL 2000 DB on Windows 2000using Tomcat 4.0.2b1 with no problem. -- Have coded a stand-alone application that works and is ableto connect to MySQL and query the DB with no problems -- Have upgraded to the latest MySQL 2.0.11 driver Any help or advice would be greatly appreciated. Thanks in advance, --Ross -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Tomcat 4.0.2 - MySQL Connection Pooling
Hello, I'm trying to setup JNDI connection pooling in Tomcat 4.0.2 to a MySQL (v3.23.49) database. I'm also running an Apache 1.3.20 AJP13 connector (using mod_jk) if that makes a difference all on a RedHat Linux 7.2 server. The following is a snippet of the JNDI resource creation in server.xml: Host name=www.abc.com debug=0 appBase=webapps/abc.com unpackWARs=true Context path=/test docBase=test debug=1 reloadable=true privileged=true Resource name=jdbc/TestDB auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/TestDB parameternameuser/namevalueroot/value/parameter parameternamepassword/namevalueaseraser/value/parameter parameter namedriverClassName/name valueorg.gjt.mm.mysql.Driver/value /parameter parameter namedriverName/name valuejdbc:mysql://localhost/menagerie/value /parameter /ResourceParams The following is the corresponding web.xml: resource-ref res-ref-namejdbc/TestDB/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref The sample code that I'm using in a servlet to grab the connection is the following: //Get the pooled DB connection Context initCtx = new InitialContext(); Context envCtx = (Context)initCtx.lookup(java:comp/env); DataSource ds = (DataSource)envCtx.lookup(jdbc/TestDB); //Connect to the DB data source and run a query The exception that is being thrown is: javax.naming.NamingException: Cannot create resource instance I was wondering if there is somemthing that I'm still missing??? Some other notes: -- Have setup connection pooling to SQL 2000 DB on Windows 2000 using Tomcat 4.0.2b1 with no problem. -- Have coded a stand-alone application that works and is able to connect to MySQL and query the DB with no problems -- Have upgraded to the latest MySQL 2.0.11 driver Any help or advice would be greatly appreciated. Thanks in advance, --Ross _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Cannot connect Servlet/JSP running in Tomcat to MySQL Database
Is your Tomcat using the security manager?? That would explain the error
message. If so, you'll have to allow access to the datasource in
catalina.policy. Otherwise it should work.
--David
On Wednesday 05 December 2001 05:19 pm, you wrote:
Hi, I am unable to connect a servlet or jsp running in Tomcat to a MySQL
database. Here are the particulars:
Tomcat Version: 4.0.1
MySQL Version: 3.23.45
MySQL JDBC Driver Version: mm.mysql-2.0.4-bin.jar
Linux Version: Red Hat 7.1 running Kernel Version 2.4.2-2smp
Here is some sample code:
***
* ***
%@ page import=java.sql.* %
%! Connection c; %
% try {
Class.forName(org.gjt.mm.mysql.Driver).newInstance();
}
catch (Exception e) {}
try {
c =
DriverManager.getConnection(jdbc:mysql://localhost/PAARsnp?user=rootpassw
o rd=);
% Could do it! %
}
catch (Exception e) {
%
Can't do it!BR
%= e.getMessage() %
% } %
***
* ***
And the resultant output:
Can't do it!
Server configuration denies access to data source
***
* ***
I know for a fact that the connection string is correct. However, I do not
know where to go from here. I also know that I can successfully connect
to this database from a PHP script, just not from Java code running
within Tomcat.
Thanks in advance for any help
Matt Stine
Software Engineer
Hartwell Center for Bioinformatics and Biotechnology
St. Jude Children's Research Hospital
332 N. Lauderdale St.
Memphis, TN 38105-2794
Phone: 901.495.4602
Fax: 901.495.2945
[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
Cannot connect Servlet/JSP running in Tomcat to MySQL Database
Hi, I am unable to connect a servlet or jsp running in Tomcat to a MySQL
database. Here are the particulars:
Tomcat Version: 4.0.1
MySQL Version: 3.23.45
MySQL JDBC Driver Version: mm.mysql-2.0.4-bin.jar
Linux Version: Red Hat 7.1 running Kernel Version 2.4.2-2smp
Here is some sample code:
***
%@ page import=java.sql.* %
%! Connection c; %
% try {
Class.forName(org.gjt.mm.mysql.Driver).newInstance();
}
catch (Exception e) {}
try {
c =
DriverManager.getConnection(jdbc:mysql://localhost/PAARsnp?user=rootpasswo
rd=);
% Could do it! %
}
catch (Exception e) {
%
Can't do it!BR
%= e.getMessage() %
% } %
***
And the resultant output:
Can't do it!
Server configuration denies access to data source
***
I know for a fact that the connection string is correct. However, I do not
know where to go from here. I also know that I can successfully connect
to this database from a PHP script, just not from Java code running
within Tomcat.
Thanks in advance for any help
Matt Stine
Software Engineer
Hartwell Center for Bioinformatics and Biotechnology
St. Jude Children's Research Hospital
332 N. Lauderdale St.
Memphis, TN 38105-2794
Phone: 901.495.4602
Fax: 901.495.2945
[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Cannot connect Servlet/JSP running in Tomcat to MySQL Database
Try using the 2 argument DriverManager.getConnection method:
DriverManager.getConnection(String connectString, Properties
connectProperties);
Where:
connectString doesn't include the ?user=rootpassword=
connectProperties is a java.util.Properties with elements user and
password
Also, could there be a MySQL filter that denies access to the DB from
anything but PHP?
-August
--- Stine, Matt [EMAIL PROTECTED] wrote:
Hi, I am unable to connect a servlet or jsp running in Tomcat to a
MySQL
database. Here are the particulars:
Tomcat Version: 4.0.1
MySQL Version: 3.23.45
MySQL JDBC Driver Version: mm.mysql-2.0.4-bin.jar
Linux Version: Red Hat 7.1 running Kernel Version 2.4.2-2smp
Here is some sample code:
***
%@ page import=java.sql.* %
%! Connection c; %
% try {
Class.forName(org.gjt.mm.mysql.Driver).newInstance();
}
catch (Exception e) {}
try {
c =
DriverManager.getConnection(jdbc:mysql://localhost/PAARsnp?user=rootpasswo
rd=);
% Could do it! %
}
catch (Exception e) {
%
Can't do it!BR
%= e.getMessage() %
% } %
***
And the resultant output:
Can't do it!
Server configuration denies access to data source
***
I know for a fact that the connection string is correct. However, I
do not
know where to go from here. I also know that I can successfully
connect
to this database from a PHP script, just not from Java code running
within Tomcat.
Thanks in advance for any help
Matt Stine
Software Engineer
Hartwell Center for Bioinformatics and Biotechnology
St. Jude Children's Research Hospital
332 N. Lauderdale St.
Memphis, TN 38105-2794
Phone: 901.495.4602
Fax: 901.495.2945
[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Tomcat and MySQL
Any recommendations for JDBC connection pool software? I'd seen Turbine mentioned in this context, but couldn't figure out how to extract just that functionality from it. Any other recommended packages for a simple but robust pool? -- Gary Lawrence Murphy [EMAIL PROTECTED] TeleDynamics Communications Inc Business Innovations Through Open Source Systems: http://www.teledyn.com Computers are useless. They can only give you answers.(Pablo Picasso)
Re: Tomcat and MySQL
DbConnectionBroker available at www.javaexchange.com. I've also heard of Poolman, but have never used it myself. Thanks, --jeff - Original Message - From: Gary Lawrence Murphy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 1:24 PM Subject: Re: Tomcat and MySQL Any recommendations for JDBC connection pool software? I'd seen Turbine mentioned in this context, but couldn't figure out how to extract just that functionality from it. Any other recommended packages for a simple but robust pool? -- Gary Lawrence Murphy [EMAIL PROTECTED] TeleDynamics Communications Inc Business Innovations Through Open Source Systems: http://www.teledyn.com Computers are useless. They can only give you answers.(Pablo Picasso)
Re: Tomcat and MySQL
the Sun press Core Servlets books also has some good sample code, if you wanted to write your own connection pool class. - Original Message - From: Gary Lawrence Murphy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 1:24 PM Subject: Re: Tomcat and MySQL Any recommendations for JDBC connection pool software? I'd seen Turbine mentioned in this context, but couldn't figure out how to extract just that functionality from it. Any other recommended packages for a simple but robust pool? -- Gary Lawrence Murphy [EMAIL PROTECTED] TeleDynamics Communications Inc Business Innovations Through Open Source Systems: http://www.teledyn.com Computers are useless. They can only give you answers.(Pablo Picasso)
Re: Tomcat and MySQL
On Thu, 10 May 2001, Jeff Kilbride wrote: DbConnectionBroker available at www.javaexchange.com. I've also heard of Poolman, but have never used it myself. [...] Any recommendations for JDBC connection pool software? I'd seen Turbine mentioned in this context, but couldn't figure out how to extract just that functionality from it. Any other recommended packages for a simple but robust pool? There is one under Jakarta Commons. http://jakarta.apache.org/cvsweb/index.cgi/jakarta-commons/dbcp/ ..bip
Re: Tomcat and MySQL
B == Bip Thelin [EMAIL PROTECTED] writes: B There is one under Jakarta Commons. B http://jakarta.apache.org/cvsweb/index.cgi/jakarta-commons/dbcp/ I'd tried DbConnectionBroker and was reasonably satisfied, but the jakarta-commons project looks very interesting Thanks. -- Gary Lawrence Murphy [EMAIL PROTECTED] TeleDynamics Communications Inc Business Innovations Through Open Source Systems: http://www.teledyn.com Computers are useless. They can only give you answers.(Pablo Picasso)
Tomcat and MySQL
Hi to all! I use Tomcat together with mysql to store my data. I wrote an servlet at school that uses an Oracle Database to store and retrieve data. It worked fine. So I wanted to use this servlet at home too. I changed the JDBC driver but now i get in the tomcat.log file an exception. The source of the exception is, that i cn't connect to my database. in my tomcat.log - file i found this entry: 2001-04-30 10:50:05 - Ctx( /examples ): Exception in: R( /examples + /servlet/Navigation + null) - java.lang.NoClassDefFoundError: org/gjt/mm/mysql/Driver at JDBCAdapter.init(JDBCAdapter.java:48) at Navigation.doGet(Navigation.java:35) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404) at org.apache.tomcat.core.Handler.service(Handler.java:286) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79 7) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.connector.JNIConnectionHandler.processConnection(J NIConnectionHandler.java:167) at org.apache.tomcat.service.JNIEndpoint.service(JNIEndpoint.java:162) Before i had some other errors. I change the classpath that the mysql-jdbc driver is also in it. And now the error mentioned above occours. Is this a problem of my classpath and why does the exception writes: org/gjt/mm/my an not org.gjt.mm.my.? I know this is not a problem of tomcat, but I think many of you use the mysql database with java. Perhaps someone can help me. Thanks in advance, Robert
Re: Tomcat and MySQL
Hi, Try to put your mysql-comp.jar and mysql-uncomp.jar in the war/WEB-INF/lib of your app. It should do the trick. Benoît Hi to all! I use Tomcat together with mysql to store my data. I wrote an servlet at school that uses an Oracle Database to store and retrieve data. It worked fine. So I wanted to use this servlet at home too. I changed the JDBC driver but now i get in the tomcat.log file an exception. The source of the exception is, that i cn't connect to my database. in my tomcat.log - file i found this entry: 2001-04-30 10:50:05 - Ctx( /examples ): Exception in: R( /examples + /servlet/Navigation + null) - java.lang.NoClassDefFoundError: org/gjt/mm/mysql/Driver at JDBCAdapter.init(JDBCAdapter.java:48) at Navigation.doGet(Navigation.java:35) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404) at org.apache.tomcat.core.Handler.service(Handler.java:286) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:7 9 7) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.connector.JNIConnectionHandler.processConnection( J NIConnectionHandler.java:167) at org.apache.tomcat.service.JNIEndpoint.service(JNIEndpoint.java:162) Before i had some other errors. I change the classpath that the mysql-jdbc driver is also in it. And now the error mentioned above occours. Is this a problem of my classpath and why does the exception writes: org/gjt/mm/my an not org.gjt.mm.my.? I know this is not a problem of tomcat, but I think many of you use the mysql database with java. Perhaps someone can help me. Thanks in advance, Robert
Re: Tomcat and MySQL
I have MySQL working fine with the driver you mention below (version 2.0.4) by putting the library for it (the jar file) into the WEB-INF/lib directory, where it belongs. If it doesn't work for you there, you can try the $TOMCAT_HOME/lib directory. Some things (like JCE 1.2.1) only will work from there due to problems in tomcat. I use Tomcat 3.2.1. Doug At 04:54 AM 4/30/2001, Robert Wohlgemuth wrote: Hi to all! I use Tomcat together with mysql to store my data. I wrote an servlet at school that uses an Oracle Database to store and retrieve data. It worked fine. So I wanted to use this servlet at home too. I changed the JDBC driver but now i get in the tomcat.log file an exception. The source of the exception is, that i cn't connect to my database. in my tomcat.log - file i found this entry: 2001-04-30 10:50:05 - Ctx( /examples ): Exception in: R( /examples + /servlet/Navigation + null) - java.lang.NoClassDefFoundError: org/gjt/mm/mysql/Driver at JDBCAdapter.init(JDBCAdapter.java:48) at Navigation.doGet(Navigation.java:35) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404) at org.apache.tomcat.core.Handler.service(Handler.java:286) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79 7) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.connector.JNIConnectionHandler.processConnection(J NIConnectionHandler.java:167) at org.apache.tomcat.service.JNIEndpoint.service(JNIEndpoint.java:162) Before i had some other errors. I change the classpath that the mysql-jdbc driver is also in it. And now the error mentioned above occours. Is this a problem of my classpath and why does the exception writes: org/gjt/mm/my an not org.gjt.mm.my.? I know this is not a problem of tomcat, but I think many of you use the mysql database with java. Perhaps someone can help me. Thanks in advance, Robert
AW: Tomcat and MySQL
THIS WORKS NOW! Thanks a lot. I'm so fascinated about the great possibilities of servlets :) I've thousands of ideas to implement. -Ursprungliche Nachricht- Von: Doug Fields [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 30. April 2001 17:43 An: [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: Re: Tomcat and MySQL I have MySQL working fine with the driver you mention below (version 2.0.4) by putting the library for it (the jar file) into the WEB-INF/lib directory, where it belongs. If it doesn't work for you there, you can try the $TOMCAT_HOME/lib directory. Some things (like JCE 1.2.1) only will work from there due to problems in tomcat. I use Tomcat 3.2.1. Doug At 04:54 AM 4/30/2001, Robert Wohlgemuth wrote: Hi to all! I use Tomcat together with mysql to store my data. I wrote an servlet at school that uses an Oracle Database to store and retrieve data. It worked fine. So I wanted to use this servlet at home too. I changed the JDBC driver but now i get in the tomcat.log file an exception. The source of the exception is, that i cn't connect to my database. in my tomcat.log - file i found this entry: 2001-04-30 10:50:05 - Ctx( /examples ): Exception in: R( /examples + /servlet/Navigation + null) - java.lang.NoClassDefFoundError: org/gjt/mm/mysql/Driver at JDBCAdapter.init(JDBCAdapter.java:48) at Navigation.doGet(Navigation.java:35) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404) at org.apache.tomcat.core.Handler.service(Handler.java:286) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:7 9 7) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.connector.JNIConnectionHandler.processConnection( J NIConnectionHandler.java:167) at org.apache.tomcat.service.JNIEndpoint.service(JNIEndpoint.java:162) Before i had some other errors. I change the classpath that the mysql-jdbc driver is also in it. And now the error mentioned above occours. Is this a problem of my classpath and why does the exception writes: org/gjt/mm/my an not org.gjt.mm.my.? I know this is not a problem of tomcat, but I think many of you use the mysql database with java. Perhaps someone can help me. Thanks in advance, Robert
Tomcat and mySQL
Hi! I'm using JDBCRealm authorisation. How can I force mySQL not to close the connection Tomcat opened upon startup (to database where users, roles, user_roles tables are stored)? i assume mySQL's variable wait_timeout is responsible for closing inactive connections. the default is 28800 secs, will changing it to zero do the trick? or else? anyone? regards, vVolf - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
RE: Tomcat and mySQL
Add ;autoreconnect=true to the db connect string. -Original Message- From: Herchel Wojciech [mailto:[EMAIL PROTECTED]] Sent: den 28 februari 2001 17:32 To: 'Tomcat' Subject: Tomcat and mySQL Hi! I'm using JDBCRealm authorisation. How can I force mySQL not to close the connection Tomcat opened upon startup (to database where users, roles, user_roles tables are stored)? i assume mySQL's variable wait_timeout is responsible for closing inactive connections. the default is 28800 secs, will changing it to zero do the trick? or else? anyone? regards, vVolf - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
ODP: Tomcat and mySQL
ok, i've checked tomcat logs - it tries to reconnect, but then it reports: There was a SQLException: Invalid authorization specification: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) why does tomcat log as 'nobody'? although in server.xml there is a different connectionUser specified. how can i make it to use original connection user and passwd? vVolf -Oryginalna wiadomo- Od: Cato, Christopher [mailto:[EMAIL PROTECTED]] Wysano: 28 lutego 2001 17:56 Do: '[EMAIL PROTECTED]' Temat: RE: Tomcat and mySQL Add ;autoreconnect=true to the db connect string. -Original Message- From: Herchel Wojciech [mailto:[EMAIL PROTECTED]] Sent: den 28 februari 2001 17:32 To: 'Tomcat' Subject: Tomcat and mySQL Hi! I'm using JDBCRealm authorisation. How can I force mySQL not to close the connection Tomcat opened upon startup (to database where users, roles, user_roles tables are stored)? i assume mySQL's variable wait_timeout is responsible for closing inactive connections. the default is 28800 secs, will changing it to zero do the trick? or else? anyone? regards, vVolf - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
ODP: Tomcat and mySQL
ok, now i know what's happening, looking at the process list i can see that upon startup tomcat logs as specified by connectionUser/Password strings from server.xml files. but then for no apparent reason it tries to reconnect as nobody without providing passwd. how can i fix that? vVolf -Oryginalna wiadomo- Od: Cato, Christopher [mailto:[EMAIL PROTECTED]] Wysano: 28 lutego 2001 17:56 Do: '[EMAIL PROTECTED]' Temat: RE: Tomcat and mySQL Add ;autoreconnect=true to the db connect string. -Original Message- From: Herchel Wojciech [mailto:[EMAIL PROTECTED]] Sent: den 28 februari 2001 17:32 To: 'Tomcat' Subject: Tomcat and mySQL Hi! I'm using JDBCRealm authorisation. How can I force mySQL not to close the connection Tomcat opened upon startup (to database where users, roles, user_roles tables are stored)? i assume mySQL's variable wait_timeout is responsible for closing inactive connections. the default is 28800 secs, will changing it to zero do the trick? or else? anyone? regards, vVolf - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
Linux/Apache/Tomcat/JDBC/MySQL, was: RE: Tomcat and jdk
jdk1.2 I'm currently using the IBM JDK 1.1.8 since both JDBC thingies I have don't work under Sun's JDK 1.2.2... Which leads to to YAQ: does anybody have JDBC for MySQL that works under JDK1.2 or greater? I don't have the time to do a JDBC right now! ;) Dave
Re: Linux/Apache/Tomcat/JDBC/MySQL, was: RE: Tomcat and jdk
Try http://www.mysql.com/downloads/api-jdbc.html to get mm MySql driver (type 4). I'm using jdk1.3 and seems to work OK (so far!) Andrew PS you probably shouldn't be posting to this list unless tomcat specific ;-) On Thu, 14 Dec 2000, you wrote: jdk1.2 I'm currently using the IBM JDK 1.1.8 since both JDBC thingies I have don't work under Sun's JDK 1.2.2... Which leads to to YAQ: does anybody have JDBC for MySQL that works under JDK1.2 or greater? I don't have the time to do a JDBC right now! ;) Dave
