CDR Processor Application

This Go application is designed to process Call Detail Records (CDR) from .gz files, extract information, and store it in a MySQL database.

Features

• Watches a specified directory for new .gz files.
• Extracts .gz files to a temporary directory.
• Processes extracted .log files to parse CDR data.
• Inserts parsed data into a MySQL database.
• Moves processed .gz files to an archive directory.

Setup and Installation

Prerequisites

• Golang installed.
• MySQL server running.

Steps to Run

1. Clone the Repository:

   git clone [repository-url]
   cd [repository-directory]

2. Build the Application:

   go build -o cdr_processor

3. Run the Application:

   ./cdr_processor

Configuration

The application can be configured using command-line flags:

• mainDir: Main working directory for .gz files.
• tempDir: Temporary directory for processing files.
• archiveDir: Archive directory for processed files.
• sqlUser: SQL database username.
• sqlPassword: SQL database password.
• sqlHost: SQL database host.
• sqlPort: SQL database port.
• sqlDatabase: SQL database name.

Example:

./cdr_processor -mainDir="./new" -tempDir="./tmp" -archiveDir="./archive" -sqlUser="root" -sqlPassword="password" -sqlHost="localhost" -sqlPort="3306" -sqlDatabase="mydb"

Database Setup

Creating the Database and Table

Run the following SQL commands to create the necessary database and table:

USE tb_cdr;

CREATE TABLE IF NOT EXISTS tb_cdr (
Timestamp TIMESTAMP,
Type VARCHAR(255),
SessionID VARCHAR(255),
LegID VARCHAR(255),
StartTime VARCHAR(255),
ConnectedTime VARCHAR(255),
EndTime VARCHAR(255),
FreedTime VARCHAR(255),
Duration VARCHAR(255),
TerminationCause VARCHAR(255),
TerminationSource VARCHAR(255),
Calling VARCHAR(255),
Called VARCHAR(255),
NAP VARCHAR(255),
Direction VARCHAR(255),
Media VARCHAR(255),
RtpRx VARCHAR(255),
RtpTx VARCHAR(255),
T38Rx VARCHAR(255),
T38Tx VARCHAR(255),
ErrorFromNetwork VARCHAR(255),
ErrorToNetwork VARCHAR(255),
MOS VARCHAR(255),
NetworkQuality VARCHAR(255)
);

Additional Resources

To effectively use this CDR processing application, it is recommended to familiarize yourself with the specifics of Text Call Detail Records (CDRs) as used and provided by TelcoBridges. The following resources offer valuable information on Automatic Text CDR Retrieval and the details of Text CDRs:

1. TelcoBridges - Automatic Text CDR Retrieval
   • This document provides guidelines on how to automatically retrieve Text CDRs. It includes information on setting up CDR retrieval and understanding the different methods available for this purpose.
2. TelcoBridges - Text Call Detail Records
   • This page offers a comprehensive overview of Text CDRs, including their format, fields, and methods for retrieval. Understanding this information is crucial for correctly processing and interpreting the data in the CDR files.

Please ensure that you review and understand these documents to get the most out of the CDR processing application.