MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)

users
#1

I have built one of these for 32 and 64 bit. I am looking for someone who has MariaDB installed on a Linux operating system to test whether this connector will work with MariaDB or not. (Each connector contains the needed MariaDB library files, so they should work.)
      From the things I have done with MySQL on my 32 and 64 bit computers, it works well.

This is the 32 bit version of the connector: If you install in the Extension Manager, it will appear to be version 1.02, but it is really 1.04_3

<http://nabble.documentfoundation.org/file/n4124313/mysql-connector-ooo_1.oxt>

This is the 64 bit version of the connector: (The Extension Manager reports this version as 1.04_3 as it should.)

<http://nabble.documentfoundation.org/file/n4124313/mysql-connector-ooo_1.oxt>

#2

I understand your problem. Accidentally, both links were to the same 32 bit connector because I became confused by the naming Nabble used for the two files. (I uploaded teh same file twice.)
      Here is the 32 bit connector for others if they want to test it:
<nabble_a href="mysql-connector-x86.oxt">mysql-connector-x86.oxt>

     Here is the 64 bit connector (which is the one you really needed):

<nabble_a href="mysql-connector-x86_64.oxt">mysql-connector-x86_64.oxt</nabble_a>

      And a very special thanks to you for what you have done.

Dan

#3

I tried to install the 64-bit and 32-bit versions but get the message
"The extension 'MySQL Connector' does not work on this computer."

I have a 64-bit Terra laptop, with Opensuse 13.1 and LibreOffice
Version: 4.1.6.2 Build ID: 410m0(Build:2)

Greetings
Harvey

#4

These extensions only work with libreoffice 4.2 and 4.3. They do not work with 4.1. Sorry if I did not mention this before. (I had written this in my email to the Quality Assurance mailing list.
      The links above are not the correct ones. They should have been

<nabble_a href="mysql-connector-x86_64.oxt">mysql-connector-x86.oxt</nabble_a> for the 32 bit connector

<nabble_a href="mysql-connector-x86_64.oxt">mysql-connector-x86_64.oxt</nabble_a> for the 64 bit connector

Dan

#5

Hi :slight_smile:
Aaargh, Nabble seems to be playing up and won't let me click on that new
link that Dan gave. Nabble hasn't gone wrong before afaik so it was a bit
unexpected. Hopefully Dan might fix the problem when time-zones allow.
Apols and regards from
Tom :slight_smile:

#6

aha...so what do I learn from this? => I should read the title of the
thread and check my own installation before taking action and/or
replying.

Sorry for that!

Cheers
Harvey

#7

The current OpenSuse 13.1 distro version of LibreOffice is still 4.1. So
I continue to use it for consistency with Opensuse 13.1.

#8

Hi :slight_smile:
On the other hand it gives you an opportunity to install the
4.3.(newest-one) in parallel with the version you use. Then you can check
it to see if;
1. this connector works for you and
2. to see if whatever was keeping you on the 4.1.x has been fixed in the
newest release. Chances are you'll not be as unlucky as Tasnstaafl as
that's pretty rare.

Regards from
Tom :slight_smile:

#9

Hi :slight_smile:
Ahh right :slight_smile: same reason i'm still on 3.5.7 on some machines then :slight_smile:
Regards from
Tom :slight_smile:

#10

Hmm... not sure what the thanks are for but, thank you and you're welcome.

And thanks to you. The corrected links enabled me to use the native MySQL
connector. Not like I have a particular need. However databases, the
desktop kind, are one of the things that got me started on an IT career so
I continue to dabble.

I have limited funds to purchase h/w or s/w and as a result the h/w and s/w
I use to experiment is relatively underpowered.

I have a database from the US gov't, npidata freely available, with about
3.5 million rows and around 350 columns. Actually the gov't provides a csv.
Imported it into a MySQL db using the MySQL command line. Never been able
to read the primary table using the Java connector. With the native MySQL
connector I can. At the MySQL command line I can. That alone tells me
something is better.

#11

Hi Alan,

I have a database from the US gov't, npidata freely available, with about
3.5 million rows and around 350 columns. Actually the gov't provides a csv.
Imported it into a MySQL db using the MySQL command line. Never been able
to read the primary table using the Java connector. With the native MySQL

Yeah, the whole Java connector thing within LibreOffice and large record
sets is a very bad combination, even with a mysql backend ! I'm not
surprised you couldn't read it with an array of data that big, even if
each field only contained 1 byte :slight_smile:

Glad that the native connector at least allows you to load the records :-))

