[Solved] Install Firebird 2.1 Di Server Linux Ubuntu 14.04 Lts

- Berawal dari kegiatan Zahir v6 yang kurang stabil jikalau dijalankan memakai firebird 2.5 atau diatasnya, sehingga mengharuskan untuk memakai Firebird versi 2.1

Bagi anda pengguna Zahir Accounting Software mungkin tutorial ini dapat anda terapkan jikalau Database ingin diletakkan pada Server Linux.

Saya lebih bahagia jikalau database zahir saya letakkan pada server linux, dan selanjutnya diakses oleh beberapa User PC menuju IP Server (untuk mengakses database zahir).

Problem :

Pada Linux Ubuntu 14.04 LTS, firebird yang direkomendasikan untuk diinstall yakni versi Firebird 2.5.

 root@zahir-v6:/home/aziz# apt-get install firebird2.1-classic    Reading package lists... Done    Building dependency tree        Reading state information... Done    Package firebird2.1-classic is not available, but is referred to by another package.    This may mean that the package is missing, has been obsoleted, or    is only available from another source    E: Package 'firebird2.1-classic' has no installation candidate   

Berikut untuk mengecek paket yang dapat diinstall dari mirror yang kita gunakan.

root@zahir-v6:/home/aziz# apt-cache search firebird2. firebird-dev - Development files for Firebird - an RDBMS based on InterBase 6.0 code firebird2.5-classic - Firebird Classic Server - an RDBMS based on InterBase 6.0 code firebird2.5-classic-common - common files for firebird 2.5 "classic" and "superclassic" firebird2.5-classic-dbg - collected debug symbols for firebird2.5-classic and -superclassic firebird2.5-common - common files for firebird 2.5 servers and clients firebird2.5-common-doc - copyright, licensing and changelogs of firebird2.5 firebird2.5-doc - Documentation files for firebird database version 2.5 firebird2.5-examples - Examples for Firebird - an RDBMS based on InterBase 6.0 code firebird2.5-server-common - common files for firebird 2.5 servers firebird2.5-super - Firebird Super Server - an RDBMS based on InterBase 6.0 code firebird2.5-super-dbg - collected debug symbols for firebird2.5-super firebird2.5-superclassic - Firebird SuperClassic Server - an RDBMS based on InterBase 6.0 code flamerobin - graphical database administration tool for Firebird DBMS firebird2.5-dev - transitional package for firebird-dev root@zahir-v6:/home/aziz#  

Pertanyaannya :

Bagaimana cara install Firebird2.1 di Ubuntu 14.04 LTS ...?

Solusi :

Tambahkan mirror cz.archive.ubuntu.com pada file /etc/apt/sources.list dan update

root@zahir-v6:/home/aziz# echo "deb http://cz.archive.ubuntu.com/ubuntu precise main universe" >> /etc/apt/sources.list root@zahir-v6:/home/aziz# apt-get update 

