Issue 20239 - Mysql database accces
Summary: Mysql database accces
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC5
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-09-27 17:20 UTC by johnprice
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description johnprice 2003-09-27 17:20:36 UTC 
In the 1.1 RC and RC5 I have had been unsuccessful in connecting to MySql.
I have tried both the ODBC with MySql ODBC 3.51 Driver and JDBC with
MySql-connector-java-3.0.8 stable and 3.1.0 alpha. The same set up in OOo1.0.3
works every time. The message I get is "Unable to connect....". I have tried to
reinstall 1.1RC5; uninstall 1.0.3 all to no avail. The MySql is active and
accessible in MySql Control Center. The sample Bibliography and MS Access
connections seem to work fine. It seemed to me when I first installed RC5 it
worked for a while, but now won't work at all.

Windows XP, OOo1.1RC and RC5

John Price johnprice@earthlink.net
Comment 1 Frank Schönheit 2003-09-29 08:35:38 UTC 
correcting sub component (see
http://www.openoffice.org/issues/describecomponents.cgi?component=Database%20access,
please), and default owner
Comment 2 johnprice 2003-10-04 16:53:55 UTC 
I believe I solved this problem. I run Zone Alarm firewall and it was
not recognizing that OOo 1.1.0 had clearance to access the internet.
Once I corrected this, OOo seems to be now running properly. Of course
it is not really going to the internet, but using a port for MySql
access. I don't remember if I had to make the same change for OOo
1.0.3 or not. Perhaps, something in the docs to remind people to make
sure firewalls aren't blocking access in this case.

Thanks,

johnprice@earthlink.net
Comment 3 Frank Schönheit 2003-10-06 07:51:15 UTC 
John, could you (as the reporter) please resolve and close this issue
then? Thanks.
Comment 4 marc.neumann 2003-10-06 08:16:51 UTC 
I close the issue as invalid.
Comment 5 marc.neumann 2003-10-06 08:17:03 UTC 
close
Comment 6 hans_werner67 2004-02-02 12:31:51 UTC 
change subcomponent to 'none'