Subject Re: Firebird 1.5.2 Remote Connection Problem
Author matt_demaray
I setup the alias and again it connects fine locally on the linux box,
but gives the sames error from the windows box.

It is definitely the firebird server listening on port 3050 because if
I set the firebird xinetd.conf file to 'disable = yes', run
killall -HUP xinetd and do netstat again nothing is listening.
Changing it back to 'disable = no' and restarting xinetd shows the
port being listened on again.

Thanks,

Matt

--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:
>
> That is fine, it is just making a successful TCP connection (not a
> database connection). That tells you that the Firebird service is in
> fact running, (unless some other service like an old interbase
> install is already listening to port 3050). It also tells you that
> you have no firewall issue connecting to it.
>
> Can you setup an alias in aliases.conf
>
> MyDB = /opt/firebird/examples/employee.fdb
>
> Then confirm you can connect from the linux box with the connection
> string
>
> linux1:MyDB
>
> If that works, then do the same from the client machine. And let us
> know how you go.
>
> Adam
>
>
>
> --- In firebird-support@yahoogroups.com, "matt_demaray"
> <matt_demaray@y...> wrote:
> >
> > It returns a blank screen, hitting a key gives you the prompt back.
> > No errors are given, but no entry is added to the firebird.log
> either.
> >
> > Matt
> >
> > --- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...>
> wrote:
> > >
> > > Hi Matt,
> > >
> > > Does the following command work from a dos box in the windows
> client?
> > >
> > > telnet linux1 3050
> > >
> > > work (ie: return a blank screen) or
> > > not work (ie: say connection refused or similar error message)
> > >
> > > Adam
> > >
> > > --- In firebird-support@yahoogroups.com, "matt_demaray"
> > > <matt_demaray@y...> wrote:
> > > >
> > > >
> > > > I'm having a problem connecting to a firebird 1.5.2 classic
> server
> > > > running on linux. I'm trying to connect using isql from
> windows (I
> > > > did a firebird 1.5.2 client-only install on the windows pc). I
> can
> > > > connect to it locally just fine using isql on the linux server
> > > > ('connect localhost:/opt/firebird/examples/employee.fdb').
> > > >
> > > > When I try to connect from windows using isql it gives me this
> > > message:
> > > >
> > > > SQL> connect linux1:/opt/firebird/examples/employee.fdb;
> > > > Statement failed, SQLCODE = -902
> > > >
> > > > Unable to complete network request to host "linux1".
> > > > -Failed to establish a connection.
> > > > -The system could not find the environment option that was
> entered.
> > > >
> > > > I can ping linux1 just fine, and netstat on the linux server
> tells
> > > me
> > > > that port 3050 is being listened on.
> > > > I'm using xinetd for starting the server and the correct
> firebird
> > > > startup script is in the xinetd.d directory.
> > > > Also, I have checked the permissions of the employee.fdb
> database
> > > and
> > > > they are set correctly at 660 with owner and group being
> firebird.
> > > > For testing purposes I set my hosts.equiv file to '+ +' to allow
> > > > anyone from anywhere. There is no firewall installed on the
> server
> > > > and only a switch between the server and the windows pc. The
> > > windows
> > > > pc can connect fine to other servers running interbase 5.6
> > > >
> > > > Lastly, no entries are added to the firebird.log file when I
> try to
> > > > connect to the linux server from the windows pc.
> > > >
> > > > I'm stumped. Any help would be greatly appreciated.
> > > >
> > > > Thanks,
> > > >
> > > > Matt