Wednesday, July 30, 2008

PostgreSQL - Firebird comparison - updated

I decided to add some infos about the latest Firebird release, see it in action

read more | digg story

Firebird Intl Conference (Italy) - Timetable is online

The timetable for the International Firebird Conference is now available in the official site. Register this week and get earlybird discount!

read more | digg story

Setting up ColdFusion and Firebird

After a long struggle on Devshed forums I decided to try on my own, after all I know Firebird and don’t see why it and ColdFusion can’t play nice together … infact they did, and easily.

read more | digg story

Versioning monitoring tables in Firebird 2.1/2.5

Firebird 2.1 added the long-awaited monitoring tables. By querying special system tables starting with MON$, you get a snapshot of the current activities in your database like who is connected to your database, which transactions and statements are running and so on

read more | digg story

Friday, July 25, 2008

From svn to git

now I can use svn repository from google code or from flamerobin
and then push it to github or keep it local

An nice guide for gnome developers is here
Git modifications and push to origin master (aka git hub )

$ cat README
Readme modified
$ git status
# On branch master
# Changed but not updated:
# (use "git add ..." to update what will be committed)
# modified: README
no changes added to commit (use "git add" and/or "git commit -a")
$ git commit -a
Created commit d47c527: test modifications
1 files changed, 1 insertions(+), 0 deletions(-)
$ git push origin master
Counting objects: 5, done.
Writing objects: 100% (3/3), 254 bytes, done.
Total 3 (delta 0), reused 0 (delta 0)
145b8ed..d47c527 master -> master

creating an git repository was easy (at github)

$ mkdir firebird_scripts
$ cd firebird_scripts
$ git init
$ touch README

$ git add README
$git commit -m 'first commit'
Created initial commit 145b8ed: first commit
0 files changed, 0 insertions(+), 0 deletions(-)
create mode 100644 README
$ git remote add origin

git push origin master
The authenticity of host ' (' can't be established.
RSA key fingerprint is 16:27:ac:a5:76:28:2d:36:63:1b:56:4d:eb:df:a6:48.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added ',' (RSA) to the list of known hosts.
Counting objects: 3, done.
Writing objects: 100% (3/3), 202 bytes, done.
Total 3 (delta 0), reused 0 (delta 0)
* [new branch] master -> master

So here is my repository
Bear with Me

- Mummmmy
- I'm Not Your Mommy
Ubuntu 8.10 Alpha 3 comes with a brand new development version of the Nautilus file manager (with tabs) and a new Linux kernel, version 2.6.26-4 (based on 2.6.26). It also includes the following applications

Thursday, July 24, 2008

building firebird 2.5 from source on ubuntu hardy

here is the script in google code

moving apache php hosts to nginx (scaling plan)

In the first stage we will use nginx to handle all images and files like javascript (is very fast and we can set high keepalive)
nginx can process php files from cakephp with fastcgi and i have wrote about the first test i have made at home for it (tested and worked the cake 1.2 and fastcgi on an ubuntu hardy system)

But to be safe we can keep apache and in first stage we use nginx as frontend for images and for php apache will handle the request
And if all ok we can switch later to an full nginx system without apache .(in part two)

Also nginx can be used as an load balancer (for content delivery) so in future if is needed we can add more servers for php serving

Think there will be more nginx servers but this only if there is a need to spread the load to many servers

git for developers , not only for gnome but for all that use subversion
i had to compile vlc from git because it seems the package building is broken for me
at the moment

