Tuesday, February 02, 2010

When Our darkest fears attacks us

I have a fear for holes in the earth like the graves
In my childhood i played with some kids in a ground hole made for a house
and for fun they had the idee of let me there without stairs.
I panicked and had great fear that something terrible will happen.
They let me cry there inside the "grave" it was not a good feeling at all.
Another fear is fear of death but i will talk about it later.
One strange fear is loosing someone you love , you think you can do anything to not happen but sometimes it does.
And when you have that fear somtimes you might try act to avoid situations that put your love in danger but in the end fear is the worst enemy and makes thinking weak and reactions not rational: that is why  panic attack and jealousy exists, and the feeling is the same : a great pain in the chest
hard rate of heart and blood pressure and feeling that you explode and can't breath
It can kill the rational self or the love we carry.




Monday, February 01, 2010

There are good deaths ?

My sister just announced me that Maria (A lui Petrica) died
she was one of the neighbors from grandmother's house.
Sometimes not the people who expect they die but the ones unexpected,
she was stranded in the house for more that 10 years and only vitamins and meds kept her alive,
I always expected to die first from the list neighbors or when my father told me that someone around died
and yes i did my little prayers so he should be lifted from this misery life but seems that my grand mother was first
that stepped on the other side.
Who knows what sins she had or what are she's rewards after this life for so much pain.and linger.
God rest her in peace i will always miss her strawberry pancakes and cookies. She was the grandmother of my best friend (Daniel) from the childhood. I should call him.

Sunday, January 31, 2010

Teddy Bear Without Heart Storyline

I want to write a song and do the 3d grapics for it (yes is 5 AM in the morning , sleepless and with ideas) and music with the help of lmms.
It's about a teddy bear that loses his heart
He has a kitty as friend and one day  teddy takes his heart and gives it to the little kitten
And kitty plays and plays around witth his heart.
And the kitty enters in a virtual world with his heart and the bear can't find them both
and becames some kind of zombie.

And he enters the virtual world and he searches his little kitten and speaks to various animals.

:- Have you seen my heart and little kitten ?

In the end he finds her and they will be very happy i guess , but is only a story



Here are the first versions of the verses

http://gist.github.com/289835

work will be under CC license http://creativecommons.org/
and i might reuse the world and animals from bigbuckbunny.org
the evil stays the evil , and the rest are good as they are for the moment
I 'm imagining that you will know who will steal the heart of the teddy from the kitten

Saturday, January 30, 2010

A part of me died in 2008

Once with my grandmother's funerals , It was like a second mother to me
I growed there at the country side with real cows and real chickens and when i was a child
she took care of me before i went to school, parents had jobs and it was hard for them with 2 childrens and work.
I want to start some of the stories about what i remember from that time.
I have big pain in the chest when i think about my grandmother , when i go now to that house
i still wait to apear and to ask me how do i feel or anything and i cry rivers
I kept my pain inside too long and i should cry more and more to free my chest.
Maybe that is the reason that i'm not the same like before , i had so much to carry with me
When i saw it that they put her in the grave something died inside me . I can't describe the pain and
the feeling that world ends at that time . and when i saw my sister's eyes i think i understood
never again in this life we will see her.
Now i put candels to the grave , but is a part of me there too .
On the bright side in the day she died there was an beatifull rainbow after all day was rainy and cold and ugly .Maybe a sign that she is ok on the brighter side of death.

Monday, January 25, 2010

Andy's death part two

Andy died of cirrhosis and he entered in servraje because he didn't drinked for about two days , anyway he wanted to die because he was lonly and forgotten
This is what his son Anduta told to my sister.
After his death he gave her his last unfinished sculpture...
Maybe if he was treated 2 years ago he was alive today

And now comes the WTF part:
The orthdox ? priests , the most hated clique in Romania
he asked for 9 Millions (old LEI) for the ceremony (and this is for a poor man)
and yes just because he was burned in Bucharest they have asked more
you know only because it's shouldn't go like a dog on the road to Bucharest.
I hate them , Let them burn in Hell , I will not kiss their dirty hands.

