Bugzilla – Bug 1017925
LibreOffice demands libobdc.so.1 but unixOBDC only provids libobdc.so.2
Last modified: 2017-09-17 14:34:58 UTC
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0 Build Identifier: It is impossible to connect Microsoft Access databases, since LibreOffice demands libobdc.so.1, but unixOBDC only provides libobdc.so.2 Reproducible: Always Steps to Reproduce: 1. Launch LibreOffice. 2. Start an New Database wizard (File->Create->Database) 3. Choose "Connect to an existing database" 4. Choose ODBC and push "Forward" 5. Try to open a file. Actual Results: You get a message: "File libodbc.so.1 missing or corrupt." Expected Results: Open a file dialog.
CCing unixODBC and libreoffice maintainers
Michael is away so I'll take a quick look. Looks like LibreOffice is trying to open wrong file. Soname for unixODBC is set correctly in libodbc.so.2 SONAME libodbc.so.2 but libreoffice seems to have these hardcoded??? openSUSE:Leap:42.1/libreoffice/libreoffice-5.0.2.2/dbaccess> grep libodbc.so. * -r source/ui/dlg/odbcconfig.cxx:#define ODBC_LIBRARY_1 "libodbc.so.1" source/ui/dlg/odbcconfig.cxx:#define ODBC_LIBRARY "libodbc.so" Quickly looking at libreoffice sources tell me that it will actually try to load the libodbc.so *first* then fallback to the hardcoded soname. Workaround is to have unixODBC-devel package installed. But haven't tested.
(In reply to Adam Majer from comment #2) > Michael is away so I'll take a quick look. Looks like LibreOffice is trying > to open wrong file. Soname for unixODBC is set correctly in libodbc.so.2 > > SONAME libodbc.so.2 > > but libreoffice seems to have these hardcoded??? > > openSUSE:Leap:42.1/libreoffice/libreoffice-5.0.2.2/dbaccess> grep > libodbc.so. * -r > source/ui/dlg/odbcconfig.cxx:#define ODBC_LIBRARY_1 "libodbc.so.1" > source/ui/dlg/odbcconfig.cxx:#define ODBC_LIBRARY "libodbc.so" > > Quickly looking at libreoffice sources tell me that it will actually try to > load the libodbc.so *first* then fallback to the hardcoded soname. > > Workaround is to have unixODBC-devel package installed. But haven't tested. Yep it dlopens it for the fun of it. I will update the code...
For Leap 42.1, please install the unixODBC-devel package. This bug has already been addressed in Leap 42.2's version unixODBC and also fixed in latest upstream version of LibreOffice (it will look for libodbc.so.2). Since this is not an important bug (because of an very easy workaround), it is unlikely to be fixed in Leap 42.1.
This is an autogenerated message for OBS integration: This bug (1017925) was mentioned in https://build.opensuse.org/request/show/451338 Factory / libreoffice
This is an autogenerated message for OBS integration: This bug (1017925) was mentioned in https://build.opensuse.org/request/show/452177 Factory / libreoffice
SUSE-SU-2017:1821-1: An update that solves 7 vulnerabilities and has 14 fixes is now available. Category: security (moderate) Bug References: 1015115,1015118,1015360,1017925,1021369,1021373,1028817,1034192,1034329,1034568,1035087,1036975,1042828,948058,959926,962777,963436,972777,975283,976831,989564 CVE References: CVE-2015-8947,CVE-2016-10327,CVE-2016-2052,CVE-2017-7870,CVE-2017-7882,CVE-2017-8358,CVE-2017-9433 Sources used: SUSE Linux Enterprise Workstation Extension 12-SP2 (src): libixion-0.12.1-12.1, libmwaw-0.3.11-9.1, liborcus-0.12.1-12.1, libreoffice-5.3.3.2-40.5.9, libstaroffice-0.0.3-2.1, libzmf-0.0.1-2.1, myspell-dictionaries-20170511-15.1 SUSE Linux Enterprise Software Development Kit 12-SP2 (src): libixion-0.12.1-12.1, libmwaw-0.3.11-9.1, liborcus-0.12.1-12.1, libreoffice-5.3.3.2-40.5.9 SUSE Linux Enterprise Desktop 12-SP2 (src): libixion-0.12.1-12.1, libmwaw-0.3.11-9.1, liborcus-0.12.1-12.1, libreoffice-5.3.3.2-40.5.9, libstaroffice-0.0.3-2.1, libzmf-0.0.1-2.1, myspell-dictionaries-20170511-15.1
openSUSE-SU-2017:1851-1: An update that solves 5 vulnerabilities and has 14 fixes is now available. Category: security (moderate) Bug References: 1015115,1015118,1015360,1017925,1021369,1021373,1028817,1034192,1034329,1034568,1035087,1036975,1042828,948058,959926,962777,972777,975283,976831 CVE References: CVE-2016-10327,CVE-2017-7870,CVE-2017-7882,CVE-2017-8358,CVE-2017-9433 Sources used: openSUSE Leap 42.2 (src): libixion-0.12.1-8.3.1, libmwaw-0.3.11-6.3.1, liborcus-0.12.1-9.3.1, libreoffice-5.3.3.2-18.6.2, libstaroffice-0.0.3-2.3.1, libzmf-0.0.1-2.1, myspell-dictionaries-20170511-6.3.1
SUSE-SU-2017:2315-1: An update that solves 7 vulnerabilities and has 19 fixes is now available. Category: security (moderate) Bug References: 1015115,1015118,1015360,1017925,1021369,1021373,1021675,1028817,1034192,1034329,1034568,1035087,1035589,1036975,1042828,1045339,947117,948058,954776,959926,962777,963436,972777,975283,976831,989564 CVE References: CVE-2015-8947,CVE-2016-10327,CVE-2016-2052,CVE-2017-7870,CVE-2017-7882,CVE-2017-8358,CVE-2017-9433 Sources used: SUSE Linux Enterprise Workstation Extension 12-SP3 (src): libixion-0.12.1-13.2.1, libmwaw-0.3.11-7.5.1, liborcus-0.12.1-10.5.1, libreoffice-5.3.5.2-43.5.4, libstaroffice-0.0.3-4.1, libzmf-0.0.1-4.1, myspell-dictionaries-20170511-16.2.1 SUSE Linux Enterprise Software Development Kit 12-SP3 (src): libixion-0.12.1-13.2.1, libmwaw-0.3.11-7.5.1, liborcus-0.12.1-10.5.1, libreoffice-5.3.5.2-43.5.4 SUSE Linux Enterprise Desktop 12-SP3 (src): libixion-0.12.1-13.2.1, libmwaw-0.3.11-7.5.1, liborcus-0.12.1-10.5.1, libreoffice-5.3.5.2-43.5.4, libstaroffice-0.0.3-4.1, libzmf-0.0.1-4.1, myspell-dictionaries-20170511-16.2.1
openSUSE-SU-2017:2488-1: An update that solves 7 vulnerabilities and has 19 fixes is now available. Category: security (moderate) Bug References: 1015115,1015118,1015360,1017925,1021369,1021373,1021675,1028817,1034192,1034329,1034568,1035087,1035589,1036975,1042828,1045339,947117,948058,954776,959926,962777,963436,972777,975283,976831,989564 CVE References: CVE-2015-8947,CVE-2016-10327,CVE-2016-2052,CVE-2017-7870,CVE-2017-7882,CVE-2017-8358,CVE-2017-9433 Sources used: openSUSE Leap 42.3 (src): libreoffice-5.3.5.2-3.4 openSUSE Leap 42.2 (src): libreoffice-5.3.5.2-18.9.4