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.

    1 comment:

    krishakumar yadhavan said...



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











    online accounting software