MySQL Native Connector

users
#1

Hello,
Some time ago somebody gave me a link to downloading the native connector
to LO/OO from MySQL. I can't find that e-mail anymore! :cry:
Could you please resend the info?
Thanks a lot in advance
Heinrich

#2

Am 17.09.2011 21:23, Heinrich Stoellinger wrote:

Hello,
Some time ago somebody gave me a link to downloading the native connector
to LO/OO from MySQL. I can't find that e-mail anymore! :cry:
Could you please resend the info?
Thanks a lot in advance
Heinrich

As far as I know, it is shipped with LibreOffice.
Choose database type MySQL instead of JDBC or ODBC.

#3

Hello Andreas,
Thanks for your hint, but...
Weird! One can in fact select "MySQL" as the (native) type of connection for
an odb-file.
However when one then tries to open the odb-file, LO displays a list-box
for the specification of a programme with which to open the odb-file.
Downloading the connector and then trying to activate the connector through
the extension manager doesn't work either.

#4

Am 17.09.2011 21:23, Heinrich Stoellinger wrote:

Hello,
Some time ago somebody gave me a link to downloading the native connector
to LO/OO from MySQL. I can't find that e-mail anymore! :cry:
Could you please resend the info?
Thanks a lot in advance
Heinrich

As far as I know, it is shipped with LibreOffice.
Choose database type MySQL instead of JDBC or ODBC.

#5

Hi Andreas,

As far as I know, it is shipped with LibreOffice.
Choose database type MySQL instead of JDBC or ODBC.

It is neither built nor shipped by the LibreOffice project. It is
shipped with various Linux distributions, who include it in their
extensions build setup. Why, well firstly because no one gives a damn,
and second, to build the connector you have to rely on the mysql C
connector library (even if you use mysql C++ library) and that library
is GPL2, which means that the connector that links to it has to be
released under the GPL (this is in fact what Sun did with the native
connector extension). The LibO project releases under the LGPL/MPL and
not the GPL.

At the moment, the OOo mysql native connector is available for download
from here :

http://extensions.services.openoffice.org/en/project/mysql_connector

My advice, get it while you can and keep a copy near to hand.

How long that will remain the case now that this site is to integrated
into the ApacheOOo project remains to be seen, because Apache can not
accept GPLed code into its projects.

I have built the native connector for MacOSX and put it on the
LibreOffice extensions site, but as far as I know, no one has built it
for Windows or Linux (on Linux the question is mostly irrelevant because
the distribs provide it in most cases, however, that does mean you are
tied to the distrib version of LibreOffice).

Alex

#6

Am 18.09.2011 16:28, Alexander Thurgood wrote:

Hi Andreas,

As far as I know, it is shipped with LibreOffice.
Choose database type MySQL instead of JDBC or ODBC.

It is neither built nor shipped by the LibreOffice project. It is
shipped with various Linux distributions, who include it in their
extensions build setup.

Thank you,
Now I see that we first choose MySQL and then we are prompted for ODBC or JDBC. I was under the impression that MySQL refers to the built-in driver.

#7

Am 18.09.2011 16:28, Alexander Thurgood wrote:

Hi Andreas,

As far as I know, it is shipped with LibreOffice.
Choose database type MySQL instead of JDBC or ODBC.

It is neither built nor shipped by the LibreOffice project. It is
shipped with various Linux distributions, who include it in their
extensions build setup.

Thank you,
Now I see that we first choose MySQL and then we are prompted for ODBC or JDBC. I was under the impression that MySQL refers to the built-in driver.

#8

Hi Alex,
As I have already mentioned in an earlier posting - I downloaded the
connector from the site you mention. However, trying to then install/activate
it in my LO 3.4.3 system fails.
Heinrich

#9

Hi :slight_smile:
It might be a good idea to plan a move from MySql to MariaDb.  MariaDb is a drop-in replacement for MySql.  MariaDb is much faster at developing and bug-fixing so a bug-report to them might get a faster response and they might well be happy to work on a project such as the extension/add-on.  It's almost all the MySql people except the ones paid by Oracle. 
Regards from
Tom :slight_smile:

