eGov Coexistence

eGovernments Foundation transforms urban governance with the use of scalable and replicable technology solutions that enable efficient and effective municipal operations, better decision making, and contact-less urban service delivery.

Our comprehensive software products enable Governments to put their resources to efficient use by minimising overheads. We also help bring in transparency, accountability and citizen centricity in the delivery of Government services.

eGovernments Foundation has been in the forefront of implementing eGovernance solutions since 2003. Our products have been serving over 325 ULBs across the country. Our time tested products have impacted the ULBs in a large way. We have also been involved in several eGovernance initiatives in the country.

Our primary business motivator is to increase the footprint of eGovernance across the country and help adoption in as many ULBs as possible. Going opensource with our products is a measure in this direction. It also gives us the ability to tap into the immense talent pool in India for strengthening and improving our cities. Open source also blends well with our ethical fabric of being open and transparent in our business.

Issue Tracking

Report issues via the eGov Coexistence JIRA.

License

The eGov suit is released under version 3.0 of the GPL.

Powered By

     

User Guide

This section contains steps that are involved in build and deploy the application. FAQ related to various deployment and development issues are discussed here

Setup with auto installer

• Clone the eGov Coexistence repository (development is done on the master branch).

$ mkdir -p ${HOME}/egovgithub && cd egovgithub
$ git clone  -b master --single-branch  https://github.com/egovernments/egov-coexistence.git

• First time setup which will install the stacks, build the source code, and deploys the artifact to Wildfly

$ cd ${HOME}/egovgithub/eGov && make all

---

• To install the prerequisites Coexistence stacks

$ cd ${HOME}/egovgithub/eGov &&  make install

• To build the source code base

$ cd ${HOME}/egovgithub/eGov && make build

• To deploy the artifact to WILDFLY

$ cd ${HOME}/egovgithub/eGov && make deploy

Manual Setup Instruction

Prerequisites

• Install maven v3.2.x
• Install PostgreSQL v9.4
• Install Elastic Search v2.4.x
• Install Jboss Wildfly v10.x
• Install Git 2.8.3
• Install JDK 8 update 112 or higher

Database Setup

1. Create a database and user in postgres
2. Create a schema called generic
3. Execute ALTER ROLE <your_login_role> SET search_path TO generic,public;

Elastic Search Setup

Elastic seach server properties needs to be configured in elasticsearch.yml under <ELASTICSEARCH_INSTALL_DIR>/config

## Your local elasticsearch clustername, DO NOT use default clustername
cluster.name: elasticsearch-<username>
## This is the default port
transport.tcp.port: 9300

NB: <username> user name of the loggedin system, enter the below command in terminal to find the username.

$ id -un

Building Source

1. Clone the eGov Coexisteence repository (development is done on the master branch)

$ mkdir egovgithub
$ cd egovgithub
$ git clone https://github.com/egovernments/egov-coexistence.git

2. Change directory to <CLONED_REPO_DIR>/egov/egov-config/src/main/resources/config/ and create a file called egov-erp-<username>.properties and enter the following values based on your environment config.

##comma separated list of host names 
elasticsearch.hosts=localhost
elasticsearch.port=9300
elasticsearch.cluster.name=elasticsearch-<username>

If required, you can override any default settings available in /egov/egov-egi/src/main/resources/config/application-config.properties by overriding the value in egov-erp-<username>.properties.

3. Change directory back to <CLONED_REPO_DIR>/egov

4. Run the following commands, this will cleans, compiles, tests, migrates database and generates ear artifact along with jars and wars appropriately

mvn clean package -s settings.xml -Ddb.user=<db_username> -Ddb.password=<db_password> -Ddb.driver=org.postgresql.Driver -Ddb.url=<jdbc_url>

Redis Server Setup

By default eGov suit uses embedded redis server (work only in Linux & OSx), to make eGov suit works in Windows OS or if you want to run redis server as standalone then follow the installation steps below.

1. Installing redis server on Linux

sudo apt-get install redis-server

2. Installing redis server on Windows :- There is no official installable available for Windows OS. To install redis on Windows OS, follow the instruction given in https://chocolatey.org/packages/redis-64

3. Once installed, set the below property in egov-erp-override.properties or egov-erp-<username>.properties.

## true by default
redis.enable.embedded=false

to control the redis server host and port use the following property values (only required if installed with non default).

## Replace <your_redis_server_host> with your redis host, localhost by default
redis.host.name=<your_redis_server_host>
## Replace <your_redis_server_port> with your redis port, 6379 by default
redis.host.port=<your_redis_server_port>

Deploying Application

Configuring JBoss Wildfly

1. Download and unzip the customized JBoss Wildfly Server from here. This server contains some additional jars that are required for the ERP.
2. In case properties needs to be overridden, edit the below file (This is only required if egov-erp-<username>.properties is not present)

<JBOSS_HOME>/modules/system/layers/base/

org
└── egov
  └── settings
    └── main
        ├── config
        │   └── egov-erp-override.properties
        └── module.xml

3. Update settings in standalone.xml under <JBOSS_HOME>/standalone/configuration

• Check Datasource setting is in sync with your database details.

