Problem installing ODBC driver on CentOS 7 linux

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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.



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






------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Problem installing ODBC driver on CentOS 7 linux

Dimitry Sibiryakov-3
09.02.2016 1:17, Nagy Szilveszter wrote:
> 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.

--
   WBR, SD.

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Problem installing ODBC driver on CentOS 7 linux

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?


Here is the output of make:



[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/include
../makefile.environ:56: FBLIBDIR is /usr/lib64
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/include -I/include -I/usr/include -fPIC -m64 -DNDEBUG -c ../../IscDbc/IscArray.cpp -o Release_x86_64/obj/IscArray.o
In file included from ../../IscDbc/IscStatement.h:30:0,
                 from ../../IscDbc/IscArray.cpp:34:
../../IscDbc/Sqlda.h:29:22: fatal error: sqltypes.h: No such file or directory
 #include <sqltypes.h>
                      ^
compilation terminated.
make: *** [Release_x86_64/obj/IscArray.o] Error 1
[root@pali2 Gcc.lin]#












On Tuesday, February 9, 2016 12:10 PM, Dimitry Sibiryakov <[hidden email]> wrote:


09.02.2016 1:17, Nagy Szilveszter wrote:

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

--
  WBR, SD.

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel




------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Problem installing ODBC driver on CentOS 7 linux

Dimitry Sibiryakov-3
09.02.2016 20:40, Nagy Szilveszter wrote:
> 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

--
   WBR, SD.

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Problem installing ODBC driver on CentOS 7 linux

Nagy Szilveszter
In reply to this post by 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 <[hidden email]> 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 <[hidden email]> 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?


Here is the output of make:



[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/include
../makefile.environ:56: FBLIBDIR is /usr/lib64
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/include -I/include -I/usr/include -fPIC -m64 -DNDEBUG -c ../../IscDbc/IscArray.cpp -o Release_x86_64/obj/IscArray.o
In file included from ../../IscDbc/IscStatement.h:30:0,
                 from ../../IscDbc/IscArray.cpp:34:
../../IscDbc/Sqlda.h:29:22: fatal error: sqltypes.h: No such file or directory
 #include <sqltypes.h>
                      ^
compilation terminated.
make: *** [Release_x86_64/obj/IscArray.o] Error 1
[root@pali2 Gcc.lin]#












On Tuesday, February 9, 2016 12:10 PM, Dimitry Sibiryakov <[hidden email]> wrote:


09.02.2016 1:17, Nagy Szilveszter wrote:

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

--
  WBR, SD.

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel








------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Loading...