Installing & Compiling OpenGTS Tracking System~!

Opengts

# Project ကလုပ္ခဲ့တာ ၁ႏွစ္ေက်ာ္ေက်ာ္ေလာက္ေတာ့ ရွိပီဗ်။ အဲ့တုန္းက လုပ္ထားတဲ့ Documentation ကိုပဲ ျပန္တင္တာပါ။

# မဟုတ္ရင္ ၾကာရင္ ေမ့သြားမွာစိုးတာရယ္၊ တျခား reference လုပ္လိုတဲ့သူေတြအတြက္ Share လိုက္ပါတယ္။

# GPS Tracking System နဲ႕ပတ္သက္ရင္ ဒီ OpenGTS တစ္ခုတည္းပဲ ရွိတာေတာ့ မဟုတ္ဖူးဗ်။ တျခား OpenSource  (or) CloseSource ေတြ အမ်ားအျပားရွိပါေသးတယ္။

Ok! let’s start.

Preparing & Setting Environment Variables

  1. ပထမဆံုး jdk-7u72-windows-x64 ကိုသြင္းပါ(default)။ ၿပီးရင္ Java run၊ မ run cmd ထဲမွာ စစ္ပါ။

java –version

  ( make sure it says “Java™” & “Java Hotspot™ Client VM” )

  1. mail-1.5.2.jar ဖိုင္ကို C:\Program Files\Java\jdk1.7.0_72\jre\lib\ext ထဲသို႕ Copy ကူးပါ။
  2. Apache “Ant” Folder ကို C:\Program Files\apache-ant ေအာက္သို႕ ေရြ႕ပါ။
  3. Apache-Tomcat Folder ကို C:\Program Files\apache-tomcat ေအာက္သို႕ေရြ႕ပါ။
  4. mysql-5.6.22-winx64 ကို Default feature အတိုင္း သြင္းပါ။
  5. mysql-connector-java-5.1.34 ဖိုင္ကို C:\Program Files\Java\jdk1.7.0_72\jre\lib\ext ထဲသို႕ Copy ကူးထည့္ပါ။
  6. 5.7 Folder ကို C:\OpenGTS_2.5.7 ေအာက္သို႕ ကူးထည့္ပါ။
  7. ၿပီးရင္ Variables ေတြ ေပါင္းသတ္မွတ္ပါမယ္။
  8. Run box ထဲမွာ sysdm.cpl ဟုရိုက္ပါ။ Advanced Tab ကိုသြားပါ။ Environment Variables ကို ႏိွပ္ပါ။
  9. System Variable ထဲမွာ New ကိုႏွိပ္ပါ။ Variable name ကို JAVA_HOME ဟုေပးပါ။ (capital letters)
  10. Variable Value မွာ C:\Program Files\Java\jdk1.7.0_72 ကိုထည့္ပါ။
  11. OK ႏွိပ္ပါ။ ဆက္လက္ၿပီး New ကိုႏွိပ္ပါ။
  12. Variable Name ကို ANT_HOME ေပးပါ။ Variable value ေနရာတြင္ C:\Program Files\apache-ant ထည့္ပါ။
  13. OK ႏွိပ္ပါ။ ဆက္လက္ၿပီး New ကိုႏွိပ္ပါ။
  14. Variable Name ကို CATALINA_HOME ေပးပါ။ Value ေနရာတြင္ C:\Program Files\apache-tomcatထည့္ပါ။
  15. OK ႏွိပ္ပါ။ ဆက္လက္ၿပီး New ကိုႏွိပ္ပါ။
  16. Variable Name ကို GTS_HOME ဟုေပးပါ။ Value ေနရာတြင္ C:\OpenGTS_2.5.7 ကိုထည့္ေပးပါ။
  17. System Variable ထဲမွာ Path ကိုရွာပါ။ Select ေပးၿပီး Edit ႏွိပ္ပါ။
  18. Variable Value ၏ ေနာက္ဆံုးေနရာမွာ semicolon [;] ခံၿပီး C:\Program Files\MySQL\MySQL Server 5.6\bin ကို ထည့္ပါ။
  19. Semicolon[;] ထပ္ခံၿပီး %JAVA_HOME%\bin ကိုဆက္ထည့္ပါ။
  20. Semicolon[;] ထပ္ခံၿပီး %ANT_HOME%\bin ကိုဆက္ထည့္ပါ။ [semicolon ခံစရာမလိုေတာ့ပါ။ OK ႏွိပ္ပါ။

 

Installing NT Service & Compiling OpenGTS Tracking System

  1. Run box ထဲကေန cmd ေခၚပါ။
  2. mysqld ကိုရိုက္ၿပီး enter ေခါက္ပါ။ TimeStamp error ျပေနပါလိမ့္မည္။ သို႕ေပမဲ့ Run ပါသည္။
  3. Run မ Run ကို Task Manager ေခၚၿပီး Process ထဲတြင္ ၾကည့္ပါ။ mysqld ဆိုပီး ေပၚေနပါလိမ့္မည္။
  4. cmd ကုိ ပိတ္မပစ္ဘဲ ဆက္ Run ထားပါ။ ေနာက္တခု cmd ထပ္ေခၚပါ။
  5. mysqld –install ဟုရိုက္ၿပီး Enter ေခါက္ပါ။ Successfully installed Service ဆိုပီး ေပၚလာပါလိမ့္မည္။
  6. MySQL သည္ default အားျဖင့္ password မပါပါ။ password ခ်ိန္းပါမယ္။
  7. mysql –uroot –p ဟုရိုက္ပါ။
  8. Enter Password ဟုေပၚလွ်င္ ဘာမွမရိုက္ဘဲ Enter ေခါက္ပါ။
  9. mysql > prompt ေပၚေနပါလိမ့္မည္။
  10. update mysql.user set password=password(‘password’)where user=’root’;
  11. ဟုရိုက္ပါ။ မ်က္ေတာင္ အဖြင့္အပိတ္ျပထားေသာ password ေနရာတြင္ password ကိုရိုက္ထည့္ပါ။

(root ေနရာတြင္ ဒီအတိုင္း ထားပါ။ မေျပာင္းပါႏွင့္)

  1. Query OK ဘာညာဆိုပီး ျပေနပါလိမ့္မည္။ ေနာက္တေၾကာင္းတြင္ flush privileges; ဟုရိုက္ထည့္ပါ။
  2. Effect ျဖစ္သြားပါလိမ့္မည္။ quit ရိုက္ပီးထြက္ပါ။ အဆင့္ ၇ မွ ျပန္၀င္ၿပီး Password ေျပာင္းမေျပာင္းစမ္းသပ္ပါ။
  3. Apache-Tomcat အားNT Service သြင္းရန္ cd %CATALINA_HOME%\bin ဟုရိုက္ပါ။
  4. bat install ဟုရိုက္ပါ။ (Run box ထဲမွ services.msc ေခၚၿပီး ၀င္၊ မ၀င္ၾကည့္ႏိုင္သည္။)
  5. cmd ထဲမွဆက္လက္ၿပီး openGTS compiling လုပ္ရန္ cd %GTS_HOME% ဟုရိုက္ကာ Directory ခ်ိန္းပါ။
  6. OpenGTS Folder လမ္းေၾကာင္းသုိ႕ေရာက္သြားပါလိမ့္မည္။ ant all ဟု ရိုက္ပါ။
  7. Build Sucessful ဟုေပၚလာပါလိမ့္မည္။ (error ျပေနလည္း ကိစၥမရွိပါ။)
  8. OpenGTS Database ေဆာက္ဖို႕အတြက္ db ကို import လုပ္ပါမယ္။
  9. cd %GTS_HOME%\bin ေအာက္သို႕ျပန္၀င္ပါ။
  10. bat “-rootUser:root” “-rootPass:password” 

    ဟုရိုက္ၿပီးEnter ေခါက္ပါ။

(password ေနရာတြင္ ေျပာင္းထားေသာ password ကို ထည့္ေပးပါ။)

  1. db ေတြ Create လုပ္သြားတာ ျမင္ရပါလိမ့္မည္။
  2. Web Interface ကို Access လုပ္ရန္ system account တခု ဖြင့္ပါမယ္။
  3. bat Account –account:sysadmin –pass:password –create

(password ေနရာတြင္ကိုယ္ႀကိဳက္တာေပးပါ။)

  1. openGTS ထဲက ဖိုင္ကို Tomcat server ထဲထည့္ပါမယ္။ Build ေအာက္တြင္ track.war ကိုရွာပါ။
  2. cd %GTS_HOME%\bin ဟုျပန္ရိုက္ပီး ant track.war ဟုျပန္ရိုက္ပါ။

(PDF ထဲတြင္ မည္သည့္ xml, conf ဖိုင္မ်ားကို ျပင္ပီးတိုင္း compile ျပန္လုပ္ေပးရမယ္လို႕ ေျပာထားပါတယ္)

  1. Compile ၿပီးသြားလွ်င္ Build\track.war ဖိုင္ကို C:\Program Files\apache-tomcat\webapps ေအာက္သို႕ Copy ကူးထည့္ပါ။
  2. Browser ေခၚၿပီး http://localhost:8080/track/Track ကိုေခၚၾကည့္ပါ။

Virtualization & Server2008R2 Active Directory

Hello everyone. Long time no see.

Recently, I attend Japan IT Networking class on local country. Before I took that class,
I already passed the exam and class from “Mikrotik” – MTCNA Certificate. That’s why, I did not totally update this blog.

Here describe slideshare is one of the presentation file from my experience. For your future reference and who will want to learn, I share it.
So, stay with me.

Greeting from MYANMAR.

pfSense 2.1 x64bit on Custom ESxi 5.5

Recently at my work, I deployed new custom vSphere Hypervisor ESXi 5.5 machine. What did you say, custom? You may want to ask because my ESXi server is not branded, its clone PC with lower hardware resources. But it works like a charm and great. Actually, that server is only purpose for pfSense and ubuntu server. pfSense is use for proxy and ubuntu to svn server. In this post, I want to describe solution while install for custom ESXi server and edit network setting for pfSense.
vimg
Here is my hardware specs:
ASUS H81M Series Motherboard
Core i3 3.30GHz
8GB Memory (No ECC)
500GB Harddisk (No RAID)
1GbE Realtek (Onboard)
1GbE Realtek (External PCIe Card)

Remark : This hardware specification is not recommended from vmware community.
Now let’s start~!
Firstly, You need to make custom ESXi iso because new ESXi ISO is not included Realtek drivers. My mainboard have R8163 chip. You can find what series of chip is currenly use in the mainboard manual or vendor website. Here is the pre-configure ESXi ISO link. https://drive.google.com/file/d/0B9e0e9dGgCykV0xFMlRJY1Rydm8/edit?usp=sharing

Step 2 – You need to enter the BIOS Setting and make sure Intel Virtualization Technology is enabled.

Step 3 – If your mainboard have UEFI boot support and other operating system is loaded before installing ESXi, you need to disable Secure boot on BIOS Setting and clear the key.

Now, left session is installing vSphere Hypervisor and vShpere Client. I believe you can do like kid playing in the park. 😀

Let’s go to the pfSense section.
Before installing any guest OS on ESXi 5.5, I recommend install too VMware Workstation 10 if you have.
It will very helpful while you editing vmware hardware resources. Coz, vSphere client is not support vmware hardware version 10. Client will be say you need to install vSphere Web Client to edit hardware settings. There are other methods available on NET. But it is better for us and begineers 🙂

Step 4 – Install pfSense on ESXi 5.5 with default option. Just use WAN interface and config for trial. And when finish, halt the system

Step 5 – In vSphere Client inventory interface, select Configuration Tab and go to Networking

Step 6 – Select Add Networking and choose Virtual Machine option button in Connection Types

Step 7 – Click Next and choose Create a Virtual Switch selecting with vmnic1

Step 8 – Click Next and give the Network label to WAN

Step 9 – Open VMware Workstation 10 for editing hardware resources and connect ESXi Server

Step 10 – Just add Network Adapter and choose WAN from drop down list in pfSense setting

Finish! You need to configure which interface is WAN or LAN in pfSense. As the above I already said, it is like kids playing in the park for you.

pfSense Squid Tips~!

# Short Notes(Created By edwardjude/ejnetwork.wordpress.com)/(Squid 2.7 Stable Package)
~!To block All destination Domain (HTTP) and allow only specific sites (edit manually on squid.conf)
—————–
# acl allowed_sites {dst|dstdomain|dstdom_regex|url_regex}
(To allow specific sites or domain with regular expression)
# acl all_dst dst 0.0.0.0/0.0.0.0 (To block all destination)
# http_access allow allowed_sites (Allow Rule for Defined ACL)
# http_access deny all_dst (Deny Rule for Defined ACL)
# deny_info URL_path_from_U all_dst (Deny Info page for Defined ACL)
—————–

~!To block download of some file extension (edit manually on squid.conf or edit from GUI in Custom Options)
—————–

 acl blockfiles url_regex -i URL_path_from_U 
 http_access deny blockfiles

—————-
Remark : When you create the file path, you need to edit of this $ expression in file.
(\.exe$)

Blocking Domains with Pfsense using DNS Forwarder~!

# Hi all! Long time no see. This article is really written by me!! 😀
# I’m gonna show you dns blocking with pfsense using DNS Forwarder Services…
# It’s like kids playing in the park. Anyone can do easily from WebGUI page from Pfsense Firewall.
# Ok! Now let’s do that ..
# You need Two options to do that ~!
# Firstly, you need to run services like dnsmasq service. Green status is up and running.
pfsense_services
# Secondly, You should make sure your LAN party DNS traffic redirect to your local DNS Forwarder Service.(Firewalling)
# This procedure will let you block DNS requests to servers that are off your network. This will let you force DNS requests from local clients to use pfSense’s DNS forwarder for resolution.
Firewall_rule
# It’s done. Now go to your pfsense WebGUI>Services>DNS Forwarder
# Pull down the page and you’ll see Domain Overrides Section.
# Now click the plus icon for edit domain override option.
Domain_Override
# Fill you want to block the domain name. Enter ! in the IP Address Field.
# Leave blank in Source IP Filed.
# Fill the description what you want to be.
# Click Save.
# Done~!

Sorry for my bad English~! I just want to share what I know. Greeting from Myanmar. Thank you All.

Edward Jude

Introduce My Facebook Page~!

# Post မတင္ျဖစ္တာ အေတာ္ၾကာပါပီ။ ဟိုဟာလုပ္ ဒီဟာလုပ္နဲ႕ မတင္ျဖစ္ပါ။(အမွန္က ပ်င္းလို႕ပါ :P)

# ကၽြန္ေတာ္လက္ရွိလုပ္ေနတဲ့အလုပ္က facebook Page ေလးကိုပဲ အညႊန္းအေနနဲ႕ေၾကာ္ျငာပါရေစ။

# အဲ့မွာရွိတာမ်ားပါတယ္။ လုပ္ထားတဲ့ Project ေတြကိုလဲ တင္ထားပါတယ္။ Messg နဲ႕ ဆက္သြယ္အၾကံျပဳႏိုိင္ပါတယ္။

ေက်းဇူးတင္ပါသည္။

https://www.facebook.com/igscrackers