Subject | Network connection to firebird server fails |
---|---|
Author | nils.gorges |
Post date | 2007-12-28T10:48:21Z |
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:
FirebirdCS 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
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:
FirebirdCS 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