Help us improve your experience.

Let us know what you think.

Do you have time for a two-minute survey?

 

Creating and Restoring the SSR Database

 

Create and restore the SSR database.

Note

If you need to customize the sessions database to match your existing cluster session database, see Customizing the SSR Database Current Sessions Table. Any customization must be done prior to running the CreateDB.sh script.

  1. Create the database by logging in to one of the SM nodes as hadm.

    Execute:

    hadm@uranus-js:~>./CreateDB.sh

  2. Restore the database from the backup you made in Backing Up the State of the Sessions in Your SSR Database.

    Execute:

    hadm@uranus-js:~>mysql -D SteelBeltedRadius </opt/backup_sbr.sql

  3. Execute the UpdateSchema.pl utility for schema upgrades.

    1. First, determine whether your schema needs to be updated for this release by executing UpdateSchema with no arguments as the hadm user. This will return a list of schemas which need to be updated for the installed version of software.

      Execute:

      hadm@uranus-js:~>perl ./UpdateSchema.pl

      Note

      Future SBR Carrier software releases may require schema updates, we recommend you execute this step every time you upgrade to determine if a schema upgrade is required.

    2. If you are running a software release that requires a schema change, execute the command again with the version to which you are upgrading. For example, if you are upgrading to SBR Carrier Release 8.5.0:

      Execute:

      hadm@uranus-js:~>perl ./UpdateSchema.pl 8.5 ColumnUpdate:Sbr_AcctSessionId

      Note

      The time required for altering the CST depends on the number of sessions stored in the CST. For example, SBR Carrier takes approximately 30 minutes to update a CST that contains 5 million sessions.

  4. Check the database restore.

    Execute:

    hadm@uranus-js:~>./ShowSessions.sh -c

  5. If you need to customize the sessions database, see Customizing the SSR Database Current Sessions Table.

  6. Configure at least one IP address pool and one range using the SSR Administration Scripts. See Testing the Installation with DemoSetup.sh. See also Session State Register Administration in the SBR Carrier Administration and Configuration Guide.