Virtual Appliance Marketplace

Features

Collegiate:
No

One-line Description:
Firebird Ultimate Appliance (Apache + Firebird + Ubuntu Linux + PHP)

Filename:
Firebird-Ubuntu-5.10.tar.bz2

Size Compressed:
529

Allocated Memory:
256

Username:
ubuntu

Password:
ubuntu

VMware Tools Installed?:
No

Operating System:
Ubuntu Breezy 5.10

Applications:
php 4.x
apache 2.0
firebird 1.5.x
flamerobin 0.7.1
ibwebadmin

Description:
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 , download the ubuntu vmware image
http://www.vmware.com/vmtn/appliances/directory/ubuntu.html
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....
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

Technical Specifications

Operating System:

Ubuntu Breezy 5.10

VMware Tools installed: No

Size: 529MB

Allocated Memory (RAM): 256

Applications Installed:

php 4.x
apache 2.0
firebird 1.5.x
flamerobin 0.7.1
ibwebadmin

Virtual Appliance Account Information