$git clone git://
$ cd vlc
$ sudo ./bootstrap
$ ./configure --mandir=/share/man --build=x86_64-linux-gnu --enable-maintaner-mode --enable-release --prefix=/opt/vlc --enable-libtool --enable-fast-install --disable-update-check --disable-gnome --disable-gtk --disable-familiar --disable-fb --enable-ggi --enable-sdl --enable-esd --enable-mad --enable-arts --enable-alsa --enable-jack --enable-pulse --disable-lirc --enable-a52 --disable-aa --enable-dvbpsi --enable-mozilla --disable-kde --enable-mp4 --enable-dvb --disable-satellite --enable-ogg --enable-vorbis --disable-shout --disable-wxwidgets --enable-qt4 --disable-slp --enable-flac --disable-skins --disable-basic-skins --enable-skins2 --enable-freetype --enable-mkv --enable-speex --enable-caca --disable-live555 --enable-libmpeg2 --disable-fribidi --enable-cdio --enable-mod --enable-theora --enable-modplug --enable-gnutls --enable-ffmpeg --enable-ncurses --enable-smb --disable-gnomevfs --enable-bonjour --enable-mpc --enable-vcd --enable-vcdx --enable-notify --enable-debug --enable-twolame --enable-x264 --enable-faad --disable-zvbi --enable-telx --enable-mediacontrol-bindings --disable-x264 --disable-atmo --enable-alsa --enable-dv --enable-v4l --enable-v4l2 --enable-pvr --enable-svgalib --disable-dvd --without-dvdcss
$make ; sudo make install

Here is the script in svn

healthy food at work
yum cheese and onions

Wednesday, July 23, 2008

OpenSSH 5.1 Released with new asci art for host keys

Parent article: OpenSSH 5.1 released

Sure. Here are a couple of my hosts courtesy of ssh -o VisualHostKey=true:

+--[ RSA 1024]----+
| E. |
| . |
| . |
| ... |
| +So. . .|
| =.. .oooo|
| o.++oo= |
| o=+o. |
| .+. |

+--[ RSA 1024]----+
|OO+ |
|Ooo. |
|oo.. |
|.o. |
| o.o S |
|. o . . |
| . oo |
| . Eo. |
| .. .. |

$tar -zxvf openssh-5.1p1.tar.gz
$cd openssh-5.1p1
$ ./configure --prefix=/opt/openssh
$ make ; sudo make install
$ /opt/openssh/bin/ssh -o VisualHostKey=true localhost
Host key fingerprint is 3e:34:fc:3e:af:ff:33:dd:65:73:fc:db:33:e3:4b:18

+--[ RSA 1024]----+
| |
| |
| |
| . |
| S E . |
| o o o.=|
| o . . +*|
| o. ++=|
| o=o.o*B|


Tuesday, July 22, 2008

Recommended update - Firebird 2.1.1

Here are a few of the fixes I consider important for 2.1 production servers and so recommend the update

read more | digg story

Firebird SuperClassic - Another option

Called SuperClassic, it will be the basis for the multi-processor support that we’ll see in Firebird 3.0.Don’t lose count. Starting from Firebird 2.5 you will be able to choose among SuperServer, ClassicServer and SuperClassic.

read more | digg story

Monday, July 21, 2008

problem with nginx and cakephp is solved now

I had to put the right root

