0

I've searched for this issue but couldn't get any solution working from the client side.

We've mysql server with Apache on Ubuntu.

Our client (MacOS) is getting "can't get hostname for your address" error when connecting to our database. He is able to connect without any problems from Home network but not from his work network.

None of our other clients face this issue so I guess there is no problem on server side. Solutions like editing my.ini or my.cnf is not what we're looking for as server side changes are not encouraged. Any help towards solving this problem will be appreciated.

Server: mysql (Apache,Ubuntu)
Client: macOS

Error

Improve this question
3
  • I did not understand well which of your clients can connect and which cannot. Are you saying that MacOS clients cannot connect while other (e.g. Windows, Linux) clients can or do you see the majority of your MacOS clients being able to connect and just one specific one cannot?
    – TorstenS
    Commented Apr 4, 2019 at 9:09
  • @TorstenS Just one MacOS client.
    – Axel
    Commented Apr 4, 2019 at 9:20
  • is your client able to resolve hostname or is the client able to access db with the ip ? can he ping the hostname or ip ? can he telnet mysql port from work network ?
    – errorfetch
    Commented Apr 4, 2019 at 11:43

2 Answers 2

Reset to default
1

When you say the client in question

is able to connect without any problems from Home network but not from his work network

then I assume it will get assigned a different IP address when connected to the office network versus when connected via VPN from home.

Getting a hostname for an address is nothing but reverse DNS, i.e. first of all, find out which IP address the machine is assigned in the office network and in the home network, see: https://apple.stackexchange.com/questions/20547/how-do-i-find-my-ip-address-from-the-command-line.

Then try an

nslookup

using either address and check if a hostname is being reported or not. I'd bet in case of the office network, it will come back with NXDOMAIN.

Then the next question is why. That means you will have to check how IP is resolved to names on your network. This can either be a local hosts file or some DHCP/DNS server on your network which doesn't know the name for an IP it's given out.

Improve this answer
3
  • Just to be on the same point, I'm repeating what I understood from your answer: Client is making a connection to mysql server from a different IP for which there is no reverse DNS record on the server. But the client will be making connection from dynamic IP, so how can we make a DNS entry for every IP?
    – Axel
    Commented Apr 4, 2019 at 10:59
  • Are we talking about internal or public IP addresses? I mean, when connecting from home, is that a VPN or is the MySQL server publicly available over the Internet?
    – TorstenS
    Commented Apr 4, 2019 at 12:08
  • MySQL server is publicly available over the Internet.
    – Axel
    Commented Apr 4, 2019 at 12:26
0

In my case, I try everything available on the Internet but nothing works for me. So I try to solve this problem by changing the name of the computer (B2 to BBB), which changes the numeric value from the Hostname of a computer and finally my problem is solved.

Improve this answer
1
  • Thanks for participating in the site! Welcome to Serverfault, Happy New Year!
    – Citizen
    Commented Dec 31, 2019 at 18:21

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .