Server Upgradation Problem...

Hello.

I am Pankaj Patel. I am facing problem and cannot find the solution so i need help from the group. My problem is given in detail below.

--

The problem i am facing is because of Server Upgradation. We were working on tomcat older version and jdk 1.4. Now we had upgraded our server to tomcat 5.5.17 and jdk 1.5 and mysql 5.

Now we had developed lots of sites based on the previous server. Now all the sites are not working properly. I am giving the few error which i am facing. With the URL.

WAITING FOR YOUR KIND RESPONSE. THANKS.

--

URL : http://www.kalptaruinfosoft.com/client/-

ERROR:

[code]HTTP Status 500 -

--

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Exception in JSP: /include/connection.jsp:2

1: <%@page import="java.io.*"%>

2: <%@page import="java.util.*"%>

3: <%@page import="java.net.*"%>

4: <%@page import="javazoom.upload.*"%>

5: <%@include file="/include/connection.jsp"%>

Stacktrace:

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

javax.servlet.ServletException: Access denied for user 'klptr'@'x68.rapidns.com' (using password: YES)

org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)

org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)

org.apache.jsp.client.index_jsp._jspService(index_jsp.java:192)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.sql.SQLException: Access denied for user 'klptr'@'x68.rapidns.com' (using password: YES)

com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)

com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771)

com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3649)

com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1176)

com.mysql.jdbc.Connection.createNewIO(Connection.java:2558)

com.mysql.jdbc.Connection.<init>(Connection.java:1485)

com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)

java.sql.DriverManager.getConnection(DriverManager.java:525)

java.sql.DriverManager.getConnection(DriverManager.java:171)

org.apache.jsp.client.index_jsp._jspService(index_jsp.java:76)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs.

--

Apache Tomcat/5.5.17

[3853 byte] By [Pankaj.Javaa] at [2007-11-26 14:24:01]
# 1
You are using wrong Username and Password for Mysql Database.Try to connect using this username and passwordin Mysql front...
Neon_Andersona at 2007-7-8 2:16:33 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2

Thanks For Trying to resolve the problem. Actually here the username and password are right.

But this problem occurs becos we had moved our server. I mean from one ip to another ip. Now i had complied all the classes using the latest version supported by the server.

I think there is a problem of Protocol Version.

Thanks.

Pankaj.Javaa at 2007-7-8 2:16:33 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3

This is MySQL, isn't it? And the MySQL security configuration allows you to configure what users can connect from what computers. Evidently somebody configured it so user 'klptr' could connect from the old location, but didn't update its security configuration so that user could connect from the new location.

Not a Java problem. Not a network problem. Not a MySQL problem. You just need to update the MySQL security configuration.

DrClapa at 2007-7-8 2:16:33 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 4
Thanks. I got the Solution.Enjoy the World Of Programming...
Pankaj.Javaa at 2007-7-8 2:16:33 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...