Creating and Restoring the SSR Database
Create and restore the SSR database.
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.
Create the database by logging in to one of the SM nodes as hadm.
Execute:
hadm@uranus-js:~>./CreateDB.shCreating database "SteelBeltedRadius" (using ENGINE ndbcluster). Creating misc tables. Creating IP Pool, Range and Address tables. Creating Wimax tables. Creating SIM Auth tables. Creating TTLS Resumption Cache tables. Creating Current Sessions table. Proxy AutoStop feature configured. Session Timeout on Missed Account Stop feature configured. Use Single Class Attribute feature configured. Creating User Concurrency table. Creating stored routines.
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.sqlExecute the UpdateSchema.pl utility for schema upgrades.
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.plUsage: perl UpdateSchema.pl [version] where [version] is 5.4, 5.5, 7.2.5, or 8.4 and above Other versions do not need a schema update. From SBR 8.5 release, to increase the Column size of AcctSessionId from 24 to 48, the below usage is recommended: Usage: perl UpdateSchema.pl <To_Version> ColumnUpdate:Sbr_AcctSessionId
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.
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.6.0:
Execute:
hadm@uranus-js:~>perl ./UpdateSchema.pl 8.6 ColumnUpdate:Sbr_AcctSessionIdAltering Tables for adding Sbr_Ipv6Address- Please wait...Done Altering Tables for changing Sbr_AcctSessionId size from 24 to 48- Please wait... Done
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.
Check the database restore.
Execute:
hadm@uranus-js:~>./ShowSessions.sh -cTotal Sessions: 611443
If you need to customize the sessions database, see Customizing the SSR Database Current Sessions Table.
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.