IP Address in CDR

DefLeppard · **Joined:** Thu Jun 30, 2011 6:23 pm **Posts:** 27

Hello,

I would like to know if there is a way to store the IP addresses where each call comes from. This would be nice to have for security.

gromm · **Joined:** Thu Jun 05, 2008 5:35 pm **Posts:** 37

Correction, this would be absolutely necessary for security and tracking down who made fraudulent calls through A2Billing!

jroper · **Joined:** Fri Jun 23, 2006 3:56 pm **Posts:** 4065

Hi

With some recent development, this is entirely possible, you need to be using A2Billing version 2.0.16

We've added two new custom fields in cc_call, where the CDR are stored. you can set the value of the CDR in the dialplan before calling a2billing.php.

Therefore, write some dialplan to get the IP address of the calling party and then insert it as per the following sample dialplan:

Code:

[a2billing]
exten => _X.,1,NoOp(A2Billing Set Custom Var into CDRs table cc_call)
exten => _X.,n,Set(A2B_CUSTOM1="XYZ1234567890")
exten => _X.,n,Set(A2B_CUSTOM2=8888)
exten => _X.,n,Set(CDR(A2B_CUSTOM1)=${A2B_CUSTOM1})
exten => _X.,n,Set(CDR(A2B_CUSTOM2)=${A2B_CUSTOM2})
exten => _X.,n,Agi(a2billing.php,1)
exten => _X.,h,Hangup

The custom fields are not shown on the interface, they are only in the cc_call table, so you'd have to take a look at the table to extract the values.

Joe

graher01 · **Posted:** Tue Dec 09, 2014 4:25 am

jroper wrote:

Hi

With some recent development, this is entirely possible, you need to be using A2Billing version 2.0.16

We've added two new custom fields in cc_call, where the CDR are stored. you can set the value of the CDR in the dialplan before calling a2billing.php.

Therefore, write some dialplan to get the IP address of the calling party and then insert it as per the following sample dialplan:

Code:

[a2billing]
exten => _X.,1,NoOp(A2Billing Set Custom Var into CDRs table cc_call)
exten => _X.,n,Set(A2B_CUSTOM1="XYZ1234567890")
exten => _X.,n,Set(A2B_CUSTOM2=8888)
exten => _X.,n,Set(CDR(A2B_CUSTOM1)=${A2B_CUSTOM1})
exten => _X.,n,Set(CDR(A2B_CUSTOM2)=${A2B_CUSTOM2})
exten => _X.,n,Agi(a2billing.php,1)
exten => _X.,h,Hangup

The custom fields are not shown on the interface, they are only in the cc_call table, so you'd have to take a look at the table to extract the values.

Joe

I donot understand. I included the dialplan as you have it above but I get nothing. is there something more that I need to do to get the IP address stored.
thanks for your help

jroper · **Joined:** Fri Jun 23, 2006 3:56 pm **Posts:** 4065

Hi

Quote:

I donot understand. I included the dialplan as you have it above but I get nothing. is there something more that I need to do to get the IP address stored.

Yes, write some dialplan that extracts the IP address and puts it in the cc_call table, and of course ensure you are running A2Billing version 2.0.16

If you need assistance with this, contact us at [email protected] for a price to do this for you.

Joe

ci83rtda · **Joined:** Mon Jul 13, 2009 9:58 pm **Posts:** 18

This is what you need to get the IP into the cc_call table

Code:

[a2billing]
exten => _X.,1,NoOp(A2Billing Set Custom Var into CDRs table cc_call)
exten => _X.,n,Set(A2B_CUSTOM1=${CHANNEL(peerip)})
exten => _X.,n,Set(CDR(A2B_CUSTOM1)=${A2B_CUSTOM1})
exten => _X.,n,Agi(a2billing.php,1)
exten => _X.,h,Hangup

provided by Star2Billing S.L.

IP Address in CDR

Who is online