MySQL Native C Connector Extension for Linux 32, 64 and OSX 64 bit versions of LibreOffice - built against future LO 4.2

users
#1

Just a heads up to let you all know that you know that if you :

- can get your hands on a 64bit daily build of LO for OSX (this doesn't
seem available anywhere I can find at the moment);

- or a 32bit or 64bit Linux daily build ;

you might want to try the mysql native C connector extensions I have
managed to build from the current master repo, and which are available
here :

http://sourceforge.net/projects/lomysqlconnectorextension/

Note that the Linux versions were built on Ubuntu/Debian based systems.

These extensions may or may not work with current 4.1.x versions of
LibreOffice, I haven't tested them so wouldn't know.

I have not built for Windows, as I have no build machine for that and
learning to cross-compile for that particular OS does not yet represent
an itch I'm dying to scratch. I believe Jésus Corrius is preparing new
Windows-built connector extensions which should be made available via
the LO extensions website.

Alex

#2

Hi Alex,
Thanks for your work! However, the connector you built does unfortunately NOT
work on my Linux-Mint-15-LO-4.1.2.3,MySQL 5.5 system.
The one that comes integrated with LO 4.1.2.3 works in principle, but garbles up
time fields. E.g., a time (Central Europe) of 20:30:00 is shown in LO-Base as
12:20:30, while it is perfectly o.k. when looking at it through the MySQL command-
line client.
I had to "revert" back to using the Java Connector for the time being. Unfortunately
I really don't have the time to go into the matter myself - at least not for the time
being.
Regards
Heinrich

#3

Hi Heinrich,

Thanks for your work! However, the connector you built does
unfortunately NOT
work on my Linux-Mint-15-LO-4.1.2.3,MySQL 5.5 system.

Which bit architecture ? 32bit or 64bit ? There is a difference in the
build sizes of the 32bit and 64bit Linux extensions, and I don't know
why, since they are built on similar base versions of Ubuntu/Mint
(13.04). The 64bit one does work apparently, since I've already had
positive feedback for that, so I guess the 32bit is doing something it
shouldn't be, or else you are missing some vital library (libstdc++ ??).

When I get some more time, I will check it out.

Alex

#4

Hi Alex,
Thanks for your work! However, the connector you built does unfortunately NOT
work on my Linux-Mint-15-LO-4.1.2.3,MySQL 5.5 system.
The one that comes integrated with LO 4.1.2.3 works in principle, but garbles up

is this due to the Extension or is it a problem after changing the datetime stuff in the API ?

Jésus Corius build a new Windows version for 4.1 , works not for XP , works fine for Win7 and Win8 but crasches on some (big 90.000 records)) tables with Timestamps and Datetime rfileds?

#5

Hi Alex,
it is 32 bit...

#6

Hi Fernand,

is this due to the Extension or is it a problem after changing the
datetime stuff in the API ?

Probably the API change. The extension to which Heinrich is referring is a PPA built one (or does Ubuntu now ship 4.1.2.3 ?), I guess, as the official TDF builds do not contain the mysql connector extension, so it seems likely that the PPA provided extension connector was built on source code that existed before the API was changed. Unless Heinrich is referring to some connector from some other source ?

Jésus Corius build a new Windows version for 4.1 , works not for XP ,
works fine for Win7 and Win8 but crasches on some (big 90.000 records))
tables with Timestamps and Datetime rfileds?

The change in the basic LO datetime handling data length code to take account of nanoseconds (for which mysql doesn't provide for suppport AFAIK) might be the cause here too. I've no idea how LO handles that lack of support here for the conversion, whether it just silently drops the excess part, or whether it tries to convert it into something meaningful and then gets confused and falls over. You'd have to ask over on the dev mailing list.

Alex