Updating time-to-live index for persistent chat

The time-to-live (TTL) setting defines how long the chat history is stored in the database. The default value is 90 days. Administrators can modify the value based on the organization's preferred setting.

Before you begin

The TTL index in MongoDB must be rebuilt. For more information, refer to Manage Indexes in the MongoDB documentation.

About this task

To update the TTL settings, modify chatlogging.ini.

Procedure

  1. Stop the Sametime Community server.
  2. Modify chatlogging.ini and set the CL_MONGO_HISTORY_TTL value to the preferred setting.
  3. In the Mongo shell, run the following commands. 
    use chatlogging
    db.EVENTS.getIndexes()
    db.EVENTS.dropIndex( "TimeStamp_1")
    The db.EVENTS.dropIndex command defines the name of the index to drop. The value is TimeStamp_1.
  4. Start the Sametime Community server. A new TTL index with the new value is created.
  5. Run the following command to confirm that the value for TimeStamp_1 has been updated. 
    db.EVENTS.getIndexes()