Subject Network connection to firebird server fails - more log messages
Author nils.gorges
Hello,

i forgot to post the output of the /var/log/message log. For one
connection try it shows:

---------------------------------
Dec 28 16:45:57 hellbase xinetd[23733]: FAIL: gds_db address
from=192.168.0.1
Dec 28 16:45:57 hellbase xinetd[23684]: START: gds_db pid=23733
from=192.168.0.1
Dec 28 16:45:57 hellbase xinetd[23684]: EXIT: gds_db status=0
pid=23733 duration=0(sec)
Dec 28 16:45:59 hellbase xinetd[23734]: FAIL: gds_db address
from=192.168.0.1
Dec 28 16:45:59 hellbase xinetd[23684]: START: gds_db pid=23734
from=192.168.0.1
Dec 28 16:45:59 hellbase xinetd[23684]: EXIT: gds_db status=0
pid=23734 duration=0(sec)
-------------------------------------

So what could be the reason for the
"FAIL: gds_db address from=192.168.0.1"

The address is entered in hosts.equiv also DNS forward and reverse
lookup is working.

Thanks again for any help.

Nils


--- In firebird-support@yahoogroups.com, "nils.gorges"
<nils.gorges@...> wrote:
>
> 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
>