Solved

MySQL: problem when connecting some hosts

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

860 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