RHEL Engineering is moving the tracking of its product development work on RHEL 6 through RHEL 9 to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "RHEL project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs in the statuses "NEW", "ASSIGNED", and "POST" are being migrated throughout September 2023. Bugs of Red Hat partners with an assigned Engineering Partner Manager (EPM) are migrated in late September as per pre-agreed dates. Bugs against components "kernel", "kernel-rt", and "kpatch" are only migrated if still in "NEW" or "ASSIGNED". If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "RHEL project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/RHEL-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.
Bug 1875355 - Introduction of compat-unixODBC234 breaks support for SAP HANA remote resource [rhel-7.9.z]
Summary: Introduction of compat-unixODBC234 breaks support for SAP HANA remote resourc...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Linux 7
Classification: Red Hat
Component: compat-unixODBC234
Version: 7.9
Hardware: x86_64
OS: Linux
unspecified
high
Target Milestone: rc
: ---
Assignee: Ondrej Dubaj
QA Contact: Jakub Heger
Lenka Špačková
URL:
Whiteboard:
Depends On: 1790655
Blocks: 1897200 1897203 1897204
TreeView+ depends on / blocked
 
Reported: 2020-09-03 11:39 UTC by Steffen Froemer
Modified: 2024-03-25 16:25 UTC (History)
15 users (show)

Fixed In Version: compat-unixODBC234-2.3.4-2
Doc Type: Known Issue
Doc Text:
Clone Of:
: 1897200 1897203 1897204 (view as bug list)
Environment:
Last Closed: 2020-12-15 11:18:29 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Knowledge Base (Solution) 5094721 0 None None None 2020-09-03 11:39:18 UTC
Red Hat Product Errata RHBA-2020:5442 0 None None None 2020-12-15 11:18:56 UTC

Description Steffen Froemer 2020-09-03 11:39:18 UTC 
Description of problem:
To enable SAP HANA Backup on Azure, unixODBC is required in version 2.3.4.
RHEL-7 only provide 2.3.1, so compat-unixODBC234 was introduced.

If customers require to use SAP HANA remote resource [1][2] they need to install Microsoft ODBC driver package [3]. This is an external package, provided by Microsoft.

This package does have dependency of unixODBC >= 2.3.1 for RHEL-7

Following solution [4] it's required to de-install unixODBC, as this isn't compatible with compat-unixODBC234.

[1]: https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.04/en-US/98cf2f660b214dbaa5c519f86e361c6f.html
[2]: https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.05/en-US/101c5d403a27456ab8de7ad9b46598e8.html
[3]: https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15
[4]: https://access.redhat.com/solutions/5094721

Version-Release number of selected component (if applicable):
compat-unixodbc234-2.3.4

How reproducible:
always

Steps to Reproduce:
1. yum remove unixODBC
2. yum install compat-unixODBC234
3. yum install msodbcsql17


Actual results:
Resolving Dependencies
--> Running transaction check
---> Package msodbcsql17.x86_64 0:17.6.1.1-1 will be installed
--> Processing Dependency: unixODBC >= 2.3.1 for package: msodbcsql17-17.6.1.1-1.x86_64
--> Processing Dependency: libodbcinst.so.2()(64bit) for package: msodbcsql17-17.6.1.1-1.x86_64
--> Running transaction check
---> Package unixODBC.x86_64 0:2.3.1-11.el7 will be installed
--> Processing Conflict: compat-unixODBC234-2.3.4-1.el7_6.x86_64 conflicts unixODBC
--> Finished Dependency Resolution
Error: compat-unixODBC234 conflicts with unixODBC-2.3.1-11.el7.x86_64

Expected results:
it should work

Additional info:
Comment 5 Ondrej Dubaj 2020-09-04 06:11:44 UTC 
Hello Steffen,

msodbcsql17 is a package which was shipped by RedHat ? Or is it some kind of 3rd partly software ? We normally do not provide support for software, which is not shipped by our company.

Thanks.
Comment 6 Peter Vreman 2020-09-04 07:14:35 UTC 
Ondrej,

