Celoteh Harian + *nix

On 22nd Oct there's a news about the gunshots at Canadian Parliament and the suspected person is a drug addicted which converted to Islam before the incident occur. My point of view, this issue can lead towards people seeing Islam as a bad religion which encourage the follower to commit suicide and kill people. I would like to stress out that Islam not allowed to kill people without any proof and Islam now allowed to kill public citizens.

I commonly not used to manage any sqlite database but in situation that you've to do.. than you've to do that! Ok there's a new server that comes up for the development and I've missing the table of my sqlite database for the application. So how we gonna create the database ? It's quite simple. I've a server that already configured the database previously. #sqlite3 database.db "select * from sqlite_master"; then it will show the database structure which you can want to create. table|bandwidth|bandwidth|2|CREATE TABLE bandwidth (id INTEGER PRIMARY KEY,name text,created text,start real,end real) Noted for myself.

Hey If you don't know that OpenBSD 5.3 new release is coming soon.. well this is the time to order your new OpenBSD cd set! :) Lot of new features http://openbsd.org/53.html#new And OpenSMTPD is matured enough to be included in 5.3 is a good sign :) Good job for the developer and contributor! You can contribute by buying a cd set here http://openbsd.org/orders.html or you can donate directly to them http://openbsd.org/donations.html  

As always we will installing PHP from the package system using pkg_add magic. Currently the latest PHP version for OpenBSD 5.2 is 5.3.14 which I think is ok for any web application out there. Let r0ck! /* Installing PHP #pkg_add -i php Ambiguous: choose package for php  a       0:          1: php-5.2.17p12          2: php-5.3.14p1 Your choice: 2 Everything will be install except extension that you might want to install later. The PHP binary will be install in /usr/local/bin/php-5.3 If you don't like to use php-5.3 you can simply create a symbolic link with any name that you want like just a php only without 5.3 thingy. /* Installing additional PHP extension. You can browse the pre compiled package at (Mirror example) ftp://ftp.jaist.ac.jp/pub/OpenBSD/5.2/packages/i386/ Let's say we want to install GD library #pkg_add php-gd-5.3.14p0 Create a symbolic link ln -sf /etc/php-5.3.sample/gd...

This is how you can stay sync your server time with the world time from ntp.org Installing from ports: #cd /usr/ports/net/ntp #make install Once install, look for ntp readme # more /usr/local/share/doc/pkg-readmes/ntp-4.2.6pl5p0 $OpenBSD: README,v 1.5 2012/04/22 11:41:55 ajacoutot Exp $ +----------------------------------------------------------------------- | Running ntp-4.2.6pl5p0 on OpenBSD +----------------------------------------------------------------------- Several steps need to be taken to properly configure the NTP daemon. 1. First, create or update the file /etc/ntp.conf.  Several    example configuration files can be found here:      /usr/local/share/examples/ntp 2. Now xntpd can be started with:      /etc/rc.d/xntpd start    Or to start 'xntpd' at every boot, add it to pkg_scripts in    /etc/rc.conf.local. #vi /etc/rc.conf.local Add as following : pk...

Sometimes we may use some of the ports tree for our usage instead of using the pkg_add method. Default installation, the ports tree is not included and you have to fetch it manually. This is the how-to : for more reliable you can install wget instead of ftp pkg_add -i wget #cd /tmp #wget -c ftp://ftp.openbsd.org/pub/OpenBSD/5.2/ports.tar.gz once done #cd /usr #tar xzvf /tmp/ports.tar.gz Done!

This is how the disk layout that I would plan for my setup (It's a Virtualbox) / - root : 500m. This will be 'a'. swap : 1G (so we'll always have enough space for a core dump), this will be partition 'b' /usr : 3g, partition d /tmp : 500m (we don't anticipate much use of this), partition e /usr/local : 5g, partition f /usr/X11R6 : 5g, partition g /home : 5g, partition h /var : 5g (that's a lot of system log files), partition j /var/www : rest of disk, partition k You can follow more specific instruction from here : http://www.openbsd.org.my/faq/faq4.html#Moredisklabel