TSP Lab Sga-CellSMS Database / Query JSON Server Sga-CellSMS_DB-QueryJSONserver

Sga-CellSMS Database / Query JSON Server
("Sga-CellSMS_DB-QueryJSONserver")

Table of Contents

Basic Operation

User Interface

The main menu

Menu Menuitem Shortcut(s) Meaning
[Log]      
  Find line containing... (Ctrl-F) Finds text in log window
  Find next matching line (F3) Finds next occurrence of text in log window
  Details   Detail level of logging (Off, Normal, Detailed, or Debug).
Note: F12 key sets log detail level to 'Off'.
[Actions]      
  Re-load IMSI prefix names   Reloads the IMSI prefix names list
  Re-load operator prefix names   Reloads the operator prefix names list
  Re-load cell names   Reloads the short cell names list.
  Re-enter password to access CellSMSmem/DB   The password used during the authentication can be re-entered
  Re-enter password to access IMSI-MSISDN/DB (IMSI-indexed)   The password used during the authentication can be re-entered
  Re-enter password to access IMSI-MSISDN/DB (MSISDN-indexed)   The password used during the authentication can be re-entered
  Re-enter password to access IMSI-IMEI/DB (IMSI-indexed)   The password used during the authentication can be re-entered
  Test all above database accesses () Tests the accessibility of databases
  Flush counters   Writes status line counters into the log
  Flush & reset counters   Writes the counters into the log and zeroes them
[Options]      
  Auto scroll (ScrollLock, or ) Allow automatic scrolling of the log screen
  Save settings   Save actual settings into the configuration (Sga-CellSMS Database / Query JSON Server.ini) file

The bottom status-line

Event names

Event code Event name
0 Handover
1 SMSoriginating
2 SMSterminating
3 CallInit
4 NormalLU
5 PeriodLU
6 Attach
7 Detach
8 PS-data
40 SGsAP/LU
41 SGsAP/Call
42 SGsAP/SMS
49 SGsAP/other
50 S1AP/Attach
51 S1AP/CS-fallback
52 S1AP/Data
53 S1AP/Detach
54 S1AP/LU
55 S1AP/other
56 S1AP/SMS
57 S1AP/Bearer-activation
58 S1AP/Bearer-deactivation
80 GPRS/---
81 GPRS/???
82 GPRS/-U-
90 GPRS/-C-
91 GPRS/ATTCH
92 GPRS/DTCH
93 GPRS/RAU
94 GPRS/PDPAc
95 GPRS/PDPDe
100 MAP/UL
101 MAP/UgL
102 MAP/CL
103 MAP/Pu
180 Diam/UL
182 Diam/CL
183 Diam/Pu
252 USSDoriginating
253 PagingResponse
254 EndOfDialog
255 OtherAction

Configuration (Sga-CellSMS_DB-QueryJSONserver.ini) file settings
Section Entry Example Meaning
[Position]      
  iLeft 140 Position of the program module on the display screen
  iTop 72 Position of the program module on the display screen
  iWidth 995 Position of the program module on the display screen
  iHeight 694 Position of the program module on the display screen
[Options]      
  bAutoScroll True (Refer to the [Options]/Auto scroll menuitem!)
[HTTP Server]     Note: At most 9 HTTP/HTTPS services can be defined.
  sAuthorizerServer 10.0.0.104 IP address of the Authorizer Server
  sService1 https://+:8881/ HTTPS service listening on TCP port 8881 bound to any IP addresses
  sService2 http://10.0.100.121:8882/ HTTP service listening on TCP port 8882 bound to 10.0.100.121
  sService3 https://+:8889/SGADB HTTPS service listening on TCP port 8889 bound to any IP addresses with a service name
[CellSMSmem database]      
  sIPaddress 127.0.0.1 Defines the IP address of the CellSMSmem database
  wTCPport 9999 TCP port of the CellSMSmem database
  sPassword password Password used during the authentication.
When it is not set then a pop-up window will appear to enter it when the module has been started
  dwMemoryDurationMaxSec 31536000 Defines the oldest data that can be accessed.
[IMSI-MSISDN database / IMSI-index]      
  sIPaddress 10.0.0.111 Defines the IP address of the IMSI-indexed part of the "IMSISDN-DB"
  wTCPport 9000 TCP port of the IMSI-indexed part of the "IMSISDN-DB"
  sPassword password Password used during the authentication.
When it is not set then a pop-up window will appear to enter it when the module has been started
[IMSI-MSISDN database / MSISDN-index]      
  sIPaddress 10.0.0.111 Defines the IP address of the MSISDN-indexed part of the "IMSISDN-DB"
  wTCPport 9001 TCP port of the MSISDN-indexed part of the "IMSISDN-DB"
  sPassword password Password used during the authentication.
When it is not set then a pop-up window will appear to enter it when the module has been started
[IMSI-IMEI database / IMSI-index]      
  sIPaddress 10.0.0.111 Defines the IP address of the IMSI-indexed part of the "IC-DB"
  wTCPport 9002 TCP port of the IMSI-indexed part of the "IC-DB"
  sPassword password Password used during the authentication.
When it is not set then a pop-up window will appear to enter it when the module has been started
[Event names]      
  0 Handover Defines event code and event name interpretations
[Advanced]      
  wLogDetailLevel 3 (Equals to the listed order; refer to the [LOG]/Details menuitem!)
  dwMaxLinesInLogWindow 1000 Number of lines in the log window on screen
  iCellNamesUse 1 Defines cell names to be appended to cell identifiers. Possible values:
  • 0 = don't use
  • 1 = short cell names (use sCellNamesFile)
  • 2 = long cell names (use sCellNamesFilesPath)
  sCellNamesFile d:\CellNames.csv Path for short cell names file. Used in case of iCellNamesUse = 1 and can be re-loaded manually from the GUI ([Actions]/"Re-load cell names" menu item) and automatically through semaphore files, see next entries.
  sCellNamesFile_SemaphoreFileIn copy_semaphore_in.txt Semaphore file to indicate that there is a new cell names file to be re-loaded
  sCellNamesFile_SemaphoreFileOut copy_semaphore_out.txt Semaphore file to indicate the result of a cell name list re-loading
  sCellNamesFilesPath d:\CellNamesFilesFolder Path for long cell name files. Used in case of iCellNamesUse = 2 and re-loaded automatically through control files.
  sIMSIPrefFile IMSIPref.lst Path and name of the IMSI prefix file
  sIMSIPrefFile_SemaphoreFileIn file1.semaphoreIn Semaphore file to indicate that there is a new IMSI prefix file to be re-loaded
  sIMSIPrefFile_SemaphoreFileOut file1.semaphoreOut Semaphore file to indicate the result of a IMSI prefix list re-loading
  sOpPrefFile OpPref.lst Path and name of the operator prefix file
  sOpPrefFile_SemaphoreFileIn file2.semaphoreIn Semaphore file to indicate that there is a new operator prefix file to be re-loaded
  sOpPrefFile_SemaphoreFileOut file2.semaphoreOut Semaphore file to indicate the result of a operator prefix list re-loading
  chOpPrefDelimiter - The delimiter character indicating the country name part
  sLogFilesPath D:\LogFiles\ Path of directory of log files

Version history