Picon

Fw: [firebird-support] Problem installing ODBC driver on CentOS 7 linux





 
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:

[root <at> 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, 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:

[root <at> 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 <at> 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 <at> 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 <at> 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 <at> 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



#yiv9807799491 -- #yiv9807799491ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;} #yiv9807799491 #yiv9807799491ygrp-mkp hr { border:1px solid #d8d8d8;} #yiv9807799491 #yiv9807799491ygrp-mkp #yiv9807799491hd { color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;} #yiv9807799491 #yiv9807799491ygrp-mkp #yiv9807799491ads { margin-bottom:10px;} #yiv9807799491 #yiv9807799491ygrp-mkp .yiv9807799491ad { padding:0 0;} #yiv9807799491 #yiv9807799491ygrp-mkp .yiv9807799491ad p { margin:0;} #yiv9807799491 #yiv9807799491ygrp-mkp .yiv9807799491ad a { color:#0000ff;text-decoration:none;} #yiv9807799491 #yiv9807799491ygrp-sponsor #yiv9807799491ygrp-lc { font-family:Arial;} #yiv9807799491 #yiv9807799491ygrp-sponsor #yiv9807799491ygrp-lc #yiv9807799491hd { margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;} #yiv9807799491 #yiv9807799491ygrp-sponsor #yiv9807799491ygrp-lc .yiv9807799491ad { margin-bottom:10px;padding:0 0;} #yiv9807799491 #yiv9807799491actions { font-family:Verdana;font-size:11px;padding:10px 0;} #yiv9807799491 #yiv9807799491activity { background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;} #yiv9807799491 #yiv9807799491activity span { font-weight:700;} #yiv9807799491 #yiv9807799491activity span:first-child { text-transform:uppercase;} #yiv9807799491 #yiv9807799491activity span a { color:#5085b6;text-decoration:none;} #yiv9807799491 #yiv9807799491activity span span { color:#ff7900;} #yiv9807799491 #yiv9807799491activity span .yiv9807799491underline { text-decoration:underline;} #yiv9807799491 .yiv9807799491attach { clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;} #yiv9807799491 .yiv9807799491attach div a { text-decoration:none;} #yiv9807799491 .yiv9807799491attach img { border:none;padding-right:5px;} #yiv9807799491 .yiv9807799491attach label { display:block;margin-bottom:5px;} #yiv9807799491 .yiv9807799491attach label a { text-decoration:none;} #yiv9807799491 blockquote { margin:0 0 0 4px;} #yiv9807799491 .yiv9807799491bold { font-family:Arial;font-size:13px;font-weight:700;} #yiv9807799491 .yiv9807799491bold a { text-decoration:none;} #yiv9807799491 dd.yiv9807799491last p a { font-family:Verdana;font-weight:700;} #yiv9807799491 dd.yiv9807799491last p span { margin-right:10px;font-family:Verdana;font-weight:700;} #yiv9807799491 dd.yiv9807799491last p span.yiv9807799491yshortcuts { margin-right:0;} #yiv9807799491 div.yiv9807799491attach-table div div a { text-decoration:none;} #yiv9807799491 div.yiv9807799491attach-table { width:400px;} #yiv9807799491 div.yiv9807799491file-title a, #yiv9807799491 div.yiv9807799491file-title a:active, #yiv9807799491 div.yiv9807799491file-title a:hover, #yiv9807799491 div.yiv9807799491file-title a:visited { text-decoration:none;} #yiv9807799491 div.yiv9807799491photo-title a, #yiv9807799491 div.yiv9807799491photo-title a:active, #yiv9807799491 div.yiv9807799491photo-title a:hover, #yiv9807799491 div.yiv9807799491photo-title a:visited { text-decoration:none;} #yiv9807799491 div#yiv9807799491ygrp-mlmsg #yiv9807799491ygrp-msg p a span.yiv9807799491yshortcuts { font-family:Verdana;font-size:10px;font-weight:normal;} #yiv9807799491 .yiv9807799491green { color:#628c2a;} #yiv9807799491 .yiv9807799491MsoNormal { margin:0 0 0 0;} #yiv9807799491 o { font-size:0;} #yiv9807799491 #yiv9807799491photos div { float:left;width:72px;} #yiv9807799491 #yiv9807799491photos div div { border:1px solid #666666;height:62px;overflow:hidden;width:62px;} #yiv9807799491 #yiv9807799491photos div label { color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;} #yiv9807799491 #yiv9807799491reco-category { font-size:77%;} #yiv9807799491 #yiv9807799491reco-desc { font-size:77%;} #yiv9807799491 .yiv9807799491replbq { margin:4px;} #yiv9807799491 #yiv9807799491ygrp-actbar div a:first-child { margin-right:2px;padding-right:5px;} #yiv9807799491 #yiv9807799491ygrp-mlmsg { font-size:13px;font-family:Arial, helvetica, clean, sans-serif;} #yiv9807799491 #yiv9807799491ygrp-mlmsg table { font-size:inherit;font:100%;} #yiv9807799491 #yiv9807799491ygrp-mlmsg select, #yiv9807799491 input, #yiv9807799491 textarea { font:99% Arial, Helvetica, clean, sans-serif;} #yiv9807799491 #yiv9807799491ygrp-mlmsg pre, #yiv9807799491 code { font:115% monospace;} #yiv9807799491 #yiv9807799491ygrp-mlmsg * { line-height:1.22em;} #yiv9807799491 #yiv9807799491ygrp-mlmsg #yiv9807799491logo { padding-bottom:10px;} #yiv9807799491 #yiv9807799491ygrp-msg p a { font-family:Verdana;} #yiv9807799491 #yiv9807799491ygrp-msg p#yiv9807799491attach-count span { color:#1E66AE;font-weight:700;} #yiv9807799491 #yiv9807799491ygrp-reco #yiv9807799491reco-head { color:#ff7900;font-weight:700;} #yiv9807799491 #yiv9807799491ygrp-reco { margin-bottom:20px;padding:0px;} #yiv9807799491 #yiv9807799491ygrp-sponsor #yiv9807799491ov li a { font-size:130%;text-decoration:none;} #yiv9807799491 #yiv9807799491ygrp-sponsor #yiv9807799491ov li { font-size:77%;list-style-type:square;padding:6px 0;} #yiv9807799491 #yiv9807799491ygrp-sponsor #yiv9807799491ov ul { margin:0;padding:0 0 0 8px;} #yiv9807799491 #yiv9807799491ygrp-text { font-family:Georgia;} #yiv9807799491 #yiv9807799491ygrp-text p { margin:0 0 1em 0;} #yiv9807799491 #yiv9807799491ygrp-text tt { font-size:120%;} #yiv9807799491 #yiv9807799491ygrp-vital ul li:last-child { border-right:none !important;} #yiv9807799491




__._,_.___
Posted by: Nagy Szilveszter <nagy_szilveszter <at> yahoo.com>


Picon

Firebird Language Reference 2.5 (English) Beta 1 (pdf) and (html).

Firebird Language Reference 2.5 (English) Beta 1 (pdf) and (html). The review of the translated text has got this far, thanks to the efforts of Paul Vinkenoog and Mark Rotteveel. Unfortunately, we didn't get any more Englsh speakers to help with the review, so there is still a way to go. (Helen Borrie).


If you find any typos or mistak es, please report to firebird-docs


http://www.firebirdsql.org/en/mailing-lists/




__._,_.___
Posted by: mapopa <at> gmail.com


Picon

C++ Exception Handling

Dear all, (apologies if you receive multiple copies)

We are investigating the use of C++ exception handling constructs in well known open-source C++ systems, and have published some results in the last International Conference on Source Code Analysis and Manipulation [1] 

We are expanding this research to a broader community, so I kindly invite you to answer our new version of the survey at:

https://www.surveymonkey.com/r/SXCB7WJ

Sincerely,

Rodrigo Bonifácio (on behalf of the authors of this research effort).

[1] "The use of C++ exception handling constructs: A comprehensive study"
http://dx.doi.org/10.1109/SCAM.2015.7335398


__._,_.___
Posted by: Rodrigo Bonifacio <rbonifacio123 <at> gmail.com>


Picon

Database Workbench 5.1.10 released

This release adds a few small features and includes Windows Terminal Server support.

Change log available for version 5.1.x.




__._,_.___
Posted by: mapopa <at> gmail.com


Picon

Raspberry Pi Zero: The new $5 Raspberry Pi Database server

Meet Raspberry Pi Zero: The new $5 Raspberry Pi

The cheapest way to run Firebird SQL on your own hardware. (Debian ARM)

https://www.raspberrypi.org/blog/raspberry-pi-zero/




__._,_.___
Posted by: mapopa <at> gmail.com


Picon

Modern SQL: With – Organize Complex Queries

Thread via HackerNews

https://news.ycombinator.com/item?id=10620057





__._,_.___
Posted by: mapopa <at> gmail.com


Picon

IBObjects Version 5.7.7 Build 2340 is released with Delphi 10 support

BObjects Version 5.7.7 [Build 2340] is released 

Jason announced the newest release of IB Objects to all download areas.
For registered users, please go to http://community.ibobjects.comand update your annual subscription if necessary. Thanks to all who continue to support IB Objects!

You can try Evaluation Kit on Lazarus/Delphi IDEs 
 http://www.ibobjects.com/ibodownload.html

Here is an excerpt from the release notes about what has been done since the last release.

http://www.ibobjects.com/ReleaseNotes.htm




__._,_.___
Posted by: mapopa <at> gmail.com


Picon

Firebird 3.0 RC1 is now released

Firebird Project announces the first Release Candidate of Firebird 3.0, the next major version of the Firebird relational database, which is now available for testing.


http://www.firebirdsql.org/en/firebird-3-0-0-rc1/




__._,_.___
Posted by: mapopa <at> gmail.com


Picon

Jaybird 2.2.9 released

I have just released Jaybird 2.2.9.

The release can be downloaded from 
http://www.firebirdsql.org/en/jdbc-driver/ or 
https://github.com/FirebirdSQL/jaybird/releases/tag/v2.2.9

The release is also available on maven(*):

      <groupId>org.firebirdsql.jdbc</groupId>
      <artifactId>jaybird-jdkXX</artifactId>
      <version>2.2.9</version>

* The artifactId depends on your target Java version: jaybird-jdk18,
jaybird-jdk17, or jaybird-jdk16.

The following has been changed or fixed since Jaybird 2.2.8:

* Fixed: Result set of type CLOSE_CURSORS_AT_COMMIT isn't correctly 
closed on commit (JDBC-307)
* Fixed: Open (output) blob in auto-commit prevents connection close. 
Fixed by fixing JDBC-307, see above. (JDBC-348)
* New feature (experimental): Use isc_tpb_autocommit in auto commit mode 
(JDBC-399)
* Fixed: "Exception. couldn't close blob: 
org.firebirdsql.gds.GDSException: invalid BLOB handle" on close of 
connection obtained from DBCP data source. Fixed by fixing JDBC-307, see 
above. (JDBC-400)
* Fixed: CallableStatement.getMetaData() and getParameterMetaData() call 
throws exception when no input parameters provided when out parameter 
registered (JDBC-402)
* Change: ResultSetMetaData will now report (VAR)CHAR CHARACTER SET 
OCTETS columns as Types.BINARY or Types.VARBINARY when using 
octetsAsBytes=true connection property. (JDBC-408)

More information is available in the release notes at
http://www.firebirdsql.org/file/documentation/drivers_documentation/java/2.2.9/release_notes.html

Kind regards,
Mark Rotteveel
--

-- 
Mark Rotteveel

------------------------------------
Posted by: Mark Rotteveel <mark <at> lawinegevaar.nl>
------------------------------------

Picon

Firebird Converter 1.0.0 is released (convertor between firebird versions)

FBConverter is a database converter for Firebird 


https://github.com/tomneko/fbconverter/tree/master/Release




__._,_.___
Posted by: mapopa <at> gmail.com


Picon

Node Firebird driver node-firebird 0.7.0 is released with bugfixes and improvements

New release for node-firebird driver with one bug fix and a few improvements :

Fix a problem with sequential read (#78)

Improvement : Reading of fetched packet

Experimental : Add params to connection (cacheQuery and maxCachedQuery).
when cacheQuery is set to true each query is cached for faster re-use during the connection like in Jaybird.
after the query is cached these steps are saved :

  1. Query allocation
  2. Com pilation and Plan
  3. Describe




__._,_.___
Posted by: mapopa <at> gmail.com



Gmane