Ubik Batch Server Installation Guide

From UbikWiki

(Difference between revisions)
(Cold deployment)
Current revision (20:38, 20 September 2012) (edit) (undo)
(Step 11 : Environment parameters)
 

(19 intermediate revisions not shown.)

Line 91:

Line 91:

[[Image:UBS_LOGGING.png|center]]
[[Image:UBS_LOGGING.png|center]]
-
==== Step 9: Mailer configuration ====
+
==== Step 9: Connectivity to Mail Server configuration ====
-
This step is for configuring the Mail notification system. Each time an error occurs a mail will be sent using the configured parameters.
+
This step is for configuring the connection to Mail server
Fill in:
Fill in:
* Host of the mailer: Host of the Mail server
* Host of the mailer: Host of the Mail server
* Port of the mailer: Port of the Mail server (defaults to 25)
* Port of the mailer: Port of the Mail server (defaults to 25)
 +
* Username: Mail used to login the Mail server
 +
* Password: Password used to login the Mail server
 +
* Use SSL: Use SSL
 +
* Use TLS: Use TLS
 +
[[Image:UBS_MailServer_01.png|center]]
 +
 +
 +
[[Image:UBS_MailServer_02.png|center]]
 +
 +
==== Step 10: Mailer configuration ====
 +
This step is for configuring the Mail notification system. Each time an error occurs a mail will be sent using the configured parameters.
 +
* Name of the mailer : Name the will appear in Mails
* Name of the mailer : Name the will appear in Mails
* Mail of administrator: Mail of the technical administrator (used only if XML storage is chosen)
* Mail of administrator: Mail of the technical administrator (used only if XML storage is chosen)
-
[[Image:UBS_MailServer.png|center]]
 
-
==== Step 10 : Environment parameters ====
+
[[Image:UBS_Mailer.png|center]]
 +
 
 +
==== Step 11 : Environment parameters ====
This step is for configuring environment parameters, it will generate a setenv.bat (for Windows) and setenv.sh (for Linux)
This step is for configuring environment parameters, it will generate a setenv.bat (for Windows) and setenv.sh (for Linux)
Fill in:
Fill in:
* Name of the NT service (Identifies the NT service) (Used only on Windows operating system)
* Name of the NT service (Identifies the NT service) (Used only on Windows operating system)
-
* JAVA_HOME: It must be a JDK 5
+
* JAVA_HOME:
 +
** For Version < 6.0.0 : It must be a JDK 5
 +
** For Version >= 6.0.0 : It must be a JDK 6 or 7
* JVM options: You may change –Xmx and –Xms and add other properties.
* JVM options: You may change –Xmx and –Xms and add other properties.
Set also:
Set also:
-
** -XX:MaxPermSize=128m
+
** -XX:MaxPermSize=128m (or more if you have many BARs or redeployments)
** -XX:+HeapDumpOnOutOfMemoryError
** -XX:+HeapDumpOnOutOfMemoryError
** -XX:HeapDumpPath=<path to logging folder>
** -XX:HeapDumpPath=<path to logging folder>
 +
** -XX:+CMSClassUnloadingEnabled
 +
** -XX:+CMSPermGenSweepingEnabled
[[Image:UBS_ENVIRONMENT.png|center]]
[[Image:UBS_ENVIRONMENT.png|center]]

Line 123:

Line 140:

[[Image:image013.png|center]]
[[Image:image013.png|center]]
-
*Click on Install:
+
*Click on Install
-
 
+
-
[[Image:image014.png|center]]
+
=== Installing from properties file ===
=== Installing from properties file ===

Line 228:

Line 243:

-
==== Copy all common libraries to folder <INSTALL_DIR>\business\lib ====
+
==== (For versions < 6.0.0)Copy all common libraries to folder <INSTALL_DIR>\business\lib ====
=== Test installation ===
=== Test installation ===

Line 357:

Line 372:

