TIBCO LogLogic SEM reports are based on French time zone even if the server is configured to use another time zone

TIBCO LogLogic SEM reports are based on French time zone even if the server is configured to use another time zone

book

Article ID: KB0077400

calendar_today

Updated On:

Products Versions
TIBCO LogLogic Security Event Manager all versions up to 2.7.3.2

Description

You may notice reports are based on French time zone even if the server is configured to use another time zone.

This issue comes from the URL used for interfacing with the report feature. The URL field in the database is truncated to 100 characters. The resolution involves simply lifting that limit by redefining the field in the db schema.

Issue/Introduction

Reports are based on French time zone even if the server is configured to use another time zone. This article explains the root cause and provides the resolution.

Resolution

To resolve just follow the procedure below:

1.     Connect to the SEM server via ssh.

2.     Execute the script: /usr/local/exaprotect/esms-setup/scripts/others/sql.sh

3.     When the MySQL prompt is displayed (mysql>) , type these 3 commands:

mysql> use prp_
mysql> alter table RE_World MODIFY URL varchar(255) NOT NULL;
mysql> update RE_World set URL='jdbc:mysql://127.0.0.1/DBNAME?autoReconnect=true&reconnectAtTxEnd=true&initialTimeout=30&maxReconnects=100000&useTimezone=true&serverTimezone=GMT0';

mysql> exit;