Subject Re: Firebird on Ubuntu (server)
Author Mike
hello all and thanks in advance for any help, and also please excuse
any obvious newbie Linux mistakes on my end. I am trying to move to
Linux away from my win2K3 server. I host tomcat and use firebird on
win2K3 and want to move all that to Linux,

Here is my problem;

I cannot connect to the localhost using isql. I get the following error,

SQL> connect 'localhost:employee.fdb';

Statement failed, SQLCODE = -902

Unable to complete network request to host "localhost".

-Failed to establish a connection.

-Connection refused

I have also tried;

SQL> connect 'localhost:employee.fdb' user 'SYSDBA' password 'masterkey';

Statement failed, SQLCODE = -902

Unable to complete network request to host "localhost".

-Failed to establish a connection.

-Connection refused

I am using ubuntu 7.04 with Firebird FirebirdCS-

I unpacked and ran the install script and it reported installing fine.

I can connect to the emplyee.fdb using isql with the directory path
only. for instance;

connect employee

this connects fine.

I have made no other changes and followed all the steps in the
readme.user.troubleshooting, including steps 2,3 and 4.

I am new to Linux, and am attempting to use ubuntu in place of my
win2k3 server. My ultimate goal is to use firebird with Tomcat. I have
some Tomcat applications that use JNDI, and the datasource URL is very
important. Hence my desire to use the localhost.

I have tried using my machine name, "ubuntu", "" to no avail.

I am not sure what or if any firewall is blocking it? I don't even
know where to start for that.

Some things from the trouble shooting I have tried and their results

root@ubuntu:/opt/firebird/bin# cat /etc/services | grep gds

gds_db 3050/tcp # InterBase server

gds_db 3050/udp

root@ubuntu:/opt/firebird/bin# cat /etc/inetd.conf | grep gds

gds_db stream tcp nowait.30000 firebird
/opt/firebird/bin/fb_inet_server fb_inet_server # Firebird Database
Remote Serve

I have tried to start the fb_inet_server from the bin directory, but
cannot seem to get anything working. after I start the server with
./fb_inet_server start, if I do this I get;

michael@ubuntu:~$ top -b -n1 | grep fb

7041 root 18 0 3468 1224 1008 S 0 0.1 0:00.00

9718 root 17 0 7536 2228 1856 S 0 0.2 0:00.00 fb_inet_serve

but still I cannot see it listening on port 3050 with

netstat -an | grep 3050

Any direction or help is appreciated!

--- In, Frank Schlottmann-Gödde
<frank@...> wrote:
> hanszorn2000 schrieb:
> > Hi,
> >
> > I am trying to get Firebird (classic 1.5x) working on the above.
> > Installing succeeded using apt-get etc. The only problem is: it
> > doesn't work. All I get when trying to connect to the server (from a
> > remote client) is: 'cannot attach to password database'.
> > Also, when I do GSEC on the server itself, it tells me a little more:
> > Operating directive open failed
> > No such file or directory
> > unable to open database
> >
> > Now it seems to me there are some post-install instructions that have
> > to be executed before use, but can anybody tell me what or where
they are?
> No real idea, I'm running FB2.0 on Ubuntu with no problems. Could you
> please check where your security2.fdb is installed and that the
> server has the appropriate rights to access it?
> Frank
> --
> "Fascinating creatures, phoenixes, they can carry immensely heavy loads,
> their tears have healing powers and they make highly faithful pets."
> - J.K. Rowling