Products | Versions |
---|---|
TIBCO LogLogic Security Event Manager | all versions up to 2.7.3.2 |
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.
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;