Today, I am publishing the RPMs for PCAP SIP Dump 0.2. All you need to do is to add my OKay's RPM repository, and just install it. PCAP SIP Dump is a tool for dumping SIP sessions (+RTP traffic, if available) to disk in a fashion similar to tcpdump -w" (format is exactly the same), but one file per sip session (even if there are thousands of concurrent SIP sessions).
RPM's are available for Centos 6 and 7. And you can find it if you type yum search pcapsipdump.
As many people have asked me about the load balanced cluster; I have found that one of the most common issues is handling the correct way the incoming calls. The issue comes with some carriers as some won't allow hostnames and others allow a basic round-robin balancing which may present connectivity and delaying issues if the node in the balancing cluster is down.
I have come with a solution. It is basically adding an (at least 2-nodes) high availability cluster that acts as an SBC. You can think on this cluster as an extension of the load balanced cluster. I will explain how it works.
This is not a new question, but I think it is interesting to know how to export a SELECT statement into a CSV formatted file. In this example, I am going to export a FusionBPX CDR format.
SELECT domain_name, direction, caller_id_name, caller_id_number, destination_number, start_stamp, end_stamp, billsec, hangup_cause
INTO OUTFILE 'amfs.csv'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
AND start_stamp >= '2015-03-01'
ORDER BY start_stamp;