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

[Social Boh]

Hello,

changing to lowercase solves the issue.

Thank you

Regards

---
I'm SoCIaL, MayBe

El 03/11/2017 a las 11:57, Bogdan-Andrei Iancu escribió:
> 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/f1cb0d93/attachment.html>