Solved

MySQL: problem when connecting some hosts

Posted on 2014-09-12
2
391 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

Webinar: MongoDB® Index Types

Join Percona’s Senior Technical Services Engineer, Adamo Tonete as he presents “MongoDB Index Types, How, When and Where Should They be Used?” on Wednesday, July 12, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7).

Question has a verified solution.

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

The purpose of this article is to demonstrate how we can use conditional statements using Python.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…

719 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