Kbase 34354: SonicMQ: Enable security needs basic tables to get recreated
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Solution ID: P4354
FACT(s) (Environment):
SonicMQ
SYMPTOM(s):
Enable security needs basic tables to get recreated
[146] progress.message.broker.EStartupFailure: Cannot recover from logs generated without Security.
CAUSE:
For security reasons, to protect the database from unwanted access, the basic tables and recovery log files are different with security enabled. The broker will not be able to recover if the basic tables and the recovery logs have been created without security, but the security property setting in the broker.ini forces to security.
FIX:
The basic tables must be recreated if you want to enable or disable security.
In cases where you don't want to lose the persistent messages which are in the database before doing the change, it is relatively straightforward to create a client application which reads the messages from one broker and transfers them to another broker.
Use dbtool to recreate the basic before creating the security tables.