Issue 116286 - Browse for MySQL direct connection socket
Summary: Browse for MySQL direct connection socket
Status: ACCEPTED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.2.1
Hardware: PC (x86_64) Linux, all
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on: 121053
Blocks:
  Show dependency tree
 
Reported: 2011-01-03 11:00 UTC by yecril71pl
Modified: 2017-05-20 11:33 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description yecril71pl 2011-01-03 11:00:10 UTC
The field specifying the connection socket in MySQL connection wizard (direct)
should be a file selector field, not a text field.  It should allow browsing for
the local MySQL socket.  The socket path should be preset to /var/run/mysql.
Comment 1 yecril71pl 2011-01-03 15:50:53 UTC
Actually, /var/run/mysql/mysql.sock.  
Comment 2 r4zoli 2012-09-09 06:12:21 UTC
Change component to none, it is Base UI enhancement not a native connector bug.
Comment 3 Ariel Constenla-Haile 2012-09-09 19:57:04 UTC
(In reply to comment #1)
> Actually, /var/run/mysql/mysql.sock

In what system is that the default location?

I think we should collect most common default locations, check which one exists, and offer this one as default.

On Fedora it is /var/lib/mysql/mysql.sock but it can be modified in /etc/my.cnf under [mysqld] with socket=SOCKET_FILE

On MacOS X it can be /var/mysql/mysql.sock or /tmp/mysql.sock according to http://dev.mysql.com/doc/refman/5.5/en/macosx-installation-notes.html

An array could contain:

/var/lib/mysql/mysql.sock
/var/run/mysql/mysql.sock
/var/mysql/mysql.sock
/tmp/mysql.sock
Comment 4 yecril71pl 2012-09-10 19:32:13 UTC
(In reply to comment #3)
> (In reply to comment #1)
> > Actually, /var/run/mysql/mysql.sock
> 
> In what system is that the default location?

openSUSE here
Comment 5 Ariel Constenla-Haile 2012-09-19 19:57:21 UTC
I'm afraid there is a bug in the office code that doesn't allow to select a socket with the office dialog (the Gtk file dialog works fine).

See attachment 79574 [details]
The macro in attachment 79575 [details] shows the logic that should be user in this bug for MySQL server socket selection.
Comment 6 Marcus 2017-05-20 11:33:15 UTC
Reset assigne to the default "issues@openoffice.apache.org".