?
Solved

Remote Firebird database server instalation

Posted on 2007-10-09
14
Medium Priority
?
2,172 Views
Last Modified: 2013-12-09
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?
0
Comment
Question by:selas
  • 8
  • 6
14 Comments
 
LVL 19

Expert Comment

by:NickUpson
ID: 20040728
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
 

Author Comment

by:selas
ID: 20041027
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
 
LVL 19

Expert Comment

by:NickUpson
ID: 20041249
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
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 

Author Comment

by:selas
ID: 20041967
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
 

Author Comment

by:selas
ID: 20041981
sorry in last my post i did mistake:
added
gds_db      tcp/3050   #Firebird service
0
 
LVL 19

Expert Comment

by:NickUpson
ID: 20042452
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
 

Author Comment

by:selas
ID: 20046527
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
 
LVL 19

Expert Comment

by:NickUpson
ID: 20046579
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
 

Author Comment

by:selas
ID: 20046658
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
 
LVL 19

Expert Comment

by:NickUpson
ID: 20047009
0
 
LVL 19

Expert Comment

by:NickUpson
ID: 20047015
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
 
LVL 19

Expert Comment

by:NickUpson
ID: 20047180
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
 

Author Comment

by:selas
ID: 20047918
Thanks In Cisco router was forwarded port and work fine with ZeBEDEE, Thank you very much.
0
 
LVL 19

Accepted Solution

by:
NickUpson earned 2000 total points
ID: 20051054
If this si complete please close it
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
What we learned in Webroot's webinar on multi-vector protection.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question