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

Many CONNECT table types do not work if server uses skip-networking or bind-address

    XMLWordPrintable

Details

    Description

      CONNECT table types that use PROXY do not work if the server is running with skip-networking or bind-address set to something other than the loopback interface.

      With bind-address set (to something other than 127.0.0.1):

      mysql 10.0.10-MariaDB (root) [test]> select * from fruit_pivot;
      ERROR 1296 (HY000): Got error 174 '(2003) Can't connect to MySQL server on 'localhost' (61 "Connection refused")' from CONNECT

      With skip-networking:

      mysql 10.0.10-MariaDB (root) [test]> select * from fruit_pivot;
      ERROR 1296 (HY000): Got error 174 '(2003) Can't connect to MySQL server on 'localhost' (49 "Can't assign requested address")' from CONNECT

      It would be neat if the CONNECT engine tried by default to connect using the socket file. It would also be good if there was some way to specify an IP to use, I guess, in the case that the server is running with bind-address set.

      Attachments

        Activity

          People

            bertrandop Olivier Bertrand
            kolbe Kolbe Kegel (Inactive)
            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.