[Firebird-odbc-devel] Problem installing ODBC driver on CentOS 7 linux

[Nagy Szilveszter]

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

I followed Marius Popa's instructions, from FB main site: http://www.firebirdnews.org/howto-install-firebird-odbc-driver-for-unixodbc-from-source/
First i installed firebird-superserver, gcc-c++ and unixodbc packets...no problem here.
But when compiling the ODBC driver i get this error:

[***@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/libmkdir: cannot create directory ‘Release_x86_64’: File existsmake: [createdirs] Error 1 (ignored)mkdir: cannot create directory ‘Release_x86_64/obj’: File existsmake: [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.oIn 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, 2014 | OdbcFb-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:

[***@pali2 Gcc.lin]# cat /etc/odbcinst.ini
[Firebird]Description = Firebird ODBC DriverDriver = /usr/lib/firebird/libOdbcFb.soSetup = /usr/lib/firebird/libOdbcJdbcS.soThreading = 1FileUsage = 1CPTimeout =CPReuse =

[***@pali2 Gcc.lin]# cat /etc/odbc.ini[sample]Description = FirebirdDriver = FirebirdDbname = localhost:/data/sample.fdbUser = SYSDBAPassword = masterkeyRole =CharacterSet = UTF8ReadOnly = NoNoWait = No


When trying to connect i get this error:

[***@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:

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




Here is my system's architecture:

[***@pali2 Gcc.lin]# uname -aLinux 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

[Dimitry Sibiryakov]

Post by Nagy Szilveszter
First i installed firebird-superserver,
../../IscDbc/IscDbc.h:33:19: fatal error: ibase.h: No such file or directory

Error is obviously telling that you either didn't install Firebird or CentOS package
doesn't put headers into /usr/include.

[Nagy Szilveszter]

Thank you, i am one step closer now.
The firebird-superserver package was installed before, but now i also installed firebird-devel package and it created /usr/include/ibase.h file.
Now i have another error: sqltypes.h is missing.
What package should i install to have it?

Post by Nagy Szilveszter
First i installed firebird-superserver,
../../IscDbc/IscDbc.h:33:19: fatal error: ibase.h: No such file or directory

  Error is obviously telling that you either didn't install Firebird or CentOS package
doesn't put headers into /usr/include.

[Dimitry Sibiryakov]

Post by Nagy Szilveszter
Now i have another error: sqltypes.h is missing.
What package should i install to have it?

http://xmodulo.com/how-to-find-what-package-file-belongs-to-on-centos-fedora.html

[Nagy Szilveszter]

Ok i found it, i also installed unixODBC-devel package and the make was successful.
Thank you very much guys!

On Tuesday, February 9, 2016 9:59 PM, Nagy Szilveszter <***@yahoo.com> wrote:


Ok i found it, i also installed unixODBC-devel package and the make was successful.
Thank you very much guys!





On Tuesday, February 9, 2016 9:40 PM, Nagy Szilveszter <***@yahoo.com> wrote:


Thank you, i am one step closer now.
The firebird-superserver package was installed before, but now i also installed firebird-devel package and it created /usr/include/ibase.h file.
Now i have another error: sqltypes.h is missing.
What package should i install to have it?

Post by Nagy Szilveszter
First i installed firebird-superserver,
../../IscDbc/IscDbc.h:33:19: fatal error: ibase.h: No such file or directory

  Error is obviously telling that you either didn't install Firebird or CentOS package
doesn't put headers into /usr/include.