Firebird News

Thursday, November 27, 2008

Ubuntu 8.10 Release Party and Presentations in Targu-Mures

The event was held at "teatru74" theater on 8 November 17:00

Here is the text in Hungarian language
http://hup.hu/node/62829
Here is the text in Romanian language , it was published on
http://cultura.inmures.ro/
http://cultura.inmures.ro/typo3temp/pics/bdb75f2db6.jpg
http://ubuntu.ro/stiri/2008.10.31/ReleaseParty-TgMures

other blogs related
http://www.mylro.org/content/view/1392/1/
http://www.softwareliber.ro/2008/11/04/prezentare-ubuntu-la-targu-mures/

Here is the gallery for the event
http://gallery.razius.org/main.php?g2_itemId=13
http://picasaweb.google.com/mapopa/UbuntuIntrepid810ReleasePartyTarguMures#

Adi Roiban talked about launchpad and the romanian team role,also what should be done in the future (translation, bug fixing),
Jani Monoses talked about http://kiwilinux.org and how it was created, OpenOffice3 will be included in December release.
Marius Popa talked about the new features in ubuntu with live demo about them 3g network connection to local providers,new compiz sphere effect, openoffice3.0 from ppa,new gnome empathy,nautilus tabs,new 2.7.27 kernel with improoved wireless connection with real example everex cloudbook support .
Demoed the bigbuckbunny moviemade with ubuntu also theYo Frankie! game , also a new game made by szaby.
New local lug created after that with many more regular meetings where we discuss about our favorite distro.
An local tv station was there at the event (Realitatea TV) and we did an interview for local station Radio Mures.
Next time we wil invite all the people from the bar (some people were affraid the get upstairs in the conference theatre room)

Here is my presentation



a here is the intro but users were to advanced :)

nginx passes 3Million hosts mark on the November 2008 Web Server Survay

compare it with July one

slow byt steady the graphs for apache and iis will not look good

the small webservers will kill the phat ones




Check the other category
http://news.netcraft.com/archives/2008/11/19/november_2008_web_server_survey.html

Wednesday, November 26, 2008

kexec-tools added a few interesting in grub lines
(the ones with crashkernel)
http://fedoraproject.org/wiki/FC6KdumpKexecHowTo
so now i removed that with
$sudo apt-get remove kexec-tools
i did an
$sudo update-grub

Thursday, November 20, 2008

VIA is actively collaborating with the OpenChrome development team on their Open Source graphics driver - initially assisting with multi-head support and RandR function." The OpenChrome driver does even support 3D

OpenChrome Gets A TODO List, Clarifies Work
I like the new gmail terminal :)





at the beginning i thought it was an bug in the arora browser rendering
but no the default theme is now enabled

Tuesday, November 18, 2008

cache-control / deflate optimizations in apache

these lines can be used in .htaccess too

now we get better results with firebug/yslow (B performance grade is now , before was an F grade )

before we had 700k of html code transfered over the wire
now is ~40K for example


#Enable Cache control http://httpd.apache.org/docs/2.2/mod/mod_expires.html
ExpiresActive On
ExpiresByType image/jpeg "access plus 1 month"
ExpiresByType image/gif "access plus 1 month"
#ExpiresByType text/html "access plus 2 days"
ExpiresByType text/css "access plus 1 year"
ExpiresByType application/x-javascript "access plus 1 year"
# compress all text & html http://httpd.apache.org/docs/2.2/mod/mod_deflate.html
AddOutputFilterByType DEFLATE text/html text/plain text/xml application/x-javascript text/css
# Insert filter
SetOutputFilter DEFLATE

# Don't compress images
SetEnvIfNoCase Request_URI \
\.(?:gif|jpe?g|png)$ no-gzip dont-vary 


ps: a good idea is to disable the parameters after css !
for example we had style.css?=200
so it reloaded all background images everytime even if we specified expire time in apache

Installing phpbb3 on firebird and ubuntu server

Installing phpbb3 on firebird and ubuntu server


1.create a database with flamerobin
/var/lib/firebird/2.5/data/phpbb3.fdb
or with isql-fb

