Difference between revisions of "Database/Drivers/MySQL Native/Beta/Known Issues"

From Apache OpenOffice Wiki
Jump to: navigation, search
(New page: === On windows, the extension crashs on some systems === On some Windows systems, if you install and use the extension, it will crash OOo. Reason: The extension ships an own version of...)
 
 
(13 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=== On windows, the extension crashs on some systems  ===
+
{{DISPLAYTITLE:Sun MySQL Connector/OOo: Known Problems (Beta)}}
  
On some Windows systems, if you install and use the extension, it will crash OOo.
+
=== Windows: OOo will crash on systems with pre-installed <code> libmysql.dll </code> when installing and using the extension ===
  
Reason: The extension ships an own version of <code>libmysql.dll</code>. When Windows loads the driver library (<code>mysqlc.uno.dll</code>), it also implicitly loads the <code>libmysql.dll</code>, which <code>mysqlc.uno.dll</code> is linked against. Unfortunately, Windows first searches in the folders specified by your <code>PATH</code> environment variable. If it finds a <code>libmysql.dll</code> in one of those folders, this one is used - no matter whether it is really compatible.  
+
The extension ships with an own version of <code> libmysql.dll </code>. When Windows loads the driver library (<code> mysqlc.uno.dll </code>), it also implicitly loads the <code> libmysql.dll </code>, which <code> mysqlc.uno.dll </code> is linked against. Unfortunately, Windows first searches in the folders specified by your <code> PATH </code> environment variable. If it finds a <code> libmysql.dll </code> in one of those folders, this one is used instead of the one from the extension - no matter whether it is really compatible.
 +
<!--
 +
=== Linux: Cannot install without <code> libstdc++.so.5 </code> ===
  
=== Linux version does not install on systems without libstdc++.so.5 ===
+
The Connector/C version used for building C/C++ (and shipped with the extension) has a run-time dependency to <code> libstdc++.so.5 </code> (which is somewhat weird for a by-definition ''C'' component). Unfortunately, OOo itself ships with <code> libstdc++.so.6 </code> only and the extension does not ship any library version. The technical background for this problem can be found in the [http://bugs.mysql.com/bug.php?id=45128 MySQL bug report #45128]. Finally, this means on systems where version 5 is not present you have to install it manually.
  
The Connector/C version used for building C/C++ (and shipped with the extension) has a runtime dependency to libstdc++.so.5 (which is somewhat weird for a by-definition ''C'' component). Unfortunately, OOo itself ships with libstdc++.so.6 only, and the extension doesn't ship any libstdc++ version, so on systems where version 5 is not present, the extension cannot be installed.
+
==== Search for the library: ====
 +
 
 +
The command <code> ls -l /usr/lib </code> should list the following:
 +
 
 +
  /usr/lib/libstdc++.so.5 -> libstdc++.so.5.0.7
 +
  /usr/lib/libstdc++.so.5.0.7
 +
 
 +
Or search for it with:
 +
 
 +
  whereis libstdc++.so.5
 +
 
 +
If it is found somewhere else, you need to link it to the correct directory:
 +
 
 +
  ln -s (path+filename where it was found) /usr/lib/libstdc++.so.5
 +
 
 +
==== Install the library if not found: ====
 +
 
 +
If it is not listed you can install the library with the following command (depending on your system):
 +
 
 +
{|cellpadding=5 cellspacing=0 border=1 style="border-collapse:collapse; border-color: #333;"
 +
|- style="background-color: #DEDEDE;"
 +
| '''Fedora''' || '''openSUSE''' || '''Mandriva/Connectiva''' || '''Gentoo''' || '''Debian/Ubuntu'''
 +
|-
 +
| <code> sudo yum install compat-libstdc++-33 </code> || <code> sudo apt-get install compat-libstdc++-33 </code> || <code> sudo urpmi libstdc++5 </code> || <code> emerge libstdc++ </code> || <code> sudo apt-get install libstdc++5 </code>
 +
|}
 +
 
 +
For other Linux distributions please have a look onto your installation CD/DVD for a similar name of the package. You can also search in the Web (Examples: [http://rpmfind.net/linux/rpm2html/search.php?query=libstdc++.so.5 RPMFind] or [http://rpmseek.com/rpm-pl/compat-libstdc\\-33.html RPMSeek]) where to get and how to install it.
 +
-->
 +
 
 +
=== Cannot access non-intranet servers via IP ===
 +
 
 +
Reportedly, the Alpha version of the driver was able to connect to a remote MySQL server in the internet, using the server's IP address. The Beta version is not able to do this anymore, while, on the very same machine, e.g. the Connector/J works fine for the very same server.
 +
 
 +
=== Much slower than the ODBC driver ===
 +
 
 +
The Connector/OOo is way slower (when fetching all records, i.e. by traveling to the last record in the table data view) than the ODBC driver. This issue was revealed after the release of the Beta version, and will be fixed in the GA release.
 +
 
 +
=== Standard Filter dialog fails to set a column filter ===
 +
 
 +
Using the "Standard Filter" dialog in either the table data view or a form fails to properly set the filter, instead you get an error message talking about a non-existent column "database.table.column".
 +
The bad news is: That's a bug in OOo itself, which is only triggered by the way how the driver (legitimately) exposes its database/tables, so, it cannot be fixed in the driver, but in OOo only.
 +
 
 +
=== Port setting is ignored ===
 +
 
 +
When you enter a port other than the default <code>3306</code>, then this is ignored. Effectively, this means you cannot connect to a MySQL database using a non-standard port. Will be fixed in the final release.
 +
[[Category:MySQL]]

Latest revision as of 21:39, 15 December 2009


Windows: OOo will crash on systems with pre-installed libmysql.dll when installing and using the extension

The extension ships with an own version of libmysql.dll . When Windows loads the driver library ( mysqlc.uno.dll ), it also implicitly loads the libmysql.dll , which mysqlc.uno.dll is linked against. Unfortunately, Windows first searches in the folders specified by your PATH environment variable. If it finds a libmysql.dll in one of those folders, this one is used instead of the one from the extension - no matter whether it is really compatible.

Cannot access non-intranet servers via IP

Reportedly, the Alpha version of the driver was able to connect to a remote MySQL server in the internet, using the server's IP address. The Beta version is not able to do this anymore, while, on the very same machine, e.g. the Connector/J works fine for the very same server.

Much slower than the ODBC driver

The Connector/OOo is way slower (when fetching all records, i.e. by traveling to the last record in the table data view) than the ODBC driver. This issue was revealed after the release of the Beta version, and will be fixed in the GA release.

Standard Filter dialog fails to set a column filter

Using the "Standard Filter" dialog in either the table data view or a form fails to properly set the filter, instead you get an error message talking about a non-existent column "database.table.column". The bad news is: That's a bug in OOo itself, which is only triggered by the way how the driver (legitimately) exposes its database/tables, so, it cannot be fixed in the driver, but in OOo only.

Port setting is ignored

When you enter a port other than the default 3306, then this is ignored. Effectively, this means you cannot connect to a MySQL database using a non-standard port. Will be fixed in the final release.

Personal tools