TSP Lab Sga-CellSMS Database / Query HTTP Server Sga-CellSMS_DB-QueryHTTPserver

Sga-CellSMS Database / Query HTTP Server
("Sga-CellSMS_DB-QueryHTTPserver")

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-load encrypted TACFAC names   Reloads TACFAC names list
  Re-load cell names   Reloads short cell names list. Only used in case of iCellNamesUse = 1
  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 HTTP Server.ini) file

The bottom status-line

Configuration (Sga-CellSMS_DB-QueryHTTPserver.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://+:8181/ HTTPS service listening on TCP port 8181 bound to any IP addresses
  sService2 http://10.0.100.121:8282/ HTTP service listening on TCP port 8282 bound to 10.0.100.121
  sService3 https://+:8888/SGADB HTTPS service listening on TCP port 8888 bound to any IP addresses with a service name
  sMainCSSfile Sga-CellSMS_DB-QueryHTTPserver - GyStyles.css Style definitions
  sMainJSfile Sga-CellSMS_DB-QueryHTTPserver - GyScripts.js JS script definitions
  sMainHTMLfile0 Sga-CellSMS_DB-QueryHTTPserver - GyLoginPage.html Login page template
  sMainHTMLfile11 Sga-CellSMS_DB-QueryHTTPserver - GyMainPageHAR_1.html Main search page template
  sMainHTMLfile13 Sga-CellSMS_DB-QueryHTTPserver - GyMainPage_3.html Footer template for main search page
  sMainHTMLfile19 Sga-CellSMS_DB-QueryHTTPserver - GyMainPage_9.html Prefix name list template
  sMainHTMLfile21 Sga-CellSMS_DB-QueryHTTPserver - GyMainPageDBs_1.html "IMEI↔IMSI↔MSISDN" queries page template
  sMainHTMLfile23 Sga-CellSMS_DB-QueryHTTPserver - GyMainPage_3.html Footer template for "IMEI↔IMSI↔MSISDN" queries page
[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.
[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
[MSS names]      
  #1 MSS Budapest Defines a name for MSS #1 in the results
  #2 MSS Debrecen Defines a name for MSS #2 in the results
[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
[IMSI-IMEI database / IMEI-index]      
  sIPaddress 10.0.0.111 Defines the IP address of the IMEI-indexed part of the "IC-DB"
  wTCPport 9003 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
[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.
  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:\HAR_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
  sTACFACnamesFileEncrypted TACFACnamesFileEncrypted.bin Path and file name of TACFAC names file
  sTACFACnamesFileEncrypted_SemaphoreFileIn file3.semaphoreIn Semaphore file to indicate that there is a new TACFAC names file to be re-loaded
  sTACFACnamesFileEncrypted_SemaphoreFileOut file3.semaphoreOut Semaphore file to indicate the result of a TACFAC names list re-loading
  sLogFilesPath D:\LogFiles\ Path of directory of log files

Version history