Results 1 to 10 of 10

Thread: Leap 15.0 + LibreOffice: The connection to the data source could not be established

  1. #1

    Default Leap 15.0 + LibreOffice: The connection to the data source could not be established

    After upgrading the OS from Suse Leap 42.3 to Leap 15.0 mysql/mariadb database cannot be accessed any more by LibreOffice. I DL-ed LO from LO web site.
    The error message reads as follows:
    The connection to the data source could not be established.
    SQL Status: 08001
    Unable to load the libmysqlcppconn.so library.

    So far, up to including Leap 42.3, I used a native mysql connector mysql-connector-linux_4-3_x86_64.oxt without any problems.
    I also tried LO 5.4.7 and LO 6.1 beta with Leap 15.0. However, the result was the same; no connection to the database.
    I tried mariadb JDBC driver and it worked fine. However, I sticked to the native driver since all my templates, forms, and querries are populated with plurality of database fields, and it would be a real nightmare to make everything from the scratch.

    So far, I have discovered only one differnce between 42.3 and 15.0; the file libmysqlclient is missing in 15.0.

    Any suggestions.

  2. #2

    Default Re: Leap 15.0 + LibreOffice: The connection to the data source could not be established

    No replies so far. Now, I am certain that the problem lies in Leap 15.0 not LO or mysql-connector. Why? Because everything runs smoothly on the other machine with Suse 42.2, LO 6.0.3.2 and mysql-connector-linux_4-3_x86_64. Therefore, either something is radically changed in LO since 6.0.4 or in Suse Leap since 15.0.

  3. #3
    Join Date
    Oct 2008
    Location
    Glasgow, Scotland
    Posts
    1,131

    Default Re: Leap 15.0 + LibreOffice: The connection to the data source could not be established

    What is wrong with using LibreOffice-6.0.4.2 and libreoffice-base-drivers-mysql, etc. from the openSUSE-Leap-15.0 repositories? If you have decided to mix packages from different sources, then it is your responsibility to resolve dependencies.
    ~Thank you for sharing an interesting problem.
    --
    slàinte mhath,
    rayH

  4. #4

    Default Re: Leap 15.0 + LibreOffice: The connection to the data source could not be established

    I did not mix different packages. As I mentioned in my first post, I use the "original" LO downloaded form the LibreOffice site for years along with the mysql-connector extension for many years without any problem. The problem arose with the upgrading of Suse Leap 42.3 to Leap 15.0. At that time, I downgraded LO to 5.4.7, and upgraded to 6.1beta, but the problem remained.

    Using the original packages (Suse version of LO) could be a solution, however, said LO is still based on Qt4 and KDE4 and also installs plenty of different packages. Nevertheless, I did install today, some minutes ago, the Suse version of LO 6.0.4.2, along with all dependecies that Yast requested. When running Suse LO and trying to connect to mysql/mariadb database, I got the error message saying sometnig about missing the libmysqlclient_r.so. Thus, also the Suse version of LO does not provide flawless connection.

    Now, I am really frustrated since my entire work is based on LO and mysql/mariadb. I have no access any more to any of the data.

  5. #5
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    10,943
    Blog Entries
    2

    Default Re: Leap 15.0 + LibreOffice: The connection to the data source could not be established

    Are you absolutely certain your problem is the changed LO MySQL connector?
    Could your MySQL security have changed?
    ie
    Have you logged in with your MySQL adminstratior account and verified you can access your tables?

    Or,
    Simply re-apply basic security settings using the provided "mysql_secure_installation" script.
    I personally create a HereDoc so that the settings are saved and can be re-applied any time

    https://en.opensuse.org/User:Tsu2/MySQL_and_Mariadb

    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!

  6. #6
    Join Date
    Oct 2011
    Location
    Germany (Ore Mountains)
    Posts
    427

    Default Re: Leap 15.0 + LibreOffice: The connection to the data source could not be established

    For the openSUSE version of LO you need to install the package "libmysqld-devel" to get libmysqlclient_r.so.
    Not that easy to guess ...

    Hendrik

  7. #7
    Join Date
    Oct 2008
    Location
    Glasgow, Scotland
    Posts
    1,131

    Default Re: Leap 15.0 + LibreOffice: The connection to the data source could not be established

    Quote Originally Posted by hendwolt View Post
    For the openSUSE version of LO you need to install the package "libmysqld-devel" to get libmysqlclient_r.so.
    The OP was looking for libmysqlcppconn.so which is part of libmysqlcppconn7, installed by default with MariaDb and LibreOffice from the openSUSE-Leap-15.0 OSS repository.

    My users have had an integrated MySQL/MariaDB and OpenOffice/LibreOffice workflow for more than 15 years now and the recent upgrade to Leap-15.0 (with three coming from 11.4 and 13.2) has not revealed a LO-MariaDB connectivity problem. They use a LAMP web-server to enter hundreds of daily reports into a MariaDB backend with LibreOffice Write to update contact details an produce periodic statistical reports.
    ~Thank you for sharing an interesting problem.
    --
    slàinte mhath,
    rayH

  8. #8

    Default Re: Leap 15.0 + LibreOffice: The connection to the data source could not be established

    Great to see users experience. But note, in addition I upgraded Leap 42.3 to Leap 15.0 on my laptop with the very same result, no connection to mysql. Also, you might want to know that mysql/mariadb database is located in a remote server where no changes have been made.
    So, the bottom line is as follows: I want to run "native" LO (not LO made by Suse) and make a connection to mysql/mariadb using SDBC mysql-connector as I did for the last 15 years.As I already mentioned, everything ran smoothly with Suse up to Leap 42.3. Upon the upgrade to Leap 15.0 the following error is shown:
    The connection to the data source "ip" could not be established.SQL Status: 08001 Unable to load the libmysqlcppconn.so library. No mysql security have been changed. One additional information. I checked in LO "Connection pooling enabled". When LO has been restarted the connection to mysql worked great. However, when I restarted LO again, the connection has gone with the above mentioned error. So, the connection worked only on one occasion.

  9. #9

    Default Re: Leap 15.0 + LibreOffice: The connection to the data source could not be established

    I placed same problems (bug) in a forum of LibreOffice document foundation (https://bugs.documentfoundation.org/....cgi?id=117931). The conclusion is to stop further investigation since the bug occurs only in SuSE Leap.
    So, I believe it is now SuSE's turn to solve the problem.

  10. #10

    Default Re: Leap 15.0 + LibreOffice: The connection to the data source could not be established

    Identical problem here. Will prevent me from upgrading other computers.

Posting Permissions

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