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

[Bogdan-Andrei Iancu]

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/ebeeb062/attachment.html>