Section 4.11.1. AddSessionQuery

4.11.1. AddSessionQuery

This string contains the SQL query for saving the SWm and S6b session information. Most of the parameters are required. Some parameters are conditional depending on the features the non-3GPP access system requires.

The following bind variables are available in AddSessionQuery:

%0
This is the IMSI.
%1
This is the value of Diameter Session-Id AVP (Attribute-Value Pair).
%2
This is the value of Diameter Origin-Host AVP.
%3
This is the value of Diameter Origin-Realm AVP.
%4
This is the Diameter Application Id value.
%5
This is the Diameter application name, which corresponds to the Application Id.
%6
This is the Diameter Service-Selection attribute value, for example, SSID (Service Set Identifier) or NAI (Network Access Identifier).
%7
This is the permanent user identity represented as NAI without leading digit in front of IMSI.
%8
This is the session start time.
%9
Conditional: This is the value of Emergency-Services attribute. There is no need to store this attribute if emergency services are not enabled.
%10
Conditional: This is the value of User-Name attribute. Storing this is only needed when IMSI privacy is enabled and the ePDG requires anonymous username instead of permanent user identity.

For more information about SQL bind variables, see Radiator reference manual

under section SQL Bind Variables.