Friday, June 30, 2006

linux sql tool for firebird - flamerobin does the job ;)

Thanks guys! FlameRobin is exactly what I was looking for. Simple and easy to use and it works . Not to mention, it isn't designed by a Grade 5 student . ;-)

[ED: I like his signature "There is no place like 127.0.0.1" it should look like this in ipv6 "There is no place like ::1 " , in ubuntu/any Gnu-linux try to ping back to home ping6 ::1 ]

Read more at thread.gmane.org/gmane....

Wednesday, June 28, 2006

Tuesday, June 27, 2006

"connection rejected for" problem

[flamerobin saved the day "Installing Flamerobinon clean machine reveals the truth. Now IBexpert connects fromwindows machine to linux FB. Thank you very much!" ]

Read more at lists.alioth.debian.org...

New Flamerobin+Firebird Mandriva Vmware image

[New vmware image with firebird + flamerobin ]

Read more at corpo.mandriva.com/xwik...

Friday, June 23, 2006

Gui for embedded firebird ?

you can try flamerobin with firebird embedded , Read the rest of the question on forums.devshed.com

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

Wednesday, June 21, 2006

svk - svn ++


[In case you have connection problems with svn/cvs servers , you can try svk (is working over svn) .

SVK let clkao mirror remote Subversion repositories, create local branches, hack while offline and later resynchronize his changes with the upstream Subversion servers. SVK is the best version control system for getting your work done while you're hiking in the mountains. It just so happens that what makes SVK wonderful when you're soaking in the hot springs makes it an excellent platform for getting your work done halfway around the world, on an airplane, in a cafe or in your office .]

Read more at use.perl.org/~jesse/jou...


Monday, June 19, 2006

building flamerobin .deb on ubuntu dapper

[step 0 : also you will need debhelper and dpatch

sudo apt-get install dpatch debhelper then follow the rest of steps ]

Read more at sourceforge.net/mailarc...

Friday, June 16, 2006

Wednesday, June 14, 2006

we are in top 10

on the spread debian web site (i have put that button on all my blogs)

http://www.spreaddebian.com/

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

Monday, June 12, 2006

Maintaining Packages in bzr for edgy

[maybe i should add the flamerobin package there in bzr, for the future version of ubuntu]

Read more at lists.ubuntu.com/archiv...

Thursday, June 08, 2006

Thursday, June 01, 2006

flamerobin wonderful package ;)

[Here is the reponse from one of our clients]

Read more at sourceforge.net/mailarc...

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




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