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

Bogdan-Andrei Iancu bogdan at opensips.org
Fri Nov 3 12:57:28 EDT 2017


I see the column listed with lowercases - try to use everywhere only 
lowercase (including in the definition of the column in the table)

Regards,

Bogdan-Andrei Iancu
   OpenSIPS Founder and Developer
   http://www.opensips-solutions.com

On 11/03/2017 05:21 PM, Social Boh wrote:
>
> 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
>>
>
>
>
> _______________________________________________
> 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/acb0d6ed/attachment.html>


More information about the Users mailing list