Meta k4mL

Friday, July 9, 2010

GPLHost VPS

Everytime I'm thinking of looking for good hosting provider in Malaysia or Singapore, I would just backed up and said it would be a waste of time. Hosting provider in Malaysia or Singapore still can survive to this millennium of 2010 just because of 2 main reasons:-

Law of physics (read: latency)
Customer ignorance.

You don't need to go further when looking for good hosting provider. Their website frontpage would tell it all and to our luck, they all look similar with each other. I'm wondering if there's 'industry standard' for web hosting's website in .my and .sg. Good hosting provider definitely would look different. Rule #1 - If you see something like pretty lady with a headphone ready to take your call, stop. Go away. (I took this somewhere else but forgot already where it is).

But looking at gplhost website, I eventually noticed something different with the content (though their sites look not much different). Firstly, they're using their own control panel which they release as an open source. This is a good sign. Rule #2 - If you see something like Cpanel/Fantastico/DirectAdmin/Plesk etc, also stop. This is just a bunch of guys who know how to run few linux commands and suddenly they have a hosting company ready to take victim, sorry customer.

I don't have to look further. Luckily hostingfu (my trusted sources for web hosting related stuff) have been with them for sometime and has few stories to share.

Tuesday, May 18, 2010

Mysql password file

The equivalent of PostgreSQL's .pgpass file for MySQL is .my.cnf. Not as flexible as .pgpass since you can't set password based on username/host/db wildcard.

[client]

password="yourpassword"

Link to docs.

Monday, January 11, 2010

Drupal themes to look for

http://drupal.org/project/dropshadow

http://drupal.org/project/changeme

http://drupal.org/project/mpFREE

http://drupal.org/project/toasted

http://drupal.org/project/tivity

http://drupal.org/project/zenland *

http://drupal.org/project/purple_box

http://drupal.org/project/nerdalistic

http://drupal.org/project/skyroots

to be continued - http://drupal.org/project/Themes?page=28

Friday, December 11, 2009

Postgresql cluster on Ubuntu

When having two versions of PostgreSQL on the same machine, need to use --cluster option for all psql command - psql, createuser, createdb, dropdb etc. The format is:-

psql --cluster version/cluster

$ pg_lsclusters

Version Cluster Port Status Owner Data directory Log file

8.3 main 5432 online postgres /var/lib/postgresql/8.3/main /var/log/postgresql/postgresql-8.3-main.log

8.4 main 5433 online postgres /var/lib/postgresql/8.4/main /var/log/postgresql/postgresql-8.4-main.log

$ psql --cluster 8.4/main mydb

dnsmasq for local virtual network

Setting up local virtual network with VirtualBox. The setup:-

Main Host

eth0/bridged mode listen on 192.168.1.200. Connected to the real local LAN.
eth1 listen on 10.0.0.1 - dnsmasq dhcp listen here.

Sub internal host

app2 - eth0/internal network 10.0.0.2
db - eth0/internal network 10.0.0.3

/etc/dnsmasq.conf setup so that the dhcp assigned the IP address from /etc/hosts for any matching hostname.

dhcp-host=app2,db

But the client still getting the lease in dhcp-range rather than the one set in /etc/hosts. Turn out we need to set "send host-name app2;" in /etc/dhcp3/dhclient.conf because dhclient does not send the hostname by default when acquiring the lease.

Thursday, December 10, 2009

Makefile notes

On changing directory in Makefile:-

Each command in a makefile is executed in its own shell. To execute three subcommands in the same shell, write them all as a single command. For instance, if your shell uses ';' as a subcommand separator, you might write

http://www.mail-archive.com/help-make@gnu.org/msg07671.html