Subject Problem installing ODBC driver on CentOS 7 linux
Author Nagy Szilveszter
Post date 2016-02-08T11:12:21Z
Hello all!

Please somebody help me with installing ODBC driver on CcentOS linux. I need it to make Sphinx work.



First i installed firebird-superserver, gcc-c++ and unixodbc packets...no problem here.

But when compiling the ODBC driver i get this error:

[root@pali2 Gcc.lin]# make -f makefile.linux
../makefile.environ:6: ARCH is x86_64
../makefile.environ:21: ODBCMANAGER is unixODBC in /usr/lib64
../makefile.environ:50: FBINCDIR is /usr/lib64/firebird/include
../makefile.environ:56: FBLIBDIR is /usr/lib64/firebird/lib
mkdir: cannot create directory ‘Release_x86_64’: File exists
make: [createdirs] Error 1 (ignored)
mkdir: cannot create directory ‘Release_x86_64/obj’: File exists
make: [createdirs] Error 1 (ignored)
g++ -w -D_REENTRANT -D_PTHREADS -DEXTERNAL -DunixODBC -I/usr/include -I/usr/lib64/firebird/include -I/include -I/usr/lib64/firebird/include -fPIC -m64 -DNDEBUG -c ../../IscDbc/Attachment.cpp -o Release_x86_64/obj/Attachment.o
In file included from ../../IscDbc/Attachment.cpp:35:0:
../../IscDbc/IscDbc.h:33:19: fatal error: ibase.h: No such file or directory
 #include <ibase.h>
                   ^
compilation terminated.
make: *** [Release_x86_64/obj/Attachment.o] Error 1



Then i tried another way:

I downloaded the ready-to-run version ODBC driver, from FB main site:
November 26, 2014OdbcFb-LIB-2.0.3.154.i686.gz
1.0 MB
Linux x86 Library


I unzipped and copied it to /usr/lib/firebird/libOdbcFb.so

I also made 2 another copies because the provided odbc config referred to libOdbcJdbc.so and libOdbcJdbcS.so files, and i had none of them. I guess the compiler should create them.

(Note: First i tried with symlinks, but not working i created real copies. But also not working.)


Here are odbc configs:

[root@pali2 Gcc.lin]# cat /etc/odbcinst.ini

[Firebird]
Description = Firebird ODBC Driver
Driver = /usr/lib/firebird/libOdbcFb.so
Setup = /usr/lib/firebird/libOdbcJdbcS.so
Threading = 1
FileUsage = 1
CPTimeout =
CPReuse =


[root@pali2 Gcc.lin]# cat /etc/odbc.ini
[sample]
Description = Firebird
Driver = Firebird
Dbname = localhost:/data/sample.fdb
User = SYSDBA
Password = masterkey
Role =
CharacterSet = UTF8
ReadOnly = No
NoWait = No


When trying to connect i get this error:

[root@pali2 Gcc.lin]# isql -v sample
[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/firebird/libOdbcJdbc.so' : file not found
[ISQL]ERROR: Could not SQLConnect

The /usr/lib/firebird/libOdbcJdbc.so file DOES EXIST.
On a forum i read that someone had the same issue and installing libstdc++ solved the problem.
But i had it installed before:

[root@pali2 Gcc.lin]# rpm -qa | grep libstdc++
libstdc++-4.8.5-4.el7.x86_64
libstdc++-devel-4.8.5-4.el7.x86_64




Here is my system's architecture:

[root@pali2 Gcc.lin]# uname -a
Linux pali2 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux
 

Please help me!

Thank you,
Szilveszter