location / {
root /var/www/app/webroot;

sound-juicer can be removed , i don't rip cds
i also use vlc 0.9.0 instead of totem
so i can remove all totem packages

$sudo apt-get remove totem totem-common totem-gstreamer totem-mozilla
How to disable ipv6 in ubuntu

here is an small howto

Before disabling

and after

$ip addr show lo
1: lo: mtu 16436 qdisc noqueue state UNKNOWN
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet scope host lo

see no ipv6
gnome-nettool is quite useful so it will stay for the moment

i use comand line tools line , traceroute and mtr but it looks nice and i like it

network status is ok for me and i don't quite care about network applet so i have removed it

I told you i don't use evolution and deskbar-applet

so i have removed them

$sudo apt-get remove contact-lookup-applet deskbar-applet

Deskbar-applet is intended as a browser-like keyword-driven url bar.
You type a web address, or an email address, or a file name, or some
keyword then the arguments, and it shows a popup with possible choices
from there. Like 'Search google for foo'.
I also don't use palm

$sudo apt-get remove gnome-pilot gnome-pilot-conduits
my next removals (i use k3b so i can remove brasero, also i use thunderbird so i can remove all evolution bloat)

$sudo apt-get remove evolution-webcal gnome-cards-data rhythmbox brasero

i'm still left with evolution-data-server-common
also i don't use msdos floppies or zipdisks so
i can remove mtools
also i don't need wvdial

on an lan network

sudo apt-get remove wvdial
if you don't use floppies
then you can remove fdutils

sudo apt-get remove fdutils
/etc git snapshots with php

Read the main article with general idea

I have wrote an small php script for daily snapshots for /etc

Here how i use it on an nacked sistem

1.install git
apt-get install git-core
2. initialize /etc to be a git repo
cd /etc
git init-db
chmod og-rwx .git
3.ignore a few files
cat > .gitignore
4.commit the current state
git add .
git commit -a -m"initial import"

then you can add an daily snapshot script or an after upgrade one (after dist-upgrade)


You can check the /etc status with

$sudo git status

in my case was

# On branch master
# Changed but not updated:
# (use "git add ..." to update what will be committed)
# modified: php5/cli/php.ini
no changes added to commit (use "git add" and/or "git commit -a")
so i have made a new snapshot
/etc Backup for Mon Jul 21 18:51:19 EEST 2008Created commit a2b9112: snapshot Mon Jul 21 18:51:19 EEST 2008
1 files changed, 1 insertions(+), 1 deletions(-)

the police office jam

some coleague working with za bass, and the others [strike]playing[/strike] are happy around

after pulse audioremoval

now i can watch youtube with sound thank you

also what is left libpulse0 , if i remove it
then it will remove audacious and mplayer
I guess i can recompile them without pulse support
also i should remove pulse from ubuntu-desktop (there is one dependency somewhere)

howto solve the pulseaudio problem in ubuntu

remove all pulseaudio [it might break your system please do it with care]

sudo apt-get remove pulseaudio pulseaudio-esound-compat pulseaudio-module-gconf pulseaudio-module-lirc libpulse-dev

or with synaptic hunt them down all packages that can be removed from the system
without breaking it too much

10 things you’ll get with Ubuntu 8.10 “Intrepid Ibex”

PulseAudio and Flash should be on top of the list

A quick resume of what the most important (IMHO) things users will get with the next Ubuntu release: Intrepid Ibex.

Ubuntu Weekly Newsletter #100!

For our 100th edition, we cover the history of the UWN and discuss what the UWN has meant for people who have worked on it. Former, current staffers, and Mark Shuttleworth discuss their experiences of contributing to the UWN and the impact of the UWN on the community, in a podcast. The usual summary of community happenings is also included.

read more | digg story

Catching Up on Ubuntu News

Let’s catch up on some of the recent news in Ubuntu

read more | digg story

Sunday, July 20, 2008

brown snitz is back in unbuntu intrepid

but i like the dark side of ubuntu studio ,
If you choose an dark theme at least choose a better theme like the one in studio

put your rest in memcache

briliant idea to use memcache and have less hits to the php and database (expensive)
I guess 99% of time the hits will be requested from memcache and only the new pages will be created
and pushed in memcache> nginx -> memcache -> php+apc- > select * from employees

Load Balancing & QoS with HAProxy

[Ed: and seems that nginx can be used like an proxy and load balancer , what next ? you can get rid of complex lvs ]

Did you know that Flickr optimizes all of their pages to render in sub 250ms?

When you're fighting with response times, the worst thing you can possibly do is queue up another request behind an already long running process. Not only does the first request take forever, but everyone else must wait in line for it to finish as well! To mitigate the problem HAProxy goes beyond a simple round-robin scheduler, and implements a very handy feature: intelligent request queuing!

HAProxy Request Queuing

You can get similar functionality in Nginx directly with the 'Fair Proxy Balancer' plugin (EngineYard is rumored to be running it).

Nginx and Memcached, a 400% boost!

seems another way to speed the request responses

Nginx, by default, comes prepackaged with the Memcached module, which allows us to bypass the Mongrel servers and talk to Memcached directly. Same hardware, and a quick test later: ~3,550 req/s, or almost a 400% improvement! Not bad for a five minute tweak!

Nginx+ Memcached

nginx is very efficient

Very efficient memory handling: it needs only 2.5Mbytes of RAM for 10000 inactive keep-alive connections.

try that with apache and php module , it will kill the server at so many requests
Serving flv files with nginx

Seems that i can ditch apache now wihout problems from equation also lighttpd (that seems to be stalled and with more crashes and memory leaks)
nginx - Basically, it's saved a server.

Quote of the day about nginx web server :

I've moved two phpAdsNew ad servers, a fairly-busy Wordpress blog, the above-mentioned Drupal site and my own Drupal site from Apache2 into Nginx in the last week. Processor use has increased on the server, but critically the ongoing web+database memory use has come down by over 300MB. This means that the box hasn't gone into swap for a week (normally it was paging out every day), server response times are up and (because I'm also using APC to store Drupal's source files in memory) page download speeds are also up considerably.

Basically, it's saved a server.
very cool radiohead video clip released as open source

Tips for configuring nginx for cake php

Here are the rewrite rules to use for nginx, seems that i will need to solve the img problems

location / {
root /var/www/cake/app/webroot;
index index.php index.html;
# If the file exists as a static file serve it
# directly without running all
# the other rewite tests on it
if (-f $request_filename) {
if (!-f $request_filename) {
rewrite ^/(.+)$ /index.php?url=$1 last;

here is my nginx config that you can take as example

Linux 2.6.26 Kernel Benchmarks

The benchmarks we used for this kernel testing was LAME MP3 encoding, Mencoder LAVC encoding, timed Gzip compression, parallel BZIP2 compression, timed LZMA compression

read more | digg story

Perl Catalyst and Cloud Computing

Interesting article about using Perl for computing in the cloud. Includes details of Amazon EC2 images that contain all the cool Perl stuff.

read more | digg story

Perl as an act of love

Clay shirky on Perl, love and the internet.

read more | digg story

VMware exec says Windows days are numbered

Seriously, and what will replace it? Would you believe a VMware exec saying it will be virtual applications running on... Linux? Believe it.

read more | digg story

Apache, PHP and Firebird Performance Tuning

In the last post I commented that I had a test-bed application, based on Apache, PHP and Firebird, and once the problem with the images was solved I could finally start doing the actual performance testing/tuning that I originally wanted to do.

read more | digg story

Firebird 2.5 Alpha 1

The Firebird Team is pleased to let loose the first Alpha of Firebird 2.5, more or less feature-complete and ready to field-test. Kits are available for 32-bit and 64-bit Windows and Linux

read more | digg story
Linus Torvalds, Geek of the Week

Linus Torvalds is remarkable, not only for being the technical genius who wrote Linux, but for then being able to inspire and lead an enormous team of people to devote their free time to work on the operating system and bring it to maturity. We sent Richard Morris off to interview Linus, and find out more.
Torvalds wrote: "PS. And to get wider distribution for this message: Digg users - you're all a bunch of Wanking Walruses. And you can quote me on that."

and then they Wanking Walruses can cooperate with the masturbating monkeys from OpenBSD

"Torvalds yesterday described OpenBSD developers as "masturbating monkeys"."
audacious stopped working and i had to reinstall xmms from source

yeah sorry about that , but i absolutely swear that it sounds better than audacius
I don't know maybe it writes directly to /dev/dsp or it uses alsa better
Yah and i fscking hate pulse-audio , nothing works , flash or other applications (audacious ...)

Friday, July 18, 2008

Firebird 2.1.1 and Flamerobin 0.8.6 on Windows 2008 Server

here is the video , but is quite low quality video

Wednesday, July 16, 2008

List of Firebug Extensions

Have you ever been interested in what extensions are available for Firebug? If yes, take a look at what I have found. Frankly, I was quite surprised how many Firebug extensions already exists out there.

  • YSlow
  • Firecookie
  • FirePHP
  • RainbowForFirebug
  • Jiffy
  • Firequark
  • LiveCoder
  • PixelPerfect
  • FirebugCodeCoverage
  • Firebug Net Panel History Overlay
  • Fireclipse
  • Chromebug

Tuesday, July 15, 2008

how to get an UUID from firebird

select GEN_UUID() from rdb$database

result in my case

To use UDF modules in ubuntu/linux

You must put full path to the UDF module when you declare the function
in my case

otherwise you will get something like
"Invalid token. invalid request BLR at offset 63. function SUBSTR is not defined. module name or entrypoint could not be found."

--FBUDF_API int isLeapYear(const ISC_TIMESTAMP* v);
declare external function isLeapYear
returns int by value
entry_point 'isLeapYear' module_name '/usr/lib/firebird/2.1/UDF/';
then it worked

select isLeapYear(hire_date) from EMPLOYEE

Thursday, July 10, 2008

html canvas 3d update

and there is some doom 3d engine based on the canvas
php5.3 firebird extension good news

seems that in today snapshot 200807100630 are less bugs

TEST 1472/4227 [ext/interbase/tests/002.phpt]^MPASS InterBase: connect, close and pconnect [ext/interbase/tests/002.phpt]
TEST 1473/4227 [ext/interbase/tests/003.phpt]^MFAIL InterBase: misc sql types (may take a while) [ext/interbase/tests/003.phpt]
TEST 1474/4227 [ext/interbase/tests/004.phpt]^MPASS InterBase: BLOB test [ext/interbase/tests/004.phpt]
TEST 1475/4227 [ext/interbase/tests/005.phpt]^MPASS InterBase: transactions [ext/interbase/tests/005.phpt]
TEST 1476/4227 [ext/interbase/tests/006.phpt]^MFAIL InterBase: binding (may take a while) [ext/interbase/tests/006.phpt]
TEST 1477/4227 [ext/interbase/tests/007.phpt]^MPASS InterBase: array handling [ext/interbase/tests/007.phpt]
TEST 1478/4227 [ext/interbase/tests/008.phpt]^MFAIL InterBase: event handling [ext/interbase/tests/008.phpt]

Wednesday, July 09, 2008

Enabling webkit's WebInspector in arora browser
Click on Tools -> Enable Web Inspector
then right click -> Inspect

and here are some nice graphs when you click on profiles

Tuesday, July 08, 2008

Firmware for xc2028 tuner and Winfast TV2000 XP Global

In case you try the v4l-dvb from mercurial repository and winfast TV2000 xp global (seems to be suported if you look the cx88 card list but no sound in my case )

install v4l-dvb from source

$hg clone

cd v4l-dvb
make ; sudo make install

Then extract the firmware


In order to use, you need to:
1) Download the windows driver with something like:
2) Extract the file hcw85bda.sys from the zip into the current dir:
unzip -j
3) run the script:
4) copy the generated file:
sudo cp xc3028-v27.fw /lib/firmware

