Difference between revisions of "Firebird"

From SME Server
Jump to navigationJump to search
m (fix setprop ->set)
 
(19 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
How to install Firebird SS on SME
+
{{Note box| What is this page about, for what purpose and what is Firebird please? What is SS or SC versions}}
  
−
1) Enable EPEL repository as from http://wiki.contribs.org/Epel<br>
+
==About Firebird==
  
−
Here is command for SME8, see there for SME7<br>
+
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==
 +
 +
{{Note box| '''Warning''' <br> I'm not sure what is the best version: SS or CS (classic) but I'm sure SS is a lot easier to install!<br>
 +
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
 +
 +
=== version 2.5.3.26780 ===
 
<pre>
 
<pre>
−
/sbin/e-smith/db yum_repositories set epel repository \
+
wget ftp://ftp.ntua.gr/pub/databases/firebird/firebird-linux-i386/2.5.3-Release/FirebirdSS-2.5.3.26780-0.i686.rpm
−
Name 'Epel - EL5' \
+
rpm -Uvh FirebirdSS-2.5.3.26780-0.i686.rpm
−
BaseUrl 'http://download.fedoraproject.org/pub/epel/5/$basearch' \
+
</pre>
−
MirrorList 'http://mirrors.fedoraproject.org/mirrorlist?repo=epel-5&arch=$basearch' \
+
=== version 2.1.5 ===
−
EnableGroups no \
+
A) Enable EPEL repository as from http://wiki.contribs.org/Epel<br>
−
GPGCheck yes \
 
−
GPGKey http://download.fedora.redhat.com/pub/epel/RPM-GPG-KEY-EPEL \
 
−
Visible no \
 
−
status disabled
 
  
−
signal-event yum-modify
+
 
 +
B) run this:
 +
<pre>
 +
yum --enablerepo=epel install firebird-superserver
 
</pre>
 
</pre>
−
2) run this:
+
 
 +
=== Post Install ===
 +
# configure Firebird for SME environment
 
<pre>
 
<pre>
−
yum --enablerepo=epel install firebird-superserver
+
config set firebird-superserver service status enabled
−
config set firebird service status enabled
+
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc7.d/S99firebird-superserver
−
cd /etc/rc7.d
+
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 S99firebird
+
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc1.d/S01firebird-superserver
−
service firebird start
+
service firebird-superserver start
 
</pre>
 
</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
 +
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
 
Extracted from: http://forums.contribs.org/index.php?topic=45447.0
 +
 +
By default, Firebird just allow access from local networks.<br>If you wanna to allow '''INTERNET ACCESS''' to your Firebird ('''NOT RECOMMENDED''') run:
 +
<pre>
 +
config setprop firebird access public TCPPort 3050
 +
signal-event remoteaccess-update
 +
</pre>
 +
 +
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<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>

Latest revision as of 13: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

Retrieved from "https://wiki.koozali.org/index.php?title=Firebird&oldid=34704"