Tuesday, July 24, 2012

FINA Online (using Firebird 2.5 with zebedee 2.5.3)

I am developing an Accounting software (known as FINA at PT. Integritas Makmur Mandiri) using Firebird 2.5 and zebedee 2.5.3 to make an online application.

There are 4 option to using FINA with online database ( through internet ) :
  1. Make a straight connection using an Public IP without forwarding service.
  2. Make a straight connection using an Public IP with forwarding service at router level.
  3. Using a tunnel (zebedee) without forwarding service.
  4. Using a tunnel (zebedee) with  forwarding service at router level.
For Option 1 : 
  • just make sure your Public IP is valid, and just connect to it like you are on the same LAN of the server computer.

For Option 2 :
  • Open your "firebird.conf", usually located at your Firebird folder.
  • Set the option of RemoteAuxPort to any port that you allowed for port communication. Remove the # symbol at the prefix of the line. Example : RemoteAuxPort=3053
  • Start / Restart your FBServer (you can find it at service page of windows).
  • Go To your forwarding application (router), make 2 rule for incoming connection 
    • from port 3051 to your server at port 3051 
    • from 3053 (RemoteAuxPort) to your server at port 3053
  • Open your FINA client (with different internet connection).
  • Select "Open Database", then
    • Fill "File Name" with the path to your database at server computer.
    • UnCheck the "Via Internet" checkbox.
    • Fill "Located in :" with your Public IP
  • Hit "OK" button, then login to your database.

For Option 3 :
  • Make sure you start Zebedee server at server computer. You can find this file at \\FINA_installation_folder\AnyWhereServer.zbd. To Start it just double click at this file.
  • Make sure your fbServer already started too.
  • Now, open your FINA Client (with different internet connection), then select "Open Database".
    • Fill "File Name" with the path to your database at server computer.
    • Check the "Via Internet" checkbox.
    • Fill "Located in :" with your Public IP
  • Hit "Ok" Button.
  • Is the login form come up?
    • Yes -> then continue to login to your database.
    • No -> Follow the next step
  • Open windows task manager, go to "Processes" tab, try to find "zebedee" process, if exist then end the process
  • Open yours regedit at \Hkey_local_machine\Software\Imamatek\FnaEE\Database. Modified the value of key "AutoCreateZBD" to 0
  • Modified "AnyWhereClient.zbd" (located at same folder of FINA.exe), make sure there are lines of :
    • verbosity 0
    • server false
    • detached True
    • tunnel 3052:222.444.4.199:3051
    • logfile '.client.log'
  • Change "222.444.4.199" with your public ip, then save the file.
  • Double Click at this file to start zebedee client service.
  • Open yours FINA client (with different internet connection) then continue with the "Open Database" step, it shall be able to connect to your server.
  • Make sure to start Zebedee client manually before you connect your FINA with Zebedee.

For Option 4 :
  • Go To your forwarding application (router), make rule for incoming connection from port 11965 to your server at port 11965 too.
  • Follow the rest of Option 3 steps.

Any further or question, just leave the comment for this post or please send me an email, i will try to reply it as soon as possible.

Thanks.

    2 comments:

    krishakumar yadhavan said...



    My cousin recommended this blog and she was totally right keep up the fantastic work!











    online accounting software

    Srini said...

    Very informative and interesting blog. Thanks for sharing.
    Want to get Automotive invoice software.