reboot and driver should look like this

[ 344.286793] xc2028 2-0061: Loading firmware for type=MTS (4), id 0000000100000007.
[ 344.334342] cx88[0]: Calling XC2028/3028 callback

Monday, July 07, 2008

enable mod expire for fast image loading

here is the example from google (they have set the cache expire far far in the future )

$ curl -I

HTTP/1.1 200 OK
Content-Type: image/gif
Last-Modified: Mon, 07 Jul 2008 04:33:28 GMT
Expires: Sun, 17 Jan 2038 19:14:07 GMT
Cache-Control: public
Date: Mon, 07 Jul 2008 10:09:52 GMT
Server: gws
Content-Length: 16715

here is my configure.nice script for apache 2.2.x

"./configure" \
"--prefix=/opt/apache2.2" \
"--enable-so" \
"--enable-mantainer-mode" \
"--enable-module=all" \
"--enable-rewrite" \
"--enable-include" \
"--enable-info" \
"--enable-expires" \

also after all is build and installed (apache server restarted)
you can check the expire config

$/opt/apache2.2/bin/httpd -l | grep expire

or in browser

and add the expire config into the httpd.conf or .htaccess

ExpiresByType text/html "access plus 1 month 15 days 2 hours"
ExpiresByType image/gif "
access plus 1 month 15 days 2 hours"

