Bugzilla – Bug 144602
OpenSuSE 10.1 Beta 1 - OpenOffice -2.0 – Database Can Not Connect to a MySQL due to missing files
Last modified: 2008-07-15 14:49:47 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.
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.
Status of the bug?
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.
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?
> 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? :-)
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.
Ok, if Suggests: doesn't really do anything right now, then I can safely add it :)
did this get fixed ? can we close it ?
(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.
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.
OK, I reassign the bug to mmarek and change the product to SLED10.
new maintainer
*** Bug 231192 has been marked as a duplicate of this bug. ***
Both in SLED10 SP1 and OpenSUSE10.3 for ODBC still missing package: MyODBC-unixODBC for JDBC missing package: mysql-connector-java
Fixed packages MyODBC-unixODBC and mysql-connector-java in Factory.