Changes

Jump to navigation Jump to search
2,282 bytes added ,  12:07, 19 May 2018
m
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]]
 
147

edits

Navigation menu