[OpenSIPS-Users] ACC Extra field On OpenSIPs Console - CDR Viewer

[Social Boh]

Hello,

in Details, there is (image)...

Thank you

---
I'm SoCIaL, MayBe

El 03/11/2017 a las 07:09, Bogdan-Andrei Iancu escribió:
> That means the "Gateway" column was *not* found in the DB query result 
> (in the accounting table).
>
> Try to click on the CDR details icon to see the raw format for the CDR 
> - check if your column is there.
>
> Regards,
> Bogdan-Andrei Iancu
>    OpenSIPS Founder and Developer
>    http://www.opensips-solutions.com
> On 11/03/2017 01:44 PM, Social Boh wrote:
>>
>> Hello, I have this message:
>>
>>  PHP Notice:  Undefined index: Gateway in 
>> /var/www/html/opensips-cp/web/tools/system/cdrviewer/template/cdrviewer.main.php 
>> on line 236, referer: http://X.X.X.X/cp/menu.php
>>
>> Thank you
>>
>> Regards
>>
>> ---
>> I'm SoCIaL, MayBe
>> El 03/11/2017 a las 06:09, Bogdan-Andrei Iancu escribió:
>>> Hi,
>>>
>>> The change looks ok - are you sure you have data in the "Gateway" 
>>> column in the DB ? Do you see any errors in the apache log when 
>>> opening the CDRViewer tool ?
>>>
>>> Regards,
>>> Bogdan-Andrei Iancu
>>>    OpenSIPS Founder and Developer
>>>    http://www.opensips-solutions.com
>>> On 11/02/2017 07:34 PM, Social Boh wrote:
>>>>
>>>> Sorry,
>>>>
>>>> OpenSIPS Control Panel 7.2.3 :)
>>>>
>>>> I have this line on ACC Configuration:
>>>>
>>>> *modparam("acc", "extra_fields", "db: gw->Gateway")*
>>>>
>>>> To know wich gateway OpenSIPs use to make a call.
>>>>
>>>> I added this field in acc table and i can see the values.
>>>>
>>>> My problem is I don't know how modify correctly:
>>>>
>>>> *config/tools/system/cdrviewer/local.inc.php*
>>>>
>>>> to see the values of this field on the CDR Viewer menu. With this:
>>>>
>>>>  // what fields to show
>>>>  $show_field[0]['time'] = "Time" ;
>>>>  $show_field[1]['method'] = "Method" ;
>>>>  $show_field[2]['callid'] = "Sip Call ID" ;
>>>>  $show_field[3]['sip_code'] = "Sip Code" ;
>>>>  $show_field[4]['sip_reason'] = "Sip Reason" ;
>>>>  $show_field[5]['setuptime'] = "Setup Time";
>>>>  $show_field[6]['duration'] = "Duration";
>>>>  $show_field[7]['from_tag'] = "Sip From Tag" ;
>>>>  $show_field[8]['to_tag'] = "Sip To Tag";
>>>> * $show_field[9]['Gateway'] = "SIP Gateway";*
>>>>
>>>> (bold) I can see the column but not contain any value.
>>>>
>>>> Thank you
>>>>
>>>> Regards
>>>>
>>>> ---
>>>> I'm SoCIaL, MayBe
>>>> El 02/11/2017 a las 12:23, Bogdan-Andrei Iancu escribió:
>>>>> Hi,
>>>>>
>>>>> I guess you mean OpenSIPS Control Panel 7.2.3 (and not OpenSIPS 
>>>>> Console).
>>>>>
>>>>> And yes, it is possible to configure the CDRViewer to display 
>>>>> extra DB fields. What are the changes you did in the local.inc.php 
>>>>> file ?
>>>>>
>>>>> Regards,
>>>>>
>>>>> Bogdan-Andrei Iancu
>>>>>   OpenSIPS Founder and Developer
>>>>> http://www.opensips-solutions.com
>>>>>
>>>>> On 11/02/2017 06:56 PM, Social Boh wrote:
>>>>>> Hello,
>>>>>>
>>>>>> I'm using OpenSIPs 2.3.2 and OpenSIPs Console 7.2.3.
>>>>>>
>>>>>> I'd like know if is possible to see Acc Extra Fields, configured 
>>>>>> on ACC Module, on CDR Viewer menu.
>>>>>>
>>>>>> I tried modifying
>>>>
>>>>>> p without success.
>>>>>>
>>>>>> Regards
>>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at lists.opensips.org
>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20171103/dbe15c8a/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: details.png
Type: image/png
Size: 8791 bytes
Desc: not available
URL: <http://lists.opensips.org/pipermail/users/attachments/20171103/dbe15c8a/attachment-0001.png>