aSET
Installing aSET, the estimation and calculation system for seismic and vibration isolation products, on GlassFish and MySQL.
Seismo Seismic Engineering System product pageIntroduction
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
Technical Document
Download the technical document (PDF)
Installation
Prerequisites
- Debian is a free operating system (OS) for your computer. Download Debian
- Java Platform is to develop and deploy Java applications on desktops and servers. Download Java SDK
- Eclipse GlassFish is the Open Source Java EE Reference Implementation. Eclipse GlassFish Documentation and User Guides
- MySQL is the most popular open source database. Download MySQL
- MySQL Connector/J is the official JDBC driver for MySQL. Download MySQL Connector/J
Install
Debian operating system is pre-installed. To update and upgrade it
# 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 upgradeTo install Java
# install jdk$ apt-get install default-jdk# check version$ java -versionTo download and install Glassfish application server
# 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 /optTo install MySQL
# Install MySQL$ apt-get install mysql-server# Improve MySQL installation security$ mysql_secure_installation# check version$ mysql --versionTo download and install MySQL Connector/J
# 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
# 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 installSetup
Set server time as GMT for the UK. Check out World Clock / Converter
To change time zone, run
$ dpkg-reconfigure tzdataTo change locale
$ nano /etc/locale.genUncomment tr_TR.UTF-8 UTF-8 line, and run below to activate locale
$ locale-genCreate MySQL database and user
$ mysqlmysql> 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
$ mysql -u aset -p aset < /path/to/aset.sqlDrop MySQL tables if database is not empty
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
$ nano /opt/glassfish5/glassfish/domains/domain1/config/domain.xmlFind 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
$ asadmin start-domain domain1Define resources to Glassfish using asadmin tool
-
Create a JDBC resource with the specified JNDI name
$ asadmin> help create-jdbc-resourcefor help$ asadmin> create-jdbc-resource --connectionpoolid aset_pool --enabled=true jdbc/asetCommand create-jdbc-resource executed successfully. -
Register a JDBC connection pool
$ asadmin> help create-jdbc-connection-poolfor 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_poolCommand create-jdbc-connection-pool executed successfully.
Add the named authentication realm to Glassfish using asadmin tool
$ asadmin> help create-auth-realm for help
$ 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: