<div class="container">
<h1>Recommended update for unixODBC</h1>
<table class="table table-striped table-bordered">
<tbody>
<tr>
<th>Announcement ID:</th>
<td>SUSE-RU-2024:2960-1</td>
</tr>
<tr>
<th>Rating:</th>
<td>moderate</td>
</tr>
<tr>
<th>References:</th>
<td>
<ul>
<li style="display: inline;">
<a href="https://bugzilla.suse.com/show_bug.cgi?id=1044970">bsc#1044970</a>
</li>
<li style="display: inline;">
<a href="https://bugzilla.suse.com/show_bug.cgi?id=1062860">bsc#1062860</a>
</li>
<li style="display: inline;">
<a href="https://jira.suse.com/browse/ECO-2305">jsc#ECO-2305</a>
</li>
</ul>
</td>
</tr>
<tr>
<th>Affected Products:</th>
<td>
<ul class="list-group">
<li class="list-group-item">SUSE Linux Enterprise High Performance Computing 12 SP5</li>
<li class="list-group-item">SUSE Linux Enterprise Server 12 SP5</li>
<li class="list-group-item">SUSE Linux Enterprise Server for SAP Applications 12 SP5</li>
<li class="list-group-item">SUSE Linux Enterprise Software Development Kit 12 SP5</li>
</ul>
</td>
</tr>
</tbody>
</table>
<p>An update that contains one feature and has two fixes can now be installed.</p>
<h2>Description:</h2>
<p>This update for unixODBC fixes the following issues:</p>
<ul>
<li>
<p>Update requires and baselibs for new libodbc2.</p>
</li>
<li>
<p>Employ shared library packaging guideline: new subpacakge
libodbc2. mariadb's ha_connect.so wants this library, but a
unixODBC's Recommends line would awkwardly pull in psqlODBC
by default.</p>
</li>
<li>
<p>Update to 2.3.9:</p>
</li>
<li>
<p>Remove "#define UNIXODBC_SOURCE" from unixodbc_conf.h</p>
</li>
<li>
<p>Update to 2.3.8:</p>
</li>
<li>Add configure support for editline</li>
<li>SQLDriversW was ignoring user config</li>
<li>SQLDataSources Fix termination character</li>
<li>Fix for pooling seg fault</li>
<li>Make calling SQLSetStmtAttrW call the W function in the driver is its there</li>
<li>Try and fix race condition clearing system odbc.ini file</li>
<li>Remove trailing space from isql/iusql SQL</li>
<li>When setting connection attributes set before connect also check if the W entry poins can be used</li>
<li>Try calling the W error functions first if available in the driver</li>
<li>Add iconvperdriver configure option to allow calling unicode_setup in SQLAllocHandle</li>
<li>iconv handles was being lost when reusing pooled connection</li>
<li>Catch null copy in iniPropertyInsert</li>
<li>Fix a few leaks </li>
<li>
<p>Remove unixODBC-2.3.7-warning-cleanup.patch: upstreamed</p>
</li>
<li>
<p>Update to 2.3.7:</p>
</li>
<li>Fix for pkg-config file update on no linux platforms</li>
<li>Add W entry for GUI work</li>
<li>Various fixes for SQLBrowseConnect/W, SQLGetConnectAttr/W,and SQLSetConnectAttr/W</li>
<li>Fix buffer overflows in SQLConnect/W and refine behaviour of SQLGet/WritePrivateProfileString</li>
<li>SQLBrowseConnect/W allow disconnecting a started browse session after error</li>
<li>Add --with-stats-ftok-name configure option to allow the selection of a file name
used to generate the IPC id when collecting stats. Default is the system odbc.ini file</li>
<li>Improve diag record handling with the behavior of Windows DM and export SQLCancelHandle</li>
<li>bug fix when SQLGetPrivateProfileString() is called to get a list of sections or a list of keys</li>
<li>Connection pooling: Fix liveness check for Unicode drivers</li>
<li>
<p>Add unixODBC-2.3.7-warning-cleanup.patch: 2.3.7 a 64bit protability error
See https://github.com/lurcher/unixODBC/issues/18</p>
</li>
<li>
<p>bsc#1062860: Recommend psqlODBC to stay feature complete</p>
</li>
<li>
<p>bsc#1062860: Don't install postgres example driver
psqlODBC package should be used instead of the example driver
provided by unixODBC (libodbcpsql.*). It is unmaintained.</p>
</li>
<li>
<p>Enabled --enable-fastvalidate option in configure (bsc#1044970)</p>
</li>
</ul>
<h2>Patch Instructions:</h2>
<p>
To install this SUSE update use the SUSE recommended
installation methods like YaST online_update or "zypper patch".<br/>
Alternatively you can run the command listed for your product:
</p>
<ul class="list-group">
<li class="list-group-item">
SUSE Linux Enterprise Software Development Kit 12 SP5
<br/>
<code>zypper in -t patch SUSE-SLE-SDK-12-SP5-2024-2960=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise High Performance Computing 12 SP5
<br/>
<code>zypper in -t patch SUSE-SLE-SERVER-12-SP5-2024-2960=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise Server 12 SP5
<br/>
<code>zypper in -t patch SUSE-SLE-SERVER-12-SP5-2024-2960=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise Server for SAP Applications 12 SP5
<br/>
<code>zypper in -t patch SUSE-SLE-SERVER-12-SP5-2024-2960=1</code>
</li>
</ul>
<h2>Package List:</h2>
<ul>
<li>
SUSE Linux Enterprise Software Development Kit 12 SP5 (aarch64 ppc64le s390x x86_64)
<ul>
<li>unixODBC-debuginfo-2.3.9-7.13.1</li>
<li>unixODBC-debugsource-2.3.9-7.13.1</li>
<li>unixODBC-devel-2.3.9-7.13.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise High Performance Computing 12 SP5 (aarch64 x86_64)
<ul>
<li>libodbc2-2.3.9-7.13.1</li>
<li>unixODBC-2.3.9-7.13.1</li>
<li>unixODBC-debugsource-2.3.9-7.13.1</li>
<li>unixODBC-debuginfo-2.3.9-7.13.1</li>
<li>libodbc2-debuginfo-2.3.9-7.13.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise High Performance Computing 12 SP5 (x86_64)
<ul>
<li>libodbc2-32bit-2.3.9-7.13.1</li>
<li>unixODBC-32bit-2.3.9-7.13.1</li>
<li>unixODBC-debuginfo-32bit-2.3.9-7.13.1</li>
<li>libodbc2-debuginfo-32bit-2.3.9-7.13.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise Server 12 SP5 (aarch64 ppc64le s390x x86_64)
<ul>
<li>libodbc2-2.3.9-7.13.1</li>
<li>unixODBC-2.3.9-7.13.1</li>
<li>unixODBC-debugsource-2.3.9-7.13.1</li>
<li>unixODBC-debuginfo-2.3.9-7.13.1</li>
<li>libodbc2-debuginfo-2.3.9-7.13.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise Server 12 SP5 (s390x x86_64)
<ul>
<li>libodbc2-32bit-2.3.9-7.13.1</li>
<li>unixODBC-32bit-2.3.9-7.13.1</li>
<li>unixODBC-debuginfo-32bit-2.3.9-7.13.1</li>
<li>libodbc2-debuginfo-32bit-2.3.9-7.13.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise Server for SAP Applications 12 SP5 (ppc64le x86_64)
<ul>
<li>libodbc2-2.3.9-7.13.1</li>
<li>unixODBC-2.3.9-7.13.1</li>
<li>unixODBC-debugsource-2.3.9-7.13.1</li>
<li>unixODBC-debuginfo-2.3.9-7.13.1</li>
<li>libodbc2-debuginfo-2.3.9-7.13.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise Server for SAP Applications 12 SP5 (x86_64)
<ul>
<li>libodbc2-32bit-2.3.9-7.13.1</li>
<li>unixODBC-32bit-2.3.9-7.13.1</li>
<li>unixODBC-debuginfo-32bit-2.3.9-7.13.1</li>
<li>libodbc2-debuginfo-32bit-2.3.9-7.13.1</li>
</ul>
</li>
</ul>
<h2>References:</h2>
<ul>
<li>
<a href="https://bugzilla.suse.com/show_bug.cgi?id=1044970">https://bugzilla.suse.com/show_bug.cgi?id=1044970</a>
</li>
<li>
<a href="https://bugzilla.suse.com/show_bug.cgi?id=1062860">https://bugzilla.suse.com/show_bug.cgi?id=1062860</a>
</li>
<li>
<a href="https://jira.suse.com/browse/ECO-2305">https://jira.suse.com/browse/ECO-2305</a>
</li>
</ul>
</div>