Firebird 2.0.3 included in Ubuntu 7.10 (gutsy)
The new ubuntu 7.10 includes firebird 2.0.3 stable
Here is the package description , Here is how to install
You can inspect the packaged stable version
apt-cache search firebird2.0-*
install the super server package (you will be asked about the SYSDBA password and what service to enable :Choose Super Server)
sudo apt-get install firebird2.0-super
The following extra packages will be installed:
firebird2.0-common libfbclient2
Recommended packages:
firebird-utils
The following NEW packages will be installed:
firebird2.0-common firebird2.0-super libfbclient2
…
Setting up firebird2.0-common (2.0.3.12981.ds1-1ubuntu2) …
Setting up libfbclient2 (2.0.3.12981.ds1-1ubuntu2) …
Setting up firebird2.0-super (2.0.3.12981.ds1-1ubuntu2) …
Created default security.fdb
* Starting Firebird 2.0 server manager… [ OK ]
* Firebird 2.0 server manager already running.
Install the examples
$sudo apt-get install firebird2.0-examples firebird2.0-dev firebird-utils
The employee.fdb archive will be under this dir
/usr/share/doc/firebird2.0-examples/examples/empbuild/
$cd /usr/share/doc/firebird2.0-examples/examples/empbuild/
$sudo gunzip employee.fdb.gz
$sudo chown firebird.firebird employee.fdb
$sudo mv employee.fdb /var/lib/firebird/2.0/data/
connect to db
$ isql-fb
SQL> connect “employee.fdb ” user ‘SYSDBA’ password ‘SYSDBApassword‘;
Now you can check the server version and the tables
SQL> show tables;
COUNTRY CUSTOMER
DEPARTMENT EMPLOYEE
EMPLOYEE_PROJECT JOB
PROJECT PROJ_DEPT_BUDGET
SALARY_HISTORY SALES
SQL> show version
CON> ;
ISQL Version: LI-V2.0.3.12981 Firebird 2.0
Server version:
Firebird/linux Intel (access method), version “LI-V2.0.3.12981 Firebird 2.0″
Firebird/linux Intel (remote server), version ” LI-V2.0.3.12981 Firebird 2.0/tcp (borkstation32)/P10″
Firebird/linux Intel (remote interface), version “LI-V2.0.1.12855 Firebird 2.0/tcp (borkstation32)/P10”
on disk structure version 11.0
Loading...
Pingback: Firebird News » Firebird 2.0.3 included in Ubuntu 8.04 (Hardy)
Are you sure this work?
In my experience, under debian, the database installed using the standard packages does not work.
There is a solution for debian users in http://jachguate.wordpress.com/2007/12/07/instalar-firebird-debian/
(in spanish, but with script download)
Regards.
Firebird 2.0 is available only in sid(unstable) and lenny (testing)
You can do an easy dist-upgrade to the testing and use them
http://packages.debian.org/lenny/firebird2.0-super
http://packages.debian.org/sid/firebird2.0-super
You can see why firebird1.5 packages are called firebird2 here
http://www.firebirdfaq.org/faq159/
I have upgraded an stable machine to testing and the install went smooth without problems like in the ubuntu tutorial from above
I have removed all firebird2 and firebird1.5 packages and then installed the firebird2.0 ones
apt-get install firebird2.0-super
Reading package lists… Done
Building dependency tree
Reading state information… Done
The following extra packages will be installed:
firebird2.0-common libfbclient2 libicu36
Suggested packages:
firebird2.0-doc
Recommended packages:
firebird-utils
The following NEW packages will be installed
firebird2.0-common firebird2.0-super libfbclient2 libicu36
Created default security.fdb
* Not starting Firebird 2.0 server manager
* Use `dpkg-reconfigure firebird2.0-super’ to enable.
:~# sudo apt-get install firebird2.0-examples firebird2.0-dev firebird-utils
Reading package lists… Done
Building dependency tree
Reading state information… Done
The following extra packages will be installed:
libfbembed2
The following NEW packages will be installed
firebird-utils firebird2.0-dev firebird2.0-examples libfbembed2
Setting up firebird-utils (2.0.3.12981.ds1-1) …
Setting up libfbembed2 (2.0.3.12981.ds1-1) …
Setting up firebird2.0-dev (2.0.3.12981.ds1-1) …
Setting up firebird2.0-examples (2.0.3.12981.ds1-1) …
:~# dpkg-reconfigure firebird2.0-super
Firebird 2.0 server manager not running.
Firebird 2.0 server manager not running.
Starting Firebird 2.0 server manager…done.
Firebird 2.0 server manager already running.
:~# cd /usr/share/doc/firebird2.0-examples/examples/empbuild/
# sudo gunzip employee.fdb.gz
# sudo chown firebird.firebird employee.fdb
# sudo mv employee.fdb /var/lib/firebird/2.0/data/
# isql-fb
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect “employee.fdb” user “SYSDBA” password “masterkey”;
Database: “employee.fdb”, User: SYSDBA
SQL> show tables;
COUNTRY CUSTOMER
DEPARTMENT EMPLOYEE
EMPLOYEE_PROJECT JOB
PROJECT PROJ_DEPT_BUDGET
SALARY_HISTORY SALES
SQL>
This is maybe old news but I add it anyway. Mariuz setup worked only once namely till the next reboot.
Found a solution (finally)at:
https://bugs.launchpad.net/ubuntu/+source/firebird/+bug/135582
Used the solution from Frau Kuchen (last one in the list) and every reboot I got Firebird back in action.
I use edubuntu