Ahh and they asked to buy candles only from the church ~1 Mil

Sunday, January 24, 2010

Crappy new year

I think this year began with sorrow and not with happyness
First our family friend Andy died alone in his apartment in Burdujeni (Suceava)
He died alone like dog , with no friends or relatives around (my grandmother always said that we die alone with only the maker in front of us , and no relatives are just dust compared with the full dark and freedom)
I don't know more about his death , what happened but i know his son tried to convince the elders that Andy's last wish was to burn in fire and not to be eaten by worms and the ugly humus.
I have to ask my sisters more about it .
He always told us stories about his family and how they went on OLT river by boat with the full crew (family)
and how they saw bears i think in Harghita moving around his boat in the dark throwing tree roots arund, he went to a store and he asked for bread and it was  Ceausescu time when bread was scarce and only you could get only one per person so the people around gave him their pieces and for the all family
and how they went down the river and somwehere where only romanians exists in the south
they throwed stones to them just for fun
Another beautiful story he told us was about his trip with the bycicle (Pegas) from Suceava to Sighisoara
over the mountains to the Medieval Festival .How they had some strong drinks with them (Afinata) and once Anduta felt with the bycicle so strong that he was bleeding but with his father help and strong drinks they continued.In Sihisoara they stayed with some high school teenagers around and they asked for some grass/pot so Andy created the master pot with simple Carpati + Pepper + other things to put in the soup not in your nose and the funny thing people liked it and they wanted more.
only after a few days Andy told them that it was only the power of Carpati and nothing else :P
Rest him in heavens , we don't know that power of Chirst is with weak people and not in the stronger ones .

Second death was by Calin's father , i don't know reea is cursed or something? because we have so many deaths in such a short time inside our company.I can't take it anymore.
I can't cry anymore just to be shoked and i can't react anymore.At the funerals i couldn't cry but only now , the shock is to heavy and too soon and sometimes the brains can't react to so many
wrong happenings.
And the big shock of today i'm almost single or more single than less single, and i swear i had a dream about it , Don't ask it's very complicated.
Between xmass and new year i had very strong flu , so strong that a few days i had only dreams , you know the shamanic ones , on the brick of life and death theritory, and death is so cold.
At the Calin's father funerals i had a revelation: with each one we loose we die ourselves piece by piece and in the end nothing is left and we fly high into one thousands suns.
There is no sense in this world if you look with mortal eyes , but maybe there is something interesting where the saints are resting and playing/singing.
ps: I can haz catz , so you know that always there someone to surpress our pain in the back (yes we do have a cat in the house)
Dear god gravitation and worms sux, we need heaven on earth soon



Tuesday, January 19, 2010

#Ubuntu #NaCL #qt compiling errors fcntl.h:99:conflicts with new declaration with ‘C’ linkage

I followed the readme http://qt.gitorious.org/qt-labs/nacl/blobs/nacl-labs/readme-nacl
git clone git://gitorious.org/qt-labs/nacl.git
cd nacl
export PATH=$PATH:/home/mariuz/Downloads/build/native_client/src/third_party/nacl_sdk/linux/sdk/nacl-sdk/bin/
export PATH=$PATH:/home/mariuz/Downloads/build/native_client/scons-out/opt-linux-x86-32/staging/
./configure -nacl /home/mariuz/Downloads/build/
cd src/tools; make
cd ../..
make sub-src

In file included from /home/mariuz/Downloads/build/native_client/src/third_party/nacl_sdk/linux/sdk/nacl-sdk/bin/../lib/gcc/nacl/4.2.2/../../../../nacl/include/fcntl.h:1,
from ../../mkspecs/qws/linux-nacl-g++/qplatformdefs.h:40,
from arch/generic/qatomic_generic_unix.cpp:44:
../../include/QtCore/../../src/corelib/nacl/qnaclunimplemented.h:32: error: previous declaration of ‘int open(const char*, int, ...)’ with ‘C++’ linkage
/home/mariuz/Downloads/build/native_client/src/third_party/nacl_sdk/linux/sdk/nacl-sdk/bin/../lib/gcc/nacl/4.2.2/../../../../nacl/include/sys/fcntl.h:99: error: conflicts with new declaration with ‘C’ linkage

