Firebird News

Friday, March 28, 2008

firebird 2.1 rc2 for ubuntu hardy/gutsy is ready

firebird 2.1 rc2 for ubuntu hardy/gutsy is ready and can be installed from ppa repository , also an administration tool is included (flamerobin)

read more | digg story

Thursday, March 27, 2008

Winfast TV2000 XP Global support on 2.6.25 kernel
while looking in the list of kernel changes
i saw that support for xc2028/xc2038 tuner was added
so i compiled that tree
hg clone http://linuxtv.org/hg/~mkrufky/cx88-xc2028-mauro/
cd cx88-xc2028-mauro/
make
sudo make install
in
/etc/modprobe.d/options
i have added

options cx88xx card=61

[ 31.868615] cx88[0]: subsystem: 107d:6618, board: Winfast TV2000 XP Global [card=61,insmod option]
[ 31.868617] cx88[0]: TV tuner type 71, Radio tuner type 0
[ 32.027194] cx88[0]/0: found at 0000:02:00.0, rev: 5, irq: 16, latency: 64, mmio: 0xce000000
[ 32.035815] cx2388x alsa driver version 0.0.6 loaded


[ 32.188771] tuner' 0-0061: chip found @ 0xc2 (cx88[0])
[ 32.188804] xc2028 0-0061: type set to XCeive xc2028/xc3028 tuner
[ 32.188808] xc2028 0-0061: xc2028/3028 firmware name not set!
[ 32.197833] NET: Registered protocol family 17
[ 32.212796] cx88[0]/0: registered device video0 [v4l2]
[ 32.212830] cx88[0]/0: registered device vbi0
[ 32.212860] cx88[0]/0: registered device radio0
[ 32.212923] xc2028 0-0061: xc2028/3028 firmware name not set!

Tuesday, March 25, 2008

How do I disable evolution-data-server

evoltion-data-server was eating 100% of cpu so i had to kill it on my hardy box


Wednesday, March 19, 2008

DKIM Wrapper that works for using dk with qmail

qmail-dk patch was not working on my qmail setup , there were some strange errors and it didn't signed an yota from mails that were going outside the server (and i lost 2 days with it)

please read the steps 4-5-6 for creating the keys the rest is just informative
http://jeremy.kister.net/howto/dk.html

so now i have use this perl+bash script that works

DKIM Wrapper

To sign all outbound messages with a DKIM and/or DomainKey, there are many alternatives. One is Russ Nelson's qmail-dk. While popular, it only handles DomainKeys, and doesn't sign all outbound messages, merely all *inbound* messages (that may then become outbound). Thus, things like bounce-messages cannot be signed, because they don't go through the usual qmail-smtpd/qmail-inject filters. Another way around this is to use a script wrapper around qmail-remote, like this. All you need to do is move the real qmail-remote to qmail-remote.orig and put that script in as qmail-remote (make sure it's readable and executable by everyone). The script uses two programs to do its job: the dktest program that comes with libdomainkeys and dkimsign.pl that comes with Perl's Mail::DKIM module. If you're interested in verifying DKIM and DomainKey signatures, a similar script that can be used in much the same way as Russ Nelson's program is here.

$cd /usr/local/src/libdomainkeys-0.68
$make
$cp dktest /usr/local/bin/
$cp dnstest /usr/local/bin/
$cp dknewkey /usr/local/bin/
$cp expected /usr/local/bin/
$cp makeheader /usr/local/bin/
$cd ..
$wget http://www.memoryhole.net/qmail/qmail-remote.sh
i have modified the relevant parths in the script
$vi qmail-remote.sh

$wget http://search.cpan.org/CPAN/authors/id/J/JA/JASLONG/Mail-DKIM-0.30.1.tar.gz
and installed the required cpan modules with
$sudo cpan
$tar -zxvf Mail-DKIM-0.30.1.tar.gz
$cd Mail-DKIM-0.30.1
$perl Makefile.PL
$make ; sudo make install
$cd script
$sudo mv * /usr/local/bin/
$cd /var/qmail/bin
$sudo mv qmail-remote qmail-remote.orig
$sudo cp /usr/local/src/qmail-remote.sh qmail-remote
$chmod +x qmail-remote
$chown root.qmail qmail-remote
$qmailctl restart

