Install a recent version of UnixODBC on CentOS 6.6?

General support questions
RunFastOrBeLast
Posts: 6
Joined: 2014/09/09 16:03:42

Install a recent version of UnixODBC on CentOS 6.6?

Postby RunFastOrBeLast » 2017/01/11 16:35:08

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...

User avatar
avij
Forum Moderator
Posts: 2180
Joined: 2010/12/01 19:25:52
Location: Helsinki, Finland
Contact:

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

Postby avij » 2017/01/11 17:24:39

There would be 2.3.1 in CentOS 6.8. Consider upgrading.

RunFastOrBeLast
Posts: 6
Joined: 2014/09/09 16:03:42

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

Postby RunFastOrBeLast » 2017/01/11 17:49:48

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

User avatar
TrevorH
Forum Moderator
Posts: 21213
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

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

Postby TrevorH » 2017/01/11 18:16:24

Is there a specific reason for requiring a newer version?
CentOS 5 died in March 2017 - migrate NOW!
Full time Geek, part time moderator. Use the FAQ Luke

User avatar
avij
Forum Moderator
Posts: 2180
Joined: 2010/12/01 19:25:52
Location: Helsinki, Finland
Contact:

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

Postby avij » 2017/01/11 18:17:44

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

RunFastOrBeLast
Posts: 6
Joined: 2014/09/09 16:03:42

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

Postby RunFastOrBeLast » 2017/01/11 19:15:50

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

User avatar
TrevorH
Forum Moderator
Posts: 21213
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

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

Postby TrevorH » 2017/01/11 20:41:20

http://www.unixodbc.org/doc/conn_pool.html says "As of release 2.0.0 of unixODBC the driver supports connection pooling".
CentOS 5 died in March 2017 - migrate NOW!
Full time Geek, part time moderator. Use the FAQ Luke

RunFastOrBeLast
Posts: 6
Joined: 2014/09/09 16:03:42

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

Postby RunFastOrBeLast » 2017/01/11 22:02:14

Indeed but here is why I wanted the latest version:

http://lists.digium.com/pipermail/asterisk-dev/2016-June/075580.html

I'm not sure when the bug first appeared.

User avatar
TrevorH
Forum Moderator
Posts: 21213
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

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

Postby TrevorH » 2017/01/11 22:06:18

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.
CentOS 5 died in March 2017 - migrate NOW!
Full time Geek, part time moderator. Use the FAQ Luke

RunFastOrBeLast
Posts: 6
Joined: 2014/09/09 16:03:42

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

Postby RunFastOrBeLast » 2017/01/12 21:24:50

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.