Firebird can't connect to host











up vote
1
down vote

favorite












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.50:/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 week 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.










share|improve this question
























  • Here could be an answer: askubuntu.com/questions/423640/firebird-connection-refused It helped me in same situation
    – Ilja
    Oct 22 '15 at 9:19















up vote
1
down vote

favorite












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.50:/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 week 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.










share|improve this question
























  • Here could be an answer: askubuntu.com/questions/423640/firebird-connection-refused It helped me in same situation
    – Ilja
    Oct 22 '15 at 9:19













up vote
1
down vote

favorite









up vote
1
down vote

favorite











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.50:/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 week 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.










share|improve this question















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.50:/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 week 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.







networking firebird






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Sep 22 '14 at 7:12

























asked Sep 22 '14 at 7:06









Andromeda

614




614












  • Here could be an answer: askubuntu.com/questions/423640/firebird-connection-refused It helped me in same situation
    – Ilja
    Oct 22 '15 at 9:19


















  • Here could be an answer: askubuntu.com/questions/423640/firebird-connection-refused It helped me in same situation
    – Ilja
    Oct 22 '15 at 9:19
















Here could be an answer: askubuntu.com/questions/423640/firebird-connection-refused It helped me in same situation
– Ilja
Oct 22 '15 at 9:19




Here could be an answer: askubuntu.com/questions/423640/firebird-connection-refused It helped me in same situation
– Ilja
Oct 22 '15 at 9:19










3 Answers
3






active

oldest

votes

















up vote
0
down vote













I had this problem on Ubuntu 16.04 LTS with Firebird 2.5.5 and resolved it as follows:



As a user with sufficient permissions, edit the firebird.conf file.



sudo -i
vi ./firebird/2.5/firebird.conf


Search for 'bind' and read the comments associated with RemoteBindAddress. Basically you have to reverse the # commented lines in order to allow network access to machine further away than yourself/localhost.



After adjusting the RemoteBindAddress, restart the Firebird service/daemon.



sudo service firebird2.5-super stop
sudo service firebird2.5-super start


Then try to connect. I had installed the sample files so this database name worked for me: 192.168.0.12:/var/lib/firebird/2.5/data/employee.fdb



Note: if the machine with FirebirdSQL is behind a firewall, port 3050 must be open in order for clients to connect.






