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)
On Mon, May 4, 2009 at 2:20 PM, Martin Koca
[email protected] wrote:
- Install the following gems:
fb (0.5.9)
fb_adapter (0.5.8)
-
Make sure that you have libfbclient.so in your /usr/lib
-
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
-
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.
Hi,
Fidel V. wrote:
…
-
Make sure that you have libfbclient.so in your /usr/lib
-
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
-
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
On Mon, May 4, 2009 at 3:10 PM, Martin Koca
[email protected] wrote:
- 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.
Fidel V. wrote:
On Mon, May 4, 2009 at 3:10 PM, Martin Koca
[email protected] wrote:
- 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
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