Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21355

10.4.11 cannot lookup "localhost" in DNS

    XMLWordPrintable

Details

    Description

      Hi,

      I installed MariaDB 10.4.11 on a Windows server.

      Everything seems to work fine with my PHP apps but unfortunately I am unable to connect to the DB server via the 'mysql' command or from SQLYog.

      E:\MariaDB 10.4\bin>mysql -uuser -ppass ERROR 1042 (HY000): Can't get hostname for your address

      E:\MariaDB 10.4\bin>mysql -uuser -ppass Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 63 Server version: 10.4.11-MariaDB mariadb.org binary distribution

      I tried it about 20 times and 50% of the time it "Can't get hostname for my address"

      When I am able to connect in show processlist it looks like the hostname is:

      localhost

      I am able to connect consistently to the MySQL 5.5 instance that is installed on this machine from both the mysql command line tool as well as SQLYOG

      Here is what the server logs when it fails to look up the DNS (for some reason):

      Aborted connection 15 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (This connection closed normally without authentication

      This seems like a bug because it should either always fail or always work. Why would it be able to "sometimes" lookup "localhost" and othertimes not be able to?

      Attachments

        Activity

          People

            Unassigned Unassigned
            ZCT Drew W
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.