Celoteh Harian + *nix

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.ini /etc/php-5.3/gd.ini View the install extension #php-