Page 1 of 2 12 LastLast
Results 1 to 10 of 20

Thread: LibreOffice Base to Mariadb connection

  1. #1

    Default LibreOffice Base to Mariadb connection

    I am connecting LibreOffice (Version 6) Base to a remote Mariadb (V10).

    However it seems that I can only make the connection if the package libreoffice-base-drivers-mysql (6.0.5.2) is installed.
    This means that I am unable to install the latest version of Libreoffice (6.1.3.2) without making the connection impossible.

    Does anyone know how to connect LibreOffice 6.1.3.2 Base with a remote Mariadb (v10) without using the libreoffice-base-drivers-mysql package?

  2. #2
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,477
    Blog Entries
    2

    Default Re: LibreOffice Base to Mariadb connection

    Quote Originally Posted by hnimmo View Post
    I am connecting LibreOffice (Version 6) Base to a remote Mariadb (V10).

    However it seems that I can only make the connection if the package libreoffice-base-drivers-mysql (6.0.5.2) is installed.
    This means that I am unable to install the latest version of Libreoffice (6.1.3.2) without making the connection impossible.

    Does anyone know how to connect LibreOffice 6.1.3.2 Base with a remote Mariadb (v10) without using the libreoffice-base-drivers-mysql package?
    I don't understand why you would want to connect Base to a mariadb without using the libreoffice-base-drivers-mysql package.

    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  3. #3

    Default Re: LibreOffice Base to Mariadb connection

    Quote Originally Posted by tsu2 View Post
    I don't understand why you would want to connect Base to a mariadb without using the libreoffice-base-drivers-mysql package.

    TSU
    The only reason is that I am obliged to deinstall LO 6.1.3.2 in order to install the version of LO that is compatible with the available libreoffice-base-drivers-mysql package.

    When I get software notifications that new packages (including LO) are available, I am obliged to remember not to install the LO package updates. Since I am not using LO Base/Mysql very often, I spent a couple of hours the other day trying to figure out why my database connection was broken before I could use it. The reason was that I had taken a string of LO updates over time not realising that there was an incompatibility between the available libreoffice-base-drivers-mysql and the current LO packages.

    It's not a monster issue, just a bit of a nuisance.

  4. #4
    Join Date
    Nov 2009
    Location
    West Virginia Sector 13
    Posts
    15,769

    Default Re: LibreOffice Base to Mariadb connection

    Not sure I understand the problem but you can lock any package you don't want to have updated in Yast-Software management Just right click and select "Protect"

  5. #5

    Default Re: LibreOffice Base to Mariadb connection

    Quote Originally Posted by gogalthorp View Post
    Not sure I understand the problem but you can lock any package you don't want to have updated in Yast-Software management Just right click and select "Protect"
    You are right. I could protect myself from LO updates, but LO-updates are always welcome

  6. #6
    Join Date
    Jun 2008
    Location
    Groningen, Netherlands
    Posts
    20,044
    Blog Entries
    14

    Default Re: LibreOffice Base to Mariadb connection

    Looks like the driver-mysql package no longer gets built by default, it's absent in Tumbleweed. You could ask the maintainer to enable the build for newer versions.
    ° Appreciate my reply? Click the star and let me know why.

    ° Perfection is not gonna happen. No way.

    https://en.opensuse.org/openSUSE:Board#Members
    http://en.opensuse.org/User:Knurpht
    http://nl.opensuse.org/Gebruiker:Knurpht

  7. #7

    Default Re: LibreOffice Base to Mariadb connection

    Quote Originally Posted by Knurpht View Post
    Looks like the driver-mysql package no longer gets built by default, it's absent in Tumbleweed. You could ask the maintainer to enable the build for newer versions.
    That sounds helpful. How do I make such a request?

  8. #8
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,477
    Blog Entries
    2

    Default Re: LibreOffice Base to Mariadb connection

    If you can wait for the drivers package to be updated, I recommend you do so.

    Else,
    You can go "old school" before native drivers were available.

    The old way...
    The procedure
    https://wiki.openoffice.org/wiki/Connect_MySQL_and_Base

    Note that the JDBC connector is recommended, the ODBC connector is an alternative that might also work.

    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  9. #9
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,477
    Blog Entries
    2

    Default Re: LibreOffice Base to Mariadb connection

    Quote Originally Posted by hnimmo View Post
    That sounds helpful. How do I make such a request?
    Submit to https://bugzilla.opensuse.org with a "Feature Request" priority.

    Edit - Although requesting a package upgrade should normally be a Feature Request,
    In this case, I might consider that the importance of this package might warrant at least a "normal" priority.

    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  10. #10

    Default Re: LibreOffice Base to Mariadb connection

    Quote Originally Posted by tsu2 View Post
    Submit to https://bugzilla.opensuse.org with a "Feature Request" priority.

    Edit - Although requesting a package upgrade should normally be a Feature Request,
    In this case, I might consider that the importance of this package might warrant at least a "normal" priority.

    TSU
    Bug 1119104 submitted.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •