147
edits
Changes
Jump to navigation
Jump to search
mLine 1:
Line 1: − How to install Firebird SS on SME+ − 1) Enable EPEL repository as from http://wiki.contribs.org/Epel<br>+ − Here is command for SME8, see there for SME7<br>+ + + + + + + + + + + + + + + + + + + − /sbin/e-smith/db yum_repositories set epel repository \+ − Name 'Epel - EL5' \+ − BaseUrl 'http://download.fedoraproject.org/pub/epel/5/$basearch' \+ − MirrorList 'http://mirrors.fedoraproject.org/mirrorlist?repo=epel-5&arch=$basearch' \+ − EnableGroups no \+ − GPGCheck yes \ − GPGKey http://download.fedora.redhat.com/pub/epel/RPM-GPG-KEY-EPEL \ − Visible no \ − status disabled − signal-event yum-modify+ + + + − 2) run this:+ + + − yum --enablerepo=epel install firebird-superserver+ − config set firebird service status enabled+ − cd /etc/rc7.d+ − + − + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
→Post Install
{{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==
{{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>
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>
yum --enablerepo=epel install firebird-superserver
</pre>
</pre>
=== Post Install ===
# configure Firebird for SME environment
<pre>
<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 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>