GIN Index on Postgres

Install postgresql-contrib package 
apt-get install postgresql-contrib-9.x
(replace x with current version in used)


Create extension pg_trgm
log in postgres with superuser role,
CREATE EXTENSION IF NOT EXISTS pg_trgm;


Create GIN index
CREATE INDEX tbdatatest_idx_date  on tbdatatest  USING GIN ( playerid gin_trgm_ops);

JCache with Payara

Create execute file java wrrapper

#!/bin/sh

cd $(dirname $0)
java  -cp jar1_path:jar2_path MainClassOfJar $@

Caused by: net.sf.ehcache.CacheException: Can't assign requested address

If you using Mac, Payara or Glassfish, when you use EHCache, maybe this error occurs:

Caused by: net.sf.ehcache.CacheException: Can't assign requested address

Solution:
add

-Djava.net.preferIPv4Stack=true

to JVM Options

That's all!

Good luck!

Install Tor proxy on Mac

1. Install latest Command Line Tools from Apple Store at https://developer.apple.com/downloads

2. Install libevent from http://libevent.org

• Download libevent compressed file
• Extract and point to folder
• compile using command: ./configure && make
• install using command: sudo make install

3. Install Tor

• download Tor source from  https://www.torproject.org/download/download (choose Source Code section)
• extract and point to folder
• compile using command: ./configure && make
• run using command: src/or/tor

You can config all network using Tor proxy by config SOCK proxy on Network section for current internet interface.

Connect internet when VPN

Open Network Connections Manager, choose your VPN connection, click on Routes... button

If your VPN network in 10.x.x.x you can setup like this

Disconnect VPN and reconnect, you can access internet with it.

Default iptables rules when install ireadmail

When I install iredmail, the default iptables rule file has created in /etc/default/iptables

Please careful when edit it because it can block access to your system.