Firebird

From SME Server
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

FAQ

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

Classic or Superserver?

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 service status enabled
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc7.d/S99firebird
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc1.d/S01firebird
service firebird start
  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