Sunday, January 17, 2010

How to disable ipv6 on #ubuntu #karmic without messing with grub

sudo kate /etc/sysctl.conf
add this line
net.ipv6.conf.all.disable_ipv6=1

reboot or disable without rebooting
sudo su 
echo 1 > /proc/sys/net/ipv6/conf/all/disable_ipv6


you can enable back
echo 0 > /proc/sys/net/ipv6/conf/all/disable_ipv6
Dear kernel devels and ubuntu motu masters , for me there is no ipv6 internet in the world and i don't have any ipv6 routers
But i need fast internet in arora browser and you know that glibc sux and doesn't
work well in resolving hosts fast in an ipv4 world where i live

https://launchpad.net/bugs/417757

Friday, January 15, 2010

Howto kill and solve spawn-fcgi

I have tested spawn-fcgi and php fast cgi under heavy load

and sometimes nginx reports that is dead "Connection refused while connecting to upstream"
ab -c 200 -n 5000 http://localhost:8080/posts/

so i modified the /usr/bin/php-fastcgi startup script

PHP_FCGI_CHILDREN=10
PHP_FCGI_MAX_REQUESTS=1000
/usr/bin/spawn-fcgi  -C 10 -F 10 -a 127.0.0.1 -p 9000 -u www-data -f /usr/bin/php5-cgi

Thursday, January 14, 2010

about #mplayer #vdpau #ubuntu #pulseaudio

I found a way to disable mplayer warning about pulseaudio that is erased from my computer
sudo vi /etc/mplayer/mplayer.conf
search for the line with pulse and remove it
it should look like this

ao=alsa,sdl:aalib

I found that vdpau video output option works
mplayer -vo vdpau http://fd.fabiensanglard.net/dEngine/doomRotated.mov

but i didn't notice any lower cpu usage

maybe i need to install vdpau packages for nvidia from ubuntu repository ?

ps: I have founded that link on reddit related to Doom classic code review

Wednesday, January 13, 2010

easy way to upgrade to #kde 4.4 rc in #kubuntu , #ubuntu #karmic

Kde 4.4 rc1 is released and here is a easy way to upgrade to it
http://www.kubuntu.org/news/kde-sc-4.4-rc-1

Nice things qt 4.6 , that will work better with arora browser (upgraded webkit engine)
and many other improvements

here is how to do it from command prompt
sudo add-apt-repository ppa:kubuntu-ppa/beta
sudo apt-get update
sudo apt-get dist-upgrade

sudo /etc/init.d/kdm restart

Sunday, January 10, 2010

compiling #sdl #quake on #ubuntu

project url is here http://www.libsdl.org/projects/quake

download the code and data
wget http://www.libsdl.org/projects/quake/src/sdlquake-1.0.9.tar.gz
wget http://www.libsdl.org/projects/quake/data/quakesw-1.0.6.tar.gz

install sdl dev files
sudo apt-get install libsdl1.2-dev

tar -x --strip-components=1 -f sdlquake-1.0.9.tar.gz
tar -x -f quakesw-1.0.6.tar.gz

I had an error when i ran make after ./configure

add `AM_PROG_AS' Makefile.am: to `configure.in'

i modified the configure.in this way added AM_PROG_AS
also removed gcc flag -mpentiumpro

touch INSTALL NEWS README AUTHORS ChangeLog
automake --add-missing

autoreconf
and then
./configure
make

you will get an linking error related to d_copy.S
grep d_copy *
search for it and remove all references from Makefile and Makefile.in , Makefile.linuxi386, Makefile.am

then do again ./configure
make
./sdlquake



or full screen

./sdlquake -fullscreen

or without sound

./sdlquake -nosound




for a better engine try something based on ioquake

