| Subject | Re: [firebird-support] Connect to FB database through VPN |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2017-09-02T07:18:45Z |
On 1-9-2017 11:28, sntpywhl3bfbefeaicfmgdnmn3pewm6576tee3zc@...
[firebird-support] wrote:
OpenVPN works, because I would guess this might not be a Firebird problem.
Are you sure you are using the right hostname (or IP address), is this
IP address actually accessible/routed over the VPN, is the server
actually listening on a port that is accessible from your host (eg could
the Firebird server only be listening on 127.0.0.1, or at least not on
the IP address available to you), a firewall could be blocking access, etc.
Note that you can could try to discern if it is a Firebird problem, or a
network/VPN problem:
From your host telnet to the right IP address + port for the Firebird
server. Eg on Windows (with the telnet client installed), do
telnet <hostname/ip address> <port>
If you get (almost immediately) a clear screen with a cursor waiting for
input, then there is something listening (could be Firebird, could be
something else). If you get a "Could not open connection" error almost
immediately then the IP address is - likely - accessible but the port is
not open, if it takes a few seconds before you get that same error then
the IP address does not exist or is not accessible to you (because the
network doesn't route it, or because a firewall 'blackholes' the port.
Mark
--
Mark Rotteveel
[firebird-support] wrote:
> I have FB3 database at a customer site and was able to log in remotelyI think it would be better if you ask this on a forum that knows how
> because they had Port Forwarding set on their router for Port 3050 and I
> used the connection string - IP Address:Database Alias. Now they have
> moved to a VPN (OpenVPN) and removed the Port Forwarding on port 3050.
> I have setup OpenVPN on the remote computer and they have provided me
> with the clientbundle for the SSL stuff. I can open the VPN and log onto
> their server but when I try to connect to the database I get the error:
>
>
> Unable to complete network request to host xxx.xxx.xxx.xx. Failed to
> establish connection.
>
> Is there something different I should be doing to connect to a FB
> database through a VPN?
>
> Any help would be appreciated.
OpenVPN works, because I would guess this might not be a Firebird problem.
Are you sure you are using the right hostname (or IP address), is this
IP address actually accessible/routed over the VPN, is the server
actually listening on a port that is accessible from your host (eg could
the Firebird server only be listening on 127.0.0.1, or at least not on
the IP address available to you), a firewall could be blocking access, etc.
Note that you can could try to discern if it is a Firebird problem, or a
network/VPN problem:
From your host telnet to the right IP address + port for the Firebird
server. Eg on Windows (with the telnet client installed), do
telnet <hostname/ip address> <port>
If you get (almost immediately) a clear screen with a cursor waiting for
input, then there is something listening (could be Firebird, could be
something else). If you get a "Could not open connection" error almost
immediately then the IP address is - likely - accessible but the port is
not open, if it takes a few seconds before you get that same error then
the IP address does not exist or is not accessible to you (because the
network doesn't route it, or because a firewall 'blackholes' the port.
Mark
--
Mark Rotteveel