Setting logging preferences

Top  Previous  Next

MFT Server logs all user activity to a log directory,  or JDBC accessible database, or the system database. Each type is described below. To configure logging preferences go to the Logging node in MFT Server Manager for the desired domain.

 

File Log

Database Log

System Database Log

Syslog

Verbose Logging

Restoring a Database Log

 

File Log

 

Logs all server activity to a directory.

 

Figure 12

 

clip0012

 

 

Directory - The directory where to store log files.

 

File rotation - The frequency in which to rotate log files.

 

 

Database Log

 

Logs all server activity to a JDBC accessible database.  To use the Database log option you must first create the database and necessary tables on your database server. Example database schema for MySQL, Microsoft SQL Server and Oracle are provided in the files etc/mysql-log.sql, etc/mssql-log.sql, etc/oracle-log.sql, and etc/postgresql-log.sql respectively. The etc directory is found inside the MFT Server installation directory.  Libraries for JDBC drivers must be placed in the libs/jdbc directory of your MFT Server installation, and the MFT Server Service must be restarted in order for the database to be accessible to MFT Server.

 

Figure 63

 

clip0063

 

 

 

JDBC URL - The JDBC URL used to connect to the database.  The above example demonstrates connecting to a MySQL database.  Contact your database vendor for access to JDBC libraries and assistance on specifying the JDBC URL.

 

Username - The username to connect with when authenticating with database.

 

Password - The password to connect with when authenticating with database.

 

Pool - The maximum number of connections in database pool.

 

Pool timeout - The maximum amount of time in minutes that the database connection can live in the pool without activity.

 

Clear records older than [x] days - When ticked, MFT Server will clear records in the database logs when their age exceeds x number of days

 

Test Parameters - Tests database connection using the specified settings.

 

System Database Log

 

Logs all server activity to the MFT Server system database. This means the system database and the user activity (for all domains) are all stored in the same database. This option is not supported if you are using the embedded (H2) database that comes bundled with MFT Server.

 

 
Syslog

 

Logs all activity to a syslog daemon in addition to your existing File Log or Database Log settings.  To use the Syslog option you must have an existing syslog daemon running.  This may be a local or remote syslog daemon.

 

Figure 116

 

clip0116

 

 

Host - The IP address of syslog daemon.

 

Port - The port of syslog daemon.

 

Facility - The syslog facility to use.

 

Process name - Process name tag to apply to all log messages sent to syslog daemon.

 

 

Settings

 

Max buffer size - Defines the maximum number of records that will be stored in the buffer

 

Figure 65

 

clip0065

 

 

 

Restoring a Database Log

 

In the event that the database server cannot be contacted logging data will be directed to a temporary file located in the backup directory of your MFT Server installation.  To move the contents of this temporary log file to your database use the js-backuplog command providing the domain that you wish to restore.  The js-backuplog executable may be found in your MFT Server installation directory.

 

Example

 

js-backuplog -domain localhost

 

The above command moves the contents of the temporary log file for domain localhost to the log database assigned to this domain.

 

 

 

 

 

 





Home | Company | Products | Solutions | Purchase | Support | Services | Blog

© 2021 Advanced Systems Concepts, Inc.