![[TEST] Document Foundation Community](https://communitytest.documentfoundation.org/images/discourse-logo-sketch.png){kind=logo}
Hello,
I installed LibreOffice 3.4rc1 today and it seems to work o.k., except ---
the native MySQL-connector is gone. The error message (roughtly translated
from German) is ... SDBC-driver was not found. When I then try to install
it (downloading the OpenOffice-provided driver) I get the answer that it
is installed already. I would prefer NOT to use either ODBC or JDBC.
Can anybody help?
Regards
H.S.
I suspect that it is related to this bug:
https://bugs.freedesktop.org/show_bug.cgi?id=32948
[Address Book Data Source Wizard Doesn't Work]
FWIW: it still doesn't work in LO 3.4RC2 either:
$ cat /opt/libreoffice3.4/program/versionrc
[Version]
AllLanguages=en-US
BuildVersion=
buildid=340m1(Build:12)
ExtensionUpdateURL=http://updateexte.libreoffice.org/ExtensionUpdateService/check.Update
OOOBaseVersion=3.4
ProductBuildid=12
ProductMajor=340
ProductMinor=1
ProductSource=OOO340
UpdateID=LibreOffice_3_en-US
UpdateURL=
UpdateUserAgent=<PRODUCT> (${buildid}; ${_OS}; ${_ARCH};
BundledLanguages=${AllLanguages})
Vendor=The Document Foundation
But this has been fixed in OOo 3.4.0:
http://openoffice.org/bugzilla/show_bug.cgi?id=107809
$ cat /opt/ooo-dev/basis3.4/program/versionrc
[Version]
buildid=340m0(Build:9583)
OOOBaseVersion=3.4
OOOPackageVersion=3.4.0
ProductBuildid=9583
ProductMajor=340
ProductMinor=0
ProductSource=OOO340
So I'm hoping that it will also eventually be fixed in LO.
Hi Heinrich,
I installed LibreOffice 3.4rc1 today and it seems to work o.k., except ---
the native MySQL-connector is gone. The error message (roughtly translated
from German) is ... SDBC-driver was not found. When I then try to install
it (downloading the OpenOffice-provided driver) I get the answer that it
is installed already. I would prefer NOT to use either ODBC or JDBC.
Can anybody help?
I have exactly the same problem on my LibreOffice 3.3.2 installation on
Mac OSX, which used to work fine and now tells me that despite the
package being installed, it can not make the connection to the database.
The package is installed in a sub-directory of :
/share/uno_packages/cache
Delete that sub-directory (make sure the LO isn't running first) in
which you find the mysql-connector, restart LibreOffice, and then
re-install the connector.
You may also find that it is installed in the equivalent LibreOffice
user directory (whatever that is for your platform, since you don't
specify). Look there and do the same before re-installing the connector.
At present, I don't have the problem with LO 3.4rc1.
Alex
Hi Alex,
I just installed 3.4rc2 and also deleted the cache subdirectory before installation.
Same result...
And - by the way - it all works fine under M$-Vista. Not particularly recommendable
when trying to use Open Software...
Regards (from rainy Salzburg!)
Heinrich
Hi 
Is MySql owned by Oracle? Are there other sql databases that could be used if a
problem developed there?
Regards from
Tom
MySQL is NOT owned by Oracle.
InnoDB, the only relational engine supported/used by MySQL IS owned by
Oracle and Oracle has been in the process of removing it from "free"
releases of MySQL.
If you want a REAL database, you install PostgreSQL. This is a really
database though and requires a bit of planning.
If all you need is some form of storage and you don't care about data
integrity, use SQLite.
Hi Heinrich,
I just installed 3.4rc2 and also deleted the cache subdirectory before
installation.
Same result...
Try completely removing or, if you don't want to lose all your settings,
renaming, your user libreoffice directory. You may have a corrupted user
configuration (which seems to happen from time to time, but I don't know
why).
Then restart LibreOffice and just re-install mysql-connector-1.0.1.oxt.
If you can see the connector in your new user configuration, then there
is something that got screwed up with the old one somewhere...
Alex
Hi Heinrich,
Well after fiddling around deleting odd bits here and there and still
getting no further, I decided to delete the whole LibreOffice user
profile and then restart LibreOffice. It meant I had to re-install the
mysql connector again, but at least this time around it worked !!!
It is rather frustrating though that the user profile is still so
fragile with respect to certain extensions.
Alex
Hello Alex,
I have in the meantime switched to using odbc. However, I still would prefer to use
the native connection. How do you delete the whole LibreOffice user profile?
Thanks for your help.
Regards
Heinrich
Hi
It depends on which OS. For Ubuntu and other gnu&linux distros it's
/home/user/.libreoffice
Replace user with your user-name. However you can probably do the same thing
with greater precision by finding the relevant folder in it's sub-folders
/home/user/.libreoffice/3/user
Personally i think it's better to rename the user-profile so that you have a
back-up. LibreOffice will still automatically generate a new one. Then you can
copy&paste fodlers back into the new one until it breaks again which helps
pin-point exactly where the problem is and still lets you keep most of the old
settings, templates and galleries and things you liked. It's probably better to
use the rsync command rather than cp or copy&paste.
The folder structure is probably similar in other platforms except that in
Windows the /home/user part is probably in something like
C:/Documents and Settings/user/Application Data
or something like that.
Good luck and regards form
Tom
From: Heinrich Stoellinger <hc.stoellinger@aon.at>
To: users@libreoffice.org
Sent: Sun, 5 June, 2011 15:11:08
Subject: Re: [libreoffice-users] Re: Native MySQL-connectionHello Alex,
I have in the meantime switched to using odbc. However, I still would prefer
to use
the native connection. How do you delete the whole LibreOffice user profile?
Thanks for your help.
Regards
Heinrich>
> Hi Heinrich,
>
> Well after fiddling around deleting odd bits here and there and still
> getting no further, I decided to delete the whole LibreOffice user
> profile and then restart LibreOffice. It meant I had to re-install the
> mysql connector again, but at least this time around it worked !!!
>
> It is rather frustrating though that the user profile is still so
> fragile with respect to certain extensions.
>
>
> Alex
>
>--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/--
Unsubscribe instructions: E-mail to users+help@libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be
deleted
Hi Tom,
Hi
It depends on which OS. For Ubuntu and other gnu&linux distros it's
/home/user/.libreoffice
And on Mac it is /Users/username/Library/Application Support/LibreOffice.
Yes, renaming instead of deleting makes sense if you have a lot of
things that have been personalised, but as I'm always doing QA on
multiple installs with multiple versions it just gets too much effort to
keep remembering what I installed to which user profile :-)) so I just
delete and recreate.
Extension administration is still a pain in the backside because of the
change in the extensions framework with OOo 3.3 and the 3.4 development
branch. This has led to some extensions not installing properly, or not
installing at all (despite them saying that they are), and unfortunately
the mysql connector extension is very much dependent on the particular
version of OOo and mysql libraries (and now LibO) being released, but
unfortunately it has not been recompiled for the LibO project...amazing
that it still works at all !!
Same with the sdbc-postgresql extension, which was present for Linux
with 3.3.2, but has no doubt accidentally managed to disappear
(following a code merge) from the source tree with the 3.4 branch and
which unfortunately does not allow editing of datasets, just retrieval.
Alex
I stand corrected. I had forgotten Oracle purchased SUN and SUN had
purchased MySQL. My information was correct up until 2009. Now you
have to use MariaDB if you want the "community" version of MySQL.
Hi Tom,
For me, the suggestion to delete the user directory did not work. The weird
thing is that when downloading and then trying to activate the mysql-connector,
I get the message that loading "mysqlc.uno.so" failed. That module is present
in the directory mentioned in the message.
As I mentioned before - I have gone over to usinge odbc and I am quite happy
doing so. I hope that some time in the future somebody cleverer than me will
fix the bug...
Regards
H
I don't think it is a bug...I'm willing to bet the "connector" you have
is for a different version of MySQL or a different version of the
client.
What distribution are you using? Not all Linux distros delete /tmp on
boot. You need to ensure that your distro is deleting /tmp on boot,
delete the user directory, REBOOT, then try your MySQL thing. OpenSuSE
does not delete /tmp by default to speed booting. Ubuntu has a lot of
bugs and only deletes it randomly under certain situations. A lot of
stuff, especially for uno it appears, gets left out in /tmp.
Hi Heinrich
If it works, use it If it's awkward to use odbc then you can always look at
the issue again later. Hopefully things will have moved on by then although
Base is not developing fast right now.
Regards from
Tom
From: Roland Hughes <roland@logikalsolutions.com>
To: users@libreoffice.org
Sent: Sun, 5 June, 2011 18:58:52
Subject: Re: [libreoffice-users] Re: Native MySQL-connectionI don't think it is a bug...I'm willing to bet the "connector" you have
is for a different version of MySQL or a different version of the
client.What distribution are you using? Not all Linux distros delete /tmp on
boot. You need to ensure that your distro is deleting /tmp on boot,
delete the user directory, REBOOT, then try your MySQL thing. OpenSuSE
does not delete /tmp by default to speed booting. Ubuntu has a lot of
bugs and only deletes it randomly under certain situations. A lot of
stuff, especially for uno it appears, gets left out in /tmp.> Hi Tom,
> For me, the suggestion to delete the user directory did not work. The weird
> thing is that when downloading and then trying to activate the
mysql-connector,
> I get the message that loading "mysqlc.uno.so" failed. That module is
present
> in the directory mentioned in the message.
> As I mentioned before - I have gone over to usinge odbc and I am quite
happy
> doing so. I hope that some time in the future somebody cleverer than me
will
> fix the bug...
> Regards
> H
>
>
>
> > /home/user/.libreoffice/3/user
>
>
> --
> Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/
>--
Roland Hughes, President
Logikal Solutions
(630)-205-1593http://www.theminimumyouneedtoknow.com
http://www.infiniteexposure.netNo U.S. troops have ever lost their lives defending our ethanol
reserves.--
Unsubscribe instructions: E-mail to users+help@libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be
deleted
Hi Roland,
I use Debian-Squeeze at the moment. Having spent too much time already doing
things where I don't understand all the possible ramifications - I hesitate
to delete /tmp. Is it o.k. for sure to do so or might I "hurt" something
in doing so down in the depth of Linux?
Regards
H
Hi Tom,
It isn't awkward to use myodbc/unixodbc at all. I had used it for quite some
time before trying JDBC (and giving up on it!). The installation is somewhat
more involved (odbc.ini und odbcinst.ini...). But then it works beautifully.
Naturally I would in the end prefer to use the native connection. However,
since I have a job to do I don't really want to spend the time digging into
the depth of every piece of software. One tends to do that a lot anyway in
the Linux world. It's nice to really UNDERSTAND things, but sometimes -
enough is enough!
Regards from Salzburg
H
P.S.: By the way, having worked for nearly 30 years as a systems engineer
at IBM, I am quite used to "digging into..."
Hi Heinrich,
I use Debian-Squeeze at the moment. Having spent too much time already
doing
things where I don't understand all the possible ramifications - I hesitate
to delete /tmp. Is it o.k. for sure to do so or might I "hurt" something
in doing so down in the depth of Linux?
Regards
H
This might be of some use, you are not alone :
Alex
There are flags that you need to set. Do a search on-line. In OpenSuSE
you set them with YAST, I forget where you set them with Ubuntu. /tmp
is only cleaned at system boot, when it "should" be empty.
Ubuntu has a lot of bugs with respect to cleaning of /tmp at system
boot. It basically doesn't work if /tmp is on a different disk drive
than the system disk.