Thursday, June 01, 2006

Firebird Ultimate Appliance (Apache + Firebird + Ubuntu Linux + PHP+Flamerobin)

1.Firebird Appliance contains LAMP like kit to easy start programming in php and working with firebird (Two administration tools were included in the virtual machine)

2.Create Ultimate Firebird Vmware Machine (How it was created)

Download vmware workstation or the player
then the ubuntu vmware machine (You need to unzip it on one folder and load it in vmware)

sudo vi /etc/apt/sources.list
decoment the universe lines

and comment the first line (with cdrom)


sudo apt-get update

apt-cache search firebird



sudo apt-get install firebird2-super-server firebird2-examples firebird2-dev firebird2-utils-super ibwebadmin libfirebird2-super

when asked for SYSDBA password put it :masterkey

See if firebird is started:
ps awwx | grep firebird

Load in firefox browser
http://localhost/ibwebadmin/

Write in the "Login to Database" field
/var/lib/firebird2/examples/employee.fdb
And in the password field:masterkey

Go to the sql tab and run this query
select * from employee;
Click on "Execute" button then on "Show Output"

you can tweak the ibwebadmin config
cd /var/www/ibwebadmin/inc

sudo vi configuration.inc.php and change these variables
define('DEFAULT_DB', 'employee.fdb');
define('DEFAULT_PATH', '/var/lib/firebird2/examples/');

Next we will install flamerobin db admin tool:
Go to flamerobin.org -> Download

Choose the lastest released kit flamerobin
http://prdownloads.sourceforge.net/flamerobin/flamerobin-0.7.1-gtk2.tar.bz2?download

tar -jxvf Desktop/flamerobin-0.7.1-gtk2.tar.bz2
rm Desktop/flamerobin-0.7.1-gtk2.tar.bz2
sudo apt-get install make libpng3
cd flamerobin-0.7.1-gtk2
sudo ln -s /usr/lib/libfbclient.so.1.5.1 /usr/lib/libfbclient.so.2
./flamerobin
register the same database as we did for ibwebadmin
Display name: employee example
Database path:/var/lib/firebird2/examples/employee.fdb
Username:SYSDBA
Password:masterkey
Click on "SAVE" then double click on the "employee example" in the left tree

You can click on "Tables -> Select * from ..."




3. Using Firebird Database with debian : there are several documentation links on the web
for python http://jclement.ca/docs/firebird_debian/firebird-debian/
for php http://php.net/ibase
debian small howto http://www.debianhelp.co.uk/firebird.htm

4. flamerobin is under expat http://flamerobin.org/license.html
firebird - IDPL (Mozilla based license)
ubuntu - free to share and modify philosophy

Screenshots




..:: ::..:: ::...:: ::...:: ::...:: ::...:: ::..

2 comments :

bee said...

There's Lazarus working with Firebird on the article, but strangely Lazarus is not mention at all within the article, nor link to Lazarus website. :)

mariuz said...

that is the second appliance i have created (monodevelop and lazarus are included in the new one)

http://www.firebirdnews.org/?p=495