Having trouble connecting to VVV server

Help
McoreD
2012-10-19
2013-05-28
  • McoreD
    McoreD
    2012-10-19

    Hi

    I have been attempting to configure my PCs so that VVV database in my Ubuntu PC can act as the server and my other Windows 7 PCs can connect to it.

    At first, I could not create a fdb in Ubuntu using FlameRobin; the only place I could create it was in:

    /var/lib/firebird/2.1/data

    After I finally got it working, I made sure the connection works okay in my Ubuntu PC:


    I also tested in my Windows 7 PC:

    https://www.dropbox.com/s/7kivxtb3gkg09zg/065010-VVV.jpg

    However, when I close VVV in my Windows 7 PC and try to open it with the setting: Connect to a server, I get the following error:

    https://www.dropbox.com/s/4wetw6mb9jz9ke5/065046-VVV_Error.png

    Any assistance would be great to rectify this.

    Thanks
    Mike Delpach (mcored)

     
  • McoreD
    McoreD
    2012-10-19

    ERROR! The markdown supplied could not be parsed correctly. Did you forget to surround a code snippet with "~~~~"?

    First screenshot is not shown for some reason because I decided to using ![](http://tags. 
    After I finally got it working, I made sure the connection works okay in my Ubuntu PC: 
    https://www.dropbox.com/s/56gzcqm944hyjml/064918-Screenshot.png)
    
     
  • Fulvio Senore
    Fulvio Senore
    2012-10-20

    It looks like VVV cannot connect to the remote server. Usually this is a problem with the server configuration.

    Try to open a catalog or another Firebird database stored in the server using FlameRobin from a Windows computer. If you cannot do it you need to check the server settings.
    Firebird uses port 3050 so you need to configure the firewall accordingly.

     
  • Fulvio Senore
    Fulvio Senore
    2012-10-23

    It might be a permission problem: maybe the server process cannot open the database file.
    IIRC the server runs as the "firebird" user that is created when you install the server.
    Please check that the firebird user has read and write access to the catalog file. You might try to temporarily grant full access to the file and the folder to everyone just to see if it fixes the problem.