modify the private.key fixed path from /usr/local/bin/dkimsign.p to be your full private key
/etc/domainkeys/example.com/default

send emails and watch the headers
tail -f -n 500 /var/log/qmail/current

now you should modify the dns , here are some tips


http://wiki.qmailtoaster.com/index.php/Domainkeys

Monday, March 17, 2008

replacing xmms with audacious

xmms will be removed from ubuntu/debian in the future

so i have installed the audacious
$sudo apt-get install audacious audacious-plugins


i have made audacious to look exactly like the xmms with Refugee skin so it can replace xmms easily on any desktop

and it has the voice removal plugin (needed for playing covers)

the cpu used is somewhere at 5% for audicious but is ok i guess

ps: the only thing i need now is an gnome applet for playing music


bonus packages :

$sudo apt-get install audacious-plugins-extra audtty pidgin-musictracker

Friday, March 14, 2008

Is it me, or that thing is weird?!

~# eog /usr/share/gnome-panel/pixmaps/gnome-gegl2.png

no is normal :P

Thursday, March 13, 2008

installing qmail on debian/sid and ubuntu


$wget http://ftp.fr.debian.org/debian/pool/non-free/q/qmail/qmail-src_1.03-45_all.deb
$wget http://ftp.is.debian.org/debian/pool/non-free/u/ucspi-tcp/ucspi-tcp-src_0.88-10_all.deb

$sudo dpkg -i qmail-src_1.03-45_all.deb
$sudo dpkg -i ucspi-tcp-src_0.88-10_all.deb


$build-ucspi-tcp
$build-qmail


create an maildir for home

$maildirmake $HOME/Maildir

$echo ./Maildir/ > ~/.qmail


vi /etc/init.d/qmail


de comment the line with

alias_empty="./Maildir/"
and comment the one with

#alias_empty="|/usr/sbin/qmail-procmail"

restart qmail and then you can start sending emails (telnet localhost 25)
freemindmap on hardy

is impressive to create an map for an new site for example

http://freemind.sourceforge.net/wiki/index.php/Main_Page

in ubuntu can be installed by

$sudo apt-get install mindmap
the most hated library upgrade - glibc upgrade in hardy

Here is the bug

When i had to upgrade systems usually the most hated part was doing it for glibc
and always was with fears that will crash the system , kernel upgrades went ok
most of the time but sometime an glibc upgrade made the system borked

Tuesday, March 11, 2008

Firebird 2.1 Release Candidate 2 Ready

The Firebird Project team is happy to announce that download kits for the second (and hopefully, last) V.2.1 release candidate

read more | digg story

Sunday, March 09, 2008

converting all the mp3/wma to ogg
one easy way is with pacpl

Download the source code from sourceforge download page

$wget http://dfn.dl.sourceforge.net/sourceforge/pacpl/pacpl-4.0.1.tar.bz2
$tar -jxvf pacpl-4.0.1.tar.bz2

and install the prerequisites with

$sudo apt-get install libvorbis-dev libflac-dev lame toolame

then start the cpan perl modules install and watch for any errors

$cd pacpl-4.0.1/extra
sudo ./mod-install.sh
then run the configure script

$cd ..
$./configure
$make
$make install

If any modules you forgot you can read the README and install the perl ones from cpan

If all is ok then you can convert all the files from amarok/konq or from comand line
$pacpl --help
usage: pacpl --to [file(s)/directory(s)]

in my case
$pacpl --to ogg -r /home/mariuz/Various

Friday, March 07, 2008

delete issues in firebird in cake php

seems that delete statement is not correct

SQL Error: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 8 "POST" [CORE/cake/libs/model/datasources/dbo_source.php, line 440]

and the delete statement is here

DELETE "POST" FROM "POSTS" "POST" WHERE "POST"."ID" IN ('5')

the correct form that works in flamerobin for example is