i like the video of elite force raytraced

Friday, January 08, 2010

google nacl + quake demo

I started the quake demo from nacl: here are 9 ! instances of quake running in the same time in browser

http://www.youtube.com/watch?v=8_zbFuaB2wc



what to watch more about nacl?
Qt's elastic nodes example running on Google Native Client
http://www.youtube.com/watch?v=U6xZsqcA-Sk

Original article is here

I'm waiting for FreePascal compiler for nacl , qt is already there and with lazarus
it would be a great IDE for google NaCL




This version of Google Native Client has expired.

/home/mariuz/.mozilla/plugins/sel_ldr
Warning: Running non-sandboxed sel_ldr
This version of Native Client has expired.


vi src/trusted/service_runtime/expiration.h

EXPIRATION_YEAR 2009 ???


seems that i need to download a correct snapshot , latest snapshot
http://code.google.com/p/nativeclient/wiki/Downloads

http://build.chromium.org/buildbot/snapshots/nacl_tarballs/latest/nacl_linux_latest.tgz



expiration date is now set to 2010 , is better :)

Monday, January 04, 2010

Dear Oracle please Kill the Dolphin (#mysql)

Monty is the new Mysql "saviour" and i got new spam about his issue.
Monty Widenius wants another billion dollars, should we help him?
I say no and neither should you

http://standardsandfreedom.net/index.php/2010/01/05/monty-widenius-wants-another-billion-dollars-should-we-help-him/

here are some interesting responses around the web:

http://nathan.crause.name/entries/science-tech/mysql-being-saved

Monty's call to arms just seems bizarre and under-handed. MySQL was
never really free (unlike Postgres or Firebird or Sqlite). He sold
MySQL to Sun and became very rich. Now he wants to claim that Oracle
is a threat to free software, when MySQL was the least free of the
free databases. There are several equally good or better alternatives
to MySQL. There are several equally good or better commercial
alternatives to MySQL. Microsoft got away with it's 90+% dominance of
desktop computers and office software for the best part of twenty
years, and it wasn't the Competition Commission that reduced
Microsoft's market share.

http://article.gmane.org/gmane.comp.ide.revolution.user/132380/match=firebird+database

I certainly wouldn't consider developing a project now that was
dependent on future versions of MySQL being available with the current
(pseudo-)free licensing. Even if you are happy distributing the
current version of MySQL with your app (and on the server), and paying
the licenses costs, there is no saying what those costs might be in
the future. That is what was so underhand about the way in which
MySQL was marketed as free-in-some-circumstances.



another response from
From: Jon 'maddog' Hal

Yes, Oracle is a dominant database company, but there are other
databases out there that are FOSS which people could use:

o PostgreSQL
o Firebird

I just think that forcing Oracle to "sell off" something that Sun was
willing to pay 1 Billion dollars for just a year earlier on the premise
that Oracle would not manage it well is probably something that will not
fly.

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 http://ftp.us.debian.org/debian/ unstable main
deb-src http://ftp.us.debian.org/debian/ unstable main
Add:
deb http://ftp.us.debian.org/debian/ experimental main
deb-src http://ftp.us.debian.org/debian/ experimental main

Then:
# 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
http://horror.about.com/od/toppicksandthemelists/tp/Scary-Christmas.htm

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
http://www.kubuntu.org/news/kde-sc-4.4-beta-2


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

CTRL-ALT-F1

sudo /etc/init.d/kdm stop

sudo apt-get purge libqtcore4
then i did the steps from above
with
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.




http://www.groklaw.net/article.php?story=20091208104422384
http://www.groklaw.net/article.php?story=20091021164738392




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
wget http://27.org/isocountrylist/iso_country_list.sql

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

http://paste.ubuntu.com/343619/

populate the table with load script from flamerobin
http://paste.ubuntu.com/343617/

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

SELECT a.ISO
FROM COUNTRY a

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

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

and do the copy paste in skype :P





Create a procedure that concatenates thouse values

and do a select

SELECT p.SKYPE_COUNTRIES
FROM RETURN_COUNTRIES10 p

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
http://www.firebirdnews.org/?p=3907

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
http://blogs.computerworld.com/15246/opposition_mounts_to_oracles_mysql_acquisition

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://gitorious.org/+wxwebkit-developers/webkit/wxwebkit.gitcd wxwebkit/WebKitTools/Scripts
./build-webkit --wx --makeargs="-j2"
cd wxwebkit/WebKitBuild/Debug.master
chmod +x libwxwebkit.so
sudo cp libwxwebkit.so /usr/lib/
./wxBrowser

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 http://ppa.launchpad.net/compiz/ppa/ubuntu karmic main
deb-src http://ppa.launchpad.net/compiz/ppa/ubuntu karmic main


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

sudo apt-key adv --keyserver keyserver.ubuntu.com --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
ps:
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
http://pypi.python.org/pypi/html2docbook/

from python console
from html2docbook import Html2DocBook
h2d = Html2DocBook()
f = open('./fb2min.html', 'r')
x=f.read()
h2d.transform(x)
'<section/>

that is the only tag that is spitted out!
if i do print(x) i get all the content for html
even
_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://firebird.cvs.sourceforge.net/cvsroot/firebird/firebird2 .
rsync -av rsync://firebird.cvs.sourceforge.net/cvsroot/firebird/CVSROOT .

cd ..
svn co --username=guest http://cvs2svn.tigris.org/svn/cvs2svn/trunk
cvs2svn-trunk

# 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

qgit




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
grub/menu.lst


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
quiet


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
http://distrowatch.com/weekly.php?issue=20091123#feature

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
http://smolt.fedoraproject.org/

I didn't knew what portreserve is so i disabled it
http://fedoraproject.org/wiki/Features/Portreserve

sudo chkconfig portreserve off


live cd install leftovers http://forums.fedoraforum.org/showthread.php?t=207366

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 http://akdwivedi.wordpress.com/2009/05/09/skype-on-64bit-fedora-10/

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

http://forums.fedoraforum.org/showthread.php?t=227165

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
)