you can check later the expire headers with curl

$curl -I

HTTP/1.1 200 OK
Date: Mon, 07 Jul 2008 12:18:14 GMT
Server: Apache/2.2.8 (Unix) PHP/5.2.6
Last-Modified: Tue, 01 Jul 2008 13:57:59 GMT
ETag: "3884a9-2348f-450f6c38087c0"
Accept-Ranges: bytes
Content-Length: 144527
Cache-Control: max-age=3895200
Expires: Thu, 21 Aug 2008 14:18:14 GMT
Content-Type: image/gif

Friday, July 04, 2008

Vote for Firebird on Sourforge Community Awards - It’s the Finals

Firebird is now Finalist on Sourforge Community Awards , and is time to vote it

Here are my votes

Visual C# under ubuntu (with vmware)

Of course i use monodevelop but for testing applications , you can install visual studio into an windows 2008 machine

Alien Cat

Originally uploaded by Vina the Great
Now that is an ugly cat ...

Thursday, July 03, 2008

First gtk# Goodbye World project

Install monodevelop and c# compiler

$apt-get install monodevelop mono-gmcs

start the monodevelop ide


then follow this tutorial from monodevelop

First Look at Thunderbird 3 Alpha

The latest version of the free, open-source email manager, Thunderbird, is in the wild—in an alpha release rough enough around the edges to earn the code-name "Shredder."

