Installing Firebird 1.5 on Centos 6 32 bit (x86)

A while ago I needed to migrate a Firebird 1.5 server from Centos 5 to Centos 6 (to a new machine) since the old server had been running for 7+ years and it was time to give the old guy a break. I tried to install it in Centos 6 64 bit to no avail so I tried the 32 bit flavor and it worked as a charm. Here I provide a quasi-script to install all the dependencies, etc.

I tried my luck with the Classic Server first since I thought it would scale better since every connection would have its own process and use the whole 4GB per process limit on 32 bit, but the server would drop connections after 10+ users so I went with the SuperServer which was the Centos 5 configuration that worked well.

# Install dependencies

sudo su -l
yum -y install glibc.i686
yum -y install libstdc++.so.5
yum -y install libncurses.so.5

# Download Firebird Super Server

wget http://downloads.sourceforge.net/project/firebird/firebird-linux-i386/1.5.6-Release/FirebirdSS-1.5.6.5026-0.i686.rpm?r=http%3A%2F%2Fwww.firebirdsql.org%2Fen%2Ffirebird-1-5%2F&ts=1384921841&use_mirror=softlayer-dal

# Install Firebird package

rpm -i FirebirdSS-1.5.6.5026-0.i686.rpm

# Turn the service on at boot time

chkconfig --level 35 firebird on

# Optionally change the sysdba password

cd /opt/firebird

cat SYSDBA.password

bin/changeDBAPassword.sh

# Optionally create db path

mkdir /home/firebird

chown firebird:firebird /home/firebird

# Optionally Install flamerobin

wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
wget http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
sudo rpm -Uvh remi-release-6*.rpm epel-release-6*.rpm

yum -y install firebird-libfbclient

cd /root

wget http://downloads.sourceforge.net/project/flamerobin/flamerobin-snapshots/0.9.x/flamerobin-0.9.1.1806-i386-gtk2.tgz?r=http%3A%2F%2Fsourceforge.net%2Fprojects%2Fflamerobin%2Ffiles%2Fflamerobin-snapshots%2F0.9.x%2F&ts=1385064466&use_mirror=softlayer-dal

cd /

tar xvzf /root/flamerobin-0.9.1.1806-i386-gtk2.tgz

# Test flamerobin

ssh -Y user@server

flamerobin