Page 1 of 1

Install a recent version of UnixODBC on CentOS 6.6?

Posted: 2017/01/11 16:35:08
by 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...

Re: Install a recent version of UnixODBC on CentOS 6.6?

Posted: 2017/01/11 17:24:39
by avij
There would be 2.3.1 in CentOS 6.8. Consider upgrading.

Re: Install a recent version of UnixODBC on CentOS 6.6?

Posted: 2017/01/11 17:49:48
by 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

Re: Install a recent version of UnixODBC on CentOS 6.6?

Posted: 2017/01/11 18:16:24
by TrevorH
Is there a specific reason for requiring a newer version?

Re: Install a recent version of UnixODBC on CentOS 6.6?

Posted: 2017/01/11 18:17:44
by avij
My apologies, the 2.3.1 version is in CentOS 7, not in CentOS 6 :-/

Re: Install a recent version of UnixODBC on CentOS 6.6?

Posted: 2017/01/11 19:15:50
by RunFastOrBeLast
We are running asterisk realtime and want to use the pooling option only available in newer odbc.

Re: Install a recent version of UnixODBC on CentOS 6.6?

Posted: 2017/01/11 20:41:20
by TrevorH
http://www.unixodbc.org/doc/conn_pool.html says "As of release 2.0.0 of unixODBC the driver supports connection pooling".

Re: Install a recent version of UnixODBC on CentOS 6.6?

Posted: 2017/01/11 22:02:14
by 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.

Re: Install a recent version of UnixODBC on CentOS 6.6?

Posted: 2017/01/11 22:06:18
by 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.

Re: Install a recent version of UnixODBC on CentOS 6.6?

Posted: 2017/01/12 21:24:50
by 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.