Firebird News

Monday, December 28, 2009

Testing Firebird 2.5 on Debian experimental

Firebird 2.5 final is now uploaded to debian experimental

Here is my sources.list
cat /etc/apt/sources.list

deb unstable main
deb-src unstable main
deb experimental main
deb-src experimental main

# apt-get update -t experimental

Then install super-server
# apt-get install -t experimental firebird2.5-super

Or if you want the new superclassic

# apt-get install -t experimental firebird2.5-superclassic

Install examples and flamerobin
apt-get install -t experimental firebird2.5-examples flamerobin

cd /usr/share/doc/firebird2.5-examples/examples/empbuild/
sudo gunzip employee.fdb.gz
sudo chown firebird.firebird employee.fdb
sudo mv employee.fdb /var/lib/firebird/2.5/data/

you can connect to the database with flamerobin

update: you can build the firebird 2.5 package from git

half of chapter 6 from django-book

i'm at half of chapter 6 from django book
to use it with firebird is quite easy and with small changes (only the sql examples needs to be modified in the example is used postgres) but i have added the comments to the book on how to modify an not null to a nullable field (or you can do it from flamerobin)

the rest of the admin area works great

The previous chapters 1-5 modifications for firebird are on this page

for about 2 days i got some strong flu virus and i only sleep and with heavy sweat

Saturday, December 26, 2009

Movies to watch ~ Xmass, Porcelain death as santa claus

I love the ones with horror inside so i guess the best movie i saw on Xmass ever
is The Nightmare Before Christmas , next is Bad Santa , Last night i saw one movie where Death was Santa :HOGFATHER (on tvr2) quite impressive
and i didn't expected to see such a good movie on Xmass , maybe because all tv station are playing the same crap over and over each year : home alone 1-2-3 , santa klauss related ones and
the ones with Arnold ... and so on

I recommend instead some good horror movies made for Xmass or for Helloween

For a commedy i guess 2012 could fit the bill
I wonder why the hack didn't put all the people on Himalaya mountains and from where they got all that water 8km high ? do the calculations and you will see that
that volume of water is more than what is found on earth

Wednesday, December 23, 2009

#kde 4.4 beta safe guide to upgrade on #ubuntu #karmic

kde 4.4 is released here is a way to upgrade and then downgrade to 4.3
in a safe way (and to keep the list of installed packages)

before you upgrade is better to save your list of pachages
dpkg --get-selections > installed-software.log

then you can reinstall qt/kde packages from console if you have
problems with (revert to qt 4.5.x if you want)

Install kde 4.4 and qt 4.6

Here is my way to revert on the old packages kde 4.3.x and qt 4.5.x


sudo /etc/init.d/kdm stop

sudo apt-get purge libqtcore4
then i did the steps from above
sudo dpkg --set-selections < installed-software.log
sudo dselect
and press I to install all the packages saved

Thursday, December 17, 2009

We are not stupid Monty

Reuters reports that Microsoft and SAP and Monty Widenius will be at the meeting on the 10th at the EU Commission, and not a single customer. Oracle has eight customers committed to being there to support Oracle's position. Eben Moglen will also participate.

even IBM is not against this issue , they know who is behind all this attack on Oracle and Open Source in general old friends: Microsoft 

Mysql ..bla bla bla ... Its primary competitor is Microsoft's SQL Server.

That i think hurts more for Microsoft , they can't sell their ms crap .
They wish Mysql to be under BSD license to be assimilated into azzure
like they did with bsd socket libs

generating all flags for skype with #flamerobin and #firebird sql

Here is how to get the original script

create a new table with this syntax (I have just deleted the "IF NOT EXISTS" from the original table creation script)

populate the table with load script from flamerobin

the only issue was quoting in firebird , you just need to replace \' type of quoting with "

If you need to use an apostrophe inside a Firebird string, you can “escape” the apostrophe character by preceding it with another apostrophe.

For example, this string will give an error:

'Joe's Emporium'

because the parser encounters the apostrophe and interprets the string as 'Joe' followed by some unknown keywords.

To make this a legal string, double the apostrophe character:

'Joe''s Emporium'

Notice that this is TWO single quotes, not one double-quote.

Run this query in flamerobin to get the iso from table


We need to add (flag:ISO) to the query with the concatenation

SELECT '(Flag:'||a.ISO||')'

and do the copy paste in skype :P

Create a procedure that concatenates thouse values

and do a select


and copy paste

result should be like this

Tuesday, December 15, 2009

Firebird community letter to Monty :we don’t have such worries!

Here is why we sleep so well in the night : because we don't touch the mysql and we don't need it

I know that Monty is part of new codeplex fundation
so his masters might be related to Microsoft:
New masters new dogfood

Another issue is Maria Fork is a dead end and i see around that nobody is using in the Lamp world
so he needs the Mysql brand back for free , That is smart because the community build it that name in Years and is very hard now to change them from Lamp to Maria (unknown one)

This post is related to Steve's post on computerworld

Thursday, December 10, 2009

wxwebkit is amazing and flamerobin future

I was thinking on howto evolve the flamerobin project and i think the next stage (for example on E/R diagraming) would be to adopt the wxwebkit engine for interface rendering , what we do now with wxhtml

Instead of it we will use jquery and paint in the browser canvas (similar like in thunderbird 3.x)
The tree in the left will stay native and the grids , but some parts in the future will be replaced with cool html that can be skinned with css.
Core will stay c++ and parts of the interface will be pure native.

To build wxwebkit on ubuntu/debian was quite easy:
sudo apt-get install gcc g++ flex bison gperf libxml2 libxslt1.1 libxslt1-dev libcurl4-openssl-dev libsqlite3-dev libpng12-dev libjpeg62-dev libpango1.0-dev libgtk2.0-dev subversion

git clone git:// wxwebkit/WebKitTools/Scripts
./build-webkit --wx --makeargs="-j2"
cd wxwebkit/WebKitBuild/Debug.master
chmod +x
sudo cp /usr/lib/

What is so amazing ?, you can put webkit in edit mode and actually Edit the website (html) !

