Re: [firebird-support] Firebird can't connect to host
On 20-11-2014 04:41, Andromeda andromedar...@gmail.com [firebird-support] wrote: I use Superclassic Firebird version and already configured the inetd conf. As far as I know SuperClassic doesn't (or shouldn't) use (x)inetd. That might be the actual problem. Mark -- Mark Rotteveel
Re: [firebird-support] Firebird can't connect to host
Hi Marcus, I use Superclassic Firebird version and already configured the inetd conf. Thanks a lot for the response, Regards Andromeda
Re: [firebird-support] Firebird can't connect to host
Finally, my friend, Nigel Weeks (nigel.we...@gmail.com) help me to solve this problem. He can't post the replies directly into this topic because of some minor issue, so we did a private conversation by email account and here is the summary of our conversation by email. *The main issue is* : I can connect to the employee.fdb with the lookup address but can't connect with host address. I try to check the network status with the netstat -lntu command and I find the Firebird is running on 127.0.0.1:3050. Actually, in my previous OS, the services is running on 0.0.0.0:3050 instead of 127xxx which means that service is able to accessed by random host, right? So, may the main issue, is I don't know why the services is running on 127xxx instead of 0.0.0.0 and I don't know how to correct this simple problem. *And Nigel suggests me to do* : Looking in /etc/firebird/2.5/firebird.conf, I see mention of the following: # Allows incoming connections to be bound to the IP address of a # specific network card. It enables rejection of incoming connections # through any other network interface except this one. By default, # connections from any available network interface are allowed. # If you are using Classic Server, this setting is for Windows only. # Under Linux, BSD or Mac OS X, with Classic server use xinetd or launchd # configuration file (bind parameter). # # Type: string # RemoteBindAddress = 127.0.0.1 But your installation is most likely using the xinetd or launchd, and this config file *'should'* be ignored, but jump in and change the IP address to 0.0.0.0, or the ethernet interface's IP, stop and start the server (`service firebird2.5-superclassic restart), and try another connect. *And the result is :* 100% correct! I set the actual address on the firebird.conf and now the server can running and listen at all interfaces correctly. Sorry for my bad english, and thanks a lot to all member of this group, especially for Nigel. Greeting from the wonderful Indonesia, Andromeda
Re: [firebird-support] Firebird can't connect to host
On 14.11.2014 08:55, Andromeda andromedar...@gmail.com [firebird-support] wrote: Hello, I'm new in FirebirdSQL. I can't connect into my host address whereas it can connect to localhost successfully. It prompt show errors like this: |SQL connect 192.168.1.37:/var/lib/firebird/2.5/data/employee.fdb user 'SYSDBA' password 'masterkey'; Statement failed, SQLSTATE = 08006 Unable to complete network request to host 192.168.1.50. -Failed to establish a connection. | I have Googled about this for almost a month but I can't find the absolute way to solve this problem. My ufw firewall already deactivated, the port 3050 is opened, but it still can't connect into my host address, but easily connect to the 127.0.0.1. The Firebird classic server is running on Lubuntu Desktop 14.04.1 and the version of Firebird is 2.5. This problem occured since I reinstall/upgrading my OS from 13.xxx into 14.xxx Lubuntu version. On the previous OS, I never facing an error like this. What's going wrong here? Whether this problem related to OS version, or just a dumb error that I can't solve, I don't know and I very need an help from the experts, please. How do you start firebird, and in which mode? Classic, Superclassic or Superserver? If Classic : Do you have installed inetd/xinetd, enabled and configured it? Any help would be very appreciated, thank a lot in advance. Regards, Andromeda [Non-text portions of this message have been removed]
[firebird-support] Firebird can't connect to host
Hello, I'm new in FirebirdSQL. I can't connect into my host address whereas it can connect to localhost successfully. It prompt show errors like this: SQL connect 192.168.1.37:/var/lib/firebird/2.5/data/employee.fdb user 'SYSDBA' password 'masterkey'; Statement failed, SQLSTATE = 08006 Unable to complete network request to host 192.168.1.50. -Failed to establish a connection. I have Googled about this for almost a month but I can't find the absolute way to solve this problem. My ufw firewall already deactivated, the port 3050 is opened, but it still can't connect into my host address, but easily connect to the 127.0.0.1. The Firebird classic server is running on Lubuntu Desktop 14.04.1 and the version of Firebird is 2.5. This problem occured since I reinstall/upgrading my OS from 13.xxx into 14.xxx Lubuntu version. On the previous OS, I never facing an error like this. What's going wrong here? Whether this problem related to OS version, or just a dumb error that I can't solve, I don't know and I very need an help from the experts, please. Any help would be very appreciated, thank a lot in advance. Regards, Andromeda