I like Firebird software very much, for many years. Development is not as fast as I would like – anyway it is still exceptional RDBM software. Now I´m focused on 3.0 alpha2 version in a linux environment.
j@deb73:~/install$ ls -la
total 5668
drwxr-xr-x 2 j j 4096 Feb 7 09:48 .
drwxr-xr-x 24 j j 4096 Feb 7 09:48 ..
-rwxrwx— 1 j j 5794723 Feb 5 16:17 Firebird-3.0.0.30860-Alpha2.amd64.tar.gz
We can expect anything from .tar.gz file 🙂
j@deb73:~/install$ tar -xzf Firebird-3.0.0.30860-Alpha2.amd64.tar.gz
j@deb73:~/install$ cd Firebird-3.0.0.30860-Alpha2.amd64/
j@deb73:~/install/Firebird-3.0.0.30860-Alpha2.amd64$ ls -la
total 5684
drwxr-xr-x 3 j j 4096 Jan 27 16:14 .
drwxr-xr-x 3 j j 4096 Feb 7 09:55 ..
-rw-r–r– 1 j j 5757383 Jan 27 16:14 buildroot.tar.gz
-rwxr-xr-x 1 j j 35927 Jan 27 16:14 install.sh
-rw-r–r– 1 j j 11777 Jan 27 16:14 manifest.txt
drwxr-xr-x 2 j j 4096 Jan 27 16:14 scripts
Let´s try it as root. No documentation, no readme file….
root@deb73:/home/j/install/Firebird-3.0.0.30860-Alpha2.amd64# ./install.sh
Firebird 3.0.0.30860-Alpha2.amd64 Installation
Press Enter to start installation or ^C to abort
Extracting install data
Please enter new password for SYSDBA user: lala
/opt/fb30-alpha/bin/gsec: error while loading shared libraries: libtommath.so.0: cannot open shared object file: No such file or directory
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
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
Looks like standalone server failed to start
Trying to continue anyway…
Install completed
root@deb73:/home/j/install/Firebird-3.0.0.30860-Alpha2.amd64#
Ok, firebird did not start – some prerequisity library is missing, we can solve it this way:
root@deb73:~# apt-get install libtommath-dev
Reading package lists… Done
Building dependency tree
Reading state information… Done
The following extra packages will be installed:
libtommath-docs libtommath0
The following NEW packages will be installed:
libtommath-dev libtommath-docs libtommath0
0 upgraded, 3 newly installed, 0 to remove and 0 not upgraded.
Need to get 1,604 kB of archives.
After this operation, 2,068 kB of additional disk space will be used.
Do you want to continue [Y/n]?
Get:1 http://ftp.cz.debian.org/debian/ wheezy/main libtommath0 amd64 0.42.0-1 [65.3 kB]
Get:2 http://ftp.cz.debian.org/debian/ wheezy/main libtommath-dev amd64 0.42.0-1 [87.2 kB]
Get:3 http://ftp.cz.debian.org/debian/ wheezy/main libtommath-docs all 0.42.0-1 [1,451 kB]
Fetched 1,604 kB in 0s (3,217 kB/s)
Selecting previously unselected package libtommath0.
(Reading database … 142206 files and directories currently installed.)
Unpacking libtommath0 (from …/libtommath0_0.42.0-1_amd64.deb) …
Selecting previously unselected package libtommath-dev.
Unpacking libtommath-dev (from …/libtommath-dev_0.42.0-1_amd64.deb) …
Selecting previously unselected package libtommath-docs.
Unpacking libtommath-docs (from …/libtommath-docs_0.42.0-1_all.deb) …
Setting up libtommath0 (0.42.0-1) …
Setting up libtommath-dev (0.42.0-1) …
Setting up libtommath-docs (0.42.0-1) …
In case that installation process was successful (seems to be), with no worries I´m rebooting machine and after reboot checking something with „fire“ in running processes:
j@deb73:~$ ps -ef | grep fire
firebird 2742 1 0 10:18 ? 00:00:00 /opt/fb30-alpha/bin/fbguard -pidfile /var/run/firebird/firebird.pid -daemon -forever
firebird 2745 2742 0 10:18 ? 00:00:00 /opt/fb30-alpha/bin/firebird
j 3439 3392 0 10:19 pts/0 00:00:00 grep fire
j@deb73:~$
Well, two main processes (fbguard and firebird) are running. Also listening on port 3050 is active:
root@deb73:/opt/fb30-alpha/doc# netstat -an | grep 3050
tcp 0 0 0.0.0.0:3050 0.0.0.0:* LISTEN
Next step = „and what now“ 🙂 Creating database (file) + connect into this database:
root@deb73:/opt/fb30-alpha/bin# ./isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> CREATE DATABASE ‚/firebird/test.fdb‘ page_size 8192
CON> user ‚SYSDBA‘ password ‚lala‘;
SQL> connect ‚/firebird/test.fdb‘
CON> user ‚SYSDBA‘ password ‚lala‘;
Commit current transaction (y/n)?y
Committing.
Database: ‚/firebird/test.fdb‘, User: SYSDBA
SQL>
Database is created. Similar way we can create test tables and other objects in isql command line.
-a-