Subject Re: [firebird-support] Connect to FB database through VPN
Author Mark Rotteveel
On 1-9-2017 11:28, sntpywhl3bfbefeaicfmgdnmn3pewm6576tee3zc@...
[firebird-support] wrote:
> I have FB3 database at a customer site and was able to log in remotely
> 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 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.

I think it would be better if you ask this on a forum that knows how
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, 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 Rotteveel