Subject Re: connection ! problem - centos 4.3, have tested with all versions of 1.5.3
Author michael_compuser
Thanks again. I did this, and it looked the app was having a good
think about whether it wanted to work properly, but alas. However
the suggestion did lead to a discovery at the process level. Could
the difference betw home and office as indicated below be
significant?:

Regards
Michael

Pastes:
1. Centos (at home - database connection problem)
For process /opt/firebird/bin/fbserver (PID 697)
Open network connections
Type Protocol File Descriptor Details
IPV4 TCP 0u Listening on port gds_db

netstat -an | grep 3050
tcp 0 0 0.0.0.0:3050 0.0.0.0:* LISTEN


2. Office computer (firebird working - Red Hat 8)

For process /opt/firebird/bin/fbserver (PID 697)
Open network connections
Type Protocol File Descriptor Details
IPV4 TCP 0u Listening on port gds_db
IPV4 TCP 1u 127.0.0.1:gds_db -> 127.0.0.1:32772 ESTABLISHED
IPV4 TCP 7u 127.0.0.1:gds_db -> 127.0.0.1:32773 ESTABLISHED
IPV4 TCP 8u 127.0.0.1:gds_db -> 127.0.0.1:32775 ESTABLISHED
IPV4 TCP 9u 192.168.1.111:gds_db -> 192.168.1.21:2625 ESTABLISHED
IPV4 TCP 11u 192.168.1.111:gds_db -> 192.168.1.21:2626 ESTABLISHED


netstat -an | grep 3050
tcp 0 0 0.0.0.0:3050 0.0.0.0:*
LISTEN
tcp 0 0 127.0.0.1:3050 127.0.0.1:32775 ESTABLISHED
tcp 0 0 127.0.0.1:3050 127.0.0.1:32773 ESTABLISHED
tcp 0 0 127.0.0.1:3050 127.0.0.1:32772 ESTABLISHED
tcp 0 0 127.0.0.1:32773 127.0.0.1:3050 ESTABLISHED
tcp 0 0 127.0.0.1:32772 127.0.0.1:3050 ESTABLISHED
tcp 0 0 127.0.0.1:32775 127.0.0.1:3050 ESTABLISHED

> I don't know. There are no clues here regarding authentication,
though.
>
> The firebird.log file doesn't get written to during
> installation. However, the gethostbyname clue says that a client
> asked to connect to host by the name of asterisk1.local and the
> network couldn't find a mapping for it. Apparently it's the
> hard-coded server name the application is trying to connect to,
not
> the IP address you put in your ini file.
>
> Look in the /etc/hosts file and see what's there for that IP
> address....if necessary, add an entry:
> 192.168.2.10 asterisk1.local
>
> (case-sensitive on Linux) and see whether the app has any better
> success at connecting.
>
> Might need a similar entry in the $windir$\system32
\drivers\etc\hosts
> file on the client, as well.
>
> ./heLen
>