Call Detail Records

[Michael Halperin]

I'm having an issue with my call detail records because it never shows my calls.  

Is there something needs to be activated or they should just show up?

[Mack Hendricks]

What’s the use case:

SIP Trunking

PBX Hosting

MSTeams

Also, are the CDR’s being stored, but not showed.  You can validate by looking here:

 mysql -e "select * from kamailio.cdrs";

On Mar 15, 2021, at 2:01 PM, Michael Halperin <michael....@gmail.com> wrote:

I'm having an issue with my call detail records because it never shows my calls.  

Is there something needs to be activated or they should just show up?

--
You received this message because you are subscribed to the Google Groups "dSIPRouter" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dSIPRouter+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dSIPRouter/0b840cdb-33fe-4c35-b74e-375138b2f678n%40googlegroups.com.

[Michael Halperin]

The use case is I'm simply taking calls in on DIDs and doing a Hard Forward out to another system.  

I also ran your command and it came back blank.

I installed using CentOS 7 and then ran the install script

[Mack Hendricks]

The CDR’s are tied to Endpoint Groups

A Hard Forward would probably not capture CDR’s.  You can put in an issue here: https://github.com/dOpensource/dsiprouter/issues

To view this discussion on the web visit https://groups.google.com/d/msgid/dSIPRouter/1f8d3bdd-40ae-41c8-9dc6-b1492529fd74n%40googlegroups.com.

[Michael Halperin]

Hi Mark. sorry, i hit reply to author only instead of reply all.

i'm bringing in a DID from a vendor and doing a hard forward to another IP based system.  

the command you gave me came back with no results. 

On Monday, March 15, 2021 at 2:05:05 PM UTC-4 Mack Hendricks wrote:

[Michael Halperin]

Is there a better way to do the very same functionality and have it create CDRs?

[Mack Hendricks]

Just an enhancement needs to be done to support this feature.  If you need it immediately please send an email to sup...@dopensource.com and we will price out the effort.

-Mack

To view this discussion on the web visit https://groups.google.com/d/msgid/dSIPRouter/43134334-dc67-4598-8bfe-1aeafe195045n%40googlegroups.com.

[Michael Halperin]

i'll put in that request.  

separate to the request, how would you recommend I look at this if i didn't want to do it as a hard forward and wanted to have it work now in a different configuration?

[Mack Hendricks]

Create an endpoint group and route the DID to an endpoint group.

To view this discussion on the web visit https://groups.google.com/d/msgid/dSIPRouter/72fac058-7574-411b-bb54-efeed9a5a8a3n%40googlegroups.com.

[Michael Halperin]

sorry to be a pain.  i tried using the endpoint group instead of the hard forward within the endpoint group and it fails.  is there anything specific I need to do differently?

[Mack Hendricks]

Do you have a pcap?  Perhaps that would explain why it’s failing.

On Mar 15, 2021, at 3:00 PM, Michael Halperin <michael....@gmail.com> wrote:

sorry to be a pain.  i tried using the endpoint group instead of the hard forward within the endpoint group and it fails.  is there anything specific I need to do differently?<Screen Shot 2021-03-15 at 2.58.55 PM.png>

To view this discussion on the web visit https://groups.google.com/d/msgid/dSIPRouter/87b5c451-f03c-4cdd-9863-ec3acf21fe6cn%40googlegroups.com.

[Michael Halperin]

Here you go.
https://www.dropbox.com/s/cst1d4856aqs69a/capture.pcap?dl=0

[Michael Halperin]

Did that help?

You received this message because you are subscribed to a topic in the Google Groups "dSIPRouter" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/dSIPRouter/Yz28HjurWhU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to dSIPRouter+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dSIPRouter/2564dead-0bda-477e-b51f-78998c34aa09n%40googlegroups.com.

[Michael Halperin]

Hi Mack,

i have an endpoint group built and am routing to it on the DID and and seeing in the PCAP 500 No rules defined for number.  Is there something special i need to setup here?

