Server-Parameter Bis S 39.5. 10

Information

• The command line options can be provided in the form -[option] [value]

Example

• ./planta_server.sh -port 23456 -migrate false -config ./config/sample_configuration.cfg

Possible options

• migrate
• config
• hibernate
• port
• silent
• debug

Notes

• A description of these options is given in the globals.conf documentation.
  
• Providing options in the command line overrides predefined values in globals.conf.

Information

• The command line options can be provided in the form -[option] [value]

Example

• ./planta_server.sh -port 23456 -migrate false -config ./config/sample_configuration.cfg

Possible options

• migrate
• config
• hibernate
• log4j
• port
• silent
• debug

Notes

• A description of these options is given in the globals.conf documentation.
  
• Providing options in the command line overrides predefined values in globals.conf.

Option	Argument	Description
-preload	Port-Number	Starts the server with Preloading on given portnumber (Linux only, Windows-Preloading comes with ppmsd)
-config	Config-File	Overrides path to config-file (default: planta.conf)
-debuglisten	Port-Number	Stops the program execution as early as possible to allow to attach a debugger

Parameter	Possible values	Description
SYS_CU_ERROR_URL	string	URL that is displayed in the Problems in System Customizing message and which links to the appropriate documentation site in PLANTA-Wiki
ENABLE_PY_SERVICE_FUNCTIONS	{0,1}	0: service functions are deactivated 1: (default) service functions are activated
PPMS_LICENSE	string	licence of PLANTA project, default is '000'
Q1CODEPAGE	int	codepage of system database ( 1 (Windows) to use Windows-1252, 2 (Linux) to use ISO885915 (Latin 9))
Q1TYPE	int	type of system database 2: Oracle 4: MSSQL
DEFAULT_LANGUAGE	string (f.ex.: de)	default language for preloading
DEFAULT_CURRENCY	string	default currency for preloading (not used atm)
DEFAULT_COUNTRY	string	default country for preloading (not used atm)
PRELOAD_LANGUAGES	string (f.ex.: en, fr, ru)	additional languages for preloading
DTP_CUSTOMIZING_MODE	{0,1}	When enabled, CU metadata will always be up-to-date and no stale values be used within the session (effectively disables all caching on DTP level). For further information, see here.
ENABLE_COMPRESSION	{0,1}	default 1; allows compressed communication with a recent and correctly configured Client (see NachrichtenKompression for details)
COMPRESSION_LEVEL	{0..9}	default 6; defines the compression level with 0:no compression and 9:best compression

Logging is not configured anymore via planta_server.conf. See logback configuration for the logging configuration.

Parameter	Possible values	Description
SYS_CU_ERROR_URL	string	URL that is displayed in the Problems in System Customizing message and which links to the appropriate documentation site in PLANTA-Wiki
ENABLE_PY_SERVICE_FUNCTIONS	{0,1}	0: service functions are deactivated 1: (default) service functions are activated
LOG_LEVEL	Bitfield	1: error 2: warning 4: info 8: debug
PLANTA_LOG_FLUSH	{0,1}	0: (default) log information are written in larger block (more efective but information can be in log after the while) 1: immediately writes log information into the log files
PLANTA_LOG_INDENT_XML	{0,1}	0: (default) XML information in log will be written without spaces to save the disk space 1: XML information in log will be written with spaces to be better readable
PLANTA_LOG_MTS_LINK_STATISTICS	{0,1}	0: (default) silence 1: MTS will print statistics wrt. how often previous record could be re-used for parent/child linkage, as opposed to a mismatch being detected, forcing to search the proper parent.
PLANTA_LOG_TIMESTAMP	{0,1}	0: (default) there will no time before every record in log file 1: time information is added to every record in log file
PLANTA_LOG_VERBOSE_SQL	{0,1}	0: (default) SQL queries are not formatted 1: SQL queries are formatted to be better readable and with values of parameters in comments
PPMS_LICENSE	string	licence of PLANTA project, default is '000'
Q1CODEPAGE	int	codepage of system database ( 1 (Windows) to use Windows-1252, 2 (Linux) to use ISO885915 (Latin 9))
Q1TYPE	int	type of system database 2: Oracle 4: MSSQL
DEFAULT_LANGUAGE	string (f.ex.: de)	default language for preloading
DEFAULT_CURRENCY	string	default currency for preloading (not used atm)
DEFAULT_COUNTRY	string	default country for preloading (not used atm)
PRELOAD_LANGUAGES	string (f.ex.: en, fr, ru)	additional languages for preloading
DTP_CUSTOMIZING_MODE	{0,1}	When enabled, CU metadata will always be up-to-date and no stale values be used within the session (effectively disables all caching on DTP level).
ENABLE_COMPRESSION NEU	{0,1}	default 1; allows compressed communication with a recent and correctly configured Client (see NachrichtenKompression for details)
COMPRESSION_LEVEL NEU	{0..9}	default 6; defines the compression level with 0:no compression and 9:best compression