http://www.skype.com/go/getskype-linux-beta-fc10

sudo rpm -Uvh skype-2.1.0.47-fc10.i586.rpm

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 gmail.com 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


wget http://github.com/AdamN/python-webkit2png/raw/master/webkit2png.py


python webkit2png.py -x -o cnn.png --debug http://www.cnn.com

chmod +x webkit2png.py

from php

passthru("/home/mariuz/webkit2png.py -x -o /tmp/google.png --debug --scale 100 100 http://www.google.com")

i want to load a page with flash content , shameless plug reea.net

webkit2png.py –scale 200 200 -x -o reea.png –debug http://reea.net

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

http://labs.trolltech.com/blogs/2008/11/03/thumbnail-preview-of-web-page/

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

and added

view->page()->settings()->setAttribute(QWebSettings::PluginsEnabled,true);

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 http://spins.fedoraproject.org/kde/ 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)
http://labs.adobe.com/downloads/flashplayer10_64bit.html

wget http://download.macromedia.com/pub/labs/flashplayer10/libflashplayer-10.0.32.18.linux-x86_64.so.tar.gz
tar -zxvf libflashplayer-10.0.32.18.linux-x86_64.so.tar.gz
mv libflashplayer.so /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 all -- 0.0.0.0/0 0.0.0.0/0 state RELATED,ESTABLISHED
ACCEPT icmp -- 0.0.0.0/0 0.0.0.0/0
ACCEPT all -- 0.0.0.0/0 0.0.0.0/0
ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 state NEW tcp dpt:22
REJECT all -- 0.0.0.0/0 0.0.0.0/0 reject-with icmp-host-prohibited

Chain FORWARD (policy ACCEPT)
target prot opt source destination
REJECT all -- 0.0.0.0/0 0.0.0.0/0 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

su

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
http://rpmfusion.org/RPM%20Fusion