read more | digg story

Wednesday, July 02, 2008

Big Buck Bunny Builds a Better Blender

A great article on about the making of the Big Buck Bunny movie and what are the plans for the future. "Peach was the second such project in Blender's history; the first was Project Orange in 2006, which developed the short film Elephants Dream. The Blender Foundation organized Orange and co-managed it with a commercial animation studio

read more | digg story

Mass-market WiFi router invites hackers

NetGear is shipping an 802.11g access point that's made to be hacked. Seemingly created in homage to LinkSys's hacker-friendly "WRT54GL," the WGR614L offers fairly generous complements of CPU power, RAM, and Flash, and support for several commercial and community-supported alternative Linux-based router distributions.

read more | digg story

The Visual History of Ubuntu

While Debian has been around for over a decade, Gentoo for five years, and Mandriva/Mandrake for nearly nine years, in less than three years of existence Ubuntu has received the most attention and generated the greatest amount of publicity in the Linux limelight. Why is that?

read more | digg story

winetricks 20080627 released

Dan Kegel updated winetricks. Look at the list below to see whats fixed and download the new version. Here is the main changes since the 20080622 release: Removed wineprefixcreate for the time being, Updated Microsoft Line Services (MSLS 3.1), Updated vcrun2005 to set winver to Windows 2000 before installation

read more | digg story

Ext4 is now the primary filesystem on my laptop

Over the weekend, I converted my laptop to use the ext4 filesystem. So far so good! So far I’ve found one bug as a result of my using ext4 in production (if delayed allocation is enabled, i_blocks doesn’t get updated until the block allocation takes place

read more | digg story

Tuesday, July 01, 2008

One more reason to switch to an open IM standards like thouse used at or

Cannot connect to ICQ ("The client version you are using is too old.")
building kompozer from source

1. download it

2. unzip it
tar -xjf kompozer-*-src.tar.bz2
3. make it
cd mozilla
sudo apt-get install libgtk2.0-dev libidl-dev
make -f build_all it

cd ..
obj-kompozer/dist/bin/kompozer &

deleting files older than 2 days

find . -type f -mtime +2 -print0 | xargs -0 rm
sendmail, command to flush queue?

Try "sendmail -q -v"