DELETE FROM "POSTS" "POST" WHERE "POST"."ID" IN ('5')

Thursday, March 06, 2008

seems that i had to use cakephp 1.2 cookbook

here is the right tutorial for beta

and /add data validation is done without errors now
About the cakephp blog tutorial error problem

I found this answer about the tutorial bug

The blog tutorial must be updated... because we are using Form Helper
now instead of Html Helper.
See : http://book.cakephp.org/view/182/forms to know how use Form
Helper.
Here is the final blog tutorial database for cakephp

/****************** GENERATORS ********************/

CREATE GENERATOR GEN_POSTS_ID;
/******************** TABLES **********************/

CREATE TABLE POSTS
(
ID Integer NOT NULL,
TITLE Varchar(50),
BODY Varchar(2000),
CREATED Timestamp,
MODIFIED Timestamp,
PRIMARY KEY (ID)
);


/******************** TRIGGERS ********************/

SET TERM ^ ;
CREATE TRIGGER POSTS_BI FOR POSTS ACTIVE
BEFORE INSERT POSITION 0
AS
BEGIN
IF (NEW.ID IS NULL) THEN
NEW.ID = GEN_ID(GEN_POSTS_ID, 1);
END^
SET TERM ; ^

GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
ON POSTS TO SYSDBA WITH GRANT OPTION;
i couldn't install vmware player on hardy so instead i installed virtualbox
and then i downloaded the jeos iso and created an new disk for it
i will call it ubuntu-firebird (4g image)

after installing it with
$sudo apt-get install virtualbox-ose
i have added myself in vboxusers
$grep vboxusers /etc/group
vboxusers:x:124:mariuz

then restarted the system
this thing is really faast , it runs at the native speed , i like it and i think i will convert my
vmware images to virtual box ones
did i mentioned that is open source too ??

soon i will test kvm on my machine

Wednesday, March 05, 2008

insert one blog post into database

INSERT INTO POSTS (ID, TITLE, BODY, CREATED, MODIFIED)
VALUES (
null,
'Foo',
'bar',
'now',
'now'
)

and do an select

SELECT a.ID, a.TITLE, a.BODY, a.CREATED, a.MODIFIED
FROM POSTS a


'now' is an predefined timestamp literal in firebird
creating the blog database for cakephp (beta)

after creating the empty database for cake and php5_interbase is installed
now i create the posts table from the cake tutorial

CREATE TABLE POSTS(
ID Integer NOT NULL,
TITLE Varchar(50),
BODY Varchar(2000),
CREATED Timestamp,
MODIFIED Timestamp,
PRIMARY KEY (ID)
);

also an autoincremental id with generator

CREATE GENERATOR GEN_POSTS_ID;

SET TERM ^ ;
CREATE TRIGGER POSTS_BI FOR POSTS ACTIVE
BEFORE INSERT POSITION 0
AS
BEGIN
IF (NEW.ID IS NULL) THEN
NEW.ID = GEN_ID(GEN_POSTS_ID, 1);
END^
SET TERM ;
flamerobin 0.8.5 snapshot ready in the debian repository

you can test it in debian unstable (amd64 and i386)
http://packages.debian.org/sid/flamerobin

Other binary snapshots for 0.8.5 are here

Tuesday, March 04, 2008

firebird2.0 package is now included in debian etch backport

firebird2.0.3 package is now included in debian etch backports (stable)also the firebird 2.1.x can be tested (from git)

read more | digg story

Monday, March 03, 2008

Choice between MySQL and Firebird?

For developing desktop application :Which one of the two would you choose and why?

read more | digg story

Sunday, March 02, 2008

Ubuntu Weekly Newsletter #80

Welcome to the Ubuntu Weekly Newsletter, Issue 80 for the weeks February 24th - March 1st, 2008. In this issue we cover the Alpha 6 Freeze, the release of Kubuntu-KDE4, Full Circle Magazine #10, Ubuntu Mobile, launch of Ubuntu Brainstorm, a Mark Shuttleworth Interview, and, as always, much, much more!

read more | digg story