It does not matter who provided the package. RedHat has introduced the breakage for everyone that relied on the stable package names of RHEL.

It is official RedHat provided compat-unixODBC that conflicts with the offical RedHat UnixODBC and with that it breaks all rpms having a dependency on standard RHEL unixODBC. Even if the other rpm has 'unixODBC >= 2.3.1'

If compat-unixODBC could provide 'unixODBC' to statisfy the dependencies of all unixODBC drivers then it would solve the problem.

Peter
Comment 8 Ondrej Dubaj 2020-09-04 08:13:59 UTC 
Peter,

thanks for the explanation. I might try to explain now, why is this happening. Azure SAP has requested us to update unixODBC from version 2.3.1 to version 2.3.4 recently. This was a problem, as ABI compatibility was not preserved. So we came out with a solution to package unixODBC version 2.3.4 as a totally new package -> compat-unixODBC234, which was shipped only in SAP channels (as far as I know). These two packages (unixODBC and compat-unixODBC234) obviously cannot be installed on one system together, as they conflict with each other, so this an expected issue.

A solution for you might be to request msodbcsql17 developers not to require unixODBC package, instead require compat-unixODBC234 package as dependency. With this minor fix, everything should work properly.
Comment 9 Steffen Froemer 2020-09-04 08:40:30 UTC 
Ondrej, this request does not work!

What you're requesting is change 'unixODBC >= 2.3.1' to 'compat-unixODBC234 >= 2.3.4'
This will break more than you're trying to resolve currently.


compat-unixODBC234 is required for SAP HANA Backup on Azure. The package itself is included in SAP-related repositories.
But the 'Microsoft ODBC driver' package is required by more than only this single use-case.

One example is MSSQL Server running on RHEL [1]. With this server running on RHEL, you does not have access to SAP related repositories.

We now have msodbcsql17, which depends on unixODBC 2.3.4 or newer, also for SAP HANA systems running on Azure but the Feature of HANA Azure backup relies on unixODBC version 2.3.4.

I do not see a chance to make changes on msodbcsql17 Package by Microsoft, than we have to check how we can rebase unixODBC 2.3.4 to RHEL-7.

Cheers, Steffen

[1]: https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-red-hat?view=sql-server-ver15
Comment 10 Ondrej Dubaj 2020-09-04 09:08:11 UTC 
Adding reference to previous tracker, where the discussion held place and where we discussed adding new package compat-unixODBC234 to SAP channels. There is also an explanation why rebasing unixODBC to verison 2.3.4 is risky and also a confirmation from SAP, that the provided package worked.

https://bugzilla.redhat.com/show_bug.cgi?id=1790655
Comment 15 Steffen Froemer 2020-09-07 07:18:05 UTC 
Ondrej,
I think it make sense to move the discussion offline, as we have different problems here. Would it be possible to schedule a meeting with PM to move this discussion forward.
I'm looking for a solution which is good in longterm and not a suitable technical workaround for now.

Thanks,
Steffen
Comment 27 Ondrej Dubaj 2020-09-09 13:10:14 UTC 
Steffen, are you please able to rebuild packages, which should use compat-unixODBC234 package against it ?
Comment 29 Steffen Froemer 2020-09-10 09:20:11 UTC 
(In reply to Ondrej Dubaj from comment #27)
> Steffen, are you please able to rebuild packages, which should use
> compat-unixODBC234 package against it ?

No, I'm not able to rebuilt any package. As the mentioned one are provided by Microsoft, they have to be involved into that.
Comment 30 Oliver Falk 2020-09-10 09:25:52 UTC 
I already opened a collaboration with MSFT on this!
I'll let you know, once there is some progress that's worth sharing!

Oliver
Comment 31 Ondrej Dubaj 2020-09-10 09:29:06 UTC 
Thanks to both of you!
Comment 74 errata-xmlrpc 2020-12-15 11:18:29 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory (compat-unixODBC234 bug fix update), and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2020:5442
Note You need to log in before you can comment on or make changes to this bug.