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 setprop 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> |