<connection-url>jdbc:postgresql://localhost:5432/<YOUR_DB_NAME></connection-url>
<security>
  <user-name><YOUR_DB_USER_NAME></user-name>
  <password><YOUR_DB_USER_PASSWORD></password
</security>

• Check HTTP port configuration is correct in

<socket-binding name="http" port="${jboss.http.port:8080}"/>

4. Change directory back to <CLONED_REPO_DIR>/egov/dev-utils/deployment/ and run the below command

$  chmod +x deploy.sh
$ ./deploy.sh

Alternatively this can be done manually by following the below steps.

• Copy the generated exploded ear <CLONED_REPO_DIR>/egov/egov-ear/target/egov-ear-<VERSION>.ear in to your JBoss deployment folder <JBOSS_HOME>/standalone/deployments
• Create or touch a file named egov-ear-<VERSION>.ear.dodeploy to make sure JBoss picks it up for auto deployment

5. Start the wildfly server by executing the below command

 $ cd <JBOSS_HOME>/bin/
 $ nohup ./standalone.sh -b 0.0.0.0 &

In Mac OSx, it may also required to specify -Djboss.modules.system.pkgs=org.jboss.byteman

-b 0.0.0.0 only required if application accessed using IP address or domain name.

6. Monitor the logs and in case of successful deployment, just hit http://localhost:<YOUR_HTTP_PORT>/egi in your favorite browser.
7. Login using username as egovernments and password demo

Accessing the application using IP address and domain name

This section is to be referred only if you want the application to run using any ip address or domain name.

1. To access the application using IP address:

• Have an entry in eg_city table in database with an IP address of the machine where application server is running (for ex: domainurl="172.16.2.164") to access application using IP address.
• Access the application using an url http://172.16.2.164:8080/egi/ where 172.16.2.164 is the IP and 8080 is the port of the machine where application server is running.

2. To access the application using domain name:

• Have an entry in eg_city table in database with domain name (for ex: domainurl= "www.egoverpphoenix.org") to access application using domain name.
• Add the entry in hosts file of your system with details as 172.16.2.164 www.egoverpphoenix.org (This needs to be done both in server machine as well as the machines in which the application needs to be accessed since this is not a public domain).
• Access the application using an url http://www.egoverpphoenix.org:8080/egi/ where www.egoverpphoenix.org is the domain name and 8080 is the port of the machine where application server is running.

Always start the wildfly server with the below command to access the application using IP address or domain name.

 nohup ./standalone.sh -b 0.0.0.0 &

Developer Guide

This section gives more details regarding developing and contributing to eGov suit.

Repository Structure

egov - folder contains all the source code of eGov opensource projects

Check out sources

git clone [email protected]:egovernments/egov-coexistence.git or git clone https://github.com/egovernments/egov-coexistence.git

Prerequisites

• Install your favorite IDE for java project. Recommended Eclipse or IntelliJ IDEA
• Install maven >= v3.2.x
• Install PostgreSQL >= v9.4
• Install Elastic Search >= v2.4.x
• Install Jboss Wildfly v10.x
• Install Git 2.8.3
• Install JDK 8 update 112 or later

Note: Please check in eGov Tools Repository for any of the above software installables before downloading from internet.

1. Eclipse Deployment

• Install Eclipse Mars Eclipse Mars
• Import the cloned git repo using maven Import Existing Project.
• Install Jboss Tools and configure Wildfly Server.
• Since jasperreport related jar's are not available in maven central, we have to tell eclipse to find jar's in alternative place for that navigate to Windows -> Preference -> Maven -> User Settings -> Browse Global Settings and point settings.xml available under egov-erp/
• Now add your EAR project into the configured Wildfly server.
• Install the lombok plugin in eclipse. Download from this link https://search.maven.org/search?q=g:org.projectlombok%20AND%20a:lombok&core=gav and run the commond java -jar lombok-1.18.4.jar
• Start Wildfly in debug mode, this will enable hot deployment.

2. Intellij Deployment

• Install Intellij
• Open project
• In project settings set JDK to 1.8
• Add a run configuration for JBoss and point the JBOSS home to the wildfly unzipped folder
• Add lombok plugin in Intellij (marketplace -> plugin -> lombok -> install -> restart ide).
• Run

3. Database Migration Procedure

• Any new sql files created should be added under directory <CLONED_REPO_DIR>/egov/egov-<javaproject>/src/main/resources/db/migration
• Core product DDL and DML should be added under <CLONED_REPO_DIR>/egov/egov-<javaproject>/src/main/resources/db/migration/main
• Core product sample data DML should be added under <CLONED_REPO_DIR>/egov/egov-<javaproject>/src/main/resources/db/migration/sample
• All sql scripts should be named with following format.
• Format V<timestamp-in-YYYYMMDDHHMMSS-format>__<module-name>_<description>.sql
• DB migration will automatically happen when application server starts, incase required while maven build use the above given maven command.

Migration file name sample

V20150918161507__egi_initial_data.sql

For more details refer Flyway

Note: This system is supported

OS:-

• Linux (Recommended)
• Mac
• Windows (If Redis server standalone installed).

Browser:-

• Chrome (Recommended)
• Firefox
• Internet Explorer