我是資深的電腦資訊從業員,曾於 Motorola 及 Philips 等跨國大型公司管理層工作十多年,具各類ERP資源管理系統及其它應用系統經驗,如QAD之MFG/PRO、SAP、Ufida(用友)、Kingdee(金蝶)、Microsoft's Dynamic、Wonderware's In-Track (SFC)、Webplan (SCM)、Hyperion (business intelligence)、Informatics (Data Warehouse)...等等。另外,我精於廠房車間之電腦資訊運作,擁有 CISSP 及 ITIL 認證,能提供日常資訊運作之檢測及審查,以提高操作效率。 本人誠意為各類大中小型廠房提供資訊審計、支援及意見,歡迎聯絡,電郵為




我想很多人會對"香港股票價位的歷史數據"有興趣,我已下載成Microsoft Access database version 2000 的文檔,資料由2008/1/1至2009/12/2,zip壓縮後也有11M,若索取請留你的PM我 。




Script to install OpenVPN on Linux

Steps to Install OpenVPN Server on Linux
1. Install tun
# wget
# tar –zxvf tun-1.1.tar.gz
# cd tun-1.1
# ./configure
# make
# make install
# modprobe tun
# edit /etc/modules.conf
  alias char-major-90 tun           ! for 2.2.x Core
  alias char-major-10-200 tun       ! for 2.4 Core
# modprobe –a
Add to rc.local  “ modprobe tun “

2. Install SSL
# rpm –qa |grep openssl
# wget
# tar –zxvf openssl-1.0.0g.tar.gz
# cd openssl-1.0.0g
# ./configure
# make
# make install

3. Install lzo
# wget
# tar –zxvf ..   / cd  ..   /   ./configure   /  make    /   make install

4. Install openvpn
# wget
# tar –zxvf ..   / cd  ..   /   ./configure   /  make    /   make install

Openvpn-2.2.2#  mkdir etc
Openvpn-2.2.2#  mkdir keys
Openvpn-2.2.2#  cp /root/openvpn-2.2.2/sample-config-files/server.conf /usr/local/openvpn-2.2.2/etc
Openvpn-2.2.2#  cp –ra /root/openvpn-2.2.2/easy-rsa /usr/local/openvpn-2.2.2
Openvpn-2.2.2#  vi /usr/local/openvpn2.2.2/easy-rsa/vars
Export EASY_RSA=”’pwd’”
                Export OPENSSL=”openssl”
                Export PKCS11TOOL=”pkcs11-tool”
                Export GREP=”grep”
                Export KEY_CONFIGURE=’$EASY_RSA/whichopensslcnf $EASY_RSA’
                Export KEY_DIR=”EASY_RSA/keys”
                Export PKCS11_MODULES_PATH=”dummy”
                Export PKCS11_PIN=”dummy”
                Export KEY_SIZE=1024
                Export CA_EXPIRES=3650
Export KEY_EXPIRE=3650
                Export KEY_COUNTRY=”CN”
                Export KEY_PROVINCE=”BJ”
                Export KEY_CITY=”Beijing”
                Export KEY_ORG=”w3”
                Export KEY_CN=xxx
                Export KEY_NAME=infoctech
                Export KEY_OU=xxx
                Export PKCS11_MODULE_PATH=changeme
                Export PKCS11_PIN=1234

# source vars
# ./clean-all

5, Create CA & Cert
# ./build-ca
# ./build-key-server server            ! sign the certificate = y
# ./build-key client2                  ! sign certificate = y

6. Create Diffie Hellman
# ./build-dh
# cp /usr/local/openvpn-2.2.2/easy-rsa/keys/* /usr/local/openvpn-2.2.2/keys

7. Start OpenVPN
# /usr/local/openvpn-2.2.2/sbin/openvpn /usr/local/openvpn-2.2.2/etc/server.conf
# cp /root/openvpn2.2.2/sample-scripts/openvpn.init /etc/init.d/openvpn/
# chkconfig –add openvpn
# chkconfig –level 35 openvpn on

8. Install OpenVPN client on Linux

# mkdir /etc/openvpn-client
# tree
-- ca.crt
-- client.ovpn
-- client2.crt
-- client2.key

