[DOCS-9245] Documentation for BI-539: support sockets on unix systems Created: 31/Oct/16  Updated: 30/Nov/17  Resolved: 18/Nov/16

Status: Closed
Project: Documentation
Component/s: BI Connector
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Minor - P4
Reporter: Emily Hall Assignee: Andrew Aldridge
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Documented
Participants:
Days since reply: 7 years, 12 weeks, 5 days ago
Story Points: 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"



 Comments   
Comment by Githook User [ 18/Nov/16 ]

Author:

{u'username': u'i80and', u'name': u'Andrew Aldridge', u'email': u'i80and@foxquill.com'}

Message: DOCS-9245: Clarify socket path
Branch: sqlproxy
https://github.com/mongodb/docs/commit/189b244ad402cfde77a6b38117b1301d88ec05af

Comment by Jeffrey Yemin [ 16/Nov/16 ]

Already documented here: https://docs-mongodbcom-staging.corp.mongodb.com/bi-connector/andrew/sqlproxy/reference/mongosqld.html#socket-options.

But should mention that the socket name is mysql.sock.

Generated at Thu Feb 08 07:57:54 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.