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

MariaDB will not bind to "localhost" if localhost is both IPv4/IPv6 enabled

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.1, 5.5.30
    • 5.5.31
    • None
    • None
    • Linux 2.6, with "localhost" being defined as both 127.0.0.1 and ::1

    Description

      If a host is configured with both an IPv6 and an IPv4 address, MariaDB will not start up. This was reported against mysql in http://bugs.mysql.com/bug.php?id=61713, and was later fixed. This fix is not in MariaDB.

      I would also note that the mysql folks fixed it incorrectly. Please see http://bugs.mysql.com/bug.php?id=65122 for the follow up.

      We are looking at migrating from MySQL to using MariaDB, but this inability to properly support IPv6 means that migration is a no-starter. I am astonished that since this was already at least partially fixed in MySQL it is not already in MariaDB.

      zimbra@zre-ldap003:~$ cat /etc/hosts
      127.0.0.1       localhost
      10.137.242.53   zre-ldap003.eng.vmware.com      zre-ldap003
       
      # The following lines are desirable for IPv6 capable hosts
      ::1     localhost ip6-localhost ip6-loopback
      fc00:10:137:242::53     zre-ldap003.eng.vmware.com      zre-ldap003
      fe00::0 ip6-localnet
      ff00::0 ip6-mcastprefix
      ff02::1 ip6-allnodes
      ff02::2 ip6-allrouters
       
      130402 16:51:24 mysqld_safe mysqld from pid file /opt/zimbra/db/mysql.pid ended
      130402 16:56:53 mysqld_safe Starting mysqld daemon with databases from /opt/zimbra/db/data
      130402 16:56:53 [ERROR] Can't start server: bind-address refers to multiple interfaces!
      130402 16:56:53 [ERROR] Aborting

      Attachments

        Activity

          People

            wlad Vladislav Vaintroub
            quanah Quanah Gibson-Mount (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 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.