Page History

...

When an uncontrolled file closure occurs, such as an

Spacevars
0 product

 switch-over or system failure, this footer may not be present.

How to Set Up SFTP from

Spacevars
0 product

SBC to a CDR Server

If the CDR server is configured, SBC transfers the files through SFTP to the configured destination. SBC deletes the successfully transferred accounting files automatically. If transfer fails, ACT files begin to accumulate. When SBC accumulates the maximum number of configured files, it deletes the oldest unsuccessfully transferred files first. Therefore, these files are lost. The trap sonusCpEventLogFileCountNotification - MAJOR indicates that the number of event log files (in this case accounting files) is approaching the configured maximum per fileCount parameter. There are different reasons for unsuccessful transfer, which includes network errors, insufficient bandwidth, disk capacity issues on destination, bad configuration, and so on. Therefore, this trap can be used to prevent the loss of accounting or billing data.

Note
CDR files are removed when the fileCount configured for oam eventLog typeAdmin acct is reached. (see Event Log - CLI for configuration details)

Note
The accounting files (in this case .ACT files) can be copied to the event log directory, which increases the file count (all .ACT files count toward total number). SBC application does not have knowledge of that copied file and cannot automatically delete the manually copied files. For example, 100000A.ACT is copied to 100000A-backup-debug-special-project.ACT.

 

1. To create the CDR server, use the following command syntax:

   Code Block
   language none
   % set oam accounting cdrServer admin [primary | secondary] connectionTimeout <numeric: 15 to 600 seconds> filePrefix <name of SBC> ipAddress <ip address> password <password for ftp user> path <directory to ftp to> transferTimeout <numeric: 15 to 600 seconds> username <username of ftp user>

   Span

   An example to show the CDR server configuration and check the configuration is as follows:

   Code Block
   language none
   admin@SBC01> config admin@SBC01% set oam accounting cdrServer admin primary connectionTimeout 15 filePrefix SBC01 ipAddress 10.10.211.10 password sonus path /export/home/SBC01ACTrecs/ transferTimeout 15 username root admin@SBC01% commit admin@SBC01% quit admin@SBC01> show table oam accounting cdrServer admin FILE CONNECTION TRANSFER TYPE IP ADDRESS USERNAME PASSWORD PATH PREFIX TIMEOUT TIMEOUT -------------------------------------------------------------------------------------------------------------- primary 10.10.211.10 root $3$qaO71mBy8l8= /export/home/SBC01ACTrecs/ SBC01 15 15 [ok][2013-10-02 06:14:49] admin@SBC01>

   Span

2. Initially, the accounting field is not set to ftp or automatically roll over. Use the following command to view Rollover setting for accounting (See "acct" row in the example):

   Div
   class pdf6pttext
   Code Block language none admin@SBC01> show table oam eventLog typeAdmin MESSAGE FILE SYSLOG SYSLOG SYSLOG RENAME FILE FILE QUEUE SAVE FILTER ROLLOVER START ROLLOVER ROLLOVER WRITE SYSLOG REMOTE REMOTE REMOTE OPEN TYPE STATE COUNT SIZE SIZE TO LEVEL TIME INTERVAL ROLLOVER TYPE ACTION MODE STATE HOST PROTOCOL PORT FILES ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- system enabled 16 16000 32 disk info - 0 nonrepetitive stop default disabled 0.0.0.0 tcp 514 disabled debug enabled 16 16000 32 disk info - 0 nonrepetitive stop default disabled 0.0.0.0 tcp 514 disabled trace enabled 16 16000 32 disk info - 0 nonrepetitive stop default disabled 0.0.0.0 tcp 514 disabled acct enabled 16 64000 32 disk info - 0 nonrepetitive stop optimize disabled 0.0.0.0 tcp 514 disabled security enabled 16 16000 32 disk major - 0 nonrepetitive stop default disabled 0.0.0.0 tcp 514 disabled audit enabled 32 2048 10 disk info - 0 nonrepetitive stop default disabled 0.0.0.0 tcp 514 disabled packet enabled 32 2048 10 disk major - 0 nonrepetitive stop default disabled 0.0.0.0 tcp 514 disabled [ok][2013-10-02 06:41:58]

   Span

