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
..:: FlameRobin ::..:: Firebird ::...:: vmware ::...:: php ::...:: apache ::...:: ubuntu ::..
