User Manual RCDRELOverviewThe CDR logger collects signaling event reports from multiple instances of ss7boost. The events are stored in a flat file in the order in which they are received. The information in the flat files can be read into an RDBMS for report generation and long term storage. CDR Logger and the RDBMS should run on a machine that is physically different from any of the the SMG feeding it information so that logging, sorting, and reporting does not impact the real-time performance of the SMG. Contents Features
InstallationUse the SMG installer as follows:
Or you can manually do the following:
ConfigurationThe contents of the configuration file is as follows: # This is the cdr_logger.conf file used by cdr_logger. # Copyright (c) 2006 Xygnada Technology, Inc. [CONNECT] # Opposite config should be used by CDR event pushers like ss7boost and # sangoma_mgd # # Local # address port 192.168.1.141 55011 # Remote (don't care, not used) # address port 192.168.1.202 55011 [OUTPUT] # CDR file path and prefix file rotate period (minutes) /usr/local/ss7box/cdr/cdrfile- 30 OperationNote that ss7boost and CDR Logger may be running on separate machines.
CDR Log File FormatThe CDR log file is a sequence of lines where each line is a set of comma separated values. Each lines corresponds to a call event in ss7boost. There are four line types:
Call Event Field Referencemt - message typemd - message direction sy - system id y - year mn - month d - day h - hour m - minute s - second sn - call serial number es - epoch timestamp seconds esu - epoch timestamp micro-seconds cs - call state cd - call direction su - csupid, call setup id tg - trunk group sp - span ch - chan ci - circuit id code dc - called number digit count dd - called number digits gc - calling number digit count gd - calling number digits gpi - calling number presentation indicator rc - release cause Call Event Record: CallstartMessage Type: 128
Call Event Record: IAMMessage Type: 1001
Call Event Record: Common
Call Event Record: ReleaseMessage Type: 1012
Creating Call RecordsThe CDR Logger files are designed to be imported to a spreadsheet or database for storage, sorting, and reporting. A call report is created by first sorting on the system id (sy), then by the epoch time (es/esu), and then by the call serial number (sn). This will group the calls by system, time, and call. The call start time, end time, and duration are derived by using the calendar date/time and epoch times. Schema ExampleThe call event records can be parsed in to a dB using a schema as shown in this section.
Created by: mike last modification: Tuesday 11 of September, 2007 [20:03:05 UTC] by mike |
Login |