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.
Today, I am publishing the RPMs for SNGrep 1.4.6 All you need to do is to add my OKay's RPM repository, and just install it. SNGrep is a tool for displaying SIP calls message flows from the terminal. It supports live capture to display real-time SIP packets and can also be used as PCAP viewer.
If you wonder what is the big difference from my RPM's, these have all the options enabled as much as possible. This RPM enables the HEP/EEP protocol, very handy if you want to use it to interact with Homer.
RPM's are available for Centos 6 and 7. And you can find it if you type yum search sngrep.
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;