Monday, February 25, 2008

hosted firebird (1.5 or 2.03) in linux, using with Zahir Accounting

a week ago, with one of company in surabaya that current running Zahir Accounting Enterprise,
there is a plan moving Firebird database to the internet...there will be centralize Firebird database that will able accessed from different places

the result is NOT good enough..for the speed and performance factor
conclusion:
1. Firebird and zebedee combination is able or at least quick enough to access via internet
2. Zahir Accounting is NOT design for using database via internet

step that I've done: (server linux using: ubuntu 7.04)
1. install Fb firebirdss_2.0.3.12981-nptl_i386.deb ( alien --scripts FirebirdSS-2.0.3.12981-1.nptl.i686.rpm, from sourceforge.net)
# dpkg -i firebirdss_2.0.3.12981-nptl_i386.deb

or

install Fb superserver 1.5(firebird2-super-server 1.5.4.4910rel-6) from repository
# apt-get install firebird2-super-server

2. copy and upload file *.gdb(coba1.gdb and security.gdb) from Firebird database windows local to user local linux home directory

3. install zebedee
a. download zebedee-2.4.1A.tar.gz, blowfish-0.9.5a.tar.gz, bzip2-1.0.3.tar.gz, zlib-1.2.3.tar.gz
b. extract to some directory( there will create dir ~linux/blowfish-0.9.5a and ~linux/bzip2-1.0.3 and ~linux/zebedee-2.4.1A and ~/linux/zlib-1.2.3)
c.
$ cd zebedee-2.4.1A
$ make
$ cp zebedee ~linux/

4. run zebedee as non-root user
$ ~linux/zebedee -m -z9 -s localhost:3050

5. open firewall tcp port for zebedee at port 11965

6. create aliases in /opt/firebird/aliases.conf fo/home/r FB ver 2.03 and /etc/firebird/1.5
/aliases.conf
coba1.gdb = /home/jail/home/linux/coba1.gdb

7. copy security2.fdb to directory /opt/firebird or security.fdb for FB ver 2.03
or copy security.fdb to directory /usr/lib/firebird/1.5

8. restart firebird server
/etc/init.d/firebird restart

9. running zebedee di client computer
a. open command prompt di windows
b. cd to directory C:\Program Files\Zebedee
c. run zebedee -z9 -m 3050:IPAddressFirebirdServer:3050

10. run Zahir Accounting in client computer
a. Buka Data
b. entry server with "localhost"
c. entry lokasi file: "coba1.gdb"

result:
- opening for the first time, need at least 170kb data download for opening zahir, that's quite long time needed for just opening data
- when transaction or window forms still open, zahir will not tolerate if the connection closed, the connection to the database is not stateless connection

1 comment:

Romie said...

Terima kasih atas infonya mas, jika boleh mas bantu ane ada sedikit masalah dengan firebird pada red hat linux enterprise server 6.4. Bisa kah mas bantu tutor step by step nya?

Aktivasi DNS Over HTTPS (DoH) DNS Google di Mikrotik v6.47

Domain Name System atau biasa disebut DNS merupakan salah satu fitur yang ada pada setiap perangkat jaringan. Berfungsi pada sistem untuk me...