Difference between revisions of "Firebird"

From SME Server
Jump to navigationJump to search
(→‎How to install Firebird SS on SME: included Version 2.5.3 - easier to install and updated!)
Line 6: Line 6:
 
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
 +
</pre>
 +
 +
=== Post Install ===
 +
# configure Firebird for SME environment
 +
<pre>
 
config set firebird service status enabled
 
config set firebird service status enabled
cd /etc/rc7.d
+
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc7.d/S99firebird
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
 
service firebird start
 
service firebird start
 
</pre>
 
</pre>
  
Verify your firebird is running:
+
# Verify your firebird is running:
 
  netstat -an|grep 3050
 
  netstat -an|grep 3050
 
should show:
 
should show:
Line 28: Line 40:
 
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:

Revision as of 17:42, 1 February 2015

Important.png Note:
What is this page about, for what purpose and what is Firebird please? What is SS or SC versions


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 service status enabled
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc7.d/S99firebird
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc1.d/S01firebird
service firebird start
  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