Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-9245

Documentation for BI-539: support sockets on unix systems

    XMLWordPrintableJSON

Details

    • Icon: Task Task
    • Resolution: Done
    • Icon: Minor - P4 Minor - P4
    • None
    • None
    • BI Connector
    • None
    • 0.5

    Description

      Documentation Changes

      Check that the documentation mentions the following if necessary:

      • mysql.sock
      • localhost special behavior
      Description

      Engineering Ticket Description:

      On Unix, MySQL programs treat the host name, localhost specially, in a way that is likely different from what you expect compared to other network-based programs. For connections to localhost, MySQL programs attempt to connect to the local server by using a Unix socket file. This occurs even if a --port or -P option is given to specify a port number. To ensure that our clients have a seamless experience, we should support unix sockets when possible.

      This will also be helpful for clients connecting with BI tools such as Tableau. See http://dev.mysql.com/doc/refman/5.5/en/connecting.html for more

      See also https://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_socket

      Help text:

      Socket options:
            --filePermissions=                      permissions to set on UNIX domain socket file (default to 0700) (default: 0700)
            --noUnixSocket                          disable listening on UNIX domain sockets
            --unixSocketPrefix=                     alternative directory for UNIX domain sockets (default to /tmp) (default: /tmp)
      

      Note that the socket name is always "mysql.sock", so by default the full path to the socket is "/tmp/mysql.sock"

      Attachments

        Activity

          People

            andrew.aldridge@mongodb.com Andrew Aldridge
            emily.hall Emily Hall
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              7 years, 12 weeks, 5 days ago