Friday, October 29, 2010

Using Firebird 2.5 official tar.gz installer on #Ubuntu Maverick Meerkat 10.10

get a old libstdc++5 from debian archives
in my case ubuntu is on 64 bit so i need amd64 (aka x86-64 and can be used even on Intel machines)
for 32 bit use the following link

you can determine you type of installation with
$ uname -m

sudo dpkg -i libstdc++5_3.3.6-18_amd64.deb

Download the Firebird tar.gz installer from Firebird 2.5 release page

The easiest way is to install FirebirdSS (aka Super Server)
in my case i choose the 64 bit version for Linux

tar -zxvf FirebirdSS-
cd FirebirdSS-

sudo ./

Firebird super Installation

Press Enter to start installation or ^C to abort
Extracting install data

Starting Firebird server: Please enter new password for SYSDBA user: SYSDBApassword
Install completed

(ignore the insserv warnings )

Now work withe the example database

SQL> connect "/opt/firebird/examples/empbuild/employee.fdb " user 'SYSDBA' password 'SYSDBApassword';
Database:  "/opt/firebird/examples/empbuild/employee.fdb ", User: SYSDBA
SQL> show tables;
       COUNTRY                                CUSTOMER                       
       DEPARTMENT                             EMPLOYEE                       
       EMPLOYEE_PROJECT                       JOB                            
       PROJECT                                PROJ_DEPT_BUDGET               
       SALARY_HISTORY                         SALES                          


Next install flamerobin and you start working with your new shinny firebird server (create databasese ...)

sudo apt-get install flamerobin

SQL> CREATE DATABASE '/tmp/myshinnymetal*ss' user 'SYSDBA' password 'SYSDBApassword';
SQL> connect "/tmp/myshinnymetal*ss" user 'SYSDBA' password 'SYSDBApassword';
Database:  "/opt/firebird/examples/empbuild/employee.fdb", User: SYSDBA


José Torres said...

Thanks! I hope this can help me, I am not Linux expert and have tried to install Fb twice on Ubuntu 10.10, without success.

Antonio said...

Hi I had followed your instruction here to install firebird 2.5 in my ubuntu server 18.04 and it's running fine but when I reboot my server the firebird service isn't starting up automatic so I have to start it manually