Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MySQL: connection error?

Posted on 2011-02-14
6
Medium Priority
?
364 Views
Last Modified: 2012-06-22
Hi experts,

My jsp code worked quite well before yesterday.  Yesterday I modified the ip address to point to a new MySQL. I got an error of

[Mon Feb 14 08:07:05 2011] System: Connection reset by peer (errno: 104)
[Mon Feb 14 08:07:10 2011] mod_ssl: SSL handshake interrupted by system [Hint: Stop button pressed in browser?!] (System error follows)


I did not click any stop button.

I could telnet from this platform to the new MySQL with the correct port number. And my another jsp file works well with this new MySQL. Why does this jsp file not?

Any ideas?

Thanks.
Old code that worked well:

table.dbURL = "jdbc:mysql://1.3.9.14:3306/reporting";

New code:

table.dbURL = "jdbc:mysql://1.3.9.230:3306/reporting";

I did not touch anything else. I just changed this ip address to point to the new MySQL.

Open in new window

0
Comment
Question by:davidw88
  • 3
6 Comments
 

Author Comment

by:davidw88
ID: 34888645
Thanks slightwv. I did look for "MySQL Server" however I could not find it.
0
 

Author Comment

by:davidw88
ID: 34889587
Experts, please help....

Any ideas or suggestions?

Thanks so much.
0
 
LVL 43

Assisted Solution

by:Rob
Rob earned 200 total points
ID: 34894323
Surely it will be to do with the new server configuration. What is different between the old and new servers? Are they running the same os, same apache version, mysql version etc?
0
 
LVL 83

Accepted Solution

by:
leakim971 earned 800 total points
ID: 34903385
Did you restarted your app server ?
0
 

Author Comment

by:davidw88
ID: 34911071
Thanks experts for your replies. Appreciated.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question