Native MySQL-Connector

users
#1

Just out of curiosity...
I simply have not been able to do anything for the MySQL/MariaDB
native connector. Has anything happened in the past 2 to 3 months
or - are there any known efforts in the foreseeable future in this
respect?
I have been using the ODBC-connection under Linux/Mint and Debian/
Wheezy but is not REALLY "production-ready". Of course - under
Windows/Vista and LO 3.5.2-rc1 the native connector works
satisfactorily - at least in my opinion.
Regards from sunny (and finally spring-like Salzburg)
Heinrich

#2

Heinrich ,

Native Connector Works fine , LO 3.5 , MYSQL5.1 Windows

Regards from the also sunny Belgium Coast :slight_smile:

Fernand

#3

I have recently got the direct connection working. The steps were:
  select 'existng database' and MySQL
  'connect directly'
  select server/port and type in 'localhost' (the port 3306 is default)
  now select 'socket' and type in the socket address that mysqld gave
  you when you started it. That was unexpected because it looks as if
  server and socket are alternatives.
My first try give the error 'can't access socket /var/run/mysqld/mysqld.sock'
but mysqld actually said '/tmp/mysqld.sock'.

good luck

Tony Sumner

#4

Heinrich,

I've just done a default installation of Linux Mint 12 on a spare
machine, so I will test with the default provided LO and mysql-connector
and report back when I get some time.

Additionally, you might like to try with the old connectors provided via
the Apache OpenOffice.org website, since these are now said to function
again with LibreOffice 3.5 (bug corrected in LO regarding component
registration).

Alex

#5

I know,as I am also using the Native Connector on my LO 3.5.2-rc1 -
Windows-VIsta system. Unfortunately it does NOT work on my Linux boxes...
Regards
Heinz

#6

Hello Tony,
Thanks for your suggestions. However, I get the error "cannot find an SDBC-driver
for the URL specified".
Regards
Heinrich

#7

Hi Alex,
Thanks for the hint! I downloaded the deb-package from the Apache-OpenOffice.org
website and tried to install it with dpkg -i ...
Unfortunately it refuses to install because I have the wrong version of libreoffice-core
(3.3) installed according to aptitude. As mentioned before - being a glutton for punischment -
I installed LO 3.5.2-rc1 (again - using dpkg -i for the deb-packages downloaded from the LO-site).
I am not quite aware how I can still have libreoffice-core 3.3 installed after this, but
there you are - at least as far as aptitude is concerned. Obviously things are somewhat
muddled up on my Mint-system.
Regards
Heinrich

#8

Errr, yes, it would appear so.

Have you tried :

dpkg --purge libreoffice-*

That should give your system a good clean out (including the LO you just
downloaded). Then of course, you'd have to re-install again...

Alex

#9

Thanks for your hint. When I try to install the mysql connector now I get
the message that it depends on "libreoffice-core". However this package is
not installed and - according to aptitude - only available at level 3.3.
I don't want to fall back to that level though. So, it looks as if I will
have to unfortunately wait till this situation clears up as I don't have the
time available within the next few days to build the connector for 3.5.2-rc1.
Regards
Heinrich

#10

Hi Heinrich,

Thanks for your hint. When I try to install the mysql connector now I get
the message that it depends on "libreoffice-core". However this package is
not installed and - according to aptitude - only available at level 3.3.

Which connector is that ? Surely, you are talking about the one supplied by Mint here ? That would be logical, because the distrib supplied one would probably only work with the distrib specific version of LO.

I don't want to fall back to that level though. So, it looks as if I will
have to unfortunately wait till this situation clears up as I don't have
the
time available within the next few days to build the connector for
3.5.2-rc1.

For what its worth, I tested on Bodhi Linux, with DEBS from the LO official download :
- the Bodhi supplied OOo mysql connector - failed to install
- the Bodhi supplied LO 3.3.2 mysql connector - failed to install
- the Oracle AOOo mysql connector - failed to install
- and the 32bit connector which I made available on the LO extensions site - failed to install

Each time I tried to install the extensions other than the Bodhi supplied ones, I got an error message about failing to load component blahblah

I noticed that my home built connector was much smaller than the Oracle one and indeed, seemed to be missing at least 2 libraries. I am currently trying to build a new connector which should include those libraries (with a bit of luck)

Alex