Alex

#12

Alex Thurgood schrieb:

Hi Alan,

I have a database from the US gov't, npidata freely available, with about
3.5 million rows and around 350 columns. Actually the gov't provides a csv.
Imported it into a MySQL db using the MySQL command line. Never been able
to read the primary table using the Java connector. With the native MySQL

Yeah, the whole Java connector thing within LibreOffice and large record
sets is a very bad combination, even with a mysql backend ! I'm not
surprised you couldn't read it with an array of data that big, even if
each field only contained 1 byte :slight_smile:

Glad that the native connector at least allows you to load the records :-))

Alex

Hi Alex,
I do have a long-time "connection" with ALL 3 kinds of MySQL connectors.
Only the native one REALLY works o.k...
There is one problem in MY case, however: My DB-Hosting facility specifies
a connection time-out value of 1 minute. With the Java connector one can
specify "reconnect-true" (or yes?) when defining the DB under LO. This
means that LO at least re-connects after a termination of the connection
by the server. This is NOT a good situation, but it is kind of acceptable.
The native connector does NOT allow such a specification. This makes it
unusable to me unfortunately. I hope that it might be possible to change
this limitation of the native connector.
Regards
Heinrich

#13

This may not be much of a work a round. I have a database using MySQL 5.5 server that I leave open for long periods of time. So when I come back the database, I get the message: MySQL has gone away. Since the database is the only thing that I am using LibreOffice for at the time, I close the database rather than LibreOffice. This opens the Start window which contains a list of previously used files. I double click the name of the database, and I am reconnected. It even remembers the user name and password, so the database is opened and ready to use.
      Have you filed a bug report about this?

Dan

#14

Dan Lewis schrieb:

Alex Thurgood schrieb:

Hi Alan,

I have a database from the US gov't, npidata freely available, with about
3.5 million rows and around 350 columns. Actually the gov't provides a csv.
Imported it into a MySQL db using the MySQL command line. Never been able
to read the primary table using the Java connector. With the native MySQL

Yeah, the whole Java connector thing within LibreOffice and large record
sets is a very bad combination, even with a mysql backend ! I'm not
surprised you couldn't read it with an array of data that big, even if
each field only contained 1 byte :slight_smile:

Glad that the native connector at least allows you to load the records :-))

Alex

Hi Alex,
I do have a long-time "connection" with ALL 3 kinds of MySQL connectors.
Only the native one REALLY works o.k...
There is one problem in MY case, however: My DB-Hosting facility specifies
a connection time-out value of 1 minute. With the Java connector one can
specify "reconnect-true" (or yes?) when defining the DB under LO. This
means that LO at least re-connects after a termination of the connection
by the server. This is NOT a good situation, but it is kind of acceptable.
The native connector does NOT allow such a specification. This makes it
unusable to me unfortunately. I hope that it might be possible to change
this limitation of the native connector.
Regards
Heinrich

     This may not be much of a work a round. I have a database using MySQL 5.5 server that I leave open for long periods of time. So when I come back the database, I get the message: MySQL has gone away. Since the database is the only thing that I am using LibreOffice for at the time, I close the database rather than LibreOffice. This opens the Start window which contains a list of previously used files. I double click the name of the database, and I am reconnected. It even remembers the user name and password, so the database is opened and ready to use.
     Have you filed a bug report about this?

Dan

Hello Dan,
I understand what you are telling me! However, a one-minute-timeout value (which I unfortunately
cannot change since I don't have sysadmin access to the server) is simply too short. It means that
it interrupts "normal" work far too often. Certainly one cannot go away for a coffee and excpect
the server to still be connected!!!
No, I haven't yet filed a bug report. Solving this issue (auto-reconnect) is probably more of an
enhancement than a bug. However, I think I will follow your suggestion in any case.
Regards
Heinrich

#15

Heinrich, Dan,

It is a known limitation of the native mysql connector, although I don't
remember right now whether an enhancement request has been filed. I
couldn't find one after a quick search on bugzilla.

Alex