Property file has information necessary to boot application, and meta database connection information.
To manually change on configuation property file, follow steps bellow. Open the following file on editor.
{app_home}/config/amplix.properties
Update [META_DATABASE] section with meta database connection information.
|
Secured Database password management
On booting time, database connection password, email automatically encrypted and the value changes to starting {ENC} and followed encrypted codes.
This protects and secure important database configuration information from leaking outside.
|
Configuration file
Sectional parameters on configuration file.
Details on configuration nodes is as follows:
[META_DATABASE] section
|
Parameter
|
Description
|
Default Value
|
Notes
|
|
connection_method
|
Connecion pool method selection
|
Tomcat Connection Pool
|
|
|
connectionpool
|
|
|
|
|
autocommit
|
|
|
|
|
maxpoolsize
|
|
|
|
|
monitor
|
|
|
|
[META_DATABSE] JDBC connection information
|
Parameter
|
Description
|
Default value
|
Notes
|
|
databasetype
|
mysql / oracle / apacheembd / postgress / mssql
db2 / as400 / sybase_iq
|
|
|
|
jdbcdriver
|
com.mysql.jdbc.Driver
|
|
|
|
jdbcurl
|
jdbc:mysql://localhost/bo_dev_01
|
|
|
|
userid
|
|
|
|
|
password
|
|
|
|
|
userowlimit
|
|
|
|
|
validatesql
|
|
|
|
Configuration file information and structure
Bellow is example amplix.properties file.
Password information on database connection, email password is automatically encrypted with application startup. After changing configuration file, need to restart web application server to reflect the changes on server.
|
[META_DATABASE]
############################################################################
# database general settings
############################################################################
connection_method = "tomcat_dbcp"
connectionpool = true
autocommit = true
maxpoolsize = 20
monitor = false
# data base connection information only system applies first matching values
# password is automatically encrypted after server startup
databasetype="mysql"
jdbcdriver="com.mysql.jdbc.Driver"
jdbcurl="jdbc:mysql://localhost/bo_dev_01"
userid="root"
password = "Your password"
validatesql="select 1"
#automatically ignores bellow. delete settings after leaving top node
##--------------------------------------------------------------------------
databasetype="oracle"
jdbcdriver="oracle.jdbc.OracleDriver"
jdbcurl="jdbc:oracle:thin:@localhost:1521:orcl"
userid=
password=
schemaname=
validatesql="select 1 from dual"
databasetype="apacheembd"
jdbcdriver="org.apache.derby.jdbc.EmbeddedDriver"
jdbcurl="jdbc:derby:c:/workspace/metadata;create=true"
userid=
password=
schemaname=
validatesql="select 1 from sysibm.sysdummy1"
databasetype="oracle"
jdbcdriver="oracle.jdbc.OracleDriver"
jdbcurl="jdbc:oracle:thin:@localhost:1521:orcl"
userid=
password=
schemaname=
validatesql="select 1 from dual"
databasetype="postgresql"
jdbcdriver="org.postgresql.Driver"
jdbcurl="jdbc:postgresql://localhost:5432/dbname"
userid=
password=
schemaname=
validatesql="select 1"
##--------------------------------------------------------------------------
[APPLICATION]
############################################################################
# Application specific settings
############################################################################
appliction.mainpage.mdi = "../launcher/analytics.jsp"
appliction.mainpage.dashboard = "../launcher/dashboard.jsp"
[SCHEDULE_SERVER]
############################################################################
# Scheduler server information
############################################################################
acceptcount = 10
defaultlocale = "en_US"
idletimeout = 0
ignore_error = false
maxthreads = 30
minthreads = 0
port = 4504
serverhost = 127.0.0.1
servername = "mecsvr"
session_expire = 600
defaultdateformat = "''yy-MM-dd hh:mm:ss a"
[SERVER_BOOT_CONFIG]
############################################################################
# Apache embedded boot server configuration
############################################################################
server_port = 8280
server_protocol = HTTP
https_keyalias = keyAlias
https_keystore_pass = "changeit"
https_keystore_file = "keystore.jks"
https_ssl_protocol = TLS
context_root = "/"
shutdown_port = 6680
|
Start tomcat server with command.
$TOMCAT/bin/startup.bat
or unix machine
$TOMCAT/bin/startup.sh
Open web browser and connect to URL:
http://localhost:8080/amplix/
|