Solved

MySQL: problem when connecting some hosts

Posted on 2014-09-12
2
386 Views
Last Modified: 2014-09-13
I have a problem with connecting mysql on our main db server with other hosts we run.

NOTE: The problem does appear now while we have had to migrate our networks and IP addresses, presumably caused (or evidenced) by this migration.

Migration context: most of our machines have been migrated to (ip.1 on eth0) to (ip.2 on eth0, ip.1 on eth0:0)
This seems to have gone OK, but now I must remove the eth0:0, and some problem do appear. Most presumably some problems of the db machine being aware of its 2 IPs, and allowing connection from the outside only on its old eth0:0
Error message 1:
The mysqli error was: Can't connect to MySQL server on 'xxx.fr' (110).

Open in new window

Error message 2:
#2003 - Can't connect to MySQL server on 'xxx.fr' (110)

Open in new window


- I have disabled IPTables filtering and denyhosts
- I have commented the line bind-address      in my.cnf
- etc

All suggestions and ideas are welcome.
How can I find or trace the blocked incoming connexions? nothing appears  in the usual logs..
0
Comment
Question by:fibo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 29

Accepted Solution

by:
fibo earned 0 total points
ID: 40320610
Found the problem: /etc/hosts/ both on the db machine and on the other sites were outdated and pointed to old addresses... which I had not removed at the same time.
0
 
LVL 29

Author Closing Comment

by:fibo
ID: 40320611
Having all network addresses change at the same time is really a nightmare!
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

734 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