[Mack Hendricks]

I just looked at the PCAP.  You should be able to just specify the Endpoint Group in the Inbound Mapping for the DID.

To view this discussion on the web visit https://groups.google.com/d/msgid/dSIPRouter/cfe154b2-73ed-49ee-889b-7fe524c9e5e5n%40googlegroups.com.

[Mack Hendricks]

Diable hardforwarding …otherwise, it will forward the call.

[Michael Halperin]

i have it setup that way and it never actually sends out of the system unless I have the hard forwarding enabled.  otherwise, i get the 500 No Routes error

[Mack Hendricks]

How is the endpoint group setup…registration or ip?  Can you show how that’s configured.

To view this discussion on the web visit https://groups.google.com/d/msgid/dSIPRouter/ff84cd05-9dd5-4b70-9b99-162ce12c3b97n%40googlegroups.com.

[Michael Halperin]

it's setup as IP auth with 1 IP in the Endpoints.  

Configs are the default settings

[Mack Hendricks]

You want to make sure the IP address for the endpoint group is not defined in a carrier group.  An IP can’t be both.  It sounds like this is the case

Sent from my iPhone

On Mar 16, 2021, at 1:12 PM, Michael Halperin <michael....@gmail.com> wrote:

it's setup as IP auth with 1 IP in the Endpoints.  

To view this discussion on the web visit https://groups.google.com/d/msgid/dSIPRouter/a8fc460c-8671-4fda-8910-db26dcbebf1fn%40googlegroups.com.

[Michael Halperin]

I did have that setup and removed it and it still doesn't work.  Same issue.  

[Michael Halperin]

Hi Mack,

Any further thoughts here?  i did the setup the way you stated and it doesn't forward the calls, it keeps saying 500 no route .

This only works if I do the hard forward.

Thanks.

Mike

[Mack Hendricks]

Not sure..never had this issue.  If you really need this then engage our paid support so that we can figure out what’s going going on.  Please send an email to sup...@dopensource.com

To view this discussion on the web visit https://groups.google.com/d/msgid/dSIPRouter/280785bf-eca5-41f5-9574-0e56ba62ffe4n%40googlegroups.com.

[Michael Halperin]

Hi Mack,

I engaged your paid support and they said it's a bug.

I also reinstalled using your debian instructions and have the same issue.  What is the last known stable version of an OS to use your script and have it actually work?

[Mack Hendricks]

Hey Michael,

It looks like it’s based on the version of the Database.  It looks like MySQL 8 and above works.  We are working thru your ticket.  We install whatever version that’s in the Repo.  I think we need to start forcing a certain version of the MySQL.  But, we are working thru the issue.  Just respond back to ticket if you have any questions.  

To view this discussion on the web visit https://groups.google.com/d/msgid/dSIPRouter/88e268ff-50e9-4361-ac17-3b63c1bf5aa8n%40googlegroups.com.

[Michael Halperin]

Got it. thank you. 

[marc....@northbynorth.ca]

was this resolved? Still not showing CDR when use case is SIP trunking 

[Michael Halperin]

I don’t believe so

To view this discussion on the web visit https://groups.google.com/d/msgid/dSIPRouter/567df23b-9ee7-4ba0-9abe-223532e5a4a2n%40googlegroups.com.

[marc....@northbynorth.ca]

There is a bug in the Call Detail Records. Records do not display in the CDR nor by running code   mysql -e "select * from kamailio.cdrs";

Unless one fiddles with the field CDR in the Endpoint Group Details, and even this doesnt always help - the month setting keeps returning to 1 instead of * unless there is an email value in the email field, but then it stops working unless the email field is cleared and re-entered. Its very buggy. 

Can a fix be applpied for more consistent CDR reports?

[José Miguel Gonçalves]

Any news about this issue?

Having the same problem in a SIP Trunking use case.

I'm running Debian 11 (with MariaDB 10.5).