Difference between revisions of "Firebird"

From SME Server
Jump to navigationJump to search
 
(11 intermediate revisions by 4 users not shown)
Line 1: Line 1:
 
{{Note box| What is this page about, for what purpose and what is Firebird please? What is SS or SC versions}}
 
{{Note box| 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==
 
==How to install Firebird SS on SME==
Line 6: Line 20:
 
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. <Br>- Jáder}}
 
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. <Br>- Jáder}}
  
 +
#Choose the version
  
1) Enable EPEL repository as from http://wiki.contribs.org/Epel<br>
+
=== version 2.5.3.26780 ===
 +
<pre>
 +
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
 +
</pre>
 +
=== version 2.1.5 ===
 +
A) Enable EPEL repository as from http://wiki.contribs.org/Epel<br>
  
  
2) run this:
+
B) run this:
 
<pre>
 
<pre>
 
yum --enablerepo=epel install firebird-superserver
 
yum --enablerepo=epel install firebird-superserver
config set firebird service status enabled
 
cd /etc/rc7.d
 
ln -s /etc/rc.d/init.d/e-smith-service S99firebird
 
service firebird start
 
 
</pre>
 
</pre>
  
Verify your firebird is running:
+
=== Post Install ===
 +
# configure Firebird for SME environment
 +
<pre>
 +
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
 +
</pre>
 +
 
 +
NB. The above commands have been updated by TDBSOFT on 1/1/2017 (with help from Stefano).<br>
 +
The update is to resolve the new service name firebird-superserver changed from firebird.<br>
 +
See http://forums.contribs.org/index.php?topic=52794<br>
 +
<br>
 +
# Verify your firebird is running:
 
  netstat -an|grep 3050
 
  netstat -an|grep 3050
 
should show:
 
should show:
Line 26: Line 57:
 
Extracted from: http://forums.contribs.org/index.php?topic=45447.0
 
Extracted from: http://forums.contribs.org/index.php?topic=45447.0
  
By default, Firebird just allow access from local networks.<br>
+
By default, Firebird just allow access from local networks.<br>If you wanna to allow '''INTERNET ACCESS''' to your Firebird ('''NOT RECOMMENDED''') run:
If you wanna to allow INTERNET ACCESS to your Firebird (NOT RECOMMENDED) run:
+
<pre>
 
+
config setprop firebird access public TCPPort 3050
config setprop firebird access public TCPPort 3050
+
signal-event remoteaccess-update  
signal-event remoteaccess-update  
+
</pre>
  
 
Verify the config:
 
Verify the config:
Line 42: Line 73:
 
     status=enabled
 
     status=enabled
  
 +
Additional note by TDBSOFT 1/1/2017<br>
 +
There is a minor bug in the firebird-superserver service when you run the command<br>
 +
<pre>
 +
service firebird-superserver start
 +
</pre>
 +
<br>
 +
This will show the following result
 +
<br>
 +
<pre>
 +
Starting Firebird server [default] /usr/bin/dirname: extra operand `-daemon'<br>
 +
Try `/usr/bin/dirname --help' for more information.    [ OK ]
 +
</pre>
 +
<br>
 +
To resolve this issue edit the file  /etc/init.d/firebird-superserver and change the line below<br>
 +
<pre>
 +
daemon --user=$FBRunUser "export FIREBIRD LD_LIBRARY_PATH; $GUARDIAN -pidfile $pidfile -daemon -forever"
 +
</pre><br>
 +
to
 +
<pre>
 +
daemon --check="X" --user=$FBRunUser "export FIREBIRD LD_LIBRARY_PATH; $GUARDIAN -pidfile $pidfile -daemon -forever"
 +
</pre>
 +
<br>
  
 
+
See this article on the problem http://tracker.firebirdsql.org/browse/CORE-5069<br>
----
 
[[Category:Howto]]
 

Latest revision as of 12:07, 19 May 2018

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 --check="X" --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