3. To create the accounting file rollover and ftp, use the following command syntax:

   Code Block
   language none
   % set oam eventLog typeAdmin acct rolloverStartTime <CCYY-MM-DDTHH:MM:SS> rolloverInterval <number of seconds between each file rollover> rolloverType repetitive rolloverAction start where 'T' in 'DDTHH' is a constant used to indicate the Time follows.

   Span

   An example of the configuration and display of the accounting file rollover and ftp is as follows:

   Div
   class pdf6pttext
   Code Block language none admin@SBC01% set oam eventLog typeAdmin acct rolloverStartTime 2013-10-02T06:30:00 rolloverInterval 900 rolloverType repetitive rolloverAction start [ok][2013-10-02 06:41:25] [edit] admin@SBC01% commit Commit complete. [ok][2013-10-02 06:41:28] [edit] admin@SBC01% quit admin@SBC01> show table oam eventLog typeAdmin MESSAGE FILE SYSLOG SYSLOG SYSLOG RENAME FILE FILE QUEUE SAVE FILTER ROLLOVER START ROLLOVER ROLLOVER WRITE SYSLOG REMOTE REMOTE REMOTE OPEN TYPE STATE COUNT SIZE SIZE TO LEVEL TIME INTERVAL ROLLOVER TYPE ACTION MODE STATE HOST PROTOCOL PORT FILES ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- system enabled 16 16000 32 disk info - 0 nonrepetitive stop default disabled 0.0.0.0 tcp 514 disabled debug enabled 16 16000 32 disk info - 0 nonrepetitive stop default disabled 0.0.0.0 tcp 514 disabled trace enabled 16 16000 32 disk info - 0 nonrepetitive stop default disabled 0.0.0.0 tcp 514 disabled acct enabled 16 64000 32 disk info 2013-10-02T06:30:00 900 repetitive start optimize disabled 0.0.0.0 tcp 514 disabled security enabled 16 16000 32 disk major - 0 nonrepetitive stop default disabled 0.0.0.0 tcp 514 disabled audit enabled 32 2048 10 disk info - 0 nonrepetitive stop default disabled 0.0.0.0 tcp 514 disabled packet enabled 32 2048 10 disk major - 0 nonrepetitive stop default disabled 0.0.0.0 tcp 514 disabled [ok][2013-10-02 06:41:58]

   Span

4. View CDR Server status using the following command:

   Code Block
   language none
   admin@SBC01> show table oam accounting cdrServer status SUCCESSFUL FAILED PENDING TYPE STATE PROGRESS TRANSFERS TRANSFERS TRANSFERS ------------------------------------------------------------- primary active done 3 0 0 [ok][2013-10-02 07:27:19]

   Span

5. Verify that the files were transferred to the FTP server by logging in to the CDR server and executing the following command:

   Code Block
   language none
   ftp server: root@hostname # pwd /export/home/SBC01ACTrecs root@hostname # ls -l total 708 -rw-r--r-- 1 root other 346730 Oct 2 06:45 SBC01.20131002064500.1000022.ACT -rw-r--r-- 1 root other 175 Oct 2 07:00 SBC01.20131002070000.1000023.ACT -rw-r--r-- 1 root other 175 Oct 2 07:15 SBC01.20131002071500.1000024.ACT root@hostname #

   Span

6. Execute the following command to view the successful and failed CDR file transfer:

   Code Block
   language none
   % show table oam accounting cdrServer status SUCCESSFUL FAILED PENDING TYPE STATE PROGRESS TRANSFERS TRANSFERS TRANSFERS --------------------------------------------------------- primary active done 2 0 0 secondary standby idle 0 7 0

...

The SBC RADIUS application uses standard attributes from the RADIUS when possible. For CDR Fields fields that cannot be mapped to the standard attributes, vendor-specific attributes are defined. The

Spacevars
0 product

allows instances of the standard attributes in Accounting request message as per following table:

...

Caption
0 Table 1 Allowed Standard Attributes 3 Allowed Standard Attributes
Attribute Name Attributes description NAS-IP-Address The IP Address of the SBC generating accounting request. NAS -Identifier The configured NAS Identifier for a given Spacevars 0 product . When sending RADIUS accounting messages, the NAS-Identifier field is populated with the corresponding value configured for the RADIUS server to which message is sent. Acct-Status-Type The type of accounting message sent by the Spacevars 0 product . The Spacevars 0 product uses the appropriate value of Acct-Status-Type corresponding to the CDR type to be generated. “Value” field in Acct-Status-Type attribute is “1” when call accounting record type is “START”. “Value” field in Acct-Status-Type attribute is “2” when call accounting record type is “STOP”. “Value” field in Acct-Status-Type attribute is “3” when call accounting record type is “INTERMEDIATE”. “Value” field in Acct-Status-Type attribute is “4” when call accounting record type is “ATTEMPT”. “Value” field in Acct-Status-Type attribute is “5” when call accounting record type is “REBOOT”. “Value” field in Acct-Status-Type attribute is “6” when call accounting record type is “SWITCHOVER”. Acct-Session-Id Uniquely identifies accounting records for a given call. It is possible to match all accounting records for a given call when correlating call records. Acct-Session-Time The number of seconds during which the user received service (duration of the call). Acct-Terminate-Cause The class of termination cause. This value is derived from the disconnect reasons class value.

Spacevars
0 product

accounting records may be sent to three different locations:

...