# ./openvpn –config /etc/openvpn-client/client.ovpn
# more /etc/rc.local
  /usr/local/openvpn-2.2.2/sbin/openvpn –config /etc/openvpn-client/client.ovpn

# ifconfig
# route
# ping …
# smbclient –L //…    !check Samba share

Another set of script to Install openvpn on fedora 20 with the transition to systemd, OpenVPN no longer has a single monolithic init script, where every connection with a configuration file in/etc/openvpn/ is started automatically. Instead, individual connections can be started and stopped with systemctl.
For example, to start a connection, run systemctl start openvpn@foo.service, where the connection is defined in/etc/openvpn/foo.conf.

Setting up an OpenVPN server
1. yum install openvpn easy-rsa
2. Copy /usr/share/easy-rsa/2.0 somewhere (like root's home directory with cp -ai /usr/share/easy-rsa/2.0 ~/easy-rsa).
3. cd ~/easy-rsa
4. Edit vars appropriately.
5. . vars
6. ./clean-all
7. Before continuing, make sure the system time is correct. Preferably, set up NTP .
8. ./build-ca
9. ./build-key-server $( hostname | cut -d. -f1 )
10. ./build-dh
11. mkdir /etc/openvpn/keys
12. cp -ai keys/$( hostname | cut -d. -f1 ).{crt,key} keys/ca.crt keys/dh*.pem /etc/openvpn/keys/
13. cp -ai /usr/share/doc/openvpn*/sample/sample-config-files/roadwarrior-server.conf /etc/openvpn/server.conf
14. Edit /etc/openvpn/server.conf appropriately to set your configuration and key paths, which are found in /etc/openvpn/keys/.
15. Fix selinux context of files: restorecon -Rv /etc/openvpn
16. ln -s /lib/systemd/system/openvpn\@.service /etc/systemd/system/\@server.service (Note that 'server' corresponds with the configuration name in /etc/openvpn/ such as server.conf)
17. systemctl -f enable openvpn@server.service
18. systemctl start openvpn@server.service
19. Verify that firewall rules allow traffic in from tun+, out from the LAN to tun+, and in from the outside on UDP port 1194.

The following should work (assuming an outside interface is eth1 and an inside interface is eth0):
iptables -A INPUT -i eth1 -p udp --dport 1194 -j ACCEPT
iptables -A INPUT -i tun+ -j ACCEPT
iptables -A FORWARD -i tun+ -j ACCEPT
iptables -A FORWARD -i eth0 -o tun+ -j ACCEPT
iptables -A FORWARD -i eth1 -o tun+ -m state --state ESTABLISHED,RELATED -j ACCEPT

Or for genfw (my firewall-generation script, not currently available in Fedora), this in /etc/sysconfig/genfw/rules:
append INPUT -i eth1 -p udp --dport 1194 -j ACCEPT
append INPUT -i tun+ -j ACCEPT
append FORWARD -i tun+ -j ACCEPT
append FORWARD -i eth0 -o tun+ -j ACCEPT
append FORWARD -i eth1 -o tun+ -j established

Or for system-config-firewall, you can add these custom rules:
-A INPUT -i eth1 -p udp --dport 1194 -j ACCEPT
-A INPUT -i tun+ -j ACCEPT
-A FORWARD -i tun+ -j ACCEPT
-A FORWARD -i eth0 -o tun+ -j ACCEPT
-A FORWARD -i eth1 -o tun+ -m state --state ESTABLISHED,RELATED -j ACCEPT

Create a file iptables-rules in /etc/sysconfig and add the above contents, then in system-config-firewall, choose the "Custom Rules" choice, click "Add", choose IPV4 for the protocol type, and filter for the firewall table. Then select /etc/sysconfig/iptables-rules for the File: choice. Then Apply the changes.

Setting up a Linux OpenVPN client

Remember that we have already installed the openvpn package in client, and we have “ca.crt”, “vpnclient1.key”, vpnclient1.crt” in /etc/openvpn/. And copy the sample client.conf to /etc/openvpn.
You need to generate new keys (or use existing other client/username keys) for the new client/username

On the server:
1. cd easy-rsa
2. . vars
3. ./build-key username

On the client:
In the following, replace MyClient with a descriptive vpn connection name.
1. Copy username.key, username.crt and ca.crt from server to /etc/openvpn/keys/.
2. cp -ai /usr/share/doc/openvpn-*/sample-config-files/client.conf /etc/openvpn/MyClient.conf
3. Edit /etc/openvpn/MyClient.conf appropriately to set your configuration (just like server configuration, port, compression,..) and key paths.
4. cd /lib/systemd/system
5. ln openvpn@.service openvpn@MyClient.service
6. systemctl enable openvpn@MyClient.service
7. systemctl start openvpn@MyClient.service

check /var/log/messages if things didn't work as expected

Alternatively, on the client, after copying the keys onto the client machine, you can use NetworkManager to add a vpn connection. Make sure you have the NetworkManager-openvpn package installed. Then just add a new VPN connection.
Should also test automatic starting at boot up, with password protected key files and maybe even --auth-user-pass. OpenVPN supports systemd's password passing if build with --enable-systemd via ./configure
Setting up a Windows OpenVPN client

On the server:
1. cd easy-rsa
2. . vars
3. ./build-key username

On the client:
1. Install the OpenVPN GUI or the stand-alone OpenVPN client.  ( and Tap-windows version )
2. Copy username.crt, username.key, and ca.crt to C:\Program Files\OpenVPN\config\ on the client.
3. Drop roadwarrior-client.conf into C:\Program Files\OpenVPN\config\ as whatever.ovpn and edit appropriately.
4. Either use the GUI to start the connection, start the OpenVPN service manually, or set the OpenVPN service to start automatically.

Ideally the client should do some verification on the server key with tls-remote in the whatever.ovpn configuration file.


Static key configurations offer the simplest setup, and are ideal for point-to-point VPNs or proof-of-concept testing.

Static Key advantages
Simple Setup
No X509 PKI (Public Key Infrastructure) to maintain

Static Key disadvantages
Limited scalability -- one client, one server
Lack of perfect forward secrecy -- key compromise results in total disclosure of previous sessions
Secret key must exist in plaintext form on each VPN peer
Secret key must be exchanged using a pre-existing secure channel

Simple Example
This example demonstrates a bare-bones point-to-point OpenVPN configuration. A VPN tunnel will be created with a server endpoint of and a client endpoint of Encrypted communication between client and server will occur over UDP port 1194, the default OpenVPN port.

Generate a static key:

openvpn --genkey --secret static.key

Copy the static key to both client and server, over a pre-existing secure channel.

Server configuration file
dev tun
secret static.key

Client configuration file
remote myremote.mydomain
dev tun
secret static.key

Firewall configuration

Make sure that:
UDP port 1194 is open on the server, and the virtual TUN interface used by OpenVPN is not blocked on either the client or server (on Linux, the TUN interface will probably be called tun0 while on Windows it will probably be called something like Local Area Connection n unless you rename it in the Network Connections control panel).

Bear in mind that 90% of all connection problems encountered by new OpenVPN users are firewall-related.

Testing the VPN
Run OpenVPN using the respective configuration files on both server and client, changing myremote.mydomain in the client configuration to the domain name or public IP address of the server.
To verify that the VPN is running, you should be able to ping from the server and from the client.
Expanding on the Simple Example
Use compression on the VPN link
Add the following line to both client and server configuration files:

Make the link more resistent to connection failures
Deal with:
keeping a connection through a NAT router/firewall alive, and follow the DNS name of the server if it changes its IP address.

Add the following to both client and server configuration files:
keepalive 10 60

Run OpenVPN as a daemon (Linux/BSD/Solaris/MacOSX only)

Run OpenVPN as a daemon and drop privileges to user/group nobody.

Add to configuration file (client and/or server):
user nobody
group nobody

Allow client to reach entire server subnet

Suppose the OpenVPN server is on a subnet Add the following to client configuration:

Then on the server side, add a route to the server's LAN gateway that routes to the OpenVPN server machine (only necessary if the OpenVPN server machine is not also the gateway for the server-side LAN). Also, don't forget to enable IP Forwarding on the OpenVPN server machine.