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?
selasAsked:
Who is Participating?
 
Nick UpsonConnect With a Mentor Principal Operations EngineerCommented:
If this si complete please close it
0
 
Nick UpsonPrincipal Operations EngineerCommented:
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
0
 
selasAuthor Commented:
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.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Nick UpsonPrincipal Operations EngineerCommented:
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
0
 
selasAuthor Commented:
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?
0
 
selasAuthor Commented:
sorry in last my post i did mistake:
added
gds_db      tcp/3050   #Firebird service
0
 
Nick UpsonPrincipal Operations EngineerCommented:
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?
0
 
selasAuthor Commented:
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?
0
 
Nick UpsonPrincipal Operations EngineerCommented:
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
0
 
selasAuthor Commented:
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.
0
 
Nick UpsonPrincipal Operations EngineerCommented:
0
 
Nick UpsonPrincipal Operations EngineerCommented:
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"
0
 
Nick UpsonPrincipal Operations EngineerCommented:
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.
0
 
selasAuthor Commented:
Thanks In Cisco router was forwarded port and work fine with ZeBEDEE, Thank you very much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.