#10

Hi :slight_smile:
It might be a good idea to plan a move from MySql to

MariaDb. MariaDb is a

drop-in replacement for MySql. MariaDb is much faster at

developing and

bug-fixing so a bug-report to them might get a faster

response and they

might well be happy to work on a project such as the

extension/add-on.

It's almost all the MySql people except the ones paid by

Oracle. Regards

from
Tom :slight_smile:

From: Andreas Säger <saegerei@t-online.de>
Subject: [libreoffice-users] Re: MySQL Native Connector
To: users@global.libreoffice.org
Date: Sunday, 18 September, 2011, 15:54

Am 18.09.2011 16:28, Alexander Thurgood wrote:
>
>
> Hi Andreas,
>
>> As far as I know, it is shipped with LibreOffice.
>> Choose database type MySQL instead of JDBC or ODBC.
>
> It is neither built nor shipped by the LibreOffice project.

It is

> shipped with various Linux distributions, who include it

in their

> extensions build setup.

Thank you,
Now I see that we first choose MySQL and then we are

prompted for ODBC

or JDBC. I was under the impression that MySQL refers to

the built-in

driver.

Do you know if this will work in parallel with MySQl until
things can be migrated? Also so phpMyAdmin or something
simular work with it?

Thats

#11

Hi :slight_smile:
I don't think it's urgent but it is worth researching
http://mariadb.org/
I am not sure if you can have both on the same system at the same time.  It might be worth setting up a virtual machine and testing it that way if possible. 
Regards from
Tom :slight_smile:

#12

Hi

Hi :slight_smile:
I don't think it's urgent but it is worth researching
http://mariadb.org/
I am not sure if you can have both on the same system at the same time. It might be worth setting up a virtual machine and testing it that way if possible.
Regards from
Tom :slight_smile:

I believe you can only have one MySQL/Mariadb installation.

From: upscope <upscope@nwi.net>
Subject: Re: [libreoffice-users] Re: MySQL Native Connector
To: users@global.libreoffice.org
Date: Sunday, 18 September, 2011, 20:16

> Hi :slight_smile:
> It might be a good idea to plan a move from MySql to
MariaDb. MariaDb is a
> drop-in replacement for MySql. MariaDb is much faster at
developing and
> bug-fixing so a bug-report to them might get a faster
response and they
> might well be happy to work on a project such as the
extension/add-on.
> It's almost all the MySql people except the ones paid by
Oracle. Regards
> from
> Tom :slight_smile:
>
>
>
> From: Andreas Säger <saegerei@t-online.de>
> Subject: [libreoffice-users] Re: MySQL Native Connector
> To: users@global.libreoffice.org
> Date: Sunday, 18 September, 2011, 15:54
>
> Am 18.09.2011 16:28, Alexander Thurgood wrote:
> >
> >
> > Hi Andreas,
> >
> >> As far as I know, it is shipped with LibreOffice.
> >> Choose database type MySQL instead of JDBC or ODBC.
> >
> > It is neither built nor shipped by the LibreOffice project.
It is
> > shipped with various Linux distributions, who include it
in their
> > extensions build setup.
>
> Thank you,
> Now I see that we first choose MySQL and then we are
prompted for ODBC
> or JDBC. I was under the impression that MySQL refers to
the built-in
> driver.

There is a third MySQL connection available in Linux that works very
well. However if the distro supports 3.3.x like Ubuntu it can be
difficult to install and get working with 3.4.x

Do you know if this will work in parallel with MySQl until
things can be migrated? Also so phpMyAdmin or something
similar work with it?

I know MySQL Workbench works with Mariadb in Linux. In Windows, Mariadb
installs another GUI, Heidi I believe. My understanding is if something
works with MySQL it will work with Mariadb. Mariadb uses the some names
for the files as does MySQL so you can use the MySQL documentation.

#13

Howdy Andreas,

