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
x86_64

wget http://ftp.us.debian.org/debian/pool/main/g/gcc-3.3/libstdc++5_3.3.6-18_amd64.deb
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
wget http://downloads.sourceforge.net/project/firebird/firebird-linux-amd64/2.5-Release/FirebirdSS-2.5.0.26074-0.amd64.tar.gz

tar -zxvf FirebirdSS-2.5.0.26074-0.amd64.tar.gz
cd FirebirdSS-2.5.0.26074-0.amd64/


sudo ./install.sh

Firebird super 2.5.0.26074-0.amd64 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

/opt/firebird/bin/isql
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                          

SQL>

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

2 comments:

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