Parameter	Possible values	Description
SYS_CU_ERROR_URL NEU	string	URL that is displayed in the Problems in System Customizing message and which links to the appropriate documentation site in PLANTA-Wiki
ENABLE_PY_SERVICE_FUNCTIONS NEU	{0,1}	0: service functions are deactivated 1: (default) service functions are activated
LOG_LEVEL	Bitfield	1: error 2: warning 4: info 8: debug
PLANTA_LOG_FLUSH	{0,1}	0: (default) log information are written in larger block (more efective but information can be in log after the while) 1: immediately writes log information into the log files
PLANTA_LOG_INDENT_XML	{0,1}	0: (default) XML information in log will be written without spaces to save the disk space 1: XML information in log will be written with spaces to be better readable
PLANTA_LOG_MTS_LINK_STATISTICS	{0,1}	0: (default) silence 1: MTS will print statistics wrt. how often previous record could be re-used for parent/child linkage, as opposed to a mismatch being detected, forcing to search the proper parent.
PLANTA_LOG_TIMESTAMP	{0,1}	0: (default) there will no time before every record in log file 1: time information is added to every record in log file
PLANTA_LOG_VERBOSE_SQL	{0,1}	0: (default) SQL queries are not formatted 1: SQL queries are formatted to be better readable and with values of parameters in comments
PPMS_LICENSE	string	licence of PLANTA project, default is '000'
Q1CODEPAGE	int	codepage of system database ( 1 (Windows) to use Windows-1252, 2 (Linux) to use ISO885915 (Latin 9))
Q1TYPE	int	type of system database 2: Oracle 4: MSSQL
DEFAULT_LANGUAGE	string (f.ex.: de)	default language for preloading
DEFAULT_CURRENCY	string	default currency for preloading (not used atm)
DEFAULT_COUNTRY	string	default country for preloading (not used atm)
PRELOAD_LANGUAGES	string (f.ex.: en, fr, ru)	additional languages for preloading
DTP_CUSTOMIZING_MODE	{0,1}	When enabled, CU metadata will always be up-to-date and no stale values be used within the session (effectively disables all caching on DTP level).

Parameter	Possible values	Description
RESTART_BINARY	string	absolute path to binary that ppms executes when it does a restart (default is currently running binary)
BIND_ADDRESS	string	IPv4 address for daemon or forking-server to listen on (default: all network interfaces, as before)
LOG_LEVEL	Bitfield	1: error 2: warning 4: info 8: debug
PLANTA_LOG_FLUSH	{0,1}	0: (default) log information are written in larger block (more efective but information can be in log after the while) 1: immediately writes log information into the log files
PLANTA_LOG_INDENT_XML	{0,1}	0: (default) XML information in log will be written without spaces to save the disk space 1: XML information in log will be written with spaces to be better readable
PLANTA_LOG_MTS_LINK_STATISTICS	{0,1}	0: (default) silence 1: MTS will print statistics wrt. how often previous record could be re-used for parent/child linkage, as opposed to a mismatch being detected, forcing to search the proper parent.
PLANTA_LOG_TIMESTAMP	{0,1}	0: (default) there will no time before every record in log file 1: time information is added to every record in log file
PLANTA_LOG_VERBOSE_SQL	{0,1}	0: (default) SQL queries are not formatted 1: SQL queries are formatted to be better readable and with values of parameters in comments
ORACLE_HOME	string	home directory of the Oracle; only evaluated via xinetd, forking setup needs this inside the global configuration file for the init script
PPMS_LICENSE	string	licence of PLANTA project, default is '000'
Q1CODEPAGE	int	codepage of system database ( 1 (Windows) to use Windows-1252, 2 (Linux) to use ISO885915 (Latin 9))
Q1PATH	string	path to system database
Q1PWD	string	password to system database
Q1TYPE	int	type of system database 2: Oracle 4: MSSQL
Q1USER	string	username to system database
Q1PREFETCH	int	number of records OCI-client fetches at once (default: 256). Further information
Q1TRACE _LEVEL	int	enable oracle server-trace at certain level (default: 0) 0: trace disabled 1, 2: basic trace info (parsing, executes and fetches) 4: include bind information 8: include wait information 12: include binds and waits
DEFAULT_LANGUAGE	string (f.ex.: de)	default language for preloading
DEFAULT_CURRENCY	string	default currency for preloading (not used atm)
DEFAULT_COUNTRY	string	default country for preloading (not used atm)
PRELOAD_LANGUAGES	string (f.ex.: en, fr, ru)	additional languages for preloading
DTP_CUSTOMIZING_MODE	{0,1}	When enabled, CU metadata will always be up-to-date and no stale values be used within the session (effectively disables all caching on DTP level).
VG_BIN	string	Full path to Valgrind Binary (Linux only, otherwise unused)
VG_ARGS	string	Arguments for Valgrind Binary (Linux only, otherwise unused)
PPMS_PREP_INST	int	number of prepared instances for windows pre-spawning (default 5) 0: pre-spawning disable >0: number of prepared instances

Parameter	Possible values	Description
config	path to PLANTA server configuration file
hibernate	path to hibernate configuration file
krb.conf	path to kerberos configuration file
auth.conf	path to authentication configuration file
auth.methods	described here	described here
port	Int	Port the server is listening on for client connections
migrate	Boolean	makes the server run in migration mode (see migration procedure): all obligatory migration packages are then installed
monitoring	Boolean	activation of monitoring interface, default false
monitoring_interface	host name/ip address	interface the web server is bound to; localhost by default
monitoring_port	Int	port number the web server listens at; required parameter (monitoring is implicitely deactivated when no port is configured)
performance_counting NEU	Boolean	false by default; true enables performance counting globally
debug	Boolean	loads a debug version of the python library when set to true - developement option
silent	Boolean	de-/activates some output to standard output and standard error - developement option
timeout	Int	currently without effect

Parameter	Possible values	Description
config	path to PLANTA server configuration file
hibernate	path to hibernate configuration file
krb.conf	path to kerberos configuration file
auth.conf	path to authentication configuration file
auth.methods	described here	described here
port	Int	Port the server is listening on for client connections
migrate	Boolean	makes the server run in migration mode (see migration procedure): all obligatory migration packages are then installed
monitoring NEU	Boolean	activation of monitoring interface, default false
monitoring_interface NEU	host name/ip address	interface the web server is bound to; localhost by default
monitoring_port NEU	Int	port number the web server listens at; required parameter (monitoring is implicitely deactivated when no port is configured)
debug	Boolean	loads a debug version of the python library when set to true - developement option
silent	Boolean	de-/activates some output to standard output and standard error - developement option
timeout	Int	currently without effect

Parameter	Possible values	Description
migrate	Boolean	makes the server run in migration mode (see migration procedure): all obligatory migration packages are then installed
monitoring NEU	Boolean	activation of monitoring interface, default false
debug	Boolean	loads a debug version of the python library when set to true - developement option
silent	Boolean	de-/activates some output to standard output and standard error - developement option
auth.methods	described here	described here
monitoring_interface NEU	host name/ip address	interface the web server is bound to; localhost by default
port	Int	Port the server is listening on for client connections
monitoring_port NEU	Int	port number the web server listens at; required parameter (monitoring is implicitely deactivated when no port is configured)
timeout	Int	currently without effect
auth.conf	path to authentication configuration file
hibernate	path to hibernate configuration file
krb.conf	path to kerberos configuration file
log4j	path to log4j configuration
config	path to PLANTA server configuration file

