Migrating TIBCO Security Server Database from Earlier Version to Version 2.4.1

In TIBCO Enterprise Administrator 2.4.1, H2 database version is upgraded from version 1.4.195 to 2.1.210. You must perform the following steps to migrate your TIBCO Security Server database configured in an earlier version of TIBCO Enterprise Administrator to new format in the version 2.4.1.

    Procedure

  1. Stop TIBCO Security Server.

  2. Take backup of <TIBCO_CONFIG_HOME>/tibco/cfgmgmt/tss/data/ directory.
  3. Take backup of <TIBCO_HOME>/tea/agents/tss/1.2/bin/tibco/cfgmgmt/data directory.

  4. Run the following commands:

    Copy 
    cd <TIBCO_HOME>/tea/agents/tss/1.2/lib
    Copy 

    java -cp h2-1.4.195.jar org.h2.tools.Script -url jdbc:h2:<TIBCO_CONFIG_HOME>/tibco/cfgmgmt/tss/data/teaAgentDb  -user "sa" -password "sa" -script taagentDB.zip -options compression zip
    Copy 
    java -cp h2-1.4.195.jar org.h2.tools.Script -url jdbc:h2:<TIBCO_HOME>/tea/agents/tss/1.2/bin/tibco/cfgmgmt/data/tssDb  -user "sa" -password "sa" -script tssDB.zip -options compression zip

    This creates taagentDB.zip and tssDB.zip file in the current directory.

  5. In the <TIBCO_CONFIG_HOME>/tibco/cfgmgmt/tss/data/ folder, delete teaAgentDb.mv.db and teaAgentDb.trace.db. In the <TIBCO_HOME>/tea/agents/tss/1.2/bin/tibco/cfgmgmt/data/ folder, delete tssDb.mv.db and tssDb.trace.db.
  6. Install TIBCO Enterprise Administrator 2.4.1 which installs TIBCO Security Server 1.2.1. For more information, see Installation.

  7. Copy taagentDB.zip and tssDB.zip files from <TIBCO_HOME>tea/agents/tss/1.2/lib to <TIBCO_HOME>/tea/agents/tss/1.2.1/lib directory using the following command:

    Copy 
    cd <TIBCO_HOME>/tea/agents/tss/1.2.1/lib
    Copy 

    cp <TIBCO_HOME>/tea/agents/tss/1.2/lib/taagentDB.zip <TIBCO_HOME>/tea/agents/tss/1.2.1/lib
    Copy 

    cp <TIBCO_HOME>/tea/agents/tss/1.2/lib/tssDB.zip  <TIBCO_HOME>/tea/agents/tss/1.2.1/lib

  8. Run the following commands to restore the database:

    Copy 
    cd <TIBCO_HOME>/tea/agents/tss/1.2.1/lib
    Copy 
    java -cp h2-2.1.210.jar org.h2.tools.RunScript -script taagentDB.zip -url "jdbc:h2:<TIBCO_CONFIG_HOME>/tibco/cfgmgmt/tss/data/teaAgentDb;NON_KEYWORDS=KEY,VALUE" -options compression zip variable_binary
    Copy 
    java -cp h2-2.1.210.jar org.h2.tools.RunScript -script tssDB.zip -url "jdbc:h2:<TIBCO_HOME>/tea/agents/tss/1.2.1/bin/tibco/cfgmgmt/data/tssDb;NON_KEYWORDS=KEY,VALUE" -options compression zip variable_binary

  9. Start the TIBCO Security Server from <TIBCO_HOME>tea/agents/tss/1.2.1/bin directory and verify if all the data from previous version is migrated to version 2.4.1.