[Libreoffice-bugs] [Bug 48886] New: : MySQL Database Connection Failure with Base

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=48886

             Bug #: 48886
           Summary: : MySQL Database Connection Failure with Base
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.3.0 release
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
 Status Whiteboard: BSA
          Severity: normal
          Priority: medium
         Component: Writer
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: jive.email at gmail.com


Problem description: 

Submitted as OpenOffice Bug 119242.

A similar problem occurs with LibreOffice.

Can't seem to connect to a MySQL database in Base (in OS X Lion.)

The "Database properties - Additional Settings" dialog "Socket" field is a bare
text box that is missing a filesystem browser button to select a socket file,
i.e. "/usr/local/zend/mysql/tmp/mysql_sock". This field is not even available
using the initial database connection wizard pages; I went in and found it
after trying to create a connection using a MYSQL (JDBC) connection with File /
New / Database and having it fail (after a long time looking at the spinning
beach ball), then going in to the connection properties after Base loaded and
choosing MySQL (Native) from Edit / Database / Connection Type.

Then, the "Finish" button never became available. 

I was able to get the "Finish" button to become active a second time through
Edit / Database / Connection Type (don't see why...), but then in trying to
select Tables on the left in Base, got a dialog with the following error:

"The connection to the data source "xxxxxxxxx" could not be established. The
connection to the external data source could not be established. No SDBC driver
was found for the given URL."

This error also occurs when trying to connection via the port vs. the socket.

I am able to make this connection via a mysql prompt in Terminal, and through
phpMyAdmin - tested at the same time / after the OpenOffice connection error.

Steps to reproduce:
1. File / New / Database - no MySQL (Native) option
2. Edit / Database / Connection Type = MySQL (Native) - no Finish button
3. Edit / Database / Connection Type = MySQL (Native) - click Finish button
4. Click Tables on left - observe error dialog per above.

Current behavior:
Eventual failure with SDBC driver error.

Expected behavior:
Be offered the option to select a socket file, and create a database
connection.

Platform (if different from the browser): 

Mac OS X Lion 10.7.3 (11D50d)

The version text in the OpenOffice / About menu is not selectable to be copied,
but it says:
OpenOffice.org 3.3.0
OOO330m20 (Build: 9567)

Safari Version 5.2 (7535.18.5)

Browser: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_3) AppleWebKit/535.18.5
(KHTML, like Gecko) Version/5.2 Safari/535.18.5

I tried to search for existing bugs, but couldn't see a way to on the web page
I was offered.

Also, the Browse button on the bug submission page doesn't work - it may be
Ghostery in Safari on OS X Lion.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.