Page tree
    Loading...
Skip to end of metadata
Go to start of metadata

Settings file wcs-manager.properties

Main manager options are in /usr/local/FlashphonerWebCallServer/conf/wcs-manager.properties file.

Setting

Default value

Description

spring.datasource.url

jdbc:h2:C:/tmp/wcs_manager;FILE_LOCK=NO

JDBC URL of the database

spring.datasource.driverClassName

org.h2.Driver

Class of the database driver

spring.datasource.database

org.hibernate.dialect.H2Dialect

SQL dialect used

spring.datasource.username

admin

Username

spring.datasource.password

admin

Password

spring.datasource.ddlMode

update

Should the required tables be created in the database upon the first run

create - create tables

validate - do not create tables, validate integrity

update - do not create tables, update the scheme

spring.jpa.hibernate.ddl-auto

update

Automatically create and fill the database upon start:

create - create

validate - do not create, validate integrity

update - do not create, update the scheme

create-drop - create, drop tables in the end of the session

spring.jpa.hibernate.naming_strategy

org.hibernate.cfg.ImprovedNamingStrategy

Table naming strategy in the database

spring.jpa.database

H2

Database dialect used

spring.jpa.show-sql

true

Show SQL queries to the database.

server.port

9091

The HTTP port, WCS Manager will respond to incoming HTTP requests to.

manager.enable_https

true

Enable HTTPS

manager.https_port

8888

HTTPS port

manager.keystore

wss.jks

SSL certificate store

manager.keystore_password

password

Password to the SSL certificate store

spring.profiles.active

dev

Active profile

dev - if this profile is enabled, WCS Manager will listen for HTTP port and will not require authentication.

production - if this profile is enabled, WCS Manager will listen for HTTPS port and will require Basic-authentication from incoming HTTPS connections.

The profile can be redefined upon server startup as well as other settings. See the Startup options section.

node_api.port

1098

Local WCS Core port WCS Manager will connect using the RMI interface to for data exchange.

node_api.service_name

NodeApi

Name under which WCS Core is registered in the RMI register

node_api.host

localhost

Host the RMI request is addressed to.

rest_template.allow_self_signed

true

Accept self-signed certificated from the Web server when accessing the Web server via HTTPS/REST.

shell.disabled-commands

autoconfig*,beans*,cron*,dashboard*,egrep*,endpoint*,env*,filter*,java*,jmx*,jul*,jvm*,jpa*,jdbc*,jndi*,less*,mail*,metrics*,shell*,sleep*,sort*,system*,thread*,repl*

Filters out unnecessary commands

spring.main.show_banner

false

Show the banner

node.enable_stdout

false

Enable logging of WCS Server to logs/server_stdout.log. /Can be used for debugging.

sun.rmi.dgc.client.gcInterval

36000000000

Sets interval for the garbage collector for the RMI client, in milliseconds. This setting allows you to turn off forced execution of the garbage collector to increase performance of the server

sun.rmi.dgc.server.gcInterval

36000000000

Sets interval for the garbage collector for the RMI server, in milliseconds. This setting allows you to turn off forced execution of the garbage collector to increase performance of the server

stream_stat_persist_data

false

Record stream statistics to the database

server.session-timeout

10

Session timeout, in minutes

loggc

/usr/local/FlashphonerWebCallServer/logs/gc-manager-

Location and prefix of the log file of the garbage collector. The name is constructed as /usr/local/FlashphonerWebCallServer/logs/gc-manager-YYYY-MM-DD_HH-MM.log

manager.rest_redirect_http_port8081Port number to redirect REST API queries from server.port
manager.rest_redirect_https_port8444Port number to redirect REST API queries from manager.https_port

Settings file log4j.properties

This file defines logging settings for WCS Manager. By default, logs of WCS Manager are recorded to flashphoner_manager.log. See the Logging section for advanced settings and logging control.

This file is packed into wcs_manager-1.0.jar file. Use Midnight Commander to change settings - just 'enter' into wcs_manager-1.0.jar file, open log4j.properties file, edit and save changes. Restart WCS for changes to take effect.

Configuring WCS Manager database

Creating a database

By default, WCS Manager uses the embedded H2 database that is created and filled up upon first startup of the WCS server.
Database files are created in the home directory of the WCS server in the 'database' directory.

If the database file does not exist, an attempt to create the database afresh will be made.
If the database file already exists, WCS Manager simply connects to this database.

Filling up the database

The base is filled up with default values (users, groups, applications etc.) only if there is no a super-group record.
In all other cases the contents of the database remain intact.

Migrating to MySQL

MySQL installation and setup

Install MySQL (on CentOS 7 example) with command

rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
yum install mysql-server

Launch MySQL and set root password

/sbin/service mysqld start
/usr/bin/mysqladmin -u root password 'rootpassword'

Log in to MySQL as root

mysql -uroot -prootpassword

Create database and user, grant to the user privileges to the database

create database wcs_db;
create user 'webcallserver'@'localhost' identified by 'password';
grant all privileges on wcs_db.* to 'webcallserver'@'localhost';

WCS configuration

Add the following strings to wcs-manager.properties file

-Dspring.datasource.url=jdbc:mysql://localhost/wcs_db
-Dspring.datasource.driverClassName=com.mysql.jdbc.Driver
-Dspring.datasource.database=org.hibernate.dialect.MySQL5Dialect
-Dspring.datasource.username=webcallserver
-Dspring.datasource.password=password

Where

  • 'wcs_db' is the database name
  • 'webcallserver' and 'password' is user name and password

Restart WCS server

service webcallserver restart

Upon first startup of WCS, set spring.datasource.ddlMode=create in wcs-manager.properties. In this case all required tables will be created automatically. Upon a subsequent run, switch this setting to spring.datasource.ddlMode=validate. As a result connection to the existing database is performed without creating tables.

Data import from H2 to MySQL

Migrating from H2 to MySQL, data exported from H2 database can be imported to MySQL database::

a) using SQL script

mysql -uroot -prootpassword wcs_db < wcs_h2_db.sql;

b) loading data to tables from CSV files:

stop WCS server

service webcallserver stop

log in to MySQL

mysql -uroot -prootpassword

select database

use wcs_db;

load data from CSV file to existing table, e.g.,

LOAD DATA INFILE "/var/lib/mysql-files/STREAM_INFO_3.csv"
REPLACE INTO TABLE stream_info_3
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES;

However, SQL script and CSV files generated by H2 are not fully compatible with MySQL and would have to be changed for importing. E.g., for table STREAM_INFO_3 it would be required to change Boolean values.


  • No labels