Wednesday, September 12, 2007

flamerobin/firebird livecd+bootable usb key with mandriva this time

I made a Mandriva Live CD with Firebird

Inside is Mandriva 2007.1, Firebird 2.0.1 Classic, Flamerobin, Ibwebadmin,
kinterbasdb.

Default language is French, but you can change it.
The good news is that it made with MCNLive so you can do your own iso from it
and even make your own bootable usb key, simply using a wizzard !
Thanks MCNLive.

To download it :
http://downloads.sourceforge.net/firebird-fr/fbmdv.iso
http://downloads.sourceforge.net/firebird-fr/fbmdv.iso.md5.txt

Next step will be to add Lazarus FreePascal on it with UIB components


Philippe Makowski
http://www.ibphoenix.com
Supporting users of Firebird and InterBase
Firebird serveur SQL open-source en fran├žais http://firebird-fr.eu.org


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

Tuesday, September 04, 2007

creating an flamerobin/firebird livecd with ubuntu feisty fawn


You can download the final live cd from this page 
i used this guide
https://help.ubuntu.com/community/LiveCDCustomization
download ubuntu-7.04-desktop-i386.iso from http://www.ubuntu.com/getubuntu/download
in my case my nearest mirror
wget http://ftp.iasi.roedu.net/mirrors/ubuntulinux.org/releases/feisty/ubuntu-7.04-desktop-i386.iso
sudo apt-get install squashfs-tools mkisofs qemu
sudo modprobe squashfs
cp ~/ubuntu-7.04-desktop-i386.iso ~/live/
cd ~/live
mkdir mnt
sudo mount -o loop ubuntu-7.04-desktop-i386.iso mnt
mkdir extract-cd
rsync --exclude=/casper/filesystem.squashfs -a mnt/ extract-cd
mkdir squashfs
sudo mount -t squashfs -o loop mnt/casper/filesystem.squashfs squashfs
mkdir edit
sudo cp -a squashfs/* edit/
sudo cp /etc/resolv.conf edit/etc/
sudo cp /etc/hosts edit/etc/
sudo chroot edit
mount -t proc none /proc
mount -t sysfs none /sys
export HOME=/root
export LC_ALL=C
in the Customization part (after you do sudo chroot edit)
I decomented the two lines in /etc/apt/sources.list sudo vi /etc/apt/sources.list
deb http://archive.ubuntu.com/ubuntu feisty universe
deb-src http://archive.ubuntu.com/ubuntu feisty universe
apt-get update
apt-get install flamerobin
apt-get install firebird2-super-server

Please enter new password for SYSDBA user:masterkey
apt-get clean
rm -rf /tmp/*
rm /etc/resolv.conf
umount /proc
umount /sys
exit
chmod +w extract-cd/casper/filesystem.manifest
sudo chroot edit dpkg-query -W --showformat='${Package} ${Version}\n' > extract-cd/casper/filesystem.manifest
sudo cp extract-cd/casper/filesystem.manifest extract-cd/casper/filesystem.manifest-desktop
sudo sed -ie '/ubiquity/d' extract-cd/casper/filesystem.manifest-desktop

sudo rm extract-cd/casper/filesystem.squashfs
sudo mksquashfs edit extract-cd/casper/filesystem.squashfs
sudo -s
rm extract-cd/md5sum.txt
cd extract-cd && find . -type f -print0 | xargs -0 md5sum > md5sum.txt
exit
sudo mkisofs -r -V "$IMAGE_NAME" -cache-inodes -J -l -b isolinux/isolinux.bin -c isolinux/boot.cat -no-emul-boot -boot-load-size 4 -boot-info-table -o ../ubuntu-7.04-desktop-i386-flamerobin.iso .
qemu -cdrom ubuntu-7.04-desktop-i386-flamerobin.iso -boot d

or write the iso ubuntu-7.04-desktop-i386-flamerobin.iso on the dvd with k3b or nautilus
after the system boots you can create an database with
the username:sysdba
password:masterkey
and the path
/tmp/flamrobin.fdb


technorati tags:, , , , , , ,

Blogged with Flock

Popularity contest statistics for flamerobin (in debian )

popcon graph

http://qa.debian.org/popcon.php?package=flamerobin

technorati tags:, , ,

Blogged with Flock

Monday, September 03, 2007

browser usage on the flamerbin.org page

More than 57% are using firefox also the other browsers are in the charts too

konqueror, safari , opera

technorati tags:, , , , , , , ,

Blogged with Flock