Solved

MySQL: problem when connecting some hosts

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
PHP: Insert Data into MySQL 5 41
how to install java on RHEL image on EC2 4 28
LINUX backups with VEEAM 8 83
Mysql Left Join Case 10 56
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
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…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

803 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