SQL> create database "/var/lib/firebird/2.5/data/phpbb3.fdb" pagesize 8192 user 'SYSDBA' password 'SYSDBAPASSWORD';
SQL> quit
CON>; 



you need to choose the page size 8192

2.then download phpbb3

wget http://www.phpbb.com/files/release/phpBB-3.0.11.tar.bz2

3.unzip-ip in your www dir /var/www

tar -jxf phpBB-3.0.11.tar.bz2

chown -R www-data.www-data phpBB3

4.run the installer from http://localhost/phpBB3
pointing to the new created database

Database name :/var/lib/firebird/2.5/data/phpbb3.fdb
Database user :somedba
Database password :*********






6.After all is configured you must delete de install folder inside phpbb3 directory

rm -rf install

Friday, November 14, 2008

my to do maintain /etc on all servers with git/hg



Maintain /etc with mercurial on Debian
Here is another one with git this time

here is article copy pasted (site seems to be down)

Anyway, here is how you can track your /etc directory with git, and have apt update it
automatically each time a package is installed.




The following steps require root access:




  • install git



    apt-get install git-core

  • initialize /etc to be a git repo



    cd /etc
    git init-db
    chmod og-rwx .git

  • ignore a few files



    cat > .gitignore
    *~
    *.dpkg-new
    *.dpkg-old

  • commit the current state



    git add .
    git commit -a -m"initial import"

  • install a snapshot script for apt to call



    cat > apt/git-snapshot-script
    #!/bin/bash
    set -e
    caller=$(ps axww | grep "^ *$$" -B3 | grep " apt-get " | head -n1 | sed 's/^.*\(apt-get .*\)/\1/' )
    git-add .
    git-commit -a -m"snapshot after: $caller"


    ... make it executable ...



    chmod +x apt/git-snapshot-script

  • configure apt to track changes



    cat >> /etc/apt/apt.conf
    DPkg {
    Post-Invoke {"cd /etc ; ./apt/git-snapshot-script";};
    }

  • track these two files



    git add .
    git commit -a -m"apt will track /etc automagically using git"



... and you're done.



Note that the chmod og-rwx /etc/.git step is very important. Your /etc/.git directory should
only be accessible to root. If not, it's as good as giving everyone access to your /etc/shadow
and other secrets that hide in /etc. Should you clone this repository to another box, you
have to make sure that the same precautions are taken.



Now when you install a package, it will be tracked in the git repository.



    # apt-get install mercurial
...
Created commit daa7de7264b65cd073a1ef0f75ba50aa488d5af2
3 files changed, 409 insertions(+), 0 deletions(-)
create mode 100644 bash_completion.d/mercurial
create mode 100644 mercurial/hgrc
create mode 100644 mercurial/hgrc.d/hgext.rc


You can see what changed...



    # git whatchanged -1
commit daa7de7264b65cd073a1ef0f75ba50aa488d5af2
Author: Bart Trojanowski <bart@jukie.net>
Date: Mon Mar 12 16:09:18 2007 -0400

snapshot after: apt-get install mercurial

:000000 100644 0000000... a7f4740... A bash_completion.d/mercurial
:000000 100644 0000000... dfc3400... A mercurial/hgrc
:000000 100644 0000000... 8f2d526... A mercurial/hgrc.d/hgext.rc





And lastly, it should be noted that debian now has an etckeeper that trackes /etc in git.





ps: i started with /etc/httpd and works well with git

Thursday, November 13, 2008

Installing jaws php cms on ubuntu and firebird backend

Installing jaws-cms on ubuntu and firebird backend

$ cd /var/www
$ wget http://bits.jaws-project.com/releases/jaws-0.8.6/jaws-complete-0.8.6.tar.gz
$ tar -zxvf jaws-complete-0.8.6.tar.gz
$ mv html jaws

sudo chmod -R g+rw jaws
sudo chown -R www-data.www-data jaws

create an new database with flamerobin /var/lib/firebird/2.1/data/jaws.fdb

crate a symlink , seems that if you put only jaws.fdb in the database field
then it needs to be located in jaws/data

$ cd /var/www/jaws/data
$ ln -s /var/lib/firebird/2.1/data/jaws.fdb

