Hello,

I'm trying to connect to the firebird server over the network, but it does not work:

./isql -u sysdba -p pass localhost:/opt/firebird/bin/fb.fdb --> works fine
./isql -u sysdba -p pass 127.0.0.1:/opt/firebird/bin/fb.fdb --> works fine

./isql -u sysdba -p pass 192.168.0.1:/opt/firebird/bin/fb.fdb --> works not -->

Statement failed, SQLCODE = -923
connection rejected by remote interface
Use CONNECT or CREATE DATABASE to specify a database

Any idea? I cannot find any mistake in the configuration. RemoteBindAddress is not set in firebird.conf.

---------------------------
firebird.log shows:

firebirdsrv Thu Dec 27 18:26:42 2007
INET/inet_error: read errno = 104
---------------------------

Another thing i recoginized:
telnet localhost 3050 answers:

Connected to localhost.
Escape character is '^]'.

and waits for input, while

telnet 192.168.0.1 3050 answers and closes immediately:

Connected to 192.168.50.7.
Escape character is '^]'.
Connection closed by foreign host.


Environment:

Firebird 2.0.3.12981 on gentoo 2.6.17.14 #1 SMP x86_64

--------------------
cat /etc/xinetd.d/firebird
# default: on
# description: FirebirdSQL server
#
# Be careful when commenting out entries in this file. Active key entry should
# be the first as some scripts (CSchangeRunUser.sh in particular) use sed
# scripting to modify it.

service gds_db
{
disable = no
flags = REUSE KEEPALIVE NOLIBWRAP NODELAY
socket_type = stream
wait = no
user = root
# These lines cause problems with Windows XP SP2 clients
# using default firewall configuration (SF#1065511)
# log_on_success += USERID
# log_on_failure += USERID
server = /opt/firebird/bin/fb_inet_server
instances = UNLIMITED
per_source = UNLIMITED
cps = 200 5
}
----------------
cat /etc/services |grep -i 3050
gds_db 3050/tcp # InterBase server
gds_db 3050/udp
-----------------

Any idea what could be the problem? Thank you so much for help.

Nils


--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail