how to install navicat 10.10 on ubunut 10.04

1.download nuvicat 10.10 package for linux distribution
http://www.navicat.com/en/download/download.html

2.untar the file into your folder
#tar zxvf navicat100_permium_en.tar.gz

3.install wine runtime environment
#apt-get install wine

4.run nuvicat and register it
#cd nuvicat100
#./start_nuvicat

install openvpn integrated with mysql authentication

1.install openvpn server
#apt-get install openvpn sasl2-bin libpam-mysql libssl-dev openssl

2.install mysql server
#apt-get install mysql-server mysql-client

3.create database vpn and add one table name vpnuser
----- mysql command ------
create database vpn;
use vpn;
create table vpnuser(name char(20) not null primary key,password char(128) not null,
active int(10) not null default 1);
insert into vpnuser(name,password) values('vpn','vpn');
grant all on vpn.* to 'openvpn'@'%' identified by 'openvpn';
flush privileges;

4.add one file name openvpn on /etc/pam.d/
#vim /etc/pam.d/openvpn
auth sufficient pam_mysql.so user=openvpn passwd=openvpn host=127.0.0.1 db=vpn
table=vpnuser usercolumn=name passwdcolumn=password where=active=1 sqllog=0 crypt=0
account required pam_mysql.so user=openvpn passwd=openvpn host=127.0.0.1 db=vpn
table=vpnuser usercolumn=name passwdcolumn=password where=active=1 sqllog=0 crypt=0

5.testing pam module for mysql
#saslauthd -a pam
if no output means ok
#testsaslauthd -u vpn -p vpn -s openvpn
0: OK "Success."

6.make dir to openvpn,copy sample file and grant permission on the directory
#mkdir /etc/openvpn/easy-rsa/
#cp -r /usr/share/doc/openvpn/examples/easy-rsa/2.0/* /etc/openvpn/easy-rsa/
#chown -R root /etc/openvpn/easy-rsa/
#cd /etc/openvpn/easy-rsa/
#ln -s openssl-1.0.0.cnf openssl.cnf

7.modify some paramenters on /etc/openvpn/easy-rsa/vars
#vim /etc/openvpn/easy-rsa/vars

export KEY_COUNTRY="TW"
export KEY_PROVINCE="TW"
export KEY_CITY="TAIPEI"
export KEY_ORG="CSP_Company"
export KEY_EMAIL="tommy@csp.com"

8.generate certificate keys
#cd /etc/openvpn/easy-keys
#source vars
#./clean-all
#./bulid-dh
#./pkitool --initca
#./pkitool --server vpnc3

install dart language in ubuntu 10.04 LTS

1.install all required packeages
#apt-get install bison fakeroot flex g++ g++-multilib gperf libapache2-mod-php5 libasound2-dev libbz2-dev libcairo2-dev libdbus-glib-1-dev libgconf2-dev libgl1-mesa-dev libglu1-mesa-dev libglib2.0-dev libgtk2.0-dev libjpeg62-dev libnspr4-dev libnss3-dev libpam0g-dev libsqlite3-dev libxslt1-dev libxss-dev mesa-common-dev ttf-mscorefonts-installer patch perl pkg-config python python-dev rpm subversion libcups2-dev libgnome-keyring-dev libcurl4-gnutls-dev libelf-dev ttf-indic-fonts

2.mkdir dart folder to install depot_tools
#mkdir /dart
#cd /dart
#svn co http://src.chromium.org/svn/trunk/tools/depot_tools
#export PATH=$PATH:`pwd`/depot_tools

3.install lib_ssl package
#apt-get install libssl-dev

4.get all source,make a folder without root permission
#cd /home/tommy/
#gclient config http://dart.googlecode.com/svn/trunk/deps/all.deps
#gclient sync

5.change /home/tommy/dart/third_party/gsutil/20110627/
#gsutil config
and use browser to access the url to archieve the authentication code
than reinstall use step 4 procedure

frox ftp proxy setting

1.install frox package with squid on the server
#apt-get install frox

2.modify frox configuration
#vim /etc/frox.conf

Port 2121
BindToDevice eth0
User nobody
Group nogroup
WorkingDir /var/log/frox
DontChroot no
LogLevel 15
LogFile /var/log/frox/frox-log
XferLogging yes
PidFile /var/run/frox.pid
PAConv yes
BounceDefend yes
AllowNonASCII yes
CacheModule http
HTTPProxy 172.16.100.100:9119
MinCacheSize 65536
DoNTP yes
MaxForks 10
MaxForksPerHost 4
ACL Allow * - *

3.add new iptables rule
iptables -t nat -A PREROUTING -p tcp -s LOCALNET --dport 21 -j REDIRECT --to 2121

rename eth1 to eth0

if you change motherboard and restart ubuntu system,
you may find all networks can't work with correct interfaces.
You can rename the interface to map the correct networks.

1.modify the /etc/udev/rules/70-persistent-net.rules
#vim /etc/udev/rules/70-persistent-net.rules

change eth? to correct number with mac address

2.remove all setting on /etc/network/interfaces except lo setting
vim /etc/network/interfaces

3.reboot server

4.add network setting on /etc/network/interfaces
vim /etc/network/interfaces
auto eth1
iface eth1 inet static
address 10.x.x.x
network 255.255.255.x
gateway 10.x.x.x.x

5.restart networks
#/etc/init.d/networking restart

linux dhcp access windows dhcp multidomain

if you dns server is windows base and allow linux client to search multidomin,
please modify windows dhcp server and add option 119.
1.on dhcp global scope add predefined option
2.add a byte array
3.example:abc.com abc.com.tw
add order is ab.com.tw abc.com
0x00 0x77 0x74 0x02 0x6d 0x6f 0x63 0x03 0x63 0x62 0x61 0x03 --> abc.com.tw
0x00 0x6d 0x6f 0x63 0x03 0x63 0x62 0x61 0x03 -->abc.com
ox00 means null termination
0x02 tw two characters
0x03 com three characters
0x0c abc three characters

other setting method,please use optinos 15 to add other domain with space
abc.com abc.com.tw

search mulitdomain

#vim /etc/resolv.conf
domain abc.com.tw
search adc.com ad.adc.com abc.com.tw
nameserver 172.16.1.100
nameserver 172.16.1.110
options ndots:3

it will search multidomain on /etc/resolv.conf