ToDo: test and install nvidia driver
http://www.reddit.com/r/linux/comments/a68wl/how_to_fight_nouveau_the_wonderful_new_nvidia/
http://www.mjmwired.net/resources/mjm-fedora-nvidia.html#f12

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] http://www.gentoo-portage.com/dev-db/firebird
  • 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
/etc/cups/mime.types
and
/etc/cups/mime.convs

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

wget http://ftp.us.debian.org/debian/pool/main/g/gtk+1.2/libgtk1.2_1.2.10-18.1_i386.deb
wget http://ftp.us.debian.org/debian/pool/main/g/glib1.2/libglib1.2_1.2.10-17_i386.deb
wget http://ftp.us.debian.org/debian/pool/main/g/gtk+1.2/libgtk1.2-common_1.2.10-18.1_all.deb
wget http://ftp.us.debian.org/debian/pool/main/g/glib1.2/libglib1.2ldbl_1.2.10-19_i386.deb
wget http://ftp.us.debian.org/debian/pool/main/g/gcc-2.95/libstdc++2.10-glibc2.2_2.95.4-27_i386.deb
sudo dpkg -i *.deb



get the foxkeh
wget http://ftp.mozilla.org/pub/phoenix/releases/0.1/phoenix-0.1-i686-pc-linux-gnu.tar.gz
tar -zxvf phoenix-0.1-i686-pc-linux-gnu.tar.gz
cd phoenix
./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

https://edge.launchpad.net/~mapopa/+archive/qt4.6


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)

print_r(debug_backtrace());


Thursday, October 29, 2009

I have joined to #Alioth #Firebird #Debian project

Seems that i need alioth account http://wiki.debian.org/Alioth 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

VCS="bzr"

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 https://edge.launchpad.net/~mapopa/+archive/qt4.6

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)
with

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


wget http://sysoev.ru/nginx/nginx-0.7.62.tar.gz
tar -zxvf nginx-0.7.62.tar.gz
hg clone http://hg.mperillo.ath.cx/nginx/mod_wsgi/


wget http://lophus.org/~fred/mod_wsgi_patch.diff
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
make
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)
http://wiki.php.net/internals/windows/stepbystepbuild
I  will not copy paste all  the steps here , a short document makes them easy to follow


1.Install Cisual Studio  C++ 20xx
http://www.microsoft.com/express/Downloads/#2008-Visual-CPP
2. get and install windows sdk 6.1
3. get a php 5.x 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 http://sourceforge.net/projects/firebird/files/firebird-win32/2.5.2-Release/Firebird-2.5.2.26540-0_Win32_pdb.zip/download


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 
nmake 
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



Update:
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.x 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 http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-gpl-5.1.19-src.tar.gz/from/http://mysql.mirrors.pair.com/ -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




 ./autogen.sh
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 http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-oss-5.2.3.tar.gz/from/http://ftp.astral.ro/mirrors/mysql.com/  


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  
./autogen.sh 
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 reea.net @127.0.0.1

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
nameserver 127.0.0.1

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://git.debian.org/~fjp/debtree.git
Here is the graph for installed files for firebird2.1-classic

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



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



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
openoffice.org-hyphenatio ( dei) English (GB) hyphenation pattern for OpenOffic
openoffice.org-hyphenatio ( 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

http://paste.ubuntu.com/266785/

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
http://alioth.debian.org/~fjp/debtree/

All you need is to install the debtree package , seems that is not included by default in ubuntu So click here
http://alioth.debian.org/~fjp/debtree/debtree_0.7.3_all.deb

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


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

http://dev.mysql.com/downloads/mysql/5.1.html#source

$ sudo apt-get build-dep mysql-server

Download the last source code archives for the mysql :
$ wget http://dev.mysql.com/get/Downloads/MySQL-5.4/mysql-5.4.1-beta.tar.gz/from/http://ftp.astral.ro/mirrors/mysql.com/


$ 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
datadir=/var/lib/mysql5.4.x
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.

mysql>


Set password for root user

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


Remove the anonymous accounts

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