=== Database connectivity ===
=== Database connectivity ===
<nowiki>This configuration is in file <INSTALL_DIRECTORY>/config/datasource.xml</nowiki>
<nowiki>This configuration is in file <INSTALL_DIRECTORY>/config/datasource.xml</nowiki>
 +
 +
This configuration can be modified by 2 ways:
 +
* From BatchAdmin webapp with menu:
 +
** Configuration > JDBC Pools
 +
 +
* By editing directly the XML file (see below) and adding name/value, parameters follow Commons-DBCP naming:
 +
See [http://commons.apache.org/dbcp/configuration.html Commons-DBCP configuration]
 +
==== File Format ====
 +
 +
Configuration has the following format:
 +
 +
<source lang="xml">
 +
<?xml version="1.0" encoding="UTF-8"?>
 +
<!DOCTYPE drivers
 +
PUBLIC "-//Salto-consulting //DTD JDBC Datasource Configuration 1.0//EN"
 +
"http://www.salto-consulting.com/consolebatch/config/datasource.dtd">
 +
<drivers>
 +
<ResourceParams name="jdbc/NAME_OF_YOUR_CHOICE">
 +
<parameter>
 +
<name>username</name>
 +
<value>loginToDB</value>
 +
</parameter>
 +
...
 +
</ResourceParams>
 +
</drivers>
 +
</source>
=== Mailer connectivity ===
=== Mailer connectivity ===

Line 364:

Line 405:

-
==== Configuration parameters: ====
+
===== Configuration parameters: =====
-
{| class="prettytable"
+
{|
| Parameter
| Parameter
| Description
| Description
| Default Value
| Default Value
 +
| Since
|-
|-

Line 375:

Line 417:

| Host of the Mail Server
| Host of the Mail Server
|
|
 +
| 4.0.X
 +
 +
|-
 +
| Mailer
 +
| Name that will appear in Sent mails
 +
|
 +
| 4.0.X
|-
|-

Line 380:

Line 429:

| Port of the Mail Server
| Port of the Mail Server
| 25
| 25
 +
| 4.0.X
|-
|-
-
| Mailer
+
| useTLS
-
| Name that will appear in Sent mails
+
| boolean
|
|
 +
| 5.1.X
-
|}
 
-
=== Logging configuration ===
 
-
<nowiki>This configuration is in file <INSTALL_DIRECTORY>/config/log.properties.</nowiki>
 
- 
-
Logging is based on Log4j, and this file controls the Server log level. Batch Logging configuration is hosted in each BAR
 
- 
- 
-
See [http://logging.apache.org/log4j/docs/manual.html http://logging.apache.org/log4j/docs/manual.html]
 
- 
- 
- 
- 
-
= Batch Administration Webapp: =
 
-
This section explains the installation of the Web application that controls one or more Batch Servers.
 
- 
-
The application comes as a standard EAR to deploy on J2EE 1.3 or J2EE 1.4 server.
 
- 
-
Configuration includes:
 
-
* Creating the application Database (Separated from Batch Server database)
 
-
* Configuring the BAR Upload directory used by this application, this directory holds the BARs that are further sent to one or more batch servers. This directory must be different from directories used by the Batch Servers
 
-
* Once installed, add batch servers to make them visible for administration
 
-
== Database configuration: ==
 
-
=== Create the Database ===
 
-
Run the script adapted to your database, all databases supported by Hibernate can be used:
 
-
* DB2
 
-
* Oracle 9i
 
-
* Oracle 10G
 
-
* Sql Server 2005
 
-
* Postgres 8.x.x
 
-
* MySQL
 
-
* ...
 
- 
-
====Optional since 5.1.0.0:====
 
-
''Run the following script in the Database of BatchAdmin:
 
-
<source lang="sql">
 
-
INSERT INTO parameter(par_context, par_id, par_value, par_description, par_date_upd, par_user_upd, par_date_crt, par_user_crt)
 
-
VALUES ('BAR_UPLOAD', 'DIRECTORY', '<PATH TO BAR UPLOAD DIRECTORY>',
 
-
'Directory where uploaded BARs in deployment will be stored', SYSDATE, 'PMD', SYSDATE, 'PMD');
 
- 
-
INSERT INTO parameter(par_context, par_id, par_value, par_description, par_date_upd, par_user_upd, par_date_crt, par_user_crt)
 
-
VALUES ('CONSOLE_SERVICE', 'IMPLEMENTATION', 'com.ubikingenierie.console.connect.service.JMX',
 
-
'Service implementation type', SYSDATE, 'PMD', SYSDATE, 'PMD');
 
-
commit;
 
-
</source>
 
-
''
 
-
Where <nowiki><PATH TO BAR UPLOAD DIRECTORY></nowiki> is the path to a directory where BARs will be uploaded before deployment on servers (This is NOT the same one as the directory used by the BATCH Server)
 
- 
-
== Available roles ==
 
- 
-
{| class="prettytable"
 
-
| Task name
 
-
| Role
 
-
| Description
 
|-
|-
-
| DEPLOY
+
| useSSL
-
| ADMINISTRATOR
+
| boolean
-
| Ability to deploy/undeploy/redeploy a BAR
+
|
-
|-
+
| 5.1.X
-
| DURATION_CONFIGURATION
+
-
| ADMINISTRATOR, SUPERVISOR
+
-
| Ability to set max duration limits of a Batch
+
-
|-
+
-
| MAIL_CONFIGURATION
+
-
| ADMINISTRATOR, SUPERVISOR
+
-
| Ability to add/remove Mail recipients
+
-
|-
+
-
| MANAGE_CONSOLES
+
-
| ADMINISTRATOR
+
-
| Add, Remove, Update a Console connection in the BatchAdmin application and Start/Stop a Server
+
-
|-
+
-
| MANAGE_LOGGING
+
-
| ADMINISTRATOR, SUPERVISOR
+
-
| Ability to view loggers, change log levels
+
-
|-
+
-
| MANAGE_BATCHES
+
-
| ADMINISTRATOR, SUPERVISOR
+
-
| Ability to modify Batches configuration,
+
-
|-
+
-
| MANAGE_LAUNCHES
+
-
| ADMINISTRATOR, SUPERVISOR
+
-
| Ability to manage Launches configuration, Add/Remove Cron Triggers
+
-
|-
+
-
| MANAGE_LINKERS
+
-
| ADMINISTRATOR, SUPERVISOR
+
-
| Ability to see Linkers
+
-
|-
+
-
| MANAGE_TRIGGERS
+
-
| ADMINISTRATOR, SUPERVISOR
+
-
| Ability to Add/Remove/Modify Cron Triggers
+
-
|-
+
-
| POOL_CONFIGURATION
+
-
| ADMINISTRATOR
+
-
| Ability to add/remove/update a Pool
+
-
|-
+
-
| POOL_VIEW
+
-
| ADMINISTRATOR, SUPERVISOR, GUEST
+
-
| View Pools configuration
+
-
|-
+
-
| RESUME_PAUSE_CONSOLES
+
-
| ADMINISTRATOR
+
-
| Resume or pause a Batch server
+
-
|-
+
-
| STOP_CONSOLES
+
-
| ADMINISTRATOR
+
-
| Stop a Batch server
+
-
|-
+
-
| VIEW_BATCH_ERRORS
+
-
| ADMINISTRATOR, SUPERVISOR, GUEST
+
-
| Ability to see Batch Errors and History
+
-
|-
+
-
| VIEW_DEPLOY
+
-
| ADMINISTRATOR, SUPERVISOR, GUEST
+
-
| View Deployment History
+
-
|-
+
-
| VIEW_NEXT_EXECUTIONS
+
-
| ADMINISTRATOR, SUPERVISOR, GUEST
+
-
| View Next batches executions
+
-
|-
+
-
| VIEW_PREVIOUS_EXECUTIONS
+
-
| ADMINISTRATOR, SUPERVISOR, GUEST
+
-
| View Previous batches executions
+
-
|-
+
-
| VIEW_SCHEDULING
+
-
| ADMINISTRATOR, SUPERVISOR, GUEST
+
-
| Ability to see Running Batches
+
-
|-
+
-
| VIEW_INDICATORS
+
-
| ADMINISTRATOR, SUPERVISOR, GUEST
+
-
| View Servers Memory state and pools state
+
-
|-
+
-
| VIEW_SYSTEM_PROPERTIES
+
-
| ADMINISTRATOR
+
-
| View Server JVM properties
+
-
|-
+
-
| VIEW_THREAD_DUMP
+
-
| ADMINISTRATOR, SUPERVISOR, GUEST
+
-
| View Server Thread Dump
+
-
|}
+
-
 
+
-
== Deploy the EAR batchadmin-XXX.ear. ==
+
-
=== Map the pools: ===
+
-
 
+
-
{| class="prettytable"
+
-
| Logical Name
+
-
| Description
+
|-
|-
-
| jdbc/console
+
| user
-
| Repository of the Batch Server
+
| String
 +
| User for mail server authentication if any
 +
| 5.1.X
|-
|-
-
| jdbc/batchadmin
+
| password
-
| Database of the application
+
| String
-
 
+
| Password for mail server authentication if any
-
|-
+
| 5.1.X
-
| jdbc/cbsecurity
+
-
| This pool is used by the internal rights management system, optional if an other security system is used
+
-
 
+
|}
|}
-
== Adding a Batch Server: ==
+
=== Logging configuration ===
-
You must have the role MANAGE_CONSOLES to add a Batch server in the Administration Tool
+
<nowiki>This configuration is in file <INSTALL_DIRECTORY>/config/log.properties.</nowiki>
-
=== Open menu Configuration > Manage Consoles ===
+
Logging is based on Log4j, and this file controls the Server log level. Batch Logging configuration is hosted in each BAR
-
=== Add a Server ===
+
-
Click on [[Image:Image015.png|center]]
+
-
=== Click on Add Console ===
 
-
[[Image:UBS_ADDSERVER.png|center]]
 
-
=== Fill this form ===
+
See [http://logging.apache.org/log4j/docs/manual.html http://logging.apache.org/log4j/docs/manual.html]
-
[[Image:UBS_FILLNBS.png|center]]
+
-
 
+
-
 
+
-
Where the parameters are:
+
-
 
+
-
 
+
-
{| class="prettytable"
+
-
| Parameter
+
-
| Description
+
-
 
+
-
|-
+
-
| Server ID
+
-
| The Console ID that identifies uniquely the Batch Server in DB
+
-
 
+
-
|-
+
-
| JMX URL
+
-
| <nowiki>The JMX URL that was generated in <INSTALL_DIRECTORY>/config/</nowiki>jmx-service-url.txt
+
-
 
+
-
|-
+
-
| JMX User
+
-
| The JMX login
+
-
 
+
-
|-
+
-
| JMX Password
+
-
| The JMX password
+
-
 
+
-
|-
+
-
| Bar Transfer Host
+
-
| The Host where the Batch Server is running
+
-
 
+
-
|-
+
-
| Bar Transfer Port
+
-
| The Port of the Embedded BAR Server
+
-
 
+
-
|-
+
-
| Server Pool
+
-
| The JDBC Pool to the Batch Server repository of the configured Batch Server
+
-
 
+
-
|-
+
-
| Comments
+
-
| A Comment that will appear when you hover over a link
+
-
 
+
-
|}
+
-
 
+
-
=== Finish the Step ===
+
-
Click on '''Add Server'''
+
-
 
+
-
== Authors ==
+
-
* Philippe Mouawad
+
-
 
+
-
== Document History ==
+
-
<pageby/>
+

Current revision


Contents

Requirements

JDK

First, install a JDK.

  • For Version < 6.0.0, the server runs with a JDK 5 or JDK6, ensure you always use the last update of major JDK version:
  • Install JDK in the directory of your choice, the location will be further referenced as <JAVA_HOME>

The installation procedure requires the following elements:

  • LAST_VERSION\installer\ubik-server-installer-6.0.x.jar
  • LAST_VERSION\scripts-sql\schema-<DatabaseType>.ddl

Database

You must have a dedicated schema to the repository server.

  • All databases supported by Hibernate can be used.
  • A repository may be used by more than one Batch Server since a unique ID is associated to each server.

Batch Server Installation steps

Create the Database

Play the script adapted to your database. Supported databases are:

  • DB2
  • Oracle 9i
  • Oracle 10G
  • Sql Server 2005
  • Postgres 8.x.x
  • MySQL
  • ...

Launch the installer

Run the following command line:

<JAVA_HOME>/bin/java –jar <Path_To_Installer>/ubik-server-installer-<VERSION>.jar

This screen will appear

Step 1 (Logo screen)

  • Click on next

Step 2 (Copyright screen)

  • Click on next

Step 3 (License screen)

  • Click on accept

Step 4: Installation Options

Fill in:

  • Installation Directory: Path where the Batch server will be installed
  • ID of the console: This ID must be unique and will be used in database to identify uniquely the Server Batches,…

Step 5: JMX Connectivity

Fill in:

  • JNDI Name of the console: Path where the Batch server will be installed
  • Port of the Naming Service: Check if the chosen port is free (netstat -a)
  • Port of the JMX Service: Check if the chosen port is free (netstat -a)

Step 6: Server Repository Database parameters

Fill in:

  • DB User: User of the Server Repository Database
  • DB Password: Password of the Server Repository Database
  • Class of the JDBC Driver
  • URL of the JDBC Connection (ex : jdbc:oracle:thin:@<Host>:<Port>:<Instance>)

Step 7: Embedded BAR Server Configuration

This step is for configuring the BAR Upload server that is shipped inside the Batch Server. This server receives BARs that are sent by the Batch Admin Web Application Fill in:

  • BARs upload folder : Folder where the BARs will be stored temporarily and then deployed
  • BAR Server Port: Port of the server (check if the port is not used)

Step 8: Batch Server Logging Folder

This step is for configuring the Root Folder for Logs. This folder will be further referenced as a JVM property called LOG_ROOT_PATH Fill in:

  • Logging directory

Step 9: Connectivity to Mail Server configuration

This step is for configuring the connection to Mail server

Fill in:

  • Host of the mailer: Host of the Mail server
  • Port of the mailer: Port of the Mail server (defaults to 25)
  • Username: Mail used to login the Mail server
  • Password: Password used to login the Mail server
  • Use SSL: Use SSL
  • Use TLS: Use TLS


Step 10: Mailer configuration

This step is for configuring the Mail notification system. Each time an error occurs a mail will be sent using the configured parameters.

  • Name of the mailer : Name the will appear in Mails
  • Mail of administrator: Mail of the technical administrator (used only if XML storage is chosen)

Step 11 : Environment parameters

This step is for configuring environment parameters, it will generate a setenv.bat (for Windows) and setenv.sh (for Linux)

Fill in:

  • Name of the NT service (Identifies the NT service) (Used only on Windows operating system)
  • JAVA_HOME:
    • For Version < 6.0.0 : It must be a JDK 5
    • For Version >= 6.0.0 : It must be a JDK 6 or 7
  • JVM options: You may change –Xmx and –Xms and add other properties.

Set also:

    • -XX:MaxPermSize=128m (or more if you have many BARs or redeployments)
    • -XX:+HeapDumpOnOutOfMemoryError
    • -XX:HeapDumpPath=<path to logging folder>
    • -XX:+CMSClassUnloadingEnabled
    • -XX:+CMSPermGenSweepingEnabled

End installation

  • Click on Next
  • Click on Next
  • Click on Install

Installing from properties file

You have another option if you don’t want to re seize all options on each installation. After each installation, a file called “ant.install.properties” is writed. This file contains all seized properties.

For using this properties file “ant.install.properties” for further installations you have to copy it in the folder from which you launch the installer.

To make the installer use it:

<JAVA_HOME>\bin\java –jar <Path_To_Installer>\ubik-server-installer-<VERSION>.jar text-auto

You will be asked:

Installation configuration found. Load the existing configuration?
  • Answer yes.

Example of a generated “ant.install.properties” file:

### Ant Installer - properties auto generated on Mon\ Aug\ 20\ 09\:45\:32\ CEST\ 2007
 
basedir = D\:\\tmp\\.
ant.install.config.version = 0.0
 
 
## Properties from Page:splash
 
## Properties from Page:intro
 
## Properties from Page:license
 
## Properties from Page:properties
# .DirectoryInput
INSTALL_DIRECTORY = D\:\\console-batch
# .UnvalidatedTextInput
CONSOLE_ID = Console4005
 
## Properties from Page:properties
# .UnvalidatedTextInput
CONSOLE_JNDI_NAME = Console
# .ValidatedTextInput
NAMING_SERVICE_PORT = 5001
# .ValidatedTextInput
JMX_SERVICE_PORT = 5002
 
## Properties from Page:selector
# .UnvalidatedTextInput
DB_USER = console_batch4
# .UnvalidatedTextInput
DB_PASSWORD = console_batch4
# .LargeSelectInput
DB_DRIVER_CLASS = oracle.jdbc.OracleDriver
# .UnvalidatedTextInput
DB_URL = jdbc\:oracle\:thin\:@<DB Host>\:1529\:<DB INSTANCE>
 
## Properties from Page:properties
# .UnvalidatedTextInput
BAR_SERVER_HOST = localhost
# .ValidatedTextInput
BAR_TRANSFER_PORT = 5003
# .DirectoryInput
BAR_UPLOAD_DIRECTORY = D\:\\console-batch\\bar-upload-directory
 
## Properties from Page:properties
# .DirectoryInput
LOG_DIRECTORY = D\:\\console-batch\\logs
 
## Properties from Page:properties
# .UnvalidatedTextInput
MAIL_HOST = <Mailer IP>
# .ValidatedTextInput
MAIL_PORT = 25
# .UnvalidatedTextInput
MAILER_NAME = CB4005
# .UnvalidatedTextInput
ADMINISTRATOR_MAIL = admin@foo.com
# .SelectInput
MAIL_MANAGER_TYPE = salto.batch.system.MailManagerDBStore
 
## Properties from Page:properties
# .UnvalidatedTextInput
SERVICE_NAME = ubik-batcher
# .DirectoryInput
JAVA_HOME = D\:\\JDKs\\jdk1.5.0_12
# .UnvalidatedTextInput
JAVA_OPTS = -Xms256M -Xmx512M -XX\:MaxPermSize\=128m -DLOG_ROOT_PATH\=D\:\\console-batch\\logs
 
## Properties from Page:selector
# .TargetInput
install = true
# Targets selected for page
selector-targets = install,
 
## Properties from Page:progress
# Targets selected for page
progress-targets = cleanuptarget,

After installation

(For versions < 6.0.0)Copy all common libraries to folder <INSTALL_DIR>\business\lib

Test installation

  1. Go to <INSTALL_DIRECTORY>/bin
  2. Run console.bat or console.sh
  3. The JMX URL will be written in <INSTALL_DIRECTORY>/config/jmx-service-url.txt
  4. If the server does not stop, your installation is OK. You can now register the service by running:
<INSTALL_DIRECTORY>/bin/installConsoleBatchService.bat
  1. If the server stops, see errors logs

Batch Server Uninstallation steps:

Go to <INSTALL_DIRECTORY>/bin

Run uninstallConsoleBatchService.bat

Batch Server Configuration options:

General configuration

This configuration is in file <INSTALL_DIRECTORY>/config/config.properties

Configuration parameters:

Paramter Description Default Value
CONSOLE_ID Unique ID Of the Batch Server See 1.2.2.4
INSTALL_DIR <INSTALL_DIRECTORY> See 1.2.2.4
com.salto.console.PLUGIN_MANAGER_STORE Type of storage for Plugins configuration salto.batch.system.PluginManagerXMLStore
PLUGIN_MANAGER_FILE Path to the file that contains general plugin <INSTALL_DIRECTORY>/config/plugin-manager.xml
LOCK_DIR
CONFIG_ROOT Path to configuration Folder <INSTALL_DIRECTORY>/config
CONFIG_ROOT_BATCH Not Used
CONFIG_DATA Not Used
OUTPUT_DATA Folder used temporarily for Mail Generation and Lifecycle state <INSTALL_DIRECTORY>/output
USER_FILE File that host JMX Authentication informations
com.salto.console.MAIL_MANAGER_STORE Type of Storage for Mail Manager salto.batch.system.MailManagerDBStore (see 1.2.2.9)
MAIL_MANAGER_FILE Used only if Storage is XML
JMX_HTTP_ADAPTOR_PORT Port of the HTTP JMX adaptor if ACTIVATE_HTTP_ADAPTOR is true
ACTIVATE_HTTP_ADAPTOR JMX interface that exposes Operations in a Browser (Do not activate in PRODUCTION) false

JMX connectivity

This configuration is in file <INSTALL_DIRECTORY>/config/config.properties

This configuration is done by Wizard Installer (see 1.2.2.5)

Configuration parameters:

Paramter Description
JNDI_NAME JNDI Name that will appear at the end of the JMX URL
JMX_SERVICE_PORT JMX Port that will appear in the URL (It must be free)
NAMING_SERVICE_PORT Naming service Port

that will appear in the URL (It must be free)

service:jmx:rmi://<HOST OF THE MACHINE>:<JMX_SERVICE_PORT>/jndi/rmi:// <HOST OF THE MACHINE>:<NAMING_SERVICE_PORT>/<JNDI_NAME>

Database connectivity

This configuration is in file <INSTALL_DIRECTORY>/config/datasource.xml

This configuration can be modified by 2 ways:

  • From BatchAdmin webapp with menu:
    • Configuration > JDBC Pools
  • By editing directly the XML file (see below) and adding name/value, parameters follow Commons-DBCP naming:

See Commons-DBCP configuration

File Format

Configuration has the following format:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE drivers 
PUBLIC "-//Salto-consulting //DTD JDBC Datasource Configuration 1.0//EN" 
"http://www.salto-consulting.com/consolebatch/config/datasource.dtd">
<drivers>
  <ResourceParams name="jdbc/NAME_OF_YOUR_CHOICE">
    <parameter>
      <name>username</name>
      <value>loginToDB</value>
    </parameter>
    ...
  </ResourceParams>
</drivers>

Mailer connectivity

This configuration is in file <INSTALL_DIRECTORY>/config/mail.xml.

This configuration is done by Wizard Installer (see 1.2.2.9)


Configuration parameters:
Parameter Description Default Value Since
mailHost Host of the Mail Server 4.0.X
Mailer Name that will appear in Sent mails 4.0.X
mailPort Port of the Mail Server 25 4.0.X
useTLS boolean 5.1.X
useSSL boolean 5.1.X
user String User for mail server authentication if any 5.1.X
password String Password for mail server authentication if any 5.1.X

Logging configuration

This configuration is in file <INSTALL_DIRECTORY>/config/log.properties.

Logging is based on Log4j, and this file controls the Server log level. Batch Logging configuration is hosted in each BAR


See http://logging.apache.org/log4j/docs/manual.html

Personal tools