Skip to content

aSET

Installing aSET, the estimation and calculation system for seismic and vibration isolation products, on GlassFish and MySQL.

Seismo Seismic Engineering System product page

Introduction

aSET is a system that provides estimation and calculation modules for selecting products for seismic and vibration isolation applications.

Estimation and calculation modules include non-structural and structural seismic engineering, vibration isolation and acoustical control.

This user manual is to help you maintain, update and use the relevant application easily and quickly. You’ll find detailed screenshots, explanations and instructions on how to manage it.

Version 2.6

aripd.com

Technical Document

Download the technical document (PDF)

Installation

Prerequisites

Install

Debian operating system is pre-installed. To update and upgrade it

Terminal window
# update the list of available packages and their versions, it does not install or upgrade any packages.
$ apt-get update
# install newer versions of the installed packages
$ apt-get upgrade

To install Java

Terminal window
# install jdk
$ apt-get install default-jdk
# check version
$ java -version

To download and install Glassfish application server

Terminal window
# Download Glassfish on Maven Central
$ wget https://repo1.maven.org/maven2/org/glassfish/main/distributions/glassfish/5.1.0/glassfish-5.1.0.zip
# Install unzip and then unzip Glassfish
$ apt-get install unzip
$ unzip glassfish-5.1.0.zip -d /opt

To install MySQL

Terminal window
# Install MySQL
$ apt-get install mysql-server
# Improve MySQL installation security
$ mysql_secure_installation
# check version
$ mysql --version

To download and install MySQL Connector/J

Terminal window
# Download MySQL Connector/J and copy it to Glassfish external libraries directory
$ wget https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.21/mysql-connector-java-8.0.21.jar -P /opt/glassfish5/glassfish/domains/domain1/lib/

To install the application

Terminal window
# Clone the application
$ apt-get install git
$ git clone https://bitbucket.org/aripd/aset.git
# Compile the application
$ cd aset
$ apt-get install maven
$ mvn clean install

Setup

Set server time as GMT for the UK. Check out World Clock / Converter

To change time zone, run

Terminal window
$ dpkg-reconfigure tzdata

To change locale

Terminal window
$ nano /etc/locale.gen

Uncomment tr_TR.UTF-8 UTF-8 line, and run below to activate locale

Terminal window
$ locale-gen

Create MySQL database and user

Terminal window
$ mysql
mysql> CREATE DATABASE aset CHARACTER SET utf8 COLLATE utf8_general_ci;
mysql> CREATE USER aset@localhost IDENTIFIED BY '<DB_PASSWORD>';
mysql> GRANT ALL PRIVILEGES ON aset.* TO aset@localhost;
mysql> FLUSH PRIVILEGES;

Create MySQL tables if initial sql file is ready

Terminal window
$ mysql -u aset -p aset < /path/to/aset.sql

Drop MySQL tables if database is not empty

Terminal window
mysql> USE aset;
mysql> DROP TABLE IF EXIST products_recommendeds;
mysql> DROP TABLE IF EXIST FORMULAENTITY;
mysql> DROP TABLE IF EXIST PROPOSALITEMENTITY;
mysql> DROP TABLE IF EXIST PROPOSALENTITY;
mysql> DROP TABLE IF EXIST PRODUCTENTITY;
mysql> DROP TABLE IF EXIST USERENTITY;

Edit domain.xml to change port and application context root

Terminal window
$ nano /opt/glassfish5/glassfish/domains/domain1/config/domain.xml

Find http-listener-1 and change the value from 8080 to 80

<network-listener protocol="http-listener-1" port="8080"

Find context-root and change the value to “/aset” or ”/”

<application context-root="/aset"

You can now start Glassfish

Terminal window
$ asadmin start-domain domain1

Define resources to Glassfish using asadmin tool

  • Create a JDBC resource with the specified JNDI name

    $ asadmin> help create-jdbc-resource for help

    $ asadmin> create-jdbc-resource --connectionpoolid aset_pool --enabled=true jdbc/aset
    Command create-jdbc-resource executed successfully.
  • Register a JDBC connection pool

    $ asadmin> help create-jdbc-connection-pool for help

    $ asadmin> create-jdbc-connection-pool
    --datasourceclassname com.mysql.jdbc.jdbc2.optional.MysqlXADataSource --restype javax.sql.XADataSource
    --property portNumber=3306:password=<DB_PASSWORD>:user=aset:serverName=localhost:databaseName=aset:connectionAttributes=\;create\\=true aset_pool
    Command create-jdbc-connection-pool executed successfully.

Add the named authentication realm to Glassfish using asadmin tool

$ asadmin> help create-auth-realm for help

Terminal window
$ asadmin> create-auth-realm --classname com.sun.enterprise.security.auth.realm.jdbc.JDBCRealm --property jaas-context="jdbcRealm":datasource-jndi="jdbc/aset":user-table="USERENTITY":user-name-column="EMAIL":password-column="PASSWORD":group-table="USERENTITY":group-name-column="USERGROUP":digest-algorithm="none":digestrealm-password-enc-algorithm="none" "jdbcaset"

Support

Supporting Languages

Currently we support two languages. Default one is English GB. For further languages support please contact with us.

  • English GB (default)
  • Türkçe TR
  • Español ES
  • Français FR
  • Pусский RU

Technologies

Below are core technologies that we use for this project.

  • Operating System: Debian, CentOS
  • Development Platform: Java Enterprise Edition
  • User Interface Framework: Java Server Faces
  • Deployment Server: Oracle Glassfish
  • Database Compatibility: MySQL, MariaDB
  • Reporting Engine: JasperReports

Reports

TBD

Issues

We use Atlassian Bitbucket as our issue tracker, at:

https://bitbucket.org/aripd/aset/jira

Type to search the whole site.