Re: configuring psqlodbc-13.00.0000 in RHEL7 64bit
Posted by satish on May 04, 2021; 7:03am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/configuring-psqlodbc-13-00-0000-in-RHEL7-64bit-tp9709p9723.html
Dear Erman,
I tried with different odbc version and in new test server.This time error is different.Can you guide us
I downloaded psqlodbc-09.03.0100.tar.gz and unzipped it and then ran the configure command
[root@erpdevelopmentdb psqlodbc-09.03.0100]# ./configure --prefix=/usr/psqlodbc --enable-pthreads
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... /usr/bin/mkdir -p
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
configure: error: odbc_config not found (required for unixODBC build)----->error
So installed unixODBC as below
[root@erpdevelopmentdb psqlodbc-09.03.0100]# yum install unixODBC
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
base | 2.9 kB 00:00:00
zabbix | 2.9 kB 00:00:00
zabbix-non-supported | 951 B 00:00:00
zabbix/x86_64/primary_db | 209 kB 00:00:01
Resolving Dependencies
--> Running transaction check
---> Package unixODBC.x86_64 0:2.3.1-11.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
========================================================================================================================================================================
Package Arch Version Repository Size
========================================================================================================================================================================
Installing:
unixODBC x86_64 2.3.1-11.el7 base 413 k
Transaction Summary
========================================================================================================================================================================
Install 1 Package
Total download size: 413 k
Installed size: 1.2 M
Is this ok [y/d/N]: y
Downloading packages:
unixODBC-2.3.1-11.el7.x86_64.rpm | 413 kB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : unixODBC-2.3.1-11.el7.x86_64 1/1
Verifying : unixODBC-2.3.1-11.el7.x86_64 1/1
Installed:
unixODBC.x86_64 0:2.3.1-11.el7
Complete!
Then ran configure command again,this time error is "configure: error: libpq library not found"
erpdevelopmentdb psqlodbc-09.03.0100]# pwd
/ERPShareddrive/ERP/opm/satish/psqlodbc-09.03.0100
[root@erpdevelopmentdb psqlodbc-09.03.0100]# ./configure --prefix=/usr/psqlodbc --enable-pthreads
checking for a BSD-compatible install... /usr/bin/install -
checking for unistd.h... yes
checking for dlfcn.h... yes
checking for objdir... .libs
checking if gcc supports -fno-rtti -fno-exceptions... no
checking for gcc option to produce PIC... -fPIC -DPI
checking for pthread_create in -lpthreads... no
checking for pthread_create in -lpthread... yes
checking for PQconnectdb in -lpq... no
configure: error: libpq library not found
[root@erpdevelopmentdb psqlodbc-09.03.0100]#
Do we need to install any postgresql odbc before running above configure command?
Thanks,
SG