Firebird

From SME Server
Revision as of 12:02, 19 May 2018 by Jader (talk | contribs)
Jump to navigationJump to search
Important.png Note:
What is this page about, for what purpose and what is Firebird please? What is SS or SC versions


About Firebird

Firebird is an open source SQL relational database management system that runs on Linux, Microsoft Windows, Mac OS X and a variety of Unix. The database forked from Borland's open source edition of InterBase in 2000, but since Firebird 1.5 the code has been largely rewritten

Wikipedia - Main Features

https://en.m.wikipedia.org/wiki/Firebird_(database_server)

Classic (CS) or Superserver (SS) ?

Firebird comes in two flavors, called architectures: Classic Server and Superserver. Which one should you install? That depends on your situation. A short overview of the most important differences follows. See  http://www.firebirdsql.org/pdfmanual/html/qsg15-classic-or-super.html

How to install Firebird SS on SME

Important.png Note:
Warning
I'm not sure what is the best version: SS or CS (classic) but I'm sure SS is a lot easier to install!

I've done a CS to work...but lots of manual tweak (shame: I do not take notes)... maybe some time I have to redo it and take the apropriate notes or someone else have done it.
- Jáder


  1. Choose the version

version 2.5.3.26780

wget ftp://ftp.ntua.gr/pub/databases/firebird/firebird-linux-i386/2.5.3-Release/FirebirdSS-2.5.3.26780-0.i686.rpm
rpm -Uvh FirebirdSS-2.5.3.26780-0.i686.rpm

version 2.1.5

A) Enable EPEL repository as from http://wiki.contribs.org/Epel


B) run this:

yum --enablerepo=epel install firebird-superserver

Post Install

  1. configure Firebird for SME environment
config set firebird-superserver service status enabled
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc7.d/S99firebird-superserver
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc4.d/S99firebird-superserver
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc1.d/S01firebird-superserver
service firebird-superserver start

NB. The above commands have been updated by TDBSOFT on 1/1/2017 (with help from Stefano).
The update is to resolve the new service name firebird-superserver changed from firebird.
See http://forums.contribs.org/index.php?topic=52794

  1. Verify your firebird is running:
netstat -an|grep 3050

should show:

tcp        0      0 0.0.0.0:3050                0.0.0.0:*                   LISTEN    

Extracted from: http://forums.contribs.org/index.php?topic=45447.0

By default, Firebird just allow access from local networks.
If you wanna to allow INTERNET ACCESS to your Firebird (NOT RECOMMENDED) run:

config setprop firebird access public TCPPort 3050
signal-event remoteaccess-update 

Verify the config:

config show firebird

Should show something like:

firebird=service
    TCPPort=3050
    access=public
    status=enabled

Additional note by TDBSOFT 1/1/2017
There is a minor bug in the firebird-superserver service when you run the command

 service firebird-superserver start


This will show the following result

Starting Firebird server [default] /usr/bin/dirname: extra operand `-daemon'<br>
Try `/usr/bin/dirname --help' for more information.    [ OK ]


To resolve this issue edit the file /etc/init.d/firebird-superserver and change the line below

daemon --user=$FBRunUser "export FIREBIRD LD_LIBRARY_PATH; $GUARDIAN -pidfile $pidfile -daemon -forever" 


to

daemon </nowiki><b>--check="X"</b> --user=$FBRunUser "export FIREBIRD LD_LIBRARY_PATH; $GUARDIAN -pidfile $pidfile -daemon -forever"


See this article on the problem http://tracker.firebirdsql.org/browse/CORE-5069