Tuesday, December 08, 2009

The sad happy story of snow in Kubuntu Karmic

At first Windows-F3 key (aka Master-F3) didn't do anything

so i searched for a upto date compiz ppa

sudo kate /etc/apt/sources.list.d/compiz.list

deb karmic main
deb-src karmic main

sudo apt-get update
sudo apt-get dist-upgrade

sudo apt-key adv --keyserver --recv-keys 42C24D89

install compiz related packages

sudo apt-get install compiz compizconfig-settings-manager compiz-kde compiz-fusion-plugins-main compiz-fusion-plugins-extra emerald librsvg2-common compiz-fusion-plugins-unsupported

Install fusion-icon
sudo apt-get install fusion-icon

a tray icon to enable compiz and it will disable kwin
and also you can enable Windows decorator to be Emerald not kde4

Select Compiz Configuration:
K menu -> Applications ->Settings -> CompizConfig Settings Manager

and enable Snow Effect

well you could install compiz-dev and compile from source but is 2a.m. and i want to sleep

I have debugged the issues with snow from console with
compiz-manager --replace and with ccsm from another console
Snow seems to be removed from Karmic and it gave an api missmatch that is why it didn't worked in the first place
Now it's not as simple as it was before but problem is solved

Html2DocBook #python and Firebird in 2 Minutes #html document

I try to convert it (this html document ) to docbook format and

I have installed the html2docbook tool

from python console
from html2docbook import Html2DocBook
h2d = Html2DocBook()
f = open('./fb2min.html', 'r')

that is the only tag that is spitted out!
if i do print(x) i get all the content for html
_debug=True doesn't work no details or verbose mode

ps: i saw that some things are old on that page i was thinking that is
better to be kept in docbook format and versioned (cvs/git ...)
also i have tried to do some tidy html on it
for the moment we will stick to html format it's easier and anyone can edit it
maybe i will add it to git (docbook is harder to crack)

Friday, December 04, 2009

Found a bug in git-cvsimport so i will use cvs2git

I'm not the only one that found the bug

"Me, I don't trust anything but cvs2git to import a CVS repo. I then use git-cvsimport to keep it up-to-date, but even then, I've seen it omit a couple of commits for no good reason, forcing me to re-import from scratch."

so i will use cvs2git to import all the firebird branches

mkdir firebird2
cd firebird2

rsync -av rsync:// .
rsync -av rsync:// .

cd ..
svn co --username=guest

# Dump the CVS history in a format ready for git-fast-import (a few hours)
cd cvs2svn-trunk
./cvs2git --blobfile ../cvs2git.blob --dumpfile ../cvs2git.dump \
--username '(no author)' --fallback-encoding utf-8 ../firebird2

# Create and fill the Git repo
mkdir ../firebirdgit
cd ../firebirdgit
git init
cat ../cvs2git.{blob,dump} | git fast-import

git fast-import is that is really fast (a few minutes)
what is left to do is to export it over ssh or web

git clone --bare /tmp/firebirdgit/.git /tmp/firebird.git
and you can test it over remote
cd ~
git clone foobar@localhost:/tmp/firebird.git


the only problem left is how do i do it daily to be pushed to gitorious ?

Monday, November 30, 2009

Recovering #ubuntu grub after #fedora install

i have added in the

title Ubuntu karmic (development branch), kernel 2.6.31-14-generic
root (hd0,0)
kernel /boot/vmlinuz-2.6.31-14-generic root=/dev/sda1 ro quiet splash
initrd /boot/initrd.img-2.6.31-14-generic

and rebooted

then from ubuntu

sudo grub-install /dev/sda1
and i'm back to ubuntu for the moment

Thursday, November 26, 2009

Using #Fedora #Linux day three (#Ubuntu maniac perspective)

Here is an alternate fedora kde installer review

konqueror drives me crazy when i click an link in psi
infinite loop startup
sudo killall -9 kfmclient
so i had to change default browser to arora in the system settings

I don't have any printer configured

sudo /etc/init.d/cups stop
sudo chkconfig cups off

No iscsi sorry

sudo chkconfig iscsid off
no Yellow pages
sudo yum remove ypbind

sudo chkconfig lvm2-monitor off
sudo chkconfig openct off
I don't use nfs
sudo chkconfig rpcbind off
sudo chkconfig rpcidmapd off
sudo chkconfig netfs off
sudo chkconfig nfslock off
sudo chkconfig pcscd off
sudo chkconfig rpcgssd off

i don't update my cpu microcode too often
sudo chkconfig microcode_ctl off

I found that i have installed smolt with interesting stats about hardware used in Fedora

I didn't knew what portreserve is so i disabled it

sudo chkconfig portreserve off

live cd install leftovers

sudo chkconfig livesys off
sudo chkconfig livesys-late off

wtf sendmail by default !? maybe in next fedora it should be proposed postfix by default
also all the above daemons disabled by default (rpc/nfs related ones)

sudo yum install postfix
sudo yum remove sendmail

remove pulse audio see why skype related

sudo rpm -e kde-settings-pulseaudio-4.3-12.noarch
sudo yum remove pulseaudio
sudo yum remove pulseaudio-utils
sudo killall -9 pulseaudio

Here is how to add mp3 support in amarok

sudo yum install xine-lib-extras-freeworld

oh crap i can't remove konqueror in in the kde-base

and i miss abrowser or iceweaseal packages (unbranded firefox)

I found that qmake is qmake-qt4

what i miss from ubuntu is command line not found suggestions (when you miss package bash can suggest you what to install)

Wednesday, November 25, 2009

Using #Fedora #Linux day two (Ubuntu maniac perspective)

Installing skype for 64 bits fedora is harder than on #ubuntu

sudo yum install qt-x11-4.5.3-9.fc12.i686
sudo yum install qt-4.5.3-9.fc12.i686
sudo yum install libXScrnSaver-1.2.0-1.fc12.i686

