{"id":346,"date":"2014-02-07T10:02:47","date_gmt":"2014-02-07T10:02:47","guid":{"rendered":"http:\/\/it.tuxie.eu\/?p=346"},"modified":"2014-02-07T10:19:59","modified_gmt":"2014-02-07T10:19:59","slug":"firebird-3-0-alpha-2-installation-debian-7-2-x64","status":"publish","type":"post","link":"https:\/\/it.tuxie.eu\/?p=346","title":{"rendered":"Firebird 3.0 alpha 2 installation (Debian 7.3 x64)"},"content":{"rendered":"<p>I like Firebird software very much, for many years. Development is not as fast as I would like &#8211; anyway it is still exceptional RDBM software. Now I\u00b4m focused on 3.0 alpha2 version in a linux environment.<\/p>\n<p><!--more--><\/p>\n<p><span style=\"font-family: courier new,courier; font-size: 12px;\">j@deb73:~\/install$ <span style=\"color: #ff0000;\"><strong>ls -la<\/strong><\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">total 5668<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">drwxr-xr-x\u00a0 2 j j\u00a0\u00a0\u00a0 4096 Feb\u00a0 7 09:48 .<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">drwxr-xr-x 24 j j\u00a0\u00a0\u00a0 4096 Feb\u00a0 7 09:48 ..<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-rwxrwx&#8212;\u00a0 1 j j 5794723 Feb\u00a0 5 16:17 Firebird-3.0.0.30860-Alpha2.amd64.tar.gz<\/span><\/p>\n<p>We can expect anything from .tar.gz file \ud83d\ude42<\/p>\n<p><span style=\"font-family: courier new,courier; font-size: 12px;\">j@deb73:~\/install$ <span style=\"color: #ff0000;\"><strong>tar -xzf Firebird-3.0.0.30860-Alpha2.amd64.tar.gz <\/strong><\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">j@deb73:~\/install$ <span style=\"color: #ff0000;\"><strong>cd Firebird-3.0.0.30860-Alpha2.amd64\/<\/strong><\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">j@deb73:~\/install\/Firebird-3.0.0.30860-Alpha2.amd64$ <span style=\"color: #ff0000;\"><strong>ls -la<\/strong><\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">total 5684<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">drwxr-xr-x 3 j j\u00a0\u00a0\u00a0 4096 Jan 27 16:14 .<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">drwxr-xr-x 3 j j\u00a0\u00a0\u00a0 4096 Feb\u00a0 7 09:55 ..<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-rw-r&#8211;r&#8211; 1 j j 5757383 Jan 27 16:14 buildroot.tar.gz<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-rwxr-xr-x 1 j j\u00a0\u00a0 35927 Jan 27 16:14 install.sh<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-rw-r&#8211;r&#8211; 1 j j\u00a0\u00a0 11777 Jan 27 16:14 manifest.txt<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">drwxr-xr-x 2 j j\u00a0\u00a0\u00a0 4096 Jan 27 16:14 scripts<\/span><\/p>\n<p>Let\u00b4s try it as root. No documentation, no readme file&#8230;.<\/p>\n<p><span style=\"font-family: courier new,courier; font-size: 12px;\">root@deb73:\/home\/j\/install\/Firebird-3.0.0.30860-Alpha2.amd64# <span style=\"color: #ff0000;\"><strong>.\/install.sh<\/strong><\/span><\/span><\/p>\n<p><span style=\"font-family: courier new,courier; font-size: 12px;\">Firebird 3.0.0.30860-Alpha2.amd64 Installation<\/span><\/p>\n<p><span style=\"font-family: courier new,courier; font-size: 12px;\">Press Enter to start installation or ^C to abort<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Extracting install data<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Please enter new password for SYSDBA user: <span style=\"color: #ff0000;\"><strong>lala<\/strong><\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">\/opt\/fb30-alpha\/bin\/gsec: error while loading shared libraries: libtommath.so.0: cannot open shared object file: No such file or directory<\/span><\/p>\n<p><span style=\"font-family: courier new,courier; font-size: 12px;\">Starting Firebird server: \/opt\/fb30-alpha\/bin\/fbguard: error while loading shared libraries: libtommath.so.0: cannot open shared object file: No such file or directory<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Starting Firebird server: \/opt\/fb30-alpha\/bin\/fbguard: error while loading shared libraries: libtommath.so.0: cannot open shared object file: No such file or directory<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Looks like standalone server failed to start<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Trying to continue anyway&#8230;<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Install completed<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">root@deb73:\/home\/j\/install\/Firebird-3.0.0.30860-Alpha2.amd64#<\/span><\/p>\n<p>Ok, firebird did not start &#8211; some prerequisity library is missing, we can solve it this way:<\/p>\n<p><span style=\"font-family: courier new,courier; font-size: 12px;\">root@deb73:~# <span style=\"color: #ff0000;\"><strong>apt-get install libtommath-dev<\/strong><\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Reading package lists&#8230; Done<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Building dependency tree\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Reading state information&#8230; Done<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">The following extra packages will be installed:<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">\u00a0 libtommath-docs libtommath0<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">The following NEW packages will be installed:<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">\u00a0 libtommath-dev libtommath-docs libtommath0<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">0 upgraded, 3 newly installed, 0 to remove and 0 not upgraded.<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Need to get 1,604 kB of archives.<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">After this operation, 2,068 kB of additional disk space will be used.<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Do you want to continue [Y\/n]? <\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Get:1 http:\/\/ftp.cz.debian.org\/debian\/ wheezy\/main libtommath0 amd64 0.42.0-1 [65.3 kB]<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Get:2 http:\/\/ftp.cz.debian.org\/debian\/ wheezy\/main libtommath-dev amd64 0.42.0-1 [87.2 kB]<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Get:3 http:\/\/ftp.cz.debian.org\/debian\/ wheezy\/main libtommath-docs all 0.42.0-1 [1,451 kB]<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Fetched 1,604 kB in 0s (3,217 kB\/s)\u00a0\u00a0 \u00a0<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Selecting previously unselected package libtommath0.<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">(Reading database &#8230; 142206 files and directories currently installed.)<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Unpacking libtommath0 (from &#8230;\/libtommath0_0.42.0-1_amd64.deb) &#8230;<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Selecting previously unselected package libtommath-dev.<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Unpacking libtommath-dev (from &#8230;\/libtommath-dev_0.42.0-1_amd64.deb) &#8230;<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Selecting previously unselected package libtommath-docs.<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Unpacking libtommath-docs (from &#8230;\/libtommath-docs_0.42.0-1_all.deb) &#8230;<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Setting up libtommath0 (0.42.0-1) &#8230;<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Setting up libtommath-dev (0.42.0-1) &#8230;<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Setting up libtommath-docs (0.42.0-1) &#8230;<\/span><\/p>\n<p>In case that installation process was successful (seems to be), with no worries I\u00b4m rebooting machine and after reboot checking something with &#8222;fire&#8220; in running processes:<\/p>\n<p><span style=\"font-family: courier new,courier; font-size: 12px;\">j@deb73:~$ <span style=\"color: #ff0000;\"><strong>ps -ef | grep fire<\/strong><\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">firebird\u00a0 2742\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 10:18 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 \/opt\/fb30-alpha\/bin\/fbguard -pidfile \/var\/run\/firebird\/firebird.pid -daemon -forever<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">firebird\u00a0 2745\u00a0 2742\u00a0 0 10:18 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 \/opt\/fb30-alpha\/bin\/firebird<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">j\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3439\u00a0 3392\u00a0 0 10:19 pts\/0\u00a0\u00a0\u00a0 00:00:00 grep fire<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">j@deb73:~$ <\/span><\/p>\n<p>Well, two main processes (fbguard and firebird) are running. Also listening on port 3050 is active:<\/p>\n<p><span style=\"font-family: courier new,courier; font-size: 12px;\">root@deb73:\/opt\/fb30-alpha\/doc# <span style=\"color: #ff0000;\"><strong>netstat -an | grep 3050<\/strong><\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">tcp\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 0 0.0.0.0:3050\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.0.0.0:*\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LISTEN\u00a0 <\/span><\/p>\n<p>&nbsp;<\/p>\n<p>Next step = &#8222;and what now&#8220; \ud83d\ude42 Creating database (file) + connect into this database:<\/p>\n<p><span style=\"font-family: courier new,courier; font-size: 12px;\">root@deb73:\/opt\/fb30-alpha\/bin# <span style=\"color: #ff0000;\"><strong>.\/isql<\/strong><\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Use CONNECT or CREATE DATABASE to specify a database<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; <span style=\"color: #ff0000;\"><strong>CREATE DATABASE &#8218;\/firebird\/test.fdb&#8216; page_size 8192<\/strong><\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">CON&gt; <span style=\"color: #ff0000;\"><strong>user &#8218;SYSDBA&#8216; password &#8218;lala&#8216;;<\/strong><\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; <span style=\"color: #ff0000;\"><strong>connect &#8218;\/firebird\/test.fdb&#8216;<\/strong><\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">CON&gt; <span style=\"color: #ff0000;\"><strong>user &#8218;SYSDBA&#8216; password &#8218;lala&#8216;;<\/strong><\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Commit current transaction (y\/n)?<span style=\"color: #ff0000;\"><strong>y<\/strong><\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Committing.<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database:\u00a0 &#8218;\/firebird\/test.fdb&#8216;, User: SYSDBA<\/span><br \/>\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; <\/span><\/p>\n<p>Database is created. Similar way we can create test tables and other objects in isql command line.<\/p>\n<p>-a-<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I like Firebird software very much, for many years. Development is not as fast as I would like &#8211; anyway it is still exceptional RDBM software. Now I\u00b4m focused on 3.0 alpha2 version in a linux environment.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7,16],"tags":[],"_links":{"self":[{"href":"https:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/posts\/346"}],"collection":[{"href":"https:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=346"}],"version-history":[{"count":0,"href":"https:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/posts\/346\/revisions"}],"wp:attachment":[{"href":"https:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}