Link to home
Start Free TrialLog in
Avatar of selas
selas

asked on

Remote Firebird database server instalation

Hello,
i want to install firebird server on remote computer (not on other lan computer). Firebird database server would be in one town and my client program connect through Internet to it. I did it  but always get error:
"Unable to complete Network Request to host MY_HOST_IP" when i am trying to connect to this server that is in other town. Any solution? Maybe Firebird don't have access throught internet, only works in local network?
Avatar of Nick Upson
Nick Upson
Flag of United Kingdom of Great Britain and Northern Ireland image

this can work providing that all firewalls etc in between have been set to enable firebird to pass, be aware that you made need to enable two ports if you use events.

There is a problem however with the length of time taken between the client and server, the best fix is to setup a VNC between the 2 and use that
Avatar of selas
selas

ASKER

What 2 ports? i know that only firebird use 3050 for TCP connection, what second port is?
Now i use Hamachi, but i want without this program.  
With VNC is a little problem, because clients that will use my program and wil connect to firebird server, will be about ~30.
the default second port is 3051, it's used for events

I don't see a problem with having 30 VNC's connected, you could even have a VNC server in front of the database server
Avatar of selas

ASKER

i in firewall settings add this:
added ports:
3050 UDP
3051 UDP
3050 TCP
3051 TCP

addres program:
fbguad.exe
fbserver.exe

in system32/drivers/etc/services file added:
gdb_db      tcp/3050   #Firebird service

But no results when i am trying to connect to database server throught internet.
Scanned with Angry ip tools  program remote firebird database server ports and saw that in port list was not 3050 and 3051. Any more solution?
Avatar of selas

ASKER

sorry in last my post i did mistake:
added
gds_db      tcp/3050   #Firebird service
you don't need to add fbguard, unless the prgram uses events you only need 3050.

what about a firewall at the server end

start with basics can you reach the firebird server at all, say with ping or ssh or telnet?
Avatar of selas

ASKER

how i can test with ping firebird database server? can you write command or somethink esle?
---------------------------------------
C:\Documents and Settings\Andrius>ping 82.15.45.xxx
Pinging 82.15.45.xxx with 32 bytes of data:
Reply from 82.15.45.xxx: bytes=32 time=23ms TTL=246
Reply from 82.15.45.xxx: bytes=32 time=50ms TTL=246
Reply from 82.15.45.xxx: bytes=32 time=71ms TTL=246
Reply from 82.15.45.xxx: bytes=32 time=23ms TTL=246

Ping statistics for 82.15.45.xxx:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss)
Approximate round trip times in milli-seconds:
    Minimum = 23ms, Maximum = 71ms, Average = 41ms
C:\Documents and Settings\Andrius>
------------------------------------------------------------------
C:\Documents and Settings\Andrius>telnet 82.15.45.xxx 3050
Connecting To 82.15.45.xxx...Could not open connection to the host, on port 3050:
 Connect failed
C:\Documents and Settings\Andrius>
-------------------------------------------------------------------
Like this?
I meant what you have done, ping the server machine, that's a start

now please try to do this "telnet 82.15.45.xxx 3050" and post the response, if none then this port is still blocked.

You might want to try using a VNC to get things working at all and then try to get them going without it but it's never going to work well the response times are just too long
Avatar of selas

ASKER

VNC program cost money  so i want  a free product. Another problem with VNC,  if you are connected to server and other client trying connect to server too, then first connected user disconnects and second user connects.
Telnet response i posted in my last post:
C:\Documents and Settings\Andrius>telnet 82.15.45.xxx 3050
Connecting To 82.15.45.xxx...Could not open connection to the host, on port 3050:
 Connect failed
C:\Documents and Settings\Andrius>
So as you say port is blocked,i will tray to find how to open it.
That is not how a VNC should work, there can be many clients attached to the server, each using their own VNC connection. Double check that telnet works ok on it';s default port, "telnet 82.15.45.xxx"
from the firebird 2 manual, discussing security issues

The immediate problem can be solved easily by using any IP-tunneling software (such as ZeBeDee) to move data to and from a Firebird server, for both 1.5 and 2.0. It remains the recommended way to access your remote Firebird server across the Internet.
Avatar of selas

ASKER

Thanks In Cisco router was forwarded port and work fine with ZeBEDEE, Thank you very much.
ASKER CERTIFIED SOLUTION
Avatar of Nick Upson
Nick Upson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial