Difference between revisions of "Firebird"
m (→Post Install) |
|||
(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> | ||
− | + | B) run this: | |
<pre> | <pre> | ||
yum --enablerepo=epel install firebird-superserver | yum --enablerepo=epel install firebird-superserver | ||
− | |||
− | |||
− | |||
− | |||
</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 | |
− | + | 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> | |
− | - | ||
− |
Latest revision as of 12:07, 19 May 2018
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
- 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
- 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
- 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