Tuesday, March 14, 2017

How to - Getting Started Postgis and Spatial Query in PostgreSQL

This is a step by step on how to start using PostGIS and creating your own spatial query. This tutorial is focused on spatial query to support programming a REST web service from a backend database.

First step is the installation of PostgreSQL and PostGIS
  1. Download and Install PostgreSQL 9.6 from EnterpriseDB - https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
  2. Download PostGIS 2.3.2 - http://download.osgeo.org/postgis/windows/pg96/
  3. If you still don't have PgAdmin, you need to install a PgAdmin III. The PostGIS 2.3.2 still uses PgAdmin III version
  4. Try and Open your PostgreSQL Database from PgAdmin III. It will give you a warning, just ignore it for now.
  5. Extract PostGIS to PostgreSQL installation folder (Program Files**)
 Second Step, Lets activate PostGIS in PostgreSQL from PgAdmin III
  1. Create new Database (UTF8) to implement PostGIS, 
    WARNING : Do not implement PostGIS in Default Database postgres.

    Create Database GOLIVEHEAT UTF8;

  2. Enable PostGIS using query Extension :

    -- Enable PostGIS (includes raster)
    -- Enable Topology
    CREATE EXTENSION postgis_topology;
    -- Enable PostGIS Advanced 3D 
    -- and other geoprocessing algorithms
    -- sfcgal not available with all distributions
    CREATE EXTENSION postgis_sfcgal;
    -- fuzzy matching needed for Tiger
    CREATE EXTENSION fuzzystrmatch;
    -- rule based standardizer
    CREATE EXTENSION address_standardizer;
    -- example rule data set
    CREATE EXTENSION address_standardizer_data_us;
    -- Enable US Tiger Geocoder
    CREATE EXTENSION postgis_tiger_geocoder;

  3. Create Table : Locations, and populate with initial data

    CREATE TABLE locations(loc_id integer primary key
       , loc_name varchar(70), geog geography(POINT) );
    INSERT INTO locations(loc_id, loc_name, geog)
     VALUES (1, 'Waltham, MA', ST_GeogFromText('POINT(42.40047 -71.2577)') )
       , (2, 'Manchester, NH', ST_GeogFromText('POINT(42.99019 -71.46259)') )
       , (3, 'TI Blvd, TX', ST_GeogFromText('POINT(-96.75724 32.90977)') );

  4. Test Query

    --Test Query Spatial 1 ;
    SELECT row_to_json(fc)
     FROM ( SELECT 'FeatureCollection' As type, array_to_json(array_agg(f)) As features
     FROM (SELECT 'Feature' As type
     , ST_AsGeoJSON(lg.geog)::json As geometry
     , row_to_json((SELECT l FROM (SELECT loc_id, loc_name) As l
       )) As properties
       FROM locations As lg   ) As f )  As fc;
    --Test Query Spatial 2 ;
    SELECT row_to_json(fc)
     FROM ( SELECT 'FeatureCollection' As type, array_to_json(array_agg(f)) As features
     FROM (SELECT 'Feature' As type
     , ST_AsGeoJSON(lg.geog)::json As geometry
     , row_to_json((loc_id, loc_name)) As properties
       FROM locations As lg   ) As f )  As fc;
As you can see, the test query will give you a JSON based result. Since its related to geo location, the format follows a GeoJSON standards.