start the installer http://localhost/jaws/install/
fill in the username for database and password
at database put jaws.fdb

Some screen shots o took during install and configuration

Wednesday, November 12, 2008

What if the neo must learn Ubuntu ?

Watch the Jackie Chan style scene at the end of the movie ...

http://www.collegehumor.com/video:1886349

Thursday, November 06, 2008

PHP ships with Mac OS X by default 

I spoted this over this page 
http://www.phoronix-test-suite.com/?k=downloads

it's about php-cli
so php programmers could do scripts easier
than writing them in bash/perl/php or python

Here are some examples of scripts that i have created to automate
installation on new ubuntu server nodes

http://github.com/mariuz/firebird_scripts/tree/master

I wish php was there by default because almost all the scripts needs
to install php-cli first

I posted an new idea to the brainstorm area

http://brainstorm.ubuntu.com/idea/15590/

 

Wednesday, November 05, 2008

Chris Rock won the elections from USA

I voted for him from Romania

http://uk.youtube.com/watch?v=-tyK9Pgtznk

http://uk.youtube.com/watch?v=3erEqfFxTlE

and the only song that cames to my mind dedicated to his oponents is

Nigger from Clawfinger
http://uk.youtube.com/watch?v=D6zyOGqxxs4

Saturday, November 01, 2008

Enabling frequency scaling on my everex cloudbook
after the upgrade to ubuntu intrepid ibex (kernel 2.6.27.x) i have good sound and the syste is moving faster
maybe is because of the new io sheduler 
but the frequency scaling is not enabled (default cpu speed is 600mhz)
so i have compile it 
download the latest stable kernel from kernel.org

in my case  
$wget http://kernel.org/pub/linux/kernel/v2.6/linux-2.6.27.4.tar.bz2
$tar -jxvf linux-2.6.27.4.tar.bz2
$cd /usr/src/linux-2.6.27.3/arch/x86/kernel/cpu/
$sudo mv cpufreq /opt/build/
$ cd /opt/build/cpufreq

$vi Makefile
default:
$(MAKE) -C /lib/modules/`uname -r`/build M=`pwd` modules
clean:
rm -rf *.o .*.cmd *.ko *.mod.c .tmp_versions Module.symvers
obj-m += e_powersaver.o

Now you need to make it 
$make
$cp e_powersaver.ko /lib/modules/2.6.27-7-generic/kernel/drivers/cpufreq/
$ sudo depmod -ae
$ sudo modprobe e_powersaver
$ cpufreq-set -g performance

now my cpu is idling at 1200 mhz 
cat /proc/cpuinfo
processor : 0
vendor_id : CentaurHauls
cpu family : 6
model : 13
model name : VIA C7-M Processor 1200MHz
stepping : 0
cpu MHz : 1199.952
cache size : 128 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge cmov pat clflush acpi mmx fxsr sse sse2 tm nx up pni est tm2 xtpr rng rng_en ace ace_en ace2 ace2_en phe phe_en pmm pmm_en
bogomips : 2399.92
clflush size : 64
power management:

a good idea is to put the module at startup too 
in 
/etc/modules
add 
e_powersaver

another good command line 
cpufreq-info

analyzing CPU 0:
  driver: e_powersaver
  CPUs which need to switch frequency at the same time: 0
  hardware limits: 400 MHz - 1.20 GHz
  available frequency steps: 400 MHz, 500 MHz, 600 MHz, 700 MHz, 800 MHz, 900 MHz, 1000 MHz, 1.10 GHz, 1.20 GHz
  available cpufreq governors: ondemand, userspace, conservative, powersave, performance
  current policy: frequency should be within 400 MHz and 1.20 GHz.
                  The governor "performance" may decide which speed to use
                  within this range.
  current CPU frequency is 1.20 GHz.

or if you need an low noise system 
$ cpufreq-set -g ondemand
This post is about an interview with Ales Katona (also known as Almindor) - A contributor to FPC, Lazarus and have few of his own open source projects as well such as Lentilwars and lnet. I have asked Ales to have an interview with me regarding the open source projects and some information about himself, and I hope you all find it interesting as I have.