share|improve this answer






























    up vote
    0
    down vote













    You have to edit file "/etc/firebird/2.5/firebird.conf" and comment the line:



    RemoteBindAddress = localhost


    Like this



    #RemoteBindAddress = localhost


    Restart the firebird:



    service firebird2.5-superclassic restart




    • Im using superclassic version






    share|improve this answer





















    • Welcome to Super User. This solution looks like essentially what Chloe Tempo's answer suggests. The intention is that each answer provide a solution that is substantively different from what has already been contributed. Can you clarify what is different from the other answer? Thanks.
      – fixer1234
      Oct 14 at 1:25










    • To me, it looks like it's more detailed. Thank you
      – Lucas Catani
      Oct 15 at 14:16


















    up vote
    -1
    down vote













    Add Windows Firewall Settings.



    Go to Start --> control panel --> Windows Firewall --> goto Exceptions tab -- > Click Add Program --> and select C:Program FilesFirebirdFirebird_2_5binfbguard.exe



    same way add C:Program FilesFirebirdFirebird_2_5binfbserver.exe now Restart you system and check from client to server firebird connection.






    share|improve this answer

















    • 1




      The OP clearly sayd that the Firebird server is running under Ubuntu, not Windows.
      – nKn
      Jan 6 '16 at 10:06











    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "3"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














     

    draft saved


    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f814879%2ffirebird-cant-connect-to-host%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    3 Answers
    3






    active

    oldest

    votes








    3 Answers
    3






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes








    up vote
    0
    down vote













    I had this problem on Ubuntu 16.04 LTS with Firebird 2.5.5 and resolved it as follows:



    As a user with sufficient permissions, edit the firebird.conf file.



    sudo -i
    vi ./firebird/2.5/firebird.conf


    Search for 'bind' and read the comments associated with RemoteBindAddress. Basically you have to reverse the # commented lines in order to allow network access to machine further away than yourself/localhost.



    After adjusting the RemoteBindAddress, restart the Firebird service/daemon.



    sudo service firebird2.5-super stop
    sudo service firebird2.5-super start


    Then try to connect. I had installed the sample files so this database name worked for me: 192.168.0.12:/var/lib/firebird/2.5/data/employee.fdb



    Note: if the machine with FirebirdSQL is behind a firewall, port 3050 must be open in order for clients to connect.






    share|improve this answer



























      up vote
      0
      down vote













      I had this problem on Ubuntu 16.04 LTS with Firebird 2.5.5 and resolved it as follows:



      As a user with sufficient permissions, edit the firebird.conf file.



      sudo -i
      vi ./firebird/2.5/firebird.conf


      Search for 'bind' and read the comments associated with RemoteBindAddress. Basically you have to reverse the # commented lines in order to allow network access to machine further away than yourself/localhost.



      After adjusting the RemoteBindAddress, restart the Firebird service/daemon.



      sudo service firebird2.5-super stop
      sudo service firebird2.5-super start


      Then try to connect. I had installed the sample files so this database name worked for me: 192.168.0.12:/var/lib/firebird/2.5/data/employee.fdb



      Note: if the machine with FirebirdSQL is behind a firewall, port 3050 must be open in order for clients to connect.






      share|improve this answer

























        up vote
        0
        down vote










        up vote
        0
        down vote









        I had this problem on Ubuntu 16.04 LTS with Firebird 2.5.5 and resolved it as follows:



        As a user with sufficient permissions, edit the firebird.conf file.



        sudo -i
        vi ./firebird/2.5/firebird.conf


        Search for 'bind' and read the comments associated with RemoteBindAddress. Basically you have to reverse the # commented lines in order to allow network access to machine further away than yourself/localhost.



        After adjusting the RemoteBindAddress, restart the Firebird service/daemon.



        sudo service firebird2.5-super stop
        sudo service firebird2.5-super start


        Then try to connect. I had installed the sample files so this database name worked for me: 192.168.0.12:/var/lib/firebird/2.5/data/employee.fdb



        Note: if the machine with FirebirdSQL is behind a firewall, port 3050 must be open in order for clients to connect.






        share|improve this answer














        I had this problem on Ubuntu 16.04 LTS with Firebird 2.5.5 and resolved it as follows:



        As a user with sufficient permissions, edit the firebird.conf file.



        sudo -i
        vi ./firebird/2.5/firebird.conf


        Search for 'bind' and read the comments associated with RemoteBindAddress. Basically you have to reverse the # commented lines in order to allow network access to machine further away than yourself/localhost.



        After adjusting the RemoteBindAddress, restart the Firebird service/daemon.



        sudo service firebird2.5-super stop
        sudo service firebird2.5-super start


        Then try to connect. I had installed the sample files so this database name worked for me: 192.168.0.12:/var/lib/firebird/2.5/data/employee.fdb



        Note: if the machine with FirebirdSQL is behind a firewall, port 3050 must be open in order for clients to connect.







        share|improve this answer














        share|improve this answer



        share|improve this answer








        edited Jun 22 '17 at 7:20









        Stephen Rauch

        2,22581524




        2,22581524










        answered Jun 22 '17 at 6:03









        Chloe Tempo

        12




        12
























            up vote
            0
            down vote













            You have to edit file "/etc/firebird/2.5/firebird.conf" and comment the line:



            RemoteBindAddress = localhost


            Like this



            #RemoteBindAddress = localhost


            Restart the firebird:



            service firebird2.5-superclassic restart




            • Im using superclassic version






            share|improve this answer





















            • Welcome to Super User. This solution looks like essentially what Chloe Tempo's answer suggests. The intention is that each answer provide a solution that is substantively different from what has already been contributed. Can you clarify what is different from the other answer? Thanks.
              – fixer1234
              Oct 14 at 1:25










            • To me, it looks like it's more detailed. Thank you
              – Lucas Catani
              Oct 15 at 14:16















            up vote
            0
            down vote













            You have to edit file "/etc/firebird/2.5/firebird.conf" and comment the line:



            RemoteBindAddress = localhost


            Like this



            #RemoteBindAddress = localhost


            Restart the firebird:



            service firebird2.5-superclassic restart




            • Im using superclassic version






            share|improve this answer





















            • Welcome to Super User. This solution looks like essentially what Chloe Tempo's answer suggests. The intention is that each answer provide a solution that is substantively different from what has already been contributed. Can you clarify what is different from the other answer? Thanks.
              – fixer1234
              Oct 14 at 1:25










            • To me, it looks like it's more detailed. Thank you
              – Lucas Catani
              Oct 15 at 14:16













            up vote
            0
            down vote










            up vote
            0
            down vote









            You have to edit file "/etc/firebird/2.5/firebird.conf" and comment the line:



            RemoteBindAddress = localhost


            Like this



            #RemoteBindAddress = localhost


            Restart the firebird:



            service firebird2.5-superclassic restart




            • Im using superclassic version






            share|improve this answer












            You have to edit file "/etc/firebird/2.5/firebird.conf" and comment the line:



            RemoteBindAddress = localhost


            Like this



            #RemoteBindAddress = localhost


            Restart the firebird:



            service firebird2.5-superclassic restart




            • Im using superclassic version







            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Oct 14 at 1:09









            Lucas Catani

            11




            11












            • Welcome to Super User. This solution looks like essentially what Chloe Tempo's answer suggests. The intention is that each answer provide a solution that is substantively different from what has already been contributed. Can you clarify what is different from the other answer? Thanks.
              – fixer1234
              Oct 14 at 1:25










            • To me, it looks like it's more detailed. Thank you
              – Lucas Catani
              Oct 15 at 14:16


















            • Welcome to Super User. This solution looks like essentially what Chloe Tempo's answer suggests. The intention is that each answer provide a solution that is substantively different from what has already been contributed. Can you clarify what is different from the other answer? Thanks.
              – fixer1234
              Oct 14 at 1:25










            • To me, it looks like it's more detailed. Thank you
              – Lucas Catani
              Oct 15 at 14:16
















            Welcome to Super User. This solution looks like essentially what Chloe Tempo's answer suggests. The intention is that each answer provide a solution that is substantively different from what has already been contributed. Can you clarify what is different from the other answer? Thanks.
            – fixer1234
            Oct 14 at 1:25




            Welcome to Super User. This solution looks like essentially what Chloe Tempo's answer suggests. The intention is that each answer provide a solution that is substantively different from what has already been contributed. Can you clarify what is different from the other answer? Thanks.
            – fixer1234
            Oct 14 at 1:25












            To me, it looks like it's more detailed. Thank you
            – Lucas Catani
            Oct 15 at 14:16




            To me, it looks like it's more detailed. Thank you
            – Lucas Catani
            Oct 15 at 14:16










            up vote
            -1
            down vote













            Add Windows Firewall Settings.



            Go to Start --> control panel --> Windows Firewall --> goto Exceptions tab -- > Click Add Program --> and select C:Program FilesFirebirdFirebird_2_5binfbguard.exe



            same way add C:Program FilesFirebirdFirebird_2_5binfbserver.exe now Restart you system and check from client to server firebird connection.






            share|improve this answer

















            • 1




              The OP clearly sayd that the Firebird server is running under Ubuntu, not Windows.
              – nKn
              Jan 6 '16 at 10:06















            up vote
            -1
            down vote













            Add Windows Firewall Settings.



            Go to Start --> control panel --> Windows Firewall --> goto Exceptions tab -- > Click Add Program --> and select C:Program FilesFirebirdFirebird_2_5binfbguard.exe



            same way add C:Program FilesFirebirdFirebird_2_5binfbserver.exe now Restart you system and check from client to server firebird connection.






            share|improve this answer

















            • 1




              The OP clearly sayd that the Firebird server is running under Ubuntu, not Windows.
              – nKn
              Jan 6 '16 at 10:06













            up vote
            -1
            down vote










            up vote
            -1
            down vote









            Add Windows Firewall Settings.



            Go to Start --> control panel --> Windows Firewall --> goto Exceptions tab -- > Click Add Program --> and select C:Program FilesFirebirdFirebird_2_5binfbguard.exe



            same way add C:Program FilesFirebirdFirebird_2_5binfbserver.exe now Restart you system and check from client to server firebird connection.






            share|improve this answer












            Add Windows Firewall Settings.



            Go to Start --> control panel --> Windows Firewall --> goto Exceptions tab -- > Click Add Program --> and select C:Program FilesFirebirdFirebird_2_5binfbguard.exe



            same way add C:Program FilesFirebirdFirebird_2_5binfbserver.exe now Restart you system and check from client to server firebird connection.







            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Jan 6 '16 at 10:00









            Gowrisankar Sengottuvel

            1




            1








            • 1




              The OP clearly sayd that the Firebird server is running under Ubuntu, not Windows.
              – nKn
              Jan 6 '16 at 10:06














            • 1




              The OP clearly sayd that the Firebird server is running under Ubuntu, not Windows.
              – nKn
              Jan 6 '16 at 10:06








            1




            1




            The OP clearly sayd that the Firebird server is running under Ubuntu, not Windows.
            – nKn
            Jan 6 '16 at 10:06




            The OP clearly sayd that the Firebird server is running under Ubuntu, not Windows.
            – nKn
            Jan 6 '16 at 10:06


















             

            draft saved


            draft discarded



















































             


            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f814879%2ffirebird-cant-connect-to-host%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Probability when a professor distributes a quiz and homework assignment to a class of n students.

            Aardman Animations

            Are they similar matrix