incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 119242] New: MySQL Database Connection Failure in Base
Date Wed, 18 Apr 2012 16:07:59 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=119242

             Bug #: 119242
        Issue Type: DEFECT
           Summary: MySQL Database Connection Failure in Base
    Classification: Application
           Product: Database access
           Version: OOo 3.3
          Platform: Macintosh
        OS/Version: Mac OS X
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: MySQL Connector/OOo
        AssignedTo: needsconfirm@dba.openoffice.org
        ReportedBy: jive.email@gmail.com
                CC: ooo-issues@incubator.apache.org


Problem description: 

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). Edit / Database / Connection Type makes the dialog
attached available.

Then, the "Finish" button never became available. 

Please see attached screenshot.

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

-- 
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

Mime
View raw message