download skype rpm for fc10+ (32bit version

sudo rpm -Uvh skype-

configure it to Not use the pulse audio

arora browser is 0.10.1 with qt 4.5.3 , it's crashing if i use and then close the tab
known bug , that i have reported to arora (seems to be fixed in qt 4.6 and arora from ubuntu karmic)

qtcreator is called qt-creator and is at version 1.3 in fedora !

next is to find where is qmake

Monday, November 23, 2009

Screenshots in #php using #qt #python or #c++

I used the example from this article

and installed the needed libs on the server
sudo apt-get install libqt4-core libqt4-webkit python-qt4 xvfb


python -x -o cnn.png --debug

chmod +x

from php

passthru("/home/mariuz/ -x -o /tmp/google.png --debug --scale 100 100")

i want to load a page with flash content , shameless plug –scale 200 200 -x -o reea.png –debug

but seems i have an flash error and the image is quite empty

Adobe Flash Player: gtk_clipboard_get(GDK_SELECTION_PRIMARY); failed. Trying to call gtk_init(0,0);
Xlib: extension “RANDR” missing on display “:99.0″.

also got the same error with gnash

I have investigated the c++ websnap examples from qt labs now hosted in git

Another example in c++ is on this page and have made it compile on qt 4.5.3

and added


Using #Fedora #Linux day one (Ubuntu maniac perspective)

I liked some things on fedora 12 and i wanted to test it and and use it for a week or two (on distrowatch i saw this idea of rotating linux distributions once in a while)

I downloaded kde spin and installed on secondary partition the installer was a little harder to gasp than the default ubuntu one (from what i remember) Maybe the partition editor should need a little care for example fiber channel is weird to apear in the menu at advaced partitions options, I was expecting something else .

Another thing i didn't liked it is why on earth i need root user and after that i need to create my user anyway ?, Do it once and make it do sudo I was expecting to be in the sudo group and admin by default like is in ubuntu

What was nice about installer is it finished whithout to many questions and after reboot i configured the user . Maybe it should be the same for ubuntu installer : Less questions for installer and then copy the files from cd/dvd

First thing i disabled is of course selinux (security insanity should be an option and feature not enabled by default)

What was nice that disk image was transfered to the the partition so no extra package install time like in debian .
Another bonus for updates is that is using xz by default and only what is changed is updated

(primary partition is ubuntu)

First i installed adobe flashplayer 10 (64 bit version)

tar -zxvf
mv /usr/lib64/mozilla/plugins/

by default there are some rules in firewall so i flush them

$ sudo iptables -L -n
[sudo] password for mariuz:
Chain INPUT (policy ACCEPT)
target prot opt source destination
ACCEPT icmp --
ACCEPT all --
ACCEPT tcp -- state NEW tcp dpt:22
REJECT all -- reject-with icmp-host-prohibited

Chain FORWARD (policy ACCEPT)
target prot opt source destination
REJECT all -- reject-with icmp-host-prohibited

Chain OUTPUT (policy ACCEPT)
target prot opt source destination

$ sudo iptables -F
$ sudo iptables -L -n

added myself in sudoers list


vi /etc/sudoers
mariuz ALL=(ALL) ALL

installed fireofox arora psi and pidgin
I have created mariuz user

deleted /home/mariuz and
i use my home from ubuntu partition
added in /etc/fstab
UUID=190eba34-a00b-4245-9112-c92e73893085 /ubuntu ext4 defaults 0 1

ln -s /ubuntu/home/mariuz /home

if you want to find the block id

blkid /dev/sda1
/dev/sda1: UUID="190eba34-a00b-4245-9112-c92e73893085" TYPE="ext4"

enable rpm fusion for mp3 and other stuff

ToDo: test and install nvidia driver

Monday, November 16, 2009

#Firebird available in major #linux distros : #Mandriva , #Debian, #Ubuntu, #Fedora ,#Gentoo,#OpenSuse

Finaly OpenSuse 11.2 is out. It is the first time that Firebird is in official OpenSuse repositories.

After Mandriva (2010.0 is very nice), Debian, Ubuntu, Fedora (and RHEL/Centos Fedora project repositories),Gentoo : we have now OpenSuse

All major free distro have now latest Firebird stable version (2.1.3) available in their official repositories.

Here is the list of where firebird 2.1.3  is included or can be installed
  • Debian linuxDebian [Done] by Damyan Ivanov
  • Ubuntu linux Ubuntu [Done] in the next LTS release Lucid Lynx
  • Ubuntu linux Fedora [Done] by Philippe Makowski
  • Ubuntu linux Gentoo [Done]
  • Mandriva LinuxMandriva [Done] by Philippe Makowski
  • Mandriva Linux OpenSuse [Done] by Philippe Makowski
  • Ubuntu linuxRed Hat Enterprise Linux [Done] by Philippe Makowski
  • Ubuntu linuxCentos [Done] by Philippe Makowski
  • Pardus linuxPardus [Done] Check the pisi repository

#hp #laser printer 400x after upgrading to #ubuntu #karmic

Seems that printer didn't worked after upgrade to karmic
so i had to run the hp-setup
and delete the old configuration , seems that all went ok after that (test page and aasdasdasd odt document)

Before that i had lots of errors

Returning IPP client-error-document-format-not-supported for Send-Document (ipp://localhost:631/printers/LaserJet-4000) from localhost

but the application/octet-stream was decommented in

Friday, November 13, 2009

#Firefox 0.1 aka #Phoenix on #Ubuntu #Karmik #Koala

This is how to install it and see how free web/firefox was 7 years ago
You can test then all the releaseses until ffx 3.5.5 and more
gmail works but is not supported by that old foxie

Download phoenix 0.1

Download gtk1.2 and libstdc++ needed for it from debian stable

sudo dpkg -i *.deb

get the foxkeh
tar -zxvf phoenix-0.1-i686-pc-linux-gnu.tar.gz
cd phoenix
welcome to web 2.0 (i think it was called slashdot at that time)

Tuesday, November 10, 2009

#qt 4.6 #beta with #arora #browser compiled for it uploaded for #ubuntu #karmic

I have reuploaded the qt 4.6 beta 1 this time i have added libqt4-
phonon-dev - it was missing by mistake so it will not remove all the kde packages this time :)
also arora 0.10.1 was recompiled with new qt 4.6 features

Wednesday, November 04, 2009

Debugging #Firebird and #Drupal #php #pdo driver

I started by installing latest php : 5.3.1 rc3 and then with the help of ddd

I can step and put breakpoints in the driver source

cd /opt/build/php-5.3.1RC3

sudo ddd /usr/sbin/apache2

Load the drupal install and follow this guide

also I have started to use the debug_backtrace to figure the error without text that i have (empty exception text)


Thursday, October 29, 2009

I have joined to #Alioth #Firebird #Debian project

Seems that i need alioth account to modify the firebird packages , in fact i will modify just the Git repository , maybe i will help with manual pages for firebird 2.5 and with packaging bugs

Tuesday, October 20, 2009

git insufficient permission for adding an object to repository database ./objects

this is a shared group repository
so i had to enter the repository dir and make sure group can write into it

ssh to server
cd repository.git

sudo chmod -R g+ws *
sudo chgrp -R mygroup *

git repo-config core.sharedRepository true

and the try to push origin master again

Sunday, October 18, 2009

#etckeeper is using #bzr by default in !ubuntu #karmic

sudo apt-get install etckeeper

grep VCS /etc/etckeeper/etckeeper.conf


to see the changes in a graphical way

sudo apt-get install bzr-gtk

cd /etc

olive-gtk &

wait a few seconds/minutes ....

Thursday, October 15, 2009

#qt 4.6 beta ppa for #ubuntu #karmic , soon I will upload #arora soon

Use it at your own risk

I used the qt preview tp1 and sometimes it crashed so needed the new beta ,
I  tested it on my kde desktop + I will upload arora recompiled with 4.6 version soon

The arora from karmic should work ok with 4.6 too but maybe a
recompile is needed
before you upgrade is better to save your list of pachages

dpkg --get-selections > installed-software.log

then you can reinstall qt/kde packages from console if you have problems with (revert to qt 4.5.3 if you want)

sudo dpkg --set-selections < installed-software.log
sudo dselect

and press I to install all the packages saved

On my sistem i had before qt tp1 packages and in deb name i had "tp1" > "beta1" if you think as a
package manager so i had to remove all qt packages and kde too and
reinstall them

sudo apt-get purge libqtcore4

Then i did the steps from above

Tuesday, October 06, 2009

#nginx and #wsgi on #ubuntu howto

I wanted to install mod_wsgi for nginx on ubuntu here are some basic steps for compiling it

tar -zxvf nginx-0.7.62.tar.gz
hg clone

see why you need that patch
cd mod_wsgi/
patch -p1 < ../mod_wsgi_patch.diff
cd ..

cd nginx-0.7.62/
./configure --add-module=../mod_wsgi/ --with-debug
sudo make install

How can i use linux low level/posix api with #qt ?

well i was searching the google about the above question and i remembered that you can use c api in c++ like any other function

you can see these posix linux threads examples that can be compiled with c++ like this $ g++ -lpthread pthread1.c

Next step was to create a simple example with qt creator 
something like get_pid.c example from advanced linux programming book 

so after an empty gui project is created do small modification like this and run it 

it should give you no errors and it should print in the console the pid 

Starting /home/mariuz/work/qtgetpid/qtgetpid/qtgetpid...
/proc/self reports process id 7977
getpid() reports process id 7977

Sunday, October 04, 2009

playing with powertop on my netbook

I know that this via netbook does have issues with powermanagement and i want to digg deeper
to get some sort of power/instructions trace
so i have installed powertop

sudo apt-get install powertop
what is interesting C3 state (sleep) is buggy on this cpu (cache incoherent)
and i see that is really used , it should be disabled by bios but i know that bios is buggy too.

Powertop suggested this
echo 1500 > /proc/sys/vm/dirty_writeback_centisecs

so i have added it in /etc/rc.local
before the exit 0

Wednesday, September 30, 2009

Weird vncviewer in vncviewer with shared desktop option in #ubuntu

I wanted to share my desktop over the ssh connection , I will do ssh -X from another machine
and start the vncviewer , and here is how it looks when you start vncviewer on the localhost

Friday, September 25, 2009

Building #Firebird 2.5.x extension for #Php 5.x.x on #Windows

Follow the advice on howto compile php on windows with visual studio express (yucks)
I  will not copy paste all  the steps here , a short document makes them easy to follow

1.Install visual Studio Express C++ 20xx
2. get and install windows sdk 6.1
3. get a php 5.3 snapshot or any stable version 5.x (do not extract yet!)

Next is is to download a zip file with firebird 2.5.x final from sourceforge 

in my case

Next is to unzip the files from bin,include,lib
into C:\php-sdk\php53dev\vc9\x86\deps

enable firebird extension from the build console (By default thread safe version is build )

configure --disable-all --enable-cli --with-interbase 
cd Release_TS
php -m 

should show you that interbase/firebird extension is there 

If you want to create the shared dll for the firebird extension you need to provide 
--with-interbase=shared to the configure script
otherwise it will be included in the big php executable 
Another note is if you do use IIS with fastcgi then you must disable threading support (Non Thread Safe ) in the configure part you must add --disable-zts

The work to compile full firebird 2.5.x server with visual c++ 20xx and $sudo make the php core developers happy is DONE (the firebird extension it will be included by default in official php 5.3.4 zip file for windows)

Wednesday, September 16, 2009

Compiling #mysql #workbench 5.1.x on #ubuntu #debian #Linux

At this time 5.1.19 is available on download link 

wget -O mysql-workbench-gpl-5.1.19-src.tar.gz

tar -zxvf mysql-workbench-oss-5.1.19.tar.gz
cd mysql-workbench-oss-5.1.19/
sudo apt-get install libzip-dev libsigc++-2.0-dev libglade2-dev libgtkmm-2.4-dev
libgnome2-dev uuid-dev lua5.1 liblua5.1-0-dev libpcre3-dev

make -j2
sudo make install

Compiling #mysql #workbench alpha 5.2.x on #ubuntu #karmic

At this time alpha 5.2.3 is available on download link  wget  

tar -zxvf mysql-workbench-oss-5.2.3.tar.gz 
cd mysql-workbench-oss-5.2.3 

sudo apt-get install libzip-dev libsigc++-2.0-dev libglade2-dev libgtkmm-2.4-dev libgnome2-dev uuid-dev lua5.1 liblua5.1-0-dev libpcre3-dev  libmysqld-dev libboost-dev python-paramiko

this time you need to install libsqlite doh ! 

sudo apt-get install libsqlite3-dev  
make -j2 
sudo make install

Tuesday, September 15, 2009

You don't need #OpenDNS , you have your own dns server on #Ubuntu !ubuntu

Install isc bind server

sudo apt-get install bind9

test if the dns query works

$ dig @

make it default resolver for your system

sudo pico /etc/resolv.conf

or open it with any editor

sudo kate /etc/resolv.conf
add this entry

delete all other nameservers or comment them if you want

and that is all (tested on ubuntu karmic and intrepid)

Friday, September 11, 2009

debtree-next - better #Firebird package dependecies graphs in #debian #ubuntu

Inspired by the new dbtree from git now you can do a clean graph for the packages in debian and ubuntu

$ git clone git://
Here is the graph for installed files for firebird2.1-classic

$ ./debtree --no-recommends --no-conflicts -I -S firebird2.1-classic >
$ dot -T png -o out.png

Here is the graph for installed files for firebird2.1-supper
$ ./debtree --no-recommends --no-conflicts -I -S firebird2.1-super >
$ dot -T png -o super_out.png

Now you can do reverese dependency graph , here is the example for libselinux1 if you dare to remove it

$ ./debtree -I -R --no-recommends --no-conflicts libselinux1 > libselinux.out
$ dot -T png -o libselinux.png libselinux.out
$ gwenview .

Wednesday, September 09, 2009

How much #freedom is inside my #ubuntu borkstation ~99%

$ sudo apt-get install vrms

so i'm something like 1-2% not free , I will do some cleanup today at home

$ vrms
Non-free packages installed on borkstation64

alien-arena-data Game data files for Alien Arena
bugsx program to evolve biomorphs using genetic algorithms
nvidia-180-kernel-source NVIDIA binary kernel module source
nvidia-180-libvdpau Video Decode and Presentation API for Unix
nvidia-180-modaliases Modaliases for the NVIDIA binary X.Org driver
nvidia-glx-180 NVIDIA binary Xorg driver
nvidia-glx-180-dev NVIDIA binary Xorg driver development files
picasa Image management application from Google
skype Skype - Take a deep breath
sun-java6-bin Sun Java(TM) Runtime Environment (JRE) 6 (architecture
sun-java6-jre Sun Java(TM) Runtime Environment (JRE) 6 (architecture
unrar Unarchiver for .rar files (non-free version)
Reason: Modifications problematic
uqm-content The Ur-Quan Masters - Game data files
warsow-data Game data for Warsow

Non-free packages with status other than installed on borkstation64

cdrecord ( dei) command line CD writing tool
libmyth-0.20 ( dei) Common library code for MythTV and add-on modu
linux-restricted-modules- ( dei) Non-free Linux 2.6.24 modules on x86/x86_64
nvidia-glx ( dei) NVIDIA binary XFree86 4.x/X.Org driver
Reason: Proprietary license
nvidia-glx-new ( dei) NVIDIA binary XFree86 4.x/X.Org 'new' driver
tangerine-icon-theme ( dei) Tangerine Icon theme
xorg-driver-fglrx ( dei) Video driver for ATI graphics accelerators

Contrib packages installed on borkstation64

alien-arena Standalone 3D first person online deathmatch shooter
dosemu The Linux DOS Emulator
googleearth-package utility to automatically build a Debian package of Goo
msttcorefonts transitional dummy package
nvidia-common Find obsolete NVIDIA drivers
nvidia-kernel-common NVIDIA binary kernel module common files
nvidia-settings Tool of configuring the NVIDIA graphics driver
openttd reimplementation of Transport Tycoon Deluxe with enhan
ttf-mscorefonts-installer Installer for Microsoft TrueType core fonts
uqm The Ur-Quan Masters - An inter-galatic adventure game
warsow fast paced 3D first person shooter

Contrib packages with status other than installed on borkstation64

flashplugin-installer ( dei) Adobe Flash Player plugin installer
mozilla-mplayer ( dei) MPlayer-Plugin for Mozilla ( dei) English (GB) hyphenation pattern for OpenOffic ( dei) English (US) hyphenation pattern for OpenOffic

~43 non-free packages, 1.2% of 3574 installed packages.
16 contrib packages, 0.4% of 3574 installed packages.

Howto change #Firebird password in #Ubuntu , #Debian ,#Linux

On Ubuntu with firebird 2.1 you can change password if you forgot it this way
1.First method
$sudo gsec -modify sysdba -pw 123456 (we trust root user muhahaha)

2.Second method
$sudo su
cd /var/lib/firebird/2.1/system
cp default-security2.fdb security.fdb
$ /etc/init.d/firebird2.1-classic restart

3.Third method
$ sudo dpkg-reconfigure firebird2.1-classic

On windows if you are in the Administrator group i guess you can change it with gsec from command line
C:\Program Files\Firebird\Firebird_2_1\bin> gsec -modify sysdba -pw 123456

#Firebird , #Mysql and Not NULLs + Stored Procedures

Last night/morning i have read again some rants against the NULLs in one of the CJ Date book SQL and the Relational theory and in practice it's is true that I found one table with something like 20% of it filled with nulls (not normalized) and let's say that count(*) is in the range of millions , Now you have a lot of scans for data that is not there So is better to split that table and normalize it also the columns should be NOT NULL by default for example EMPLOYEE_ID

Now comes the good part you don't need to pollute the queries with NOT NULLS anymore and you get more speed , it depends how many nulls you had before (of course there are opimizer tricks to do some shortcuts)
and save the plannet for overheating

On mysql i eliminated not null check from one query it didn't improved too much the speed (~0.2s ) but at least it's easier to read
on firebird side it improved performance but again not so much (~0.2 s)

I started to create a selectable stored procedure and at least in firebird part it was faster 0.2s vs the query without selectable sp

In the end i got 0.4 seconds only by eliminating NULL from the query and creating a selectable procedure

Monday, September 07, 2009

wicd vs network manager on karmik

I have installed wicd by a simple 
$ sudo apt-get install wicd 

it removed network-manager and network-manager-gnome 

what do you get ? a better wireless manager , seems that it connects to the network before the gui 
gets started so from the console i can upgrade or dist-upgrade 
and it works from any DE: gnome/lxde/kde ... 

For the moment i will stick to it 

Caking for FUN+Profit

Here is my  presentation prepared for php meetup in boston but also was showed at
geekmeet #2 from Targu Mures

Firebird, mysql and CXXFLAGS

I have tried to optimize the speed for mysql and Firebird but for the moment
it seems for that particular query there is no difference (io starved) , maybe i need some queries with math calculations to see the benefit for thouse flags

On the firebird side seems that CXX flags are not considered at all and i will inspect why 

Here are my flags anyway

The good news is that at least make -j2 should work for firebird HEAD
Update: seems that it works if I export only the CXXFLAGS

export CXXFLAGS="-O3 -march=core2 -mtune=core2 -mfpmath=sse"

Firebird 2.1 dependency graph in ubuntu

I was reading about debian and ubuntu bloat growing , more useless packages are installed by default
Read the full article here

"For comparison, the size of a default Gnome desktop install for Etch was 1360MB; for Lenny it is 1830MB; for Squeeze it looks like it will be well over 3000MB! Remember that for Sarge we installed both Gnome and KDE from CD1 with both together taking 1390MB?"

So i wanted to create a dependecy graph for firebird using Debtree

All you need is to install the debtree package , seems that is not included by default in ubuntu So click here

$ debtree firebird2.1-super >
$ dot -T png -o out.png

Thursday, September 03, 2009

#xming install for #xforwarding for #windows

we needed to access xserver from windows pc and we installed xming with ssh forwarding
ran the setup
Installed the fonts
started xming then created a new ssh connection from putty
you need to add xforwarding and localhost:0 in the Xforwarding area
then from the putty prompt run xfce4-session or any X program

Wednesday, September 02, 2009

#Mysql 5.4.x from source on #Ubuntu #Karmic #Server #x64

I needed to run mysql5.4.x compiled from source , the version from ubuntu is old 5.1.x
and for this i had to do following steps
Follow the download link for mysql

$ sudo apt-get build-dep mysql-server

Download the last source code archives for the mysql :
$ wget

$ tar -zxvf mysql-5.4.1-beta.tar.gz

$ cd mysql-5.4.1-beta/
$ ./configure --prefix=/opt/mysql5.4.x --localstatedir=/opt/mysql5.4.x --with-plugins=all --without-debug --with-mysqld-user=mysql --with-unix-socket-path=/tmp/mysql5.4.x.sock

Create a non-privileged group and user for the database server, as below:

$ sudo groupadd mysql
$ sudo useradd -g mysql mysql

count the number of cpus you have

$ cat /proc/cpuinfo | grep -c processor

4 is in my case (quad core) so i will use it for make argument

$ make -j4

Create data directory and set the right permission on it:

$ sudo mkdir -p /var/lib/mysql5.4.x
$ sudo chown mysql.mysql /var/lib/mysql5.4.x

$ sudo make install
cd /opt/mysql5.4.x/bin/

$ sudo ./mysql_install_db --datadir=/var/lib/mysql5.4.x --user=mysql

Copy the init script from to the source directory mysql-5.4.1

$ sudo cp support-files/mysql.server /etc/init.d/mysql-5.4.x

modify this variable
in the start-up script

$sudo pico /etc/init.d/mysql-5.4.x

add the script at startup

$ cd /etc/init.d
$ sudo chmod +x mysql-5.4.x
$ sudo update-rc.d mysql-5.4.x defaults

Start mysql server
$ sudo /etc/init.d/mysql-5.4.x start

Connect to mysql server
$ /opt/mysql5.4.x/bin/mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.4.1 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


Set password for root user

$ /opt/mysql5.4.x/bin/mysql -u root
mysql> UPDATE mysql.user SET Password = PASSWORD('newpwd')
-> WHERE User = 'root';

Remove the anonymous accounts

mysql> use mysql
mysql> delete from user where user='';

Sunday, August 30, 2009

#yahoo 9 and wine on #ubuntu #jaunty x64

I wanted to test if yahoo mess starts with wine , I saw that on winedb is getting close to bronze medal
Well i updated my wine to latest 1.1.28 , all the setup went ok and the login to only when i try to write a message it crashes quite baddly (seems some not implemented yet functions)

Ps:Seems that winehq repository seems to be down for about 2 days , I used the ppa wine from ubuntu

Tuesday, August 25, 2009

Tell me that centos doesn't suck on desktop

do you want gnome > 2.22 as required by some software please be prepared to compile gnome with garnome
And i'm not the only one that knows that sucks on the desktop side
Here is what Caitlyn Martin has to say
"Look, stop trying to convince me. I've removed CentOS from my netbook and I'm about to explain why. As far as I am concerned it's good riddance to bad rubbish. CentOS is a wonderful server OS clone. On the desktop I have no use for it."

18 Years ago Linus started the Revolution

Do you Remember 18 years ago when Linux was conceived? , and look now the biggest threat to Microsoft. Finally it has grown up! I just can wisper some words to them : Ubuntu , Android , Netbooks (yah they defeated us on that one) , Nokia Maemo , PalmOS ... Ohh and i forgot Google . I still can read and run the assemmbler/C code from linux 0.0.1 and the starting point code was good in the sense that it worked and it was inspired by good concepts from Unix , Of course linux is not unix is something else alive and with good future.It's funny to read the comments about the portability and that it works only on his 386/harddrive , Look now i have an Android phone with Linux on and i'm free to modify it and do whatever is in my mind no one stops, try that with Iphone or windows CE devies . It's all about the freedom to hack (in good sense) and give back

Friday, August 14, 2009

The Designos Now in HQ

The designos - a fake trailer for a real design department, showcasing wiseguys that ain't afraid to get down and dirty with the photoshop

Here is the reea's design team :) watch them how they are working
The Designos from 2007 now in HQ

Thursday, August 13, 2009

Mysql 5.1.x from source on Ubuntu Jaunty Server x64

I needed to run mysql5.1.x compiled from source , the version from ubuntu is old 5.0.x
and for this i had to do following steps
Follow the download link for mysql

$ sudo apt-get build-dep mysql-server

Download the last source code archives for the mysql :
$ wget

$ tar -zxf mysql-5.1.37.tar.gz

$ sudo ./configure --prefix=/opt/mysql5.1.x --localstatedir=/opt/mysql5.1.x --with-plugins=innobase --without-debug --with-mysqld-user=mysql --with-unix-socket-path=/tmp/mysql5.1.x.sock

Create a non-privileged group and user for the database server, as below:

$ sudo groupadd mysql
$ sudo useradd -g mysql mysql

count the number of cpus you have

$ cat /proc/cpuinfo | grep -c processor

4 is in my case (quad core) so i will use it for make argument

$ make -j4

Create data directory and set the right permission on it:

sudo mkdir -p /var/lib/mysql5.1.x
sudo chown mysql.mysql /var/lib/mysql5.1.x

sudo make install
cd /opt/mysql5.1.x/bin/

sudo ./mysql_install_db --datadir=/var/lib/mysql5.1.x --user=mysql

Copy the init script from to the source directory mysql-5.1.37

sudo cp support-files/mysql.server /etc/init.d/mysql-5.1.x

modify this variable
in the start-up script

$sudo pico /etc/init.d/mysql-5.1.x

add the script at startup

$ cd /etc/init.d
$ sudo chmod +x mysql-5.1.x
$ sudo update-rc.d mysql-5.1.x defaults

Start mysql server
$sudo /etc/init.d/mysql-5.1.x start

Connect to mysql server
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.37 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


Set password for root user

/opt/mysql5.1.x/bin/mysql -u root
mysql> UPDATE mysql.user SET Password = PASSWORD('newpwd')
-> WHERE User = 'root';

Remove the anonymous accounts

mysql> use mysql
mysql> delete from user where user='';

Tuesday, August 11, 2009

sorting directories by disk usage

I needed to sort directories by disk usage using du and sort , but there was a problem with dirs that start with "-"

$du -s *

gives this error "du: invalid option --"

So i had to put the directory list result in a file:

$ find . -maxdepth 1 -type d -name '*' -print0 >file_list.lst

then i used the --files0-from

$ du -sm --files0-from file_list.lst | sort -n

seems that i needed to show the timestamp --time and maybe to exclude the "thumbs.db" from the report --exclude="thumbs.db"

$ du -sm --exclude="thumbs.db" --time --files0-from file_list.lst | sort -n

Tuesday, July 28, 2009

SQL compliant ROWS syntax obviates the need for FIRST and SKIP in Firebird

Today i found rows new syntax for first/skip that is more standard compliant

FROM POSTS a rows 4 to 6
nice that it works with update/delete too

extracting date from an timestamp value in firebird

you can use the cast to extract the date from timestamp

SELECT cast('now' as date)
FROM rdb$database

in my case the result is


someone asked on webhostingtalk how to do it

also you can extract only the year or month using the extract function

Friday, July 24, 2009

silvernight 2.0 and letour de france 2009 - fail

I really tried to watch tour de france today :(seems that microsoft and france television are partners in hell )

installed moonlight plugin for firefox 3.5 also the drm plugins/codecs from microsoft
and still i see only a black screen of death or stack traces

No wonder flash streaming is everywhere at least it works , crappy but it does work
And ogv is way better for streaming than flash / silvernight

[UPDATE:seems that stream is not allowed in Romania so kudos to mono team
Also i have tested the stream from vlc seems that akmai doesn't allow the stream to Romania

[00000414] access_mms access error: cannot connect to server
[00000414] access_mms access error: error: HTTP/1.0 401 Unauthorized
[00000412] main input error: open of `mms://

Monday, July 20, 2009

Clickable Rounded Buttons with jQuery

I have created an simple example for buttons that can be clickable with rounded corners using jquery.corner.js

Friday, July 17, 2009

Dear SourceForge - feedback on new design

Hello i like the new design only the colors are too washed , for example
the blue is too light and i can't read it very well on the white background
Please make the text darker , Thanks
Here is the new sourceforge design on project firebird page

Firebird Head Git mirror

I have created an firebird head mirror

the git cvs import was done this way

git cvsimport -C firebird2 -v -d
firebird2 -p z3
[wait a few days ...
thanks to screen now is finished]

cd firebird2/

git remote add origin
git push origin master

Counting objects: 300812, done.
Compressing objects: 100% (56994/56994), done.
Writing objects: 100% (300812/300812), 73.58 MiB | 1231 KiB/s, done.
Total 300812 (delta 249091), reused 294841 (delta 243566)
* [new branch] master -> master
=> Syncing Gitorious... [OK]

I will do an daily import push script in cron

ps: crazy ideea of the day git hook for database changes
if you modify an stored procedure it will add new version to the git
repository and commit push it there
the same for other DDL text

Wednesday, July 15, 2009

Recovering ubuntu karmic with an intrepid cd

i did an sudo apt-get dist-upgrade in karmic
and it removed upstart upstart-compat-sysv upstart-logd

I have to force from live cd to mount the partition as "-t ex4dev"

#mkfs.ext3 -E test_fs /dev/
$sudo mount /dev/sda1 -t ext4dev /mnt

$sudo chroot /mnt
seems that i need to downgrade upstart
system-services, and reinstall startup-tasks

I got the kdm prompt, had some weird errors with /dev/null when i logged in from the console (Alt F1)
so i upgraded to upstart 0.6 and again the system doesn't do the init or runs the scripts
maybe i need to put it in DEBUG mode
Now i'm studying the upstart main.c code and I wish it was written in python or any scripting language

Quote of the day is about Chrome and features

Per-process execution is a feature in Chromium (Google Chrome), not V8. And it is really needed anyway if one is using V8, because V8 is not thread safe.

So that is why you have one process for Tab in chrome (it's a bug called feature in V8)

Via trolls labs

Tuesday, July 14, 2009

git cvs-import gotchas on ubuntu and using firebird repo

I started to import the firebird cvs repository into my local git mirror.Why ?
Maybe because the bzr import failed after >30 hours ! also seems that fisheye is dead no changes to changelog there.
So my plan is to import the firebird cvs using git cvs-import and then push it to gitorious or bzr launchpad later (request a new git to bzr import)

First you need to install git-core and git-cvs
$ sudo apt-get install git-core git-cvs

you need to create the firebird2 dir with
$ mkdir firebird2
and specify it when you do the import with "-C firebird"
then you need to add the repository path from

First you need to do cvs login
$ cvs login

Here is the complete command line for importing firebird in local git repository

Monday, July 13, 2009

Quote of the day and Tree data structures in the database

The quote of the day:
The number 1 fear is speaking in front of others. Number 2 is death. Number 2. That means if you're at a funeral, you'd rather be in the coffin instead of giving the eulogy.
- Jerry Seinfield

And an advanced talk from Lorenzo Alberton :~140 pages about trees in sql
CTE can be used in firebird too

Wednesday, July 01, 2009

Arora is default full featured browser in Kubuntu

Arora is a simple cross platform web browser whose feature list includes things like "History" and "Bookmarks". It has a small code base and loads of fun to hack on. Benjamin Meyer originally created as a demo for Qt to help test the QtWebKit component and find API issues and bugs before the release Arora works with almost all websites and offers nice features like HTML 5, but needs some more features to give it the same parity as existing browsers. Arora should work with Web 2.0 websites we consider to be critical to our users. These include Slashdot, GMail, Google Calendar, Facebook, Flickr, Youtube, Yahoo and of course
[ED: tested the Slashdot , reddit , gmail , facebook , youtube, flickr and yahoo and all work OK , also and admin area
Arora passes 99/100 tests from acid3 tests also gets good scores on browser benchmarks

Thursday, May 28, 2009

volfied on dosbox (ubuntu jaunty)

in the highschool people were playing volfied almost on all computers in the lab
so today i wanted to try it on my cloudbook
sudo apt-get install dosbox
mkdir ~/dosbox/c
copy the volfied files from the zip in
mount c /home/mariuz/dosbox/c

cd volfied

the keys used are space and numeric arrows (doh on cloudbook there are none of these types)
i will try to remap them in dosbox

Romania wasting hundreds of millions of EUR on proprietary software.

Romania wasting hundreds of millions of EUR on proprietary software.
Seems they no longer need EU funds.

Microsoft Makes Itself at Home in Transylvania -
Count Dracula would have been proud of them #romania

Lucian's reaction

How to become an anonymous coward (ubuntu way)

How to become an anonymous coward (ubuntu way)

Here is how i installed the tor network privacy proxy

sudo pico /etc/apt/sources.list.d/tor.list

deb jaunty main
deb-src jaunty main

sudo apt-get update
sudo apt-get install tor

sudo pico /etc/privoxy/config

add this line at the end of file

forward-socks4a / localhost:9050 .

sudo /etc/init.d/privoxy restart

add http proxy in System -> Preferences -> Network Proxy
Http proxy:
Secure Http proxy:

That's all , Now you are an anonymous coward
You can check if you are on tor netowork

you can check also the wiki page from ubuntu

Tuesday, May 26, 2009

eLiberatica 2009: tequila shots

Not so strong as Palinca but it was ok

eLiberatica 2009: FOSS communities

the heads from the Foss comminities in romania , there were others around

eLiberatica 2009: FOSS communities

The romanian Floss communities are growing ,

Saturday, May 23, 2009

solving the esprimo sis rezolution issues

I had to add in xorg.conf (fixing one laptop at conference floor)

Section "Monitor"
Identifier "Configured Monitor"
HorizSync 30-107
VertRefresh 50-185


via :

Next was to install one driver from the above thread

and then i changed the sis or vesa driver to sis671 in xorg.conf section

Thursday, May 21, 2009

Ubuntu Romanian Team Report for April 2009

Apr 30 2009: Releasing Kiwi Linux 9.04, based on Ubuntu 9.04. Full release notes.

  • May 19 2009 the release of the Ubuntu for Romania, a localized version based on Ubuntu 9.04 Jaunty Jackalope. The installation CD is localised into Romanian and holds the majority of the default Ubuntu applications. The disk has specific network conectivity applications and legal restricted multimedia codecs to ease the transition of the new users to the Ubuntu operating system.

  • There were several Jaunty release parties in cities around the country
    • Release party Ubuntu 9.04 Jaunty Jackalope in Cluj Napoca. After the usual presentation of the operating sistem, the audience and the organizers talked about:

      • Organising the local Ubuntu comunity
      • The help and support offered by the local Ubuntu comunity
      • The statistics regarding the use of the Ubuntu operating system in Romania
      • The means and the methods that should be used to increase the number of the events held by the local comunity
      • The usual group pictures can be found here

    • Release party Ubuntu 9.04 Jaunty Jackalope in Arad

    • Release party Ubuntu 9.04 Jaunty Jackalope in Targu Mures report: almost 25 people were present and this time we had some great discussions and beer talk. We also did some serious presentatations like what is new in jaunty jack : new gnome, new kde, new qt browser like arora or development IDE like qt creator, I also showed the new firefox 3.5 ( abrowser 3.5), quassel, gwibber (microblogging client), firebird 2.1.x and some extensive discussion about ext4 crash-ing and it's amazing speed

  • The local team was reprezented to the Ubuntu 9.04 Jaunty Jackalope release party in Moldova. The pictures can be found here.