147
edits
Changes
Jump to navigation
Jump to search
mLine 5:
Line 5: − FAQ+ − + Line 39:
Line 39: − + − + − + − + + + + + + Line 52:
Line 57: − + − Line 68:
Line 72: + + + + + + + + + + + + + + + + + + + + + + + + +
→Post Install
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
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)
https://en.m.wikipedia.org/wiki/Firebird_(database_server)
Classic or Superserver?
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.
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.
# configure Firebird for SME environment
# configure Firebird for SME environment
<pre>
<pre>
config set firebird service status enabled
config set firebird-superserver 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/rc7.d/S99firebird-superserver
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc1.d/S01firebird
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc4.d/S99firebird-superserver
service firebird start
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc1.d/S01firebird-superserver
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:
# Verify your firebird is running:
netstat -an|grep 3050
netstat -an|grep 3050
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>
<pre>
config setprop firebird access public TCPPort 3050
config setprop firebird access public TCPPort 3050
access=public
access=public
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>