Firebird 2.0 rc2 from source howto (ubuntu dapper drake)
This was tested on the Ubuntu Dapper Drake (that will be released this summer)
I assume you have installed the g++ compiler (with apt-get or synaptic)
download the Firebird 2.0 RC 2 kit from the nearest mirror
wget http://ovh.dl.sourceforge.net/sourceforge/firebird/Firebird-2.0.0.12654-ReleaseCandidate2.tar.bz2
tar -jxvf Firebird-2.0.0.12654-ReleaseCandidate2.tar.bz2
cd firebird-2.0.0.12654-ReleaseCandidate2/
sudo apt-get install libreadline5-dev bison
sh autogen.sh –prefix=/opt/firebird2 –enable-superserver
make
sudo make install
ps -awwwx | grep firebird (see if is working)
/opt/firebird2/bin/isql -u SYSDBA -p masterkey /opt/firebird2/examples/empbuild/employee.fdb
Database: /opt/firebird2/examples/empbuild/employee.fdb, User: SYSDBA
SQL> show tables ;
COUNTRY CUSTOMER
DEPARTMENT EMPLOYEE
EMPLOYEE_PROJECT JOB
PROJECT PROJ_DEPT_BUDGET
SALARY_HISTORY SALES
SQL>select * from sales;
Here is one screenshot
Loading...
This doesn’t seem to work on AMD64. I’m using Kubuntu (Dapper). After performing a make, editing some source lines for precision problems, and make’ing successfully, I still get errors. Here’s my output for sudo make install:
> sudo make install
Password:
make -C gen install
make[1]: Entering directory `/d/installed_proggies/firebird-2.0.0.12654-ReleaseCandidate2/gen’
make -f ../gen/Makefile.install install
make[2]: Entering directory `/d/installed_proggies/firebird-2.0.0.12654-ReleaseCandidate2/gen’
(cd ../gen; ./install/makeInstallImage.sh)
cp: cannot stat `../doc/*.pdf’: No such file or directory
mkdir -p ../gen/FirebirdSS-debuginfo-2.0.0.12654-ReleaseCandidate2.amd64
for x in `(cd ../gen/buildroot; find)`; do
FIL=../gen/buildroot/$x;
D_FIL=../gen/FirebirdSS-debuginfo-2.0.0.12654-ReleaseCandidate2.amd64/`dirname ${x}`/.debug/`basename ${x}`.debug;
if [ ! -h $FIL ] && readelf -h $FIL > /dev/null 2> /dev/null; then
mkdir -p ../gen/FirebirdSS-debuginfo-2.0.0.12654-ReleaseCandidate2.amd64/`dirname $x`/.debug;
echo Generating external debug info for $x;
cp ${FIL} ${D_FIL};
if objcopy –add-gnu-debuglink ${D_FIL} ${FIL}; > /dev/null 2> /dev/null; then
echo Succeeded using objcopy from binutils;
else
echo Failed to set debug link for ${x};
fi;
echo Stripping unneeded symbols from ${x};
objcopy –strip-debug –strip-unneeded ${FIL};
fi;
done
Generating external debug info for ./opt/firebird/UDF/fbudf.so
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/UDF/fbudf.so
Generating external debug info for ./opt/firebird/UDF/ib_udf.so
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/UDF/ib_udf.so
Generating external debug info for ./opt/firebird/bin/qli
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/bin/qli
Generating external debug info for ./opt/firebird/bin/gbak
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/bin/gbak
Generating external debug info for ./opt/firebird/bin/gdef
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/bin/gdef
Generating external debug info for ./opt/firebird/bin/gfix
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/bin/gfix
Generating external debug info for ./opt/firebird/bin/gpre
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/bin/gpre
Generating external debug info for ./opt/firebird/bin/gsec
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/bin/gsec
Generating external debug info for ./opt/firebird/bin/isql
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/bin/isql
Generating external debug info for ./opt/firebird/bin/fbmgr.bin
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/bin/fbmgr.bin
Generating external debug info for ./opt/firebird/bin/gstat
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/bin/gstat
Generating external debug info for ./opt/firebird/bin/fbguard
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/bin/fbguard
Generating external debug info for ./opt/firebird/bin/fbserver
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/bin/fbserver
Generating external debug info for ./opt/firebird/bin/gsplit
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/bin/gsplit
Generating external debug info for ./opt/firebird/bin/fb_lock_print
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/bin/fb_lock_print
Generating external debug info for ./opt/firebird/lib/libib_util.so
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/lib/libib_util.so
Generating external debug info for ./opt/firebird/lib/libicudata.so.30.0
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/lib/libicudata.so.30.0
Generating external debug info for ./opt/firebird/lib/libfbclient.so.2.0.0
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/lib/libfbclient.so.2.0.0
Generating external debug info for ./opt/firebird/lib/libicuuc.so.30.0
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/lib/libicuuc.so.30.0
Generating external debug info for ./opt/firebird/lib/libicui18n.so.30.0
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/lib/libicui18n.so.30.0
Generating external debug info for ./opt/firebird/intl/fbintl
Succeeded using objcopy from binutils
Stripping unneeded symbols from ./opt/firebird/intl/fbintl
mkdir -p ../gen/FirebirdSS-debuginfo-2.0.0.12654-ReleaseCandidate2.amd64/usr/lib64/.debug
for x in `ls ../gen/FirebirdSS-debuginfo-2.0.0.12654-ReleaseCandidate2.amd64/opt/firebird/lib/.debug`; do
ln -f -s /opt/firebird/lib/.debug/`basename $x` ../gen/FirebirdSS-debuginfo-2.0.0.12654-ReleaseCandidate2.amd64/usr/lib64/.debug;
done
mkdir -p ../gen/FirebirdSS-2.0.0.12654-ReleaseCandidate2.amd64
cp -r ../gen/install/scripts ../gen/FirebirdSS-2.0.0.12654-ReleaseCandidate2.amd64
cp -r ../gen/install/scripts/tarMainInstall.sh ../gen/FirebirdSS-2.0.0.12654-ReleaseCandidate2.amd64/install.sh
chmod a+x ../gen/FirebirdSS-2.0.0.12654-ReleaseCandidate2.amd64/install.sh ../gen/FirebirdSS-2.0.0.12654-ReleaseCandidate2.amd64/scripts/*sh
(cd ../gen/FirebirdSS-2.0.0.12654-ReleaseCandidate2.amd64; tar -C ../buildroot -czf buildroot.tar.gz . )
(cd ../gen/FirebirdSS-2.0.0.12654-ReleaseCandidate2.amd64; tar -tzf buildroot.tar.gz > manifest.txt )
(cd ../gen/FirebirdSS-2.0.0.12654-ReleaseCandidate2.amd64; ./install.sh)
Firebird super 2.0.0.12654-ReleaseCandidate2.amd64 Installation
Press Enter to start installation or ^C to abort
Extracting install data
Updated /etc/services
Usage: useradd [options] LOGIN
Options:
-b, –base-dir BASE_DIR base directory for the new user account
home directory
-c, –comment COMMENT set the GECOS field for the new user account
-d, –home-dir HOME_DIR home directory for the new user account
-D, –defaults print or save modified default useradd
configuration
-e, –expiredate EXPIRE_DATE set account expiration date to EXPIRE_DATE
-f, –inactive INACTIVE set password inactive after expiration
to INACTIVE
-g, –gid GROUP force use GROUP for the new user account
-G, –groups GROUPS list of supplementary groups for the new
user account
-h, –help display this help message and exit
-k, –skel SKEL_DIR specify an alternative skel directory
-K, –key KEY=VALUE overrides /etc/login.defs defaults
-m, –create-home create home directory for the new user
account
-o, –non-unique allow create user with duplicate
(non-unique) UID
-p, –password PASSWORD use encrypted password for the new user
account
-s, –shell SHELL the login shell for the new user account
-u, –uid UID force use the UID for the new user account
chown: `firebird:firebird’: invalid user
chown: `firebird:firebird’: invalid user
chown: `firebird:firebird’: invalid user
chown: `firebird:firebird’: invalid user
chown: `firebird:firebird’: invalid user
chown: `firebird:firebird’: invalid user
chown: `firebird:firebird’: invalid user
Adding system startup for /etc/init.d/firebird …
/etc/rc0.d/K20firebird -> ../init.d/firebird
/etc/rc1.d/K20firebird -> ../init.d/firebird
/etc/rc6.d/K20firebird -> ../init.d/firebird
/etc/rc2.d/S14firebird -> ../init.d/firebird
/etc/rc3.d/S14firebird -> ../init.d/firebird
/etc/rc5.d/S14firebird -> ../init.d/firebird
chown: `firebird:firebird’: invalid user
Starting Firebird server: start-stop-daemon: user `firebird’ not found
(Success)
Fixing firebird’s shell to /bin/sh
usermod: user firebird does not exist
Starting Firebird server: start-stop-daemon: user `firebird’ not found
(Success)
Please enter new password for SYSDBA user: firebird
Unable to complete network request to host “localhost”.
Failed to establish a connection.
Connection refused
unable to open database
Please enter new password for SYSDBA user: firebird
This then becomes an infinite loop
Any help would be greatly appreciated.
try to add firebird user
and run the sudo make install again
That did it. Thanks!
sorry for the newbie post – but, after installing on Ubuntu 6.0 I can connect to server locally – and using Flamerobin, I can connect to server from windows client – and retrieve server version – but, I cannot connect to database or create database. TIA.
you need to create an directory lets say /opt/firebird2/databases where firebird user
can read write
You can test creating an empty database in /tmp for testing first
Thank you very much. I have fb SS version 2 running now on Ubuntu 6.0. I can connect using isql locally. Using a remote client (laptop with a 802.11g wireless – good connection), I can connect to the server but it is VERY slow(using isql and an application with .NET provider). Queries and results from stored procedures take several minutes – whereas the same applications on a Win XP server are instantaneous. The database on linux was created using a transportable backup from the Win XP server. TIA!
Replying to self. I found that the error was for file permission on the database file
using
$chmod o+rw
fixed the issue. Thanks!