Firebird issue in fb.so - ruby: symbol lookup error:

Rails
1

Hi,
I want to connect to firebird db via RoR application. But when I attempt
to connect then server shutdown with the following error :

ruby: symbol lookup error: /usr/lib/ruby/gems/1.8/gems/fb-0.5.9/./fb.so:
undefined symbol: isc_attach_database

I have tried to figure out the solution, but without success. I think I
don’t have some library, but …? Do you have any idea, clues ?

Thank you in advance
koca

32bit Linux (CentOS)

rails --version

Rails 2.3.2

ruby --version

ruby 1.8.5 (2006-08-25) [i386-linux]

gem list

*** LOCAL GEMS ***

actionmailer (2.3.2, 2.2.2)
actionpack (2.3.2, 2.2.2)
activerecord (2.3.2, 2.2.2)
activeresource (2.3.2, 2.2.2)
activesupport (2.3.2, 2.2.2)
capistrano (2.5.5)
cgi_multipart_eof_fix (2.5.0)
daemons (1.0.10)
diff-lcs (1.1.2)
echoe (3.1.1)
fastthread (1.0.7, 1.0.4, 1.0.1)
fb (0.5.9)
fb_adapter (0.5.8)
fireruby (0.4.3)
gem_plugin (0.2.3)
highline (1.5.0)
mongrel (1.1.5)
mongrel_cluster (1.0.5)
mysql (2.7)
net-scp (1.0.2)
net-sftp (2.0.2)
net-ssh (2.0.11)
net-ssh-gateway (1.0.1)
passenger (2.2.2, 2.1.2, 2.0.6)
prawn (0.4.1)
prawn-layout (0.1.0)
rack (1.0.0, 0.9.1)
rails (2.3.2, 2.2.2)
rails-firephp (0.0.1)
rake (0.8.4)
rcov (0.8.1.2.0)
rmagick (2.9.1)
rubyforge (1.0.3)
searchlogic (1.6.6, 1.6.5)

2

On Mon, May 4, 2009 at 2:20 PM, Martin Koca
[email protected] wrote:

  1. Install the following gems:

fb (0.5.9)
fb_adapter (0.5.8)

  1. Make sure that you have libfbclient.so in your /usr/lib

  2. Go to where fb-0.5.9 folder is. In mine it is found at
    /usr/lib/ruby/gems/1.8/gems/fb-0.5.9

  3. Type sudo make install. This will build the fb.so for the version
    of firebird you are using. I have tried it with FB 2.0.x and 2.1.x

That’s it.

Hope that solves your problem.

All the best,

Fidel.

3

Hi,

Fidel V. wrote:
…

  1. Make sure that you have libfbclient.so in your /usr/lib

  2. Go to where fb-0.5.9 folder is. In mine it is found at
    /usr/lib/ruby/gems/1.8/gems/fb-0.5.9

  3. Type sudo make install. This will build the fb.so for the version
    of firebird you are using. I have tried it with FB 2.0.x and 2.1.x

thanks, but the problem still persists. If I try make install then
“make: Nothing to be done for `install’.”
So if I perform make clean and then make install and then try to attempt
to connect I get the same error.
ruby: symbol lookup error: /usr/lib/ruby/gems/1.8/gems/fb-0.5.9/./fb.so:
undefined symbol: isc_attach_database

Just a note that I get some warnings for make install too, eg. :
fb.c: In function ‘fb_error_check’:
fb.c:380: warning: passing argument 1 of ‘isc_sqlcode’ from incompatible
pointer type

(I’m trying to connect like :
db = Database.new(
:database => “x.x.x.x:d:\database\tesdb.gdb”,
:username => ‘username’,
:password => ‘password’)
conn = db.connect rescue db.create.connect
)

Thanks
koca

4

On Mon, May 4, 2009 at 3:10 PM, Martin Koca
[email protected] wrote:

  1. Type sudo make install. This will build the fb.so for the version
    of firebird you are using. I have tried it with FB 2.0.x and 2.1.x

thanks, but the problem still persists. If I try make install then
“make: Nothing to be done for `install’.”
So if I perform make clean and then make install and then try to attempt
to connect I get the same error.
ruby: symbol lookup error: /usr/lib/ruby/gems/1.8/gems/fb-0.5.9/./fb.so:
undefined symbol: isc_attach_database

Which version of Firebird are you using and how did you install it?
Was it from the repository? Or from the rpm?

I have installed mine from the .tar.gz archive, and it created the
symbolic links for all the libraries in /opt/firebird/lib to /usr/lib

I know if you install from the repository (at least for Ubuntu), you
will need to install also firebird-devel.

   conn = db.connect rescue db.create.connect

)

That seems to be ok, but the path should be /database/testdb.gdb. Are
you using interbase or firebird? Or is it just a habit from interbase
to give your database files a .gdb extension?

Anyway, try to check if you have the development libraries all in
place. When I first installed the fb gem, I had the same error you
did, but then I cleaned up all the fb libraries in /usr/lib and then
created the symbolic links by hand, and that solved my problem. But,
as I said, I installed from the .tar.gz archive on Ubuntu. Don’t know
if the same will resolve your issue with CentOS, but I think it
should.

Hope that helps you solve your problem.

Fidel.

5

Fidel V. wrote:

On Mon, May 4, 2009 at 3:10 PM, Martin Koca
[email protected] wrote:

  1. Type sudo make install. This will build the fb.so for the version
    of firebird you are using. I have tried it with FB 2.0.x and 2.1.x

thanks, but the problem still persists. If I try make install then
“make: Nothing to be done for `install’.”
So if I perform make clean and then make install and then try to attempt
to connect I get the same error.
ruby: symbol lookup error: /usr/lib/ruby/gems/1.8/gems/fb-0.5.9/./fb.so:
undefined symbol: isc_attach_database

Which version of Firebird are you using and how did you install it?
Was it from the repository? Or from the rpm?

FirebirdCS-2.1.2.18118-0.i686.rpm, but I have tried older version too.
This package is from the rpm, because in the repo is no Firebird
available. Hope this include devel too. I have checked libraries in the
/usr/lib and it looks sane. I’m going to delete them and add manually.

I have installed mine from the .tar.gz archive, and it created the
symbolic links for all the libraries in /opt/firebird/lib to /usr/lib

I know if you install from the repository (at least for Ubuntu), you
will need to install also firebird-devel.

� � � �conn = db.connect rescue db.create.connect
)

That seems to be ok, but the path should be /database/testdb.gdb. Are
you using interbase or firebird? Or is it just a habit from interbase
to give your database files a .gdb extension?

Anyway, try to check if you have the development libraries all in
place. When I first installed the fb gem, I had the same error you
did, but then I cleaned up all the fb libraries in /usr/lib and then
created the symbolic links by hand, and that solved my problem. But,
as I said, I installed from the .tar.gz archive on Ubuntu. Don’t know
if the same will resolve your issue with CentOS, but I think it
should.

I will try. Libraries looks sane.

Hope that helps you solve your problem.

Fidel.

Thanks
koca

6

Hello,

I would like to know if this issue has been resolved. I have the same
problems at the moment on a opensuse 11.1 box.

Regards
M4rtijn