Lakukan Install dengan command sbb :

 root@zahir-v6:/home/aziz# apt-get install firebird2.1-classic    Reading package lists... Done    Building dependency tree        Reading state information... Done    firebird2.1-classic is already the newest version.    You might want to run 'apt-get -f install' to correct these:    The following packages have unmet dependencies:     firebird2.1-classic : Depends: libfbembed2.1 (>= 2.1.1) but it is not going to be installed                Depends: firebird2.1-common (= 2.1.4.18393-0.ds2-6build1) but it is not going to be installed                Depends: firebird2.1-server-common (= 2.1.4.18393-0.ds2-6build1) but it is not going to be installed                Depends: openbsd-inetd or                    inet-superserver                Depends: firebird2.1-common-doc (= 2.1.4.18393-0.ds2-6build1) but it is not going to be installed                Recommends: libib-util but it is not going to be installed    E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).    root@zahir-v6:/home/aziz# apt-get -f install    Reading package lists... Done    Building dependency tree        Reading state information... Done    Correcting dependencies... Done    The following extra packages will be installed:     firebird2.1-common firebird2.1-common-doc firebird2.1-server-common     libfbembed2.1 libfile-copy-recursive-perl libicu48 openbsd-inetd     update-inetd    The following NEW packages will be installed:     firebird2.1-common firebird2.1-common-doc firebird2.1-server-common     libfbembed2.1 libfile-copy-recursive-perl libicu48 openbsd-inetd     update-inetd    0 upgraded, 8 newly installed, 0 to remove and 163 not upgraded.    1 not fully installed or removed.    Need to get 10.2 MB of archives.    After this operation, 29.9 MB of additional disk space will be used.    Do you want to continue? [Y/n] y    Get:1 http://cz.archive.ubuntu.com/ubuntu/ precise/main libicu48 amd64 4.8.1.1-3 [8,103 kB]    Get:2 http://us.archive.ubuntu.com/ubuntu/ trusty/main libfile-copy-recursive-perl all 0.38-1 [20.6 kB]    Get:3 http://us.archive.ubuntu.com/ubuntu/ trusty/main update-inetd all 4.43 [19.2 kB]    Get:4 http://us.archive.ubuntu.com/ubuntu/ trusty/main openbsd-inetd amd64 0.20091229-2ubuntu3 [30.8 kB]    Get:5 http://cz.archive.ubuntu.com/ubuntu/ precise/universe firebird2.1-common-doc all 2.1.4.18393-0.ds2-6build1 [32.2 kB]    Get:6 http://cz.archive.ubuntu.com/ubuntu/ precise/universe firebird2.1-common amd64 2.1.4.18393-0.ds2-6build1 [478 kB]    Get:7 http://cz.archive.ubuntu.com/ubuntu/ precise/universe firebird2.1-server-common amd64 2.1.4.18393-0.ds2-6build1 [139 kB]    Get:8 http://cz.archive.ubuntu.com/ubuntu/ precise/universe libfbembed2.1 amd64 2.1.4.18393-0.ds2-6build1 [1,415 kB]    Fetched 10.2 MB in 11s (858 kB/s)                           Preconfiguring packages ...    Selecting previously unselected package libicu48.    (Reading database ... 55001 files and directories currently installed.)    Preparing to unpack .../libicu48_4.8.1.1-3_amd64.deb ...    Unpacking libicu48 (4.8.1.1-3) ...    Selecting previously unselected package firebird2.1-common-doc.    Preparing to unpack .../firebird2.1-common-doc_2.1.4.18393-0.ds2-6build1_all.deb ...    Unpacking firebird2.1-common-doc (2.1.4.18393-0.ds2-6build1) ...    Selecting previously unselected package firebird2.1-common.    Preparing to unpack .../firebird2.1-common_2.1.4.18393-0.ds2-6build1_amd64.deb ...    Unpacking firebird2.1-common (2.1.4.18393-0.ds2-6build1) ...    Selecting previously unselected package firebird2.1-server-common.    Preparing to unpack .../firebird2.1-server-common_2.1.4.18393-0.ds2-6build1_amd64.deb ...    Unpacking firebird2.1-server-common (2.1.4.18393-0.ds2-6build1) ...    Selecting previously unselected package libfbembed2.1.    Preparing to unpack .../libfbembed2.1_2.1.4.18393-0.ds2-6build1_amd64.deb ...    Unpacking libfbembed2.1 (2.1.4.18393-0.ds2-6build1) ...    Selecting previously unselected package libfile-copy-recursive-perl.    Preparing to unpack .../libfile-copy-recursive-perl_0.38-1_all.deb ...    Unpacking libfile-copy-recursive-perl (0.38-1) ...    Selecting previously unselected package update-inetd.    Preparing to unpack .../update-inetd_4.43_all.deb ...    Unpacking update-inetd (4.43) ...    Selecting previously unselected package openbsd-inetd.    Preparing to unpack .../openbsd-inetd_0.20091229-2ubuntu3_amd64.deb ...    Unpacking openbsd-inetd (0.20091229-2ubuntu3) ...    Processing triggers for man-db (2.6.7.1-1ubuntu1) ...    Processing triggers for ureadahead (0.100.0-16) ...    Setting up libicu48 (4.8.1.1-3) ...    Setting up firebird2.1-common-doc (2.1.4.18393-0.ds2-6build1) ...    Setting up firebird2.1-common (2.1.4.18393-0.ds2-6build1) ...    Setting up firebird2.1-server-common (2.1.4.18393-0.ds2-6build1) ...    firebird:x:84:84:Firebird Database Owner:/opt/firebird:/bin/false    Setting up libfbembed2.1 (2.1.4.18393-0.ds2-6build1) ...    Setting up libfile-copy-recursive-perl (0.38-1) ...    Setting up update-inetd (4.43) ...    Setting up openbsd-inetd (0.20091229-2ubuntu3) ...     * Stopping internet superserver inetd                                                                           [ OK ]      * Not starting internet superserver: no services enabled    Processing triggers for ureadahead (0.100.0-16) ...    Setting up firebird2.1-classic (2.1.4.18393-0.ds2-6build1) ...    Created default security.fdb     * Preparing /var/run/firebird/2.1...                                                                           [ OK ]     Processing triggers for libc-bin (2.19-0ubuntu6.5) ...    Processing triggers for ureadahead (0.100.0-16) ...    root@zahir-v6:/home/aziz# dpkg -l |grep firebird    ii firebird2.1-classic         2.1.4.18393-0.ds2-6build1    amd64    Firebird Classic Server - an RDBMS based on InterBase 6.0 code    ii firebird2.1-common         2.1.4.18393-0.ds2-6build1    amd64    common files for firebird 2.1 servers and clients    ii firebird2.1-common-doc       2.1.4.18393-0.ds2-6build1    all     copyright, licensing and changelogs of firebird2.1    ii firebird2.1-server-common      2.1.4.18393-0.ds2-6build1    amd64    common files for firebird 2.1 servers    root@zahir-v6:/home/aziz#    

Note :

• Pengalaman pribadi, jangan lupa untuk menginstall libstdc++5 atau dapat didownload disini secara manual libstdc++5_3.3.6-17ubuntu1_i386.deb

root@zahir-v6:/home/aziz# wget http://old-releases.ubuntu.com/ubuntu/pool/universe/g/gcc-3.3/libstdc++5_3.3.6-17ubuntu1_i386.deb root@zahir-v6:/home/aziz# dpkg -i libstdc++5_3.3.6-17ubuntu1_i386.debroot@zahir-v6:/home/aziz# dpkg -l |grep libstdc++5  ii  libstdc++5       1:3.3.6-17ubuntu1         i386         The GNU Standard C++ Library v3 root@zahir-v6:/home/aziz#  

• Membuat file alias, tujuannya untuk mengalias penamaan atau lokasi directory yang berada pada file /var/lib/firebird/2.1/data/databasezahir.gdb dengan nama zahir.gdb

root@zahir-v6:/home/aziz# more /etc/firebird/2.1/aliases.conf #-------------------------------- # List of known database aliases #-------------------------------- dbzahir-accounting = /var/lib/firebird/2.1/data/databasezahiraccounting-v6.gdb root@zahir-v6:/home/aziz#