[SOLVED] Install Firebird 2.1 di Server Linux Ubuntu 14.04 LTS

ITLampung.Com - Berawal dari program Zahir v6 yang kurang stabil jika dijalankan menggunakan firebird 2.5 atau diatasnya, sehingga mengharuskan untuk menggunakan Firebird versi 2.1

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

Saya lebih senang jika 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 adalah 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 bisa 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 :
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#

Subscribe to receive free email updates:

0 Response to "[SOLVED] Install Firebird 2.1 di Server Linux Ubuntu 14.04 LTS "

Post a Comment

Tinggalkan jejak agan dihalaman komentar dibawah ini.. Jangan lupa :)

- ITLampung.Com