Pentaho Kettle database cache

Sometimes when you changed a table design, in kettle you clicked "get fields", and it still loading the old design, then it's time to clean the DB cache.

The answer to “Why Do 'Cool Kids' Choose Ruby or PHP to Build Websites Instead of Java?”

This morning I'd read an article with the title: “Why Do 'Cool Kids' Choose Ruby or PHP to Build Websites Instead of Java?”, and I think I may have some opinions on this kind of topic.

Please discuss the following questions with the website owner or business owner first

  1. What is your budget and dead line for this website project?
  2. How many developers/designers involved ?

If there's system architect, ask the following questions

Replacing text in multiple files

I need to replace an IP address for a sever switch, here's the command for it: find . -name "*.php" -print | xargs sed -i 's/192.168.0.10/192.168.0.11/'

Install function list plugin for notepad++ 5.4

I'd been using notepad++ since 3.x, function list is one of my favorite feature. However when I upgrade to recent version, the function list plugin v2.0 requires extra step to install on Vista.

  1. download FunctionList_2_0_UNI_dll.zip
  2. copy FunctionList.dll to c:\program files\Notepad++\plugins
  3. copy C++.flb and FunctionListRules.xml to C:\Users\username\AppData\Roaming\Notepad++\plugins\config Note: change the "username" to your login user name

SQL Server 2005 using more than 2GB memory

You can configure SQL Server to use more than 2GB by enabling the "Use AWE to allocate memory" option

sqlserver_memory

Upgrade Zabbix Agentd on Windows

I'm going to upgrade zabbix agentd from 1.1.4 to 1.4.4 on all my Windows servers.

Configure OpenVPN on Debian Lenny

This is the original artiche

In my configuration, my server's network is 10.1.1.0 and my VPN is 10.1.10.0, in order to access the server side networks, you need to enable the forwarding and masquerading, here's the steps:

$echo 1 > /proc/sys/net/ipv4/ip_forward

$iptables -t nat -A POSTROUTING -s 10.1.10.0/24 -o eth0 -j MASQUERADE
*Assuming your nic is eth0 and your vpn network is 10.1.10.0

Change OpenERP Web Client upper left Logo

1. use find command to get the openerp_big.png location

# find / | grep openerp_big.png /usr/lib/python2.5/site-packages/openerp_web-5.0.3_1-py2.5.egg/openerp/static/images/openerp_big.png /opt/openerp-web-5.0.3/openerp/static/images/openerp_big.png

2. in the images dir, put your logo as company_logo.png 3. reload the web page and your logo is changed

OpenERP Web Client: howto change files after installation

After installed OpenERP Web Client, it copies the files onto /usr/lib/python2.5/site-packages/openerp_web-5.0.3_1-py2.5.egg/openerp So if you need to change some images, it's in the static/images directory.