takizo, not takezo

Bookmarks –> Manage Profiles –>  Terminal Profiles –> Default

check “Disable session-initiated window resizing”.

the below command in vi editor will remove the whole line that contains the word “search-keywords” on the entire file.

:g/search-keywords/d

postgresql! one of my favorite high performance open source db, of course i have it running on my mac. compiling postgresql with macports isn’t that hard, follow the step below will guide you through the installation;

first of all, make sure your macports is updated by running the command;

sudo port -v selfupdate
sudo port -v sync # some user prefer to run port sync, port selfupdate does the same thing.

installing postgresql, start it and create super user

sudo port -v install portgresql82-server # compile and install postgresql database from macports.

by default, macports will create postgresql database directory and initialize the db.

[ 149]$ ls -al /opt/local/var/db/postgresql82/
total 0
drwxr-xr-x 3 root admin 102B Nov 13 21:27 .
drwxr-xr-x 3 root admin 102B Nov 13 21:27 ..
drwx—— 16 postgres postgres 544B Mar 10 16:35 defaultdb

if the db directory is not created, follow the step below;

sudo mkdir -p /opt/local/var/db/postgresql82/defaultdb # make database directory
sudo chown postgres:postgres /opt/local/var/db/postgresql82/defaultdb # assign postgre user and group
sudo su postgres -c ‘/opt/local/lib/postgresql82/bin/initdb -D /opt/local/var/db/postgresql82/defaultdb’ # initialize default database

the default installation doesn’t include postgresql binary file into /opt/local/bin, add postgresql executable files into your shell environment

takizo@redarrows(~)
PATH=${PATH}:/opt/local/lib/postgresql82/bin

now, we will launch postgresql database and create super user and database

takizo@redarrows(~)

sudo /opt/local/etc/LaunchDaemons/org.macports.postgresql82-server/postgresql82-server.wrapper start
server starting # start postgresql database

sudo su – # switch to root user

sudo posrgres – # switch to postgres user

/opt/local/lib/postgresql82/bin/createuser -s -d -r -P

exit # quit as postgres user

exit # quit as root user

createdb -O takizo takizo # create database with takizo as privilege user

You are done, now you can logon to postgresql database with your username (mine is takizo)

psql82 -U takizo takizo

Since you have created super user, next time you can create new user with createuser command,

createuser -S -D -R -P -U takizo edward # create user edward with privilege account takizo
Enter password for new role: # password is hidden :p
Enter it again: # confirmed password is hidden too
CREATE ROLE # new user has been created

Happy playing with postgresql database!

I was trying to upgrade apache2 on my Macports but keep on getting these error messages which really annoy me;

Undefined symbols:
“_ap_ugly_hack”, referenced from:
_ap_ugly_hack$non_lazy_ptr in libmain.a(main.o)
“_ap_prelinked_module_symbols”, referenced from:
_ap_prelinked_module_symbols$non_lazy_ptr in libmain.a(core.o)
“_ap_prelinked_modules”, referenced from:
_ap_prelinked_modules$non_lazy_ptr in libmain.a(main.o)
_ap_prelinked_modules$non_lazy_ptr in libmain.a(config.o)
“_ap_http_input_filter_handle”, referenced from:
_ap_http_input_filter_handle$non_lazy_ptr in libmain.a(protocol.o)
“_ap_preloaded_modules”, referenced from:
_ap_preloaded_modules$non_lazy_ptr in libmain.a(config.o)

There are bug reports on MacPorts trac but it seem non of it giving the solution to solve the problem, so I have to do some workaround to make the upgrade works.

Try your luck to uninstall ncurses and ncursesw, re-install again, and also uninstall gawk from your macports. After that all have been done, do these

sudo port -v clean apache2 # clean apache2 port
sudo port -v install apache2 +darwin_9 # compile with darwin_9 variants

Post the comment and see what’s your outcome.

update 10th March:

malaysiakini.com domain name was suspended by sitelutions, the domain registrar. The reason they given was due to excessive query on their DNS servers, and it’s unacceptable! malaysiakini has moved their domain registrar to network solutions after the incident happened during election peak time.

–

due to technical glitches, malaysiakini.com domain name is currently down, the sister website undi.info is also not able to access anytime soon, the technical team is currently working on it to bring the domain name back as soon as possible.

for time being, to access malaysiakini.com website for latest update, click here;

malaysiakini.takizo.com
malaysiakini1.takizo.com
malaysiakini3.takizo.com

Please spread it around for latest election news.

p/s: some reader email and ask malaysiakini.com down, is it something to do with BN? NO, it’s nothing to do with BN, it’s due to some DNS issue with the registrar and it will resolve asap