Subject | Firebird 2.5 embedded on Linux - picking up wrong config? |
---|---|
Author | Reinier Olislagers |
Post date | 2013-11-18T16:39:23Z |
Struggling to get FB embedded on Linux going; below what I did based on
the 2 links in http://www.firebirdfaq.org (one about 1.5.x, one newer):
cd /home/pascaldev/embed
wget
http://sourceforge.net/projects/firebird/files/firebird-linux-amd64/2.5.2-Release/FirebirdCS-2.5.2.26540-0.amd64.tar.gz/download
#or whatever version it really is...
mv download FirebirdCS-2.5.2.26540-0.amd64.tar.gz
tar xvzf FirebirdCS-2.5.2.26540-0.amd64.tar.gz
tar xvzf FirebirdCS-2.5.2.26540-0.amd64/buildroot.tar.gz
cp opt/firebird/firebird.conf .
cp opt/firebird/firebird.msg .
cp opt/firebird/security2.fdb .
#don't know what to do with intl. copy them 2x to be sure.
cp opt/firebird/intl/fbintl.conf .
cp opt/firebird/intl/fbintl .
mkdir intl
cp opt/firebird/intl/fbintl.conf intl/
cp opt/firebird/intl/fbintl intl/
cp opt/firebird/lib/libfbembed.so.2.5.2 .
cp opt/firebird/lib/libib_util.so .
cp opt/firebird/lib/libicudata.so.30.0 .
cp opt/firebird/lib/libicuuc.so.30.0 .
cp opt/firebird/lib/libicui18n.so.30.0 .
#optional, but useful for troubleshooting:
mkdir bin
cp opt/firebird/bin/isql bin/
#clean up a bit
rm -rf FirebirdCS-2.5.2.26540-0.amd64
sudo rm -rf opt
sudo rm -rf usr
#edit firebird.conf:
#to do: replace with . or something?
RootDirectory=/home/pascaldev/embed
DatabaseAccess = Full
ExternalFileAccess = None
UdfAccess = Full
TempDirectories = /tmp
# this apparently doesn't do anything?!?!:
export FIREBIRD_TMP=/tmp
export FIREBIRD=`pwd` #/home/pascaldev/embed in my tests
# specify exact dynamic library file to use:
export FBLIB=libfbembed.so.2.5.2
# put application directory in our .so search path:
export LD_LIBRARY_PATH=`pwd`#/home/pascaldev/embed in my tests
my test application won't run; first troubleshooting
bin/isql -user sysdba -pass masterkey
connect test.fdb;
Statement failed, SQLSTATE = HY000
Can't access lock files' directory /tmp/firebird
It seems firebird is still picking up stuff (the temp dir from
firebird.conf?) from the existing system wide install.
What am I doing wrong?
Thanks.
the 2 links in http://www.firebirdfaq.org (one about 1.5.x, one newer):
cd /home/pascaldev/embed
wget
http://sourceforge.net/projects/firebird/files/firebird-linux-amd64/2.5.2-Release/FirebirdCS-2.5.2.26540-0.amd64.tar.gz/download
#or whatever version it really is...
mv download FirebirdCS-2.5.2.26540-0.amd64.tar.gz
tar xvzf FirebirdCS-2.5.2.26540-0.amd64.tar.gz
tar xvzf FirebirdCS-2.5.2.26540-0.amd64/buildroot.tar.gz
cp opt/firebird/firebird.conf .
cp opt/firebird/firebird.msg .
cp opt/firebird/security2.fdb .
#don't know what to do with intl. copy them 2x to be sure.
cp opt/firebird/intl/fbintl.conf .
cp opt/firebird/intl/fbintl .
mkdir intl
cp opt/firebird/intl/fbintl.conf intl/
cp opt/firebird/intl/fbintl intl/
cp opt/firebird/lib/libfbembed.so.2.5.2 .
cp opt/firebird/lib/libib_util.so .
cp opt/firebird/lib/libicudata.so.30.0 .
cp opt/firebird/lib/libicuuc.so.30.0 .
cp opt/firebird/lib/libicui18n.so.30.0 .
#optional, but useful for troubleshooting:
mkdir bin
cp opt/firebird/bin/isql bin/
#clean up a bit
rm -rf FirebirdCS-2.5.2.26540-0.amd64
sudo rm -rf opt
sudo rm -rf usr
#edit firebird.conf:
#to do: replace with . or something?
RootDirectory=/home/pascaldev/embed
DatabaseAccess = Full
ExternalFileAccess = None
UdfAccess = Full
TempDirectories = /tmp
# this apparently doesn't do anything?!?!:
export FIREBIRD_TMP=/tmp
export FIREBIRD=`pwd` #/home/pascaldev/embed in my tests
# specify exact dynamic library file to use:
export FBLIB=libfbembed.so.2.5.2
# put application directory in our .so search path:
export LD_LIBRARY_PATH=`pwd`#/home/pascaldev/embed in my tests
my test application won't run; first troubleshooting
bin/isql -user sysdba -pass masterkey
connect test.fdb;
Statement failed, SQLSTATE = HY000
Can't access lock files' directory /tmp/firebird
It seems firebird is still picking up stuff (the temp dir from
firebird.conf?) from the existing system wide install.
What am I doing wrong?
Thanks.