Now lets populate the database with a rather large dataset.
  • Download Data from : http://lite.ip2location.com/download?db=db5&type=csv&version=4
  • Populate data to table ip2location_geom.

    CREATE TABLE ip2location_geom(
     ip_from bigint NOT NULL,
     ip_to bigint NOT NULL,
     country_code character(2) NOT NULL,
     country_name character varying(64) NOT NULL,
     region_name character varying(128) NOT NULL,
     city_name character varying(128) NOT NULL,
     latitude real NOT NULL,
     longitude real NOT NULL,
     geog geography(Point,4326), 
     CONSTRAINT ip2location_geom_pkey PRIMARY KEY (ip_from, ip_to)

  •  Import CSV file from Downloaded file using Wizards 

    Dont forget to UNTICK field geog, because this is the field that we will use for spatial data.
  • Test Query - Data IP2Location.

    -- First Query : 
    select country_name, count(country_name) from ip2location_geom 
    where country_name = 'Indonesia' 
    group by country_name;
    -- Second Query : 
    select * from ip2location_geom where country_name = 'Indonesia'  

  • Update Geometry field in Table 

    UPDATE ip2location_geom set geog = ST_SetSRID(ST_MakePoint(longitude, latitude), 4326);

  • Query GeoJSON for ip2location_geom

    SELECT row_to_json(fc) 
    FROM ( 
      SELECT 'FeatureCollection' As type, array_to_json(array_agg(f)) As features
     FROM (
       SELECT 'Feature' As type
      , ST_AsGeoJSON(lg.geog)::json As geometry
      , row_to_json((country_code, country_name, region_name, city_name, longitude, latitude)) As properties
       FROM ip2location_geom As lg   
      ) As f 
    )  As fc;
    -- Query Results : Confirms the lat lon from existing data is the same as the lat lon in spatial data.

  • Query GeoJSON for ip2location_geom only for Indonesia

    --Query GeoJSON for ip2location_geom only for Indonesia : ON Query DB 
    --We already confirms that latitude and longitude is the same. Don't view lat lon in this query !!
    SELECT row_to_json(fc) 
    FROM ( 
      SELECT 'FeatureCollection' As type, array_to_json(array_agg(f)) As features
     FROM (
      SELECT 'Feature' As type
       , ST_AsGeoJSON(lg.geog)::json As geometry
       , row_to_json((country_code, country_name, region_name, city_name)) As properties
         FROM ip2location_geom As lg WHERE lg.country_name = 'Indonesia'   
      ) As f 
    )  As fc;
From this point on, you can call the query from web service to produce a GeoJSON format for your data.
I hope this will help anyone getting started in PostGIS and spatial query data. And to utilize it in REST web services.

Tuesday, October 16, 2012

How to Create Web Service Proxy in ESB

We will be using WSO2 ESB as our enterprise service bus. We're using WSO2 ESB because of its simplicity and even eBay uses it to process their transactions which is over 1 billion transaction a day. And most of all, its open source.

You can read all about their features from the website. http://wso2.com/products/enterprise-service-bus/ 

Installation & Running
1. Extract the wso2esb-4.0.2.zip and go to the extracted directory
2. Run the wso2server.sh or wso2server.bat as appropriate

Wait until you got to this sentence :

INFO - StartupFinalizerServiceComponent WSO2 Carbon started in 

3. Point your favourite browser to

4. Use the following username and password to login

    username : admin
    password : admin

5. Click on the left menu : Manage  Web Services  Add  Proxy Service.

6. Select WSDL Based Proxy.

Copy our WSDL URI that we have created before. 
If your confuse about the WSDL Service and Port, Don’t be !
Just open the browser and open our WSDL URI once again, and scroll down to the bottom and you will have your answers.

Next just make sure you select the Publish Same Service Contract option, and we're done. Click Create.

Congratulations, you just create a Web Service Proxy on ESB.

We were given TWO services address by the ESB, 

Now lets get back to our Deployed Service page, and click our service the HrmsService .

And Click on Security.

Lets choose the Advance Scenario Number 8. You can always choose other Security Scenario, and see how that works for you.

Number 8 requires a Username and a certificate to be available. Lets just use what is already available in WSO2 ESB.

Click Finish.

Congratulations. We now have a secured Web Service handled completely by the ESB.

Monday, October 15, 2012

Prolog to Enterprise Service Bus [In Bahasa]

Kompleksitas IT telah meningkat secara siginifikan dalam kurun waktu 20 tahun ini, dengan makin banyaknya aplikasi baru yang hadir dan di-implementasikan dalam organisasi untuk menciptakan efisiensi dalam departemen, core business, dan back office. Trend ini akan terus berlanjut untuk tahun-tahun berikutnya karena makin banyaknya aplikasi dan metodologi baru yang hadir, ditambah lagi dengan  mulai maraknya Enterprise Aplication yang telah banyak diadopsi oleh banyak Perusahaan.

Banyak perusahaan sekarang menghadapi tantangan besar untuk me-manage data secara efektif  untuk memastikan orang yang tepat memiliki akses terhadap informasi yang dibutuhkan kapanpun mereka membutuhkannya. 

Hal ini mengakibatkan tingginya permintaan terhadap integrasi data real-time intra-departemen, antar system dan antara lokasi kantor yang berbeda.

Seringkali permintaan "SEDERHANA" dari Business Owners terhadap Informasi tepat guna dalam kenyataannya lebih kompleks karena back-end system yang saling terkait satu sama lain dan aplikasi existing yang sulit untuk di-trace juntrungannya.

Application to Application (A2A) dan Business to Business (B2B) integration

Enterprise Application Integration (EAI) dan Message Oriented Middleware (MOM / middleware) adalah tools yang umumnya digunakan untuk memfasilitasi A2A dan B2B integration. Tools ini umumnya berupa adapters, transformation logic dan reliable messaging modules di core framework-nya.

  • Adapters : Adapters umumnya digunakan sebagai sarana untuk pertukaran informasi dengan aplikasi bisnis seperti SAP atau PeopleSoft, tapi bisa juga digunakan untuk berkomunikasi melalui protokol seperti TCPIP atau dengan bisnis aplikasi lain dengan perantara XML
  • Transformation logic : Digunakan untuk mengubah tipe informasi yang bisa dibaca oleh satu system menjadi tipe format berbeda yang bisa dimengerti system lain.
  • Messaging : Kunci untuk solusi integrasi adalah messaging yang cepat dan dapat diandalkan. Contoh messaging : JMS, TIBCO, etc.

Notes: Messaging hanya mensupport SOAP-based web service, dan tidak mensupport format HTTP GET/POST, REST, dll. Itulah sebab kenapa kita pertama-tama harus dapat menguasai SOAP web service.

Service Oriented Architecture (SOA) dan Enterprise Service Bus (ESB) integration

Service Oriented Architecture (SOA) adalah sebuah himpunan dari design principles (ada beberapa design principle, bukan cuma satu) yang digunakan dalan systems development dan integration. SOA muncul karena banyaknya inefficiencies dari implementasi yang menggunakan arsitektur point-to-point atau arsitektur hub-and-spoke.

P2P / Hub and Spoke

Arsitektur P2P dan hub and spoke akan melumpuhkan bisnis karena setiap perubahan memerlukan effort yang luar biasa dan resiko yang tidak kalah besarnya.

Dengan makin banyaknya pendatang baru dalam enterprise integration dengan membawa tools SOA masing-masing. SOA kini digadang-gadang sebagai "future architecture for enterprise integration" dan "significant business value" dapat direalisasikan dari implementasi SOA asalkan di-deliver secara benar.

SOA dapat secara tepat mengexpose functionality dari aplikasi kita sebagai services, memungkinkan kita untuk mengorkestrasikan workflow processes lintas system yang berbeda. Enterprise Service Bus (ESB) adalah platform yang umum digunakan dalam merealisasikan SOA. ESB mem-provides functionality untuk messaging, complex event processing, management, routing dan mediation.


Enterprise service bus mengurangi redundansi dan tight coupling diantara system yang berbeda, sehingga secara drastis mengurangi resiko dan memungkinkan reuseability secara signifikan.

Skenario ESB bagi programmer

Implementasi yang umumnya digunakan sekarang adalah P2P. Setiap aplikasi (misalnya portals.) akan mendefine system apa saja yang harus digunakan, data apa yang harus diterima dan dikirim, validasi user diambil dari database mana, transaksi log-nya akan disimpan di system mana, dan lain sebagainya. Dan itu hanya dari satu aplikasi, coba lakukan untuk aplikasi yang lain. Proses yang sama pastinya akan berulang.

Sehingga kalo kita melihat secara global, untuk semua aplikasi, hasilnya adalah keruwetan luar biasa seperti yang kita lihat pada gambar diatas (sebelum Enterprise service bus).

Jika kita menggunakan SOA, dengan ESB sebagai platformnya, maka caranya akan sedikit berbeda. Coba lihat gambar diatas. Panah diatas mewakili Web Service. Setiap aplikasi akan melakukan pemanggilan ke web service dan sebaliknya akan dipanggil oleh aplikasi lain melalui web service.

Semua functionality akan terpusat di ESB, sehingga kita hanya harus memanage semua functionality kita (Web service) dari Web Admin ESB. Dalam ESB, kita bisa mengassign user siapa saja yang bisa mengakses web service, memberikan security berupa data encryption dalam SOAP XML datanya, dll. Lebih lanjut bisa dibaca standarisasi SOA di https://www.oasis-open.org/committees/tc_home.php?wg_abbrev=soa-blueprints

Karena semua functionality kita terpusat di ESB, semua pemanggilan akan melalui ESB, sehingga kita harus meningkatkan performance dari Web traffic-nya. Disini, kita memerlukan Load Balancing dan Failover strategy seperti yang kita sudah bahas sebelumnya.

Mudah-mudahan bisa memberikan pencerahan.

Sunday, October 14, 2012

How to Load Balancing and Failover with Apache/Tomcat

Front-ending Apache Tomcat with Apache Web Server is sometimes thought to improve performance. However, performance of Tomcat standalone has already been known to be very good. So why add  Apache web server in front of it? – the answer is scalability and maintenance. Front-ending Tomcat with such web servers allows you to add more instances in case of increased load and also bring down instances for maintenance/upgrades.

These solutions provides high scalability, high availability, and good load balancing capabilities that are comparable with any other software solution. 
In order to get this done, you’ll need Apache 2.2, Tomcat 6 or 7, and the MOD_JK connector library.

Also, you’ll need to have a Java JDK installed, and your JAVA_HOME pointing to it. Make sure your PATH contains %JAVA_HOME%/bin.

  1. Install Apache 2.2. With this configuration.

  2. Copy the mod_jk-1.2.28-httpd-2.2.3.so file to your Apache/modules directory.
  3. Add the following to your apache/conf/httpd.conf

    LoadModule jk_module modules/mod_jk-1.2.28-httpd-2.2.3.so

    JkWorkersFile conf/workers.properties
    JkLogFile logs/jk.log
    JkLogLevel debug

    JkMount /* router
    JkMount /jk_status status

  4. Create a file, name it workers.properties in your Apache/conf directory. The file should contain the following:






  5. Extract the Tomcat 6 or 7 installation ZIP archive to three different directories, as we’re going to load balance three instances of Tomcat.

  6. Replace the server.xml file in each of the Tomcat conf/ directories with the following:

    <Server port="8100" shutdown="SHUTDOWN">

    <Resource name="UserDatabase" auth="Container"
    description="User database that can be updated and saved"
    pathname="conf/tomcat-users.xml" />

    <Service name="Catalina">
    <Connector port="8180" protocol="HTTP/1.1"
    redirectPort="8443" />

    <!-- Define an AJP 1.3 Connector -->
    <Connector port="8109" protocol="AJP/1.3" redirectPort="8443" />

    <Engine name="Catalina" defaultHost="localhost" jvmRoute="jvm1">
    <Realm className="org.apache.catalina.realm.UserDatabaseRealm"

    <Host name="localhost" appBase="webapps"
    unpackWARs="true" autoDeploy="true"
    xmlValidation="false" xmlNamespaceAware="false">

    <Cluster className="org.apache.catalina.ha.tcp.SimpleTcpCluster"

    <Manager className="org.apache.catalina.ha.session.DeltaManager"

    <Channel className="org.apache.catalina.tribes.group.GroupChannel">
    <Membership className="org.apache.catalina.tribes.membership.McastService"

    <Receiver className="org.apache.catalina.tribes.transport.nio.NioReceiver"

    <Sender className="org.apache.catalina.tribes.transport.ReplicationTransmitter">
    <Transport className="org.apache.catalina.tribes.transport.nio.PooledParallelSender"/>

    <Interceptor className="org.apache.catalina.tribes.group.interceptors.TcpFailureDetector"/>
    <Interceptor className="org.apache.catalina.tribes.group.interceptors.MessageDispatch15Interceptor"/>

    <Valve className="org.apache.catalina.ha.tcp.ReplicationValve" filter=""/>
    <Valve className="org.apache.catalina.ha.session.JvmRouteBinderValve"/>

    <Deployer className="org.apache.catalina.ha.deploy.FarmWarDeployer"

    <ClusterListener className="org.apache.catalina.ha.session.JvmRouteSessionIDBinderListener"/>
    <ClusterListener className="org.apache.catalina.ha.session.ClusterSessionListener"/>

    Looking into the XML above, there are three ports we’re concerned with: 8100, 8180, and 8109. These are the server, HTTP, and AJP13 ports, respectively. We’ll need each instance of Tomcat to run on it’s own ports. So, you can use this file as is in your first folder containing Tomcat, however, you’ll need to change the port numbers to: 8200, 8280, and 8209 for you 2nd installation. The third installation will use the ports, 8300, 8380, and 8309.

  7. Start (or Restart) Apache 2.2
  8. Start each instance of Tomcat (use the startup.bat script in the Tomcat /bin directory) – you should see no errors.
  9. Verify each Tomcat is working by opening a browser window to each Tomcat instance – if you’ve followed my instructions, the links are: 
  10. If Tomcat started correctly, start Apache 2.2. You should be able to access the Tomcat example pages via the following URL: 
  11. You’re done. Using my configuration, you can access a page to control the JK connector here:

    I’d recommending hiding and protecting this should you want to put this configuration into production. 

  12. Try experimenting with the configuration by stopping instance of Tomcat… as long as one instance of Tomcat is running, you should be able to see the examples.
  13. Now lets deploy, our web service that we just made before. Hrms.war
  14. Just put the war into TOMCAT_HOME\webapps.
  15. Start (or Restart) Apache 2.2
  16. Start each instance of Tomcat (use the startup.bat script in the Tomcat /bin directory) – you should see no errors.
  17. Verify each tomcat instance is working : 

  18. Now open the apache instance via the following URL : 


We have succeeded in creating a solution that provides high scalability, high availability, and good load balancing capabilities for our web services. For every request to our Apache Server, the load will be divided between the node server available (Tomcat instance). Even if one or more node server is down, as long as there is one node still running, the request will be responded by Apache. That is the true meaning of High Scalability and High Availability.

Monday, October 8, 2012

How to create a SOAP Web Services with Apache CXF

Create new Dynamic Web Project

Choose Dynamic web module version to 2.5, and Configuration template to CFX Web Services Project v2.5. And click Modify (If you haven't already)

Make sure you already download Apache CXF and extract it in your favorite folder. Manage your Apache CXF Configuration, and locate it to your Apache CXF location.

Click Configure installed runtime.. And click Add. Browse to your copy of Apache CXF runtime.

Click OK and Finish.

Project structure generated by Eclipse.

Now, Lets start by modifying the web.xml file.

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
 Then we create our employee object, Employee.java, in package com.company.hr.bean
package com.company.hr.bean;

import java.io.Serializable;
import java.util.Set;

public class Employee implements Serializable {
private static final long serialVersionUID = 1L;
private String gid;
private String lastName;
private String firstName;
private Set<String> privileges;
public Employee() {}
public Set<String> getPrivileges() {
return privileges;
public void setPrivileges(Set<String> privileges) {
this.privileges = privileges;
public String getFirstName() {
return firstName;
public void setFirstName(String firstName) {
this.firstName = firstName;
public String getGid() {
return gid;
public void setGid(String gid) {
this.gid = gid;
public String getLastName() {
return lastName;
public void setLastName(String lastName) {
this.lastName = lastName;
public boolean isUserInRole(String role) {
if(privileges == null) { return false; }
else { return privileges.contains(role); }
Lets assume we have a Data Access Object, EmployeeDAO.java, we can always replace this with an actual access to database. Put this in package com.company.hr.dao.
package com.company.hr.dao;

import com.company.hr.bean.Employee;

public class EmployeeDAO
public EmployeeDAO() {
// TODO Auto-generated constructor stub
public Employee getEmployee(String gid)
Employee bleh = new Employee(); // from database or SAP
return bleh;

Next we create an interface that will be accessed by the SOAP Web services, HrmsService.java. Lets put it in com.company.hr.service. The @WebService is a declaration to be used by SOAP WSDL, the @WebParam will maintain the parameter name in WSDL the same as the parameter name in java interface.

package com.company.hr.service;

import java.util.List;
import javax.jws.WebService;
import javax.jws.WebParam;
import com.company.hr.bean.Employee;

public interface HrmsService {
Employee getEmployee(@WebParam(name="gid") String gid);
List<Employee> getAllEmployee(@WebParam(name="status") String status);

Then we need a class for implementing the interface above, HrmsServiceImpl.java, lets put it in the same package as HrmsService,  com.company.hr.service.
The @WebService require the definition of an EndPointInterface and ServiceName. This will define the WSDL contract for our purposes.

package com.company.hr.service;

import java.util.ArrayList;
import java.util.List;
import javax.jws.WebService;
import com.company.hr.bean.Employee;
import com.company.hr.dao.EmployeeDAO;

@WebService(endpointInterface = "com.company.hr.service.HrmsService", serviceName = "hrmsService")
public class HrmsServiceImpl implements HrmsService {
public Employee getEmployee(String gid) {
EmployeeDAO dao = new EmployeeDAO();
return dao.getEmployee(gid);

public List<Employee> getAllEmployee(String status) {
List<Employee> employees = new ArrayList<Employee>();
Employee emp1 = new Employee();
Employee emp2 = new Employee();
Employee emp3 = new Employee();
return employees;

Next, we will need to manage our CXF configuration, cxf.xml, lets put this configuration file in the same package as HrmsService, com.company.hr.service.
<beans xmlns="http://www.springframework.org/schema/beans" 
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://cxf.apache.org/jaxws http://cxf.apache.org/schemas/jaxws.xsd
http://cxf.apache.org/clustering http://cxf.apache.org/schemas/clustering.xsd
http://cxf.apache.org/core http://cxf.apache.org/schemas/core.xsd">
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd 
<import resource="classpath:META-INF/cxf/cxf.xml" />
<import resource="classpath:META-INF/cxf/cxf-extension-soap.xml" />
<import resource="classpath:META-INF/cxf/cxf-servlet.xml" />
<jaxws:endpoint id="authEnd"
address="/hrmsService" >
<bean id="abstractLoggingInterceptor" abstract="true">
   <property name="prettyLogging" value="true"/>
<bean id="loggingInInterceptor" class="org.apache.cxf.interceptor.LoggingInInterceptor" parent="abstractLoggingInterceptor"/>
<bean id="loggingOutInterceptor" class="org.apache.cxf.interceptor.LoggingOutInterceptor" parent="abstractLoggingInterceptor"/>
       <ref bean="loggingInInterceptor"/>
       <ref bean="loggingOutInterceptor"/>
       <ref bean="loggingOutInterceptor"/>
       <ref bean="loggingInInterceptor"/>

The structure of the project would look like this,

Thats it, now we are ready to try our web service. Type the URL :

The Hrms is the name of your project (If you have different project name, change accordingly), the /services/ comes from servlet settings in your web.xml, the hrmsService is your WSDL contract that you define previously in interface HrmsService.

Congratulations, you have created a SOAP Web service using Apache Cxf.

Next time, once I got the time, I will try to cover all about Enterprise Service Bus from one of Open Source products.

Why open source?

Because I dont have time to install WebSphere or Oracle SOA Suite.

Tuesday, January 24, 2012

How to Setting LDAP (OpenLDAP) in Windows Development Environment

There are times when programmers are asked to connect to an M$ Active Directory or OpenLDAP Server for authentication process. So that all the application will connect to the same User directory (LDAP), and ofcourse the system administrator will only manage users from one application.

This tutorial is intended for programmers to install an OpenLDAP server in their computers, to grasp the essence of LDAP, and how to actually connect to one. It took me 15 articles to actually implement this, so i thought i'd share it to everyone.

This tutorial however, is not intended for system administrator because the settings used in almost every step in this tutorial is the default settings.

There you have it, you've been warned.

aaaaaand ... here are the steps ..
  • Install OpenLDAP for Windows from http://www.userbooster.de/en/download/openldap-for-windows.aspx and follow its installation instruction. Install it on "C:\App\OpenLDAP"
  • Accept all the default. Use the BDB (Berkley Database) as the Backend Engine.
  • Your LDAP Server is now running. To see the service just open your Windows Services and search for OpenLDAP Service. If you dont want the service to run automatically everytime the Windows restart, just change it to Manual from the Properties Dialog.
  • Next, install LDAPExplorerTool from http://ldaptool.sourceforge.net/. And try to connect to your LDAP Server using these settings :
    • Server Name or IP : According to your Computer Name or IP
    • LDAP Port : 389 ; check the use default checkbox
    • LDAP SSL Port : 636 ; check the use default checkbox
    • Version : 3 (LDAP ver. 3)
    • User DN : cn=Manager,dc=maxcrc,dc=com ; Uncheck the anonymous login.
    • Password : secret
    • Base DN (Just click the Guess Value button)
    • For everything else, just accept the default value
    • Click the Test Connection button. And after saving it, just click Open.
  • It should open an empty LDAP directory. Next we will try to add an actual value to it.
  • Create a file in C:\App\OpenLDAP\ldifdata, name it step1.ldif. The contents are :

## uses RFC 2377 format
## replace maxcrc and com as necessary below
## or for experimentation leave as is

## dcObject is an AUXILLIARY objectclass and MUST
## have a STRUCTURAL objectclass (organization in this case)
# this is an ENTRY sequence and is preceded by a BLANK line

dn: dc=maxcrc,dc=com
dc: maxcrc
description: My wonderful company as much text as you want to place
objectClass: dcObject
objectClass: organization
o: Maxcrc, Inc.

## FIRST Level hierarchy - people 
## uses mixed upper and lower case for objectclass
# this is an ENTRY sequence and is preceded by a BLANK line

dn: ou=people, dc=maxcrc,dc=com
ou: people
description: All people in organisation
objectclass: organizationalunit

## SECOND Level hierarchy
## ADD a single entry under FIRST (people) level
# this is an ENTRY sequence and is preceded by a BLANK line
# the ou: Human Resources is the department name

dn: cn=Robert Smith,ou=people,dc=maxcrc,dc=com
objectclass: inetOrgPerson
cn: Robert Smith
cn: Robert J Smith
cn: bob  smith
sn: smith
uid: rjsmith
userpassword: rJsmitH
carlicense: HISCAR 123
homephone: 555-111-2222
mail: r.smith@example.com
mail: rsmith@example.com
mail: bob.smith@example.com
description: swell guy
ou: Human Resources

  • Save the file. And open a command line and run these command 
    • cd C:\App\OpenLDAP\ClientTools
    • ldapmodify.exe -a -x -h localhost -p 389 -D "cn=manager,dc=maxcrc,dc=com" -f d:\App\OpenLDAP\ldifdata\step1.ldif -w secret 
  • From your LDAP Explorer Tool menu, select File -> Open last configuration, and you will find the LDAP Directory is no longer empty.
  • Next lets add one of our own data to the LDAP Directory. Create a file in C:\App\OpenLDAP\ldifdata, name it samz.ldif. The contents :

## SECOND Level hierarchy
## ADD a single entry under FIRST (people) level
# this is an ENTRY sequence and is preceded by a BLANK line
# the ou: Human Resources is the department name

dn: cn=Panji Pratomo,ou=people,dc=maxcrc,dc=com
objectclass: inetOrgPerson
cn: Panji Pratomo
cn: P Pratomo
cn: Panji P
sn: panji
uid: ppratomo
userpassword: SomePassword
carlicense: HISCAR 123
homephone: 555-111-2222
mail: panji.pratomo555@gmail.com
mail: panji.pratomo555@mysamz.com
mail: panji_pratomo555@yahoo.com
description: football maniac
ou: SOA

dn: cn=Fahmi Satrio,ou=people,dc=maxcrc,dc=com
objectclass: inetOrgPerson
cn: Fahmi Satrio
cn: F Satrio
cn: Mi
sn: fahmi
uid: fsatrio
userpassword: SomePassword
carlicense: HISCAR 123
homephone: 555-111-2222
mail: f.satrio222@gmail.com
mail: f.satrio222@mysamz.com
mail: guest108222@fif.co.id
description: tukang ngulik ga jelas
ou: SOA
  • Save the file. And open a command line and run these command 
    • cd C:\App\OpenLDAP\ClientTools
    • ldapmodify.exe -a -x -h localhost -p 389 -D "cn=manager,dc=maxcrc,dc=com" -f d:\App\OpenLDAP\ldifdata\samz.ldif -w secret 
  • From your LDAP Explorer Tool menu, select File -> Open last configuration.