Subject | Re: Classic server 2.1.2 on Gentoo linux |
---|---|
Author | Nikolay Marinov |
Post date | 2009-06-20T08:24:40Z |
--- In firebird-support@yahoogroups.com, Dimitry Sibiryakov <sd@...> wrote:
+++++++++++++++++++++++++++++++++++
Active UNIX domain sockets (w/o servers)
Proto RefCnt Flags Type State I-Node Path
unix 2 [ ] DGRAM 1790 @/org/kernel/udev/udevd
unix 3 [ ] STREAM CONNECTED 110385 /dev/log
unix 3 [ ] STREAM CONNECTED 110384
unix 3 [ ] STREAM CONNECTED 109604 /dev/log
unix 3 [ ] STREAM CONNECTED 109603
unix 3 [ ] STREAM CONNECTED 6602 /dev/log
unix 3 [ ] STREAM CONNECTED 6601
++++++++++++++++++++++++++++++++++++
But trying via IBExpert communication diagnostic, it seems normal:
Attempt connecting to 192.168.0.199.
Socket for connection obtained.
Found service 'GDS_DB' at port '3050'
Connection established to host '192.168.0.199',
on port 3050.
TCP/IP Communication Test Passed!
++++++++++++++++++++++++++++++++++++
Attempt connecting to 192.168.0.199.
Socket for connection obtained.
Connection established to host '192.168.0.199',
on port gds_db.
TCP/IP Communication Test Passed!
++++++++++++++++++++++++++++++++++++
but access to the database fail:
Attempting to connect to:
192.168.0.199:/sql/pn.fdb
Connecting... Failed!
------------------------------------
Connection not established.
connection rejected by remote interface.
Attempting to connect to services manager... Failed!
------------------------------------
Connection not established.
connection rejected by remote interface.
Disconnecting from database... Passed!
+++++++++++++++++++++++++++++++++++++++
Isql local conencion is fine:
/opt/firebird/bin/isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect /sql/pn.fdb;
Database: /sql/pn.fdb
SQL>
+++++++++++++++++++++++++++
isql remote connection fail:
/opt/firebird/bin/isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect localhost:/sql/pn.fdb;
Statement failed, SQLCODE = -923
connection rejected by remote interface
SQL>
The database file is owned by firebird.
>I dont see it, may be i dont the the correct command format:
> > No firewall too.
>
> Check with netstat that (x)inetd is listening port 3060 and not only
> on local interface, but on remote one too.
>
> SY, SD.
>
+++++++++++++++++++++++++++++++++++
Active UNIX domain sockets (w/o servers)
Proto RefCnt Flags Type State I-Node Path
unix 2 [ ] DGRAM 1790 @/org/kernel/udev/udevd
unix 3 [ ] STREAM CONNECTED 110385 /dev/log
unix 3 [ ] STREAM CONNECTED 110384
unix 3 [ ] STREAM CONNECTED 109604 /dev/log
unix 3 [ ] STREAM CONNECTED 109603
unix 3 [ ] STREAM CONNECTED 6602 /dev/log
unix 3 [ ] STREAM CONNECTED 6601
++++++++++++++++++++++++++++++++++++
But trying via IBExpert communication diagnostic, it seems normal:
Attempt connecting to 192.168.0.199.
Socket for connection obtained.
Found service 'GDS_DB' at port '3050'
Connection established to host '192.168.0.199',
on port 3050.
TCP/IP Communication Test Passed!
++++++++++++++++++++++++++++++++++++
Attempt connecting to 192.168.0.199.
Socket for connection obtained.
Connection established to host '192.168.0.199',
on port gds_db.
TCP/IP Communication Test Passed!
++++++++++++++++++++++++++++++++++++
but access to the database fail:
Attempting to connect to:
192.168.0.199:/sql/pn.fdb
Connecting... Failed!
------------------------------------
Connection not established.
connection rejected by remote interface.
Attempting to connect to services manager... Failed!
------------------------------------
Connection not established.
connection rejected by remote interface.
Disconnecting from database... Passed!
+++++++++++++++++++++++++++++++++++++++
Isql local conencion is fine:
/opt/firebird/bin/isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect /sql/pn.fdb;
Database: /sql/pn.fdb
SQL>
+++++++++++++++++++++++++++
isql remote connection fail:
/opt/firebird/bin/isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect localhost:/sql/pn.fdb;
Statement failed, SQLCODE = -923
connection rejected by remote interface
SQL>
The database file is owned by firebird.