Parameter	Possible values	Description
log4j	path to log4j configuration
config	path to PLANTA server configuration file
hibernate	path to hibernate configuration file
krb.conf	path to kerberos configuration file
auth.conf	path to authentication configuration file
auth.methods	described here	described here
port	Int	Port the server is listening on for client connections
migrate	Boolean	makes the server run in migration mode (see migration procedure): all obligatory migration packages are then installed
debug	Boolean	loads a debug version of the python library when set to true - developement option
silent	Boolean	de-/activates some output to standard output and standard error - developement option
timeout	Int	currently without effect

Information

• General documentation can be found here.
• Important namespaces for logging are described in the following table:

Namespace	Default level	Description
org.hibernate	WARN	log messages hibernate emits - database interaction/mapping problems are logged here
org.hibernate.SQL	INFO	SQL related messages
com.mchange	WARN	Connection pool related log messages - database connection problems are logged here
org.eclipse.jetty	WARN	web server related messages (internal monitoring interface)
PLANTA namespace
de.planta.server	INFO	PLANTA Server messages
de.planta.server.hibernate	INFO	PLANTA Server messages - hibernate interface related
de.planta.server.hibernate.startup	WARN	PLANTA Server messages - startup/data dictionary related
Special Namespaces
de.planta.server.native	INFO	log messages from the native code
de.planta.server.python	INFO	log messages from python code

Note

• For detailed logback configuration documentation, please have a look at the logback manual.

log4j.conf is not used anymore. See logback configuration for the equivalent.

For log4j configuration, please have a look at this external article.

Important namespaces for logging are described in the following table:

Namespace	Default level	Description
log4j.logger.org.hibernate	WARN	log messages hibernate emits - database interaction/mapping problems are logged here
log4j.logger.org.hibernate.SQL	WARN	SQL related messages
log4j.logger.com.mchange	WARN	Connection pool related log messages - database connection problems are logged here
log4j.logger.de.planta.server	INFO	PLANTA Server messages
log4j.logger.de.planta.server.hibernate	INFO	PLANTA Server messages - hibernate interface related
log4j.logger.de.planta.server.hibernate.startup	WARN	PLANTA Server messages - startup/data dictionary related

hibernate.cfg.xml

This file is configured using XML syntax.

Name	Example value or Possible values	Description
dialect	de.planta.server.hibernate.dialect.Oracle10gDialect de.planta.server.hibernate.dialect.SQLServerDialect	Configures Oracle or MSSQL sql dialect
hibernate.connection.driver_class	oracle.jdbc.driver.OracleDriver com.microsoft.sqlserver.jdbc.SQLServerDriver	Configures the JDBC driver
hibernate.connection.url	jdbc:oracle:thin:@$db.server:$db.oracle.port:$db.name	DB connection URL - configured via installer
hibernate.connection.username	USER_123	the username used for connecting to the DB
hibernate.connection.password	gE_he1M	password used for connecting to the DB

Connection testing:
hibernate.c3p0.testConnectionOnCheckout	false	tests a connection before it is used
hibernate.c3p0.testConnectionOnCheckin	false	tests a connection after it was used
hibernate.c3p0.idleConnectionTestPeriod	300	period after which an idle connection is tested

Notes

• All other parameters are not described here.
• The connection testing options should be employed with care because of their performance impact.
• In most cases, no manual changes should be needed, as the Installer sets all values based on queried informations.
• For configuration of the connection pooling, see the c3p0 documentation.

auth.conf, krb.conf, key.tab

For description, see KerberosAuthentication.

startup.hbm.xml

Needed for building the data dictionary via hibernate. Should not be changed.