If you do not have the native connector extension installed then only
the odbc and jdbc options are available. With the extension added into
the user configuration then a third option is available - 'Connect
directly'.

//drew

#14

Hi Drew,
As I mentioned before -- the problem is that activating the native
MySQL connector after making the correct selection for the odb-file
doesn't work, at least not on my Debian Wheezy system.
I keep getting the error message
... no SDBC driver found for the URL.
Maybe the connector has to be re-built for LO 3.4? I have no idea :frowning:
Regards
Heinrich

#15

Hi Heinrich

Hi Drew,
As I mentioned before -- the problem is that activating the native
MySQL connector after making the correct selection for the odb-file
doesn't work, at least not on my Debian Wheezy system.
I keep getting the error message
... no SDBC driver found for the URL.
Maybe the connector has to be re-built for LO 3.4? I have no idea :frowning:
Regards
Heinrich

I am able to connect with the native MySQL connector using 3.4.3 using
Ubuntu. I am using mysql-connector-ooo-1.0.1-linux-x86_64.oxt ( I have a
64 bit system). I download the connector from the OOo extension site.

Snip

#16

Hi Snip,
I suppose the fact that I use Debian-Wheezy (next after Squeeze) on a
32-bit system might be the reason. Seeing as I don't really have the
time to do more research I suppose I will just have to live with
ODBC (or even JDBC :() till somebody comes up with a solution.
Regards
Heinrich

#17

Hi all,

Hi Snip,
I suppose the fact that I use Debian-Wheezy (next after Squeeze) on a
32-bit system might be the reason. Seeing as I don't really have the
time to do more research I suppose I will just have to live with
ODBC (or even JDBC :() till somebody comes up with a solution.
Regards

The solution is to rebuild the connector for all combinations of OS/arch
from source. That is how I got my Mac OSX version of the connector
running. None of the devs at LO are building the connector, it is an
option in the configure switch that must be activated specifically.
Possibly, and I say just possibly, the Linux distribs will rebuild it
with their next updates to LO, but I have no idea who deals with that on
each distrib. Same goes for Windows (32/64). If no one complains about
that to the Linux port distrib maintainers, then nothing will get done,
that's for sure.

Additionally, if no one complains about it on the developer list here,
or opens a bug report for it, then nothing will happen either. Even if
someone complains about it, you might well get an answer back of the ilk
"the source is available, build it yourself", which granted, is not
particularly useful/helpful when one is a mere "consumer" of the product.

Alex

#18

Hi :slight_smile:
After 1 person has built it for their system can the built package be uploaded somewhere for other people to use?  If so could it be uploaded to the new LO Extensions&templates site?

How generic are builds?  Would it cover the entire family (Ubuntu, Mint, Trisquel etc), just Debian, one particular release of Debian, or just the specific machine?
Regards from
Tom :slight_smile:

#19

Hi,
Could somebody please give me info about where to get the appropriate source-code
and a bit of "how-to" regarding building the connector for 3.4.3? I will give it
a try.
Regards
Heinrich

#20

Hi Tom,

After 1 person has built it for their system can the built package be uploaded somewhere for other people to use? If so could it be uploaded to the new LO Extensions&templates site?

This is precisely what I have done for Mac OSX.

How generic are builds? Would it cover the entire family (Ubuntu, Mint, Trisquel etc), just Debian, one particular release of Debian, or just the specific machine?

I really don't know, but I'm hasarding a guess that they are fairly
generic - however, each distrib currently packages its own version of
the connector extension to accompany any given release of their own
version of LibO. What is certain is that if you want a 32bit connector,
you have to build with the 32bit mysql connector C library, and if you
want 64bit, well...the corresponding bit library for that.

If you look at the OOo extension site, the MySQL native connector
extension was provided in the following flavours :

http://extensions.services.openoffice.org/en/project/mysql_connector

Linux (32bit)
Linux x86_64
Mac OS X (32bit only)
Solaris Sparc
Solaris x86
Windows (I assume only 32bit, but who knows ?)

So, one would need to build for these arch/OSes and also Win64.

Alex