Install a recent version of UnixODBC on CentOS 6.6?

[RunFastOrBeLast]

Hi,

We have centos 6.6 and we would like to use a recent version of UnixODBC.
Yum only propose the old 2008 version unixODBC 2.2.14.
Has anyone been using a recent version successfully in CentOs 6.6?
I don't mind installing it from source but I want to make sure I won't run into any problems...

[avij]

There would be 2.3.1 in CentOS 6.8. Consider upgrading.

[RunFastOrBeLast]

I just did and yum still offers the same old version:

cat /etc/centos-release
CentOS release 6.8 (Final)


yum install unixODBC

Loaded plugins: fastestmirror, security
Setting up Install Process
Loading mirror speeds from cached hostfile
* base: mirror.its.sfu.ca
* epel: mirror.metrocast.net
* extras: centos.mirror.vexxhost.com
* updates: centos.mirror.rafal.ca
Package unixODBC-2.2.14-14.el6.x86_64 already installed and latest version
Nothing to do

[TrevorH]

Is there a specific reason for requiring a newer version?

[avij]

My apologies, the 2.3.1 version is in CentOS 7, not in CentOS 6 :-/

[RunFastOrBeLast]

We are running asterisk realtime and want to use the pooling option only available in newer odbc.

[TrevorH]

http://www.unixodbc.org/doc/conn_pool.html says "As of release 2.0.0 of unixODBC the driver supports connection pooling".

[RunFastOrBeLast]

Indeed but here is why I wanted the latest version:

http://lists.digium.com/pipermail/aster ... 75580.html

I'm not sure when the bug first appeared.

[TrevorH]

Right. The correct thing to do would be to raise a ticket on bugzilla.redhat.com and reference the upstream bug report that Digium are talking about there (they don't actually say what it is) and see if RH can/will backport that to the EL6 version of unixODBC.

I went in search of the unixODBC changelog and it lists a threading fix in the changelog for 2.3.1 - in which case you might be able to either use CentOS 7 or rebuild the CentOS 7 SRPM using mock and target it at CentOS 6.

[RunFastOrBeLast]

My old version might not have the bug, I'll do some testings. I will look into mock for sure. Never used it.
Thanks a lot for your help.