Steel-Belted Radius Carrier 7.2.x Reference Guide > Configuring the Data Accessors for the SIM and SMS Authentication Modules > Identifying Key Fields for Oracle, JDBC, and LDAP Databases

Identifying Key Fields for Oracle, JDBC, and LDAP Databases

You can use the IMSI or the MSISDN as the key field for retrieving subscriber information from a SQL database or LDAP directory. You need to configure the files listed in Table 178 to identify and use the MSISDN or IMSI as the key field:

Table 178: Files to Be Configured When Identifying the Key Field 

Oracle or JDBC (SQL)	LDAP
gsmmap.gen [SQLDatabase] section	gsmmap.gen [LDAPDatabase] section
sqlaccessor.gen or sqlaccessorjdbc.gen [Settings] section	ldapaccessor.gen [Request] section and [Search/DoLdapSearch] section
oracle or jdbc database	LDAP directory

Configuring gsmmap.gen for Key Field Identification

The choice of IMSI or MSISDN as the key field is identified in the gsmmap.gen file with the KeyForAuthorization field. (KeyForAuthorization can be MSISDN or IMSI.) In the following examples, MSISDN is identified as the key field.

Examples

gsmmap.gen file (Oracle or JDBC)

[SQLDatabase]

ModuleType=Database

DatabaseAccessorMethodName=SQL Accessor

KeyForAuthorization=MSISDN

gsmmap.gen file (LDAP)

[LDAPDatabase]

ModuleType=Database

DatabaseAccessorMethodName=LDAP Accessor

KeyForAuthorization=MSISDN

Configuring sqlaccessor.gen or sqlaccessorjdbc.gen for Key Field Identification

For SQL databases, the SELECT statement in the [Settings] section of the sqlaccessor.gen file or the sqlaccessorjdbc.gen file identifies the database column name of the key field. In the following example, subscriber_id is identified as the column containing the key field.

Examples

Oracle Example: sqlaccessor.gen file

[Settings]

MethodName=SQL Accessor

Connect=my_user_name/password@servicename

SQL=SELECT service_type FROM table1 WHERE subscriber_id=@KeyToRecord

JDBC Example: sqlaccessorjdbc.gen file

[Settings]

MethodName=SQL Accessor

Driver=com/provider/jdbc/sqlserver/SQLServerDriver

ConnectDelimiter=;

Connect=DSN=jdbc:provider:driver1:dsn_name;UID=db_username;PWD=db_password

SQL=SELECT service_type FROM table1 WHERE subscriber_id=@KeyToRecord

The corresponding database must contain a column name (as specified in the SELECT statement) containing the key field. In the following example, the column name of subscriber_id contains MSISDN values that serve as record keys.

Example SQL Database (subscriber_id column contains the key MSISDN data)

 subscriber_id

 service_type

 street_address


 1234

 basic

 10 Main Street


 6889

 premium

 15 School Street

Configuring ldapaccessor.gen for Key Field Identification

For LDAP directories, the [Request] section and the [Search/DoLdapSearch] section identifies the key to the LDAP directory. You can set the KeyToRecord field in the [Request] section to either MSISDN or IMSI. The [Search/DoLdapSearch] section identifies the column name in the LDAP directory that contains the record key.

ldapaccessor.gen file

[Request]

KeyToRecord=key

M

[Search/DoLdapSearch]

Base=o=bigco.com

Scope=2

M

Filter=wlanMSISDN=key

 NOTE: See "Configuring the LDAP Data Accessor (ldapaccessor.gen)" for more information about ldapaccessor.gen. See [Script] Section for an example LDAP script.

Example LDAP Directory (wlanMSISDN column contains the key MSISDN data)

 wlanMSISDN

 service_type

 street_address


 1234

 basic

 10 Main Street


 6889

 premium

 15 School Street