Hi, It's your mysql listening on Localhost? Have you tried to use the ip address instead of Localhost?
Best, Toni -----Original Message----- From: Krapacs Ambrose [mailto:[EMAIL PROTECTED] Sent: martes, 18 de noviembre de 2008 13:22 To: users@tomcat.apache.org Subject: Servlets / JSP can't connect to MySQL in Ubuntu Server I have tried many different configurations and I have been unable to get my Servlets / JSP to connect to MySQL server running. I am trying to get this set up on my main server which is running Ubuntu 8.10 Server with MySQL 5 and Tomcat6. I also tried setting up a Ubuntu 8.04 server with Tomcat 5.5 and MySQL 5. I have even configured Tomcat running on the 8.10 server to try to connect to MySQL running on the 8.04 server. Still no luck! The exception that is thrown is here: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago.(jdbc:mysql://localhost? user=invuser&password=admin)) org .apache .jasper .runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852) org.apache.jasper.runtime.PageContextImpl.access $1100(PageContextImpl.java:71) org.apache.jasper.runtime.PageContextImpl$12.run(PageContextImpl.java: 768) java.security.AccessController.doPrivileged(Native Method) org .apache .jasper .runtime.PageContextImpl.handlePageException(PageContextImpl.java:766) org.apache.jsp.install_jsp._jspService(install_jsp.java:141) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org .apache .jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java: 342) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun .reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 57) sun .reflect .DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 43) java.lang.reflect.Method.invoke(Method.java:616) org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:244) java.security.AccessController.doPrivileged(Native Method) javax.security.auth.Subject.doAsPrivileged(Subject.java:537) org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java: 276) org .apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java: 162) I have verified that MySQL is running and everything with Tomcat seems to be configured correctly because I can execute servlets and JSP just fine it's just the connections to MySql to that fail. I have also executed a standalone java application using the MySQL Connector/J and that worked fine. I've even tried different ways of deploying the MySql Connector/J (which is the newest version available) to see if it was a permissions problem with the library. The key to this is that the web applications that I am trying to deploy run flawlessly on my Mac OS X development machine with MySQL. I haven't tried Windows yet but if I can get this set up to host my web application I may have to set up a Windows machine to try it. --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
