Bug 144602

Summary:	OpenSuSE 10.1 Beta 1 - OpenOffice -2.0 – Database Can Not Connect to a MySQL due to missing files
Product:	[openSUSE] openSUSE 11.0	Reporter:	S3WL S#WL <s3wl201672>
Component:	OpenOffice.org	Assignee:	Ales Nosek <anosek>
Status:	RESOLVED FIXED	QA Contact:	E-mail List <qa-bugs>
Severity:	Normal
Priority:	P5 - None	CC:	m.schiedel, mmarek, pmladek
Version:	Alpha 1
Target Milestone:	---
Hardware:	32bit
OS:	Other
Whiteboard:
Found By:	Other	Services Priority:
Business Priority:		Blocker:	---
Marketing QA Status:	---	IT Deployment:	---

Description S3WL S#WL 2006-01-21 13:30:05 UTC

OpenSuSE 10.1 Beta 1 - OpenOffice -2.0 – Database Can Not Connect to a MySQL due to missing files.

For OpenOffice connected to MySQL by ODBC
As I understand it OpenOffice and MySQL require
mysqlconnector-odbc
libmysql12-4.0.20
libmysql14-4.1.5
libmysql14-devel-4.1.5

For OpenOffice connected to MySQL by JDBC
As I understand it Java runtime environment is required.

For OpenOffice connected to Oracle and PostgreSQL and other types a connector of some sort is most likely required but I no experience with other types of databases so I can not comment.

Unfortunately I am not a knowledgeable database connection type so what is required to make connections between OpenOffice and the various databases could be a different from what is noted above.

I have found by past attempts to make OpenOffice to MySQL connections that  ascertaining which files are required is not a simple matter as there is a good deal of confusion as to which file is which due to some required files being renamed et. These are both MySQL files and MySQL Connector files.

Comment 1 Petr Mladek 2006-01-23 09:08:34 UTC

OK, I'll look at it. I think that it is a candidate for the weak (optional) dependencies that should be supported by YaST now.

Comment 2 Ihno Krumreich 2006-04-24 12:21:28 UTC

Status of the bug?

Comment 3 Petr Mladek 2006-04-24 18:04:09 UTC

I could add the necessary requires if anyone provides the list. I am sorry I do not have time to play with it and generate the list myself now.

Comment 4 Petr Mladek 2006-06-07 10:36:58 UTC

I though about it a bit more. Well, OOo access most of the databases via the ODBC or JDBC driver. The soft dependencies to the real databases should be included in the unixODBC and java-*-jdbc packages rather than in OOo.

What do you think?

Comment 5 Michal Marek 2006-06-07 10:59:07 UTC

> The soft dependencies to the real databases should be
> included in the unixODBC and java-*-jdbc packages rather than in OOo.

That way, unixODBC would pull both mysql and postgresql (and maybe some more)
libraries when installed. Do we want this?

Or the ODBC drivers could provide some symbol, say odbc_driver,
and unixODBC would suggest it.

The first option means even more bloated default install, the second option
means asking the (unexperienced) user to select an ODBC something when he just
wants to install openoffice.

Suggestions? :-)

Comment 6 Petr Mladek 2006-06-07 11:49:09 UTC

We could use the weak dependency "Suggests". It would not install anything by default. It should just suggest to install some stuff in a popup or so. See also http://svn.suse.de/trac/zypp/wiki/Dependencies.

I think that unixODBC should suggest installation of all the available odbc drivers.

Comment 7 Michal Marek 2006-06-07 12:38:08 UTC

Ok, if Suggests: doesn't really do anything right now, then I can safely add it :)

Comment 8 Michael Meeks 2006-08-15 10:46:43 UTC

did this get fixed ? can we close it ?

Comment 9 Michal Marek 2006-08-15 12:16:08 UTC

(In reply to comment #8)
> did this get fixed ? can we close it ?

No. I asked on opensuse-packaging
<http://lists.opensuse.org/opensuse-packaging/2006-06/msg00011.html> and
was told that it would be possible to use something like

    Supplements(and): unixODBC mysql-shared

in the future. So let's wait for an rpm with this feature.

Comment 10 Michal Marek 2006-08-16 07:17:22 UTC

PS: feel free to reassing / change the product field, as this is more an
unixODBC problem than an OOo one. OOo just needs to depend on the unixODBC libs.

Comment 11 Petr Mladek 2006-08-16 09:19:26 UTC

OK, I reassign the bug to mmarek and change the product to SLED10.

Comment 12 Michal Marek 2006-09-06 10:48:36 UTC

new maintainer

Comment 13 Petr Mladek 2007-02-05 17:21:08 UTC

*** Bug 231192 has been marked as a duplicate of this bug. ***

Comment 14 Jian Hua Jiao 2008-01-31 07:21:19 UTC

Both in SLED10 SP1 and OpenSUSE10.3
for ODBC
 still missing package: MyODBC-unixODBC
for JDBC
 missing package: mysql-connector-java

Comment 15 Ales Nosek 2008-07-15 14:49:47 UTC

Fixed packages MyODBC-unixODBC and mysql-connector-java in Factory.