Issue 116286

Summary:	Browse for MySQL direct connection socket
Product:	Base	Reporter:	Christopher Yeleighton <giecrilj>
Component:	code	Assignee:	AOO issues mailing list <issues>
Status:	ACCEPTED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	arielch, issues, r4zoli
Version:	OOo 3.2.1
Target Milestone:	---
Hardware:	PC (x86_64)
OS:	Linux, all
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---
Issue Depends on:	121053
Issue Blocks:

Description Christopher Yeleighton 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 Christopher Yeleighton 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 Christopher Yeleighton 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".