TSP Lab Sga-CellSMS Database / Query Server Sga-CellSMS_DB-QueryServer

Sga-CellSMS Database / Query Server
("Sga-CellSMS_DB-QueryServer")

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 IMSI prefix names list
  Re-load operator prefix names   Reloads operator prefix 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
  Re-enter password to access IMSI-IMEI/DB (IMEI-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 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-QueryServer.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!)
[Query Files]      
  dwPeriodicInputCheckingSec 5 Checking period of query files
  byMaxConcurrentQueries 10 Maximum number of allowed queries at the same time
  sInputPath d:\QueryInputFolder Path for input query files
  sOutputPath d:\QueryOutputFolder Path for result files
[DAT files]      
  byPathModulo 3 Defines the number of CDR file destinations
  sPath_modN e:\CDR\ Path(s) for CDR files. As many path should be defined as the value of byOutFilePathModulo.
N runs from 0 to byOutFilePathModulo-1.
[DAT files - alternate]     Path for data files in case of path(s) defined under [DAT files] becomes unavailable
  byPathModulo 3 Defines the number of CDR file destinations
  sPath_modN k:\CDR\ Alternate path(s) for CDR files. As many path should be defined as the value of byOutFilePathModulo.
N runs from 0 to byOutFilePathModulo-1.
[INDEX files]      
  byPathModulo 3 Defines the number of index file destinations
  sPath_modN e:\CDR\ Path(s) for index files. As many path should be defined as the value of [Output INDEX files] / byOutFilePathModulo.
N runs from 0 to byOutFilePathModulo-1.
[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 0 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 0 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
[IMSI-IMEI database / IMEI-index]      
  sIPaddress 10.0.0.111 Defines the IP address of the IMEI-indexed part of the "IC-DB"
  wTCPport 0 TCP port of the IMEI-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
[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
[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
  wDataFilePeriod 15 Period of CDR files. It should be the same value as the one set in Sga-CellSMS_DB.ini
  dwMemoryDurationMaxSec 31536000 Defines the oldest data that can be accessed.
  sCellNamesFilesPath d:\CellNamesFilesFolder Path for cell name 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
  sLogFilesPath D:\LogFiles\ Path of directory of log files

Version history