Savior de Cav

OpenVPN User Manager 1.1

Basically, most of this post is taken from http://www.mertech.com.au/mertech-products-openvpnusermanager.aspx. OpenVPN user manager is a tool to manage the openvpn server. this tool is designed to make viewing and managing your OpenVPN server painless. This is features of OpenVPN User Manager 1.1 :
1. General information about users
2. Instant search of users, servers, logs and time blocks
3. Tracking of users, collects connection/disconnection times and bytes sent/received.
4. Ability to ‘Kill’ users from the application
5. Custom log file creator (you can make your own templates for data logs)
6. OpenVPN User Manager can now use the Management console to receive all information
7. [Removed] Full ASP.NET 2.0 web server built in with web access to server information (removed in version 1.0 due to rewrite)
8. Pie Chart of user’s upload and download.
9. Ability to switch between a Management connection or a status file to update users

How to setup :

Set the management option in your openVPN configuration file

add this line on your configuration file :

management 192.168.0.1 7505 pass.txt

Then click start your openvpn user manager 1.1. Click manage server and add server. After that fill IP address, port and password. The password is the first line on pass.txt. Finally you can monitor your openvpn server.

This is sreenshots openvpn user manager that i used.

OpenVPN is a SSL VPN. As we know, VPN is a technique to connect two site likes leased line. It’s liked a kind of tunneling principle. This time, i would like to share my experience installing OpenVPN on FreeBSD. Thank you to Mas Rendo, Mas Adhy, Mas Artiko and other person that support me. This installation using key for a user whose want to connect using OpenVPN.

1. We install the OpenVPN software from ports

cd /usr/ports/security/openvpn
make install clean

2. We copy example configurations folder

cp /usr/local/share/doc/openvpn/ /usr/local/etc/openvpn/

cd /usr/local/etc/openvpn cp -R sample-config-files config-files/

3. Edit main configuration of OpenVPN ( server.conf )

cd config-files

vi server.conf

This is my server.conf

port 443
# TCP or UDP server?
proto tcp
dev tun
ca /usr/local/etc/openvpn/easy-rsa/keys/ca.crt
cert /usr/local/etc/openvpn/easy-rsa/keys/server.crt
key /usr/local/etc/openvpn/easy-rsa/keys/server.key # This file should be kept secret
dh /usr/local/etc/openvpn/easy-rsa/keys/dh1024.pem
server xxx.xxx.xxx.xxx 255.255.255.224 ( your server ip address )
ifconfig-pool-persist /var/log/ipp.txt
push "route remote_host 255.255.255.255 net_gateway"
push "route xxx.xxx.xxx.xxx 255.255.255.192"
keepalive 10 120
comp-lzo
persist-key
persist-tun
status /var/log/openvpn-status.log
log-append /var/log/openvpn.log
verb 3

4. create server and client key

cd /usr/local/etc/openvpn/easy-rsa
vi vars ( change export with setenv )
./vars
./clean-all
./build-ca
./build-key-server server (can change with another name)
./build-key-pass myname --- key for us ( common name myname )
./build-dh

5. We have to run forwarding function on our server

sysctl net.inet.forwarding=1

6. Then run openvpn

openvpn /usr/local/etc/config-files/server.conf &

And then we put ca.crt, myname.crt and myname.key on client site to connect through openvpn.

Thank You

Network Address Translation (NAT, also known as Network Masquerading, Native Address Translation or IP Masquerading) involves re-writing the source and/or destination addresses of IP packets as they pass through a router or firewall. Most systems using NAT do so in order to enable multiple hosts on a private network to access the Internet using a single public IP address (see gateway). Many network administrators find NAT a convenient technique and use it widely. Nonetheless, NAT can introduce complications in communication between hosts and may have a performance impact.
As FreeBSD mania, i would like to share my experience build up a NAT gateway.
this is the topology.

I would like to use NAT in this case. The gateway has two NIC, one for the upstream and one for the downstream. I use realtek interface card to be the upstream interface. I give it IP address 202.14.xxx.xxx. And the other interface i give IP address 192.168.1.1.
Then I use packet filter ( PF ) to run NAT function.
This is the configuration to load pf in booting system

edit your /etc/rc.conf
pf_enable="YES"
pf_rules="/etc/pf.conf"
pflog_enable="YES"
pflog_logfile="/var/log/pflog"
gateway_enable="YES"

then edit the /etc/pf.conf
nat on rl0 from 192.168.1.0/24 to any -> (rl0)

after that, try the PC client the allocation IP address.
And, Its done.

-nanta-

I got some tasks from my lecture to deploy user complaint form.

I don’t know how to deploy…just try and try. And finally i know how to start. I use PHP and MySQL to deploy it. Generally, I make the form with PHP and html source code. I use 3 tables on MySQL to get Data that i want to show at form. I confuse how to join 3 tables.With help from my friend and GrandPa google, finally I know it. This the topology of that’s 3 tables:

1st table:

+———+————–
| Field | Type
+———+————–
| id | int(10)
| tanggal | varchar(30)
| nama | varchar(100)
| alamat | varchar(200)
| kota | varchar(25)
| email | varchar(150)
| idcom | int(10)
| idwil | int(10)
+———+————–

2nd table:

+——–+————–+
| Field | Type |
+——–+————–+
| idcom | int(10) |
| descom | varchar(100) |
+——–+————–+

3 rd table:

+——–+————–+
| Field | Type |
+——–+————–+
| idwil | int(10) |
| deswil | varchar(100) |
+——–+————–+

from 1 st table , i want to get 2 field idwil and idcom. this two field the same as 2nd table and 3rd table. I want to get deswil from 3rd table and descom from 2nd table. This is the syntax to join both 3 tables:

SELECT tanggal, nama, alamat, email, descom,deswil FROM tugas LEFT JOIN komplain ON tugas.idcom = komplain.idcom LEFT JOIN wilayah ON tugas.idwil = wilayah.idwil ORDER BY id

these will show 3 data from both 3 tables.

Maybe these info help you that have a problem like me..

thank you

-nanta-