Difference between revisions of "Database/Drivers/MySQL Native/Beta/Known Issues"
(→Windows: OOo will crash on systems with pre-installed libmysql.dll when installing and using the extension) |
B michaelsen (Talk | contribs) |
||
| (7 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
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. | 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: Cannot install without <code> libstdc++.so.5 </code> === | ||
| − | 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 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. |
==== Search for the library: ==== | ==== Search for the library: ==== | ||
| Line 36: | Line 36: | ||
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. | 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
Contents
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.
