<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hello,</p>
<p>changing to lowercase solves the issue.</p>
<p>Thank you</p>
<p>Regards<br>
</p>
<pre class="moz-signature" cols="72">---
I'm SoCIaL, MayBe</pre>
<div class="moz-cite-prefix">El 03/11/2017 a las 11:57,
Bogdan-Andrei Iancu escribió:<br>
</div>
<blockquote type="cite"
cite="mid:616642a5-e872-cc0c-b8bd-90d022f82752@opensips.org">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<tt>I see the column listed with lowercases - try to use
everywhere only lowercase (including in the definition of the
column in the table)<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com" moz-do-not-send="true">http://www.opensips-solutions.com</a>
</pre>
<div class="moz-cite-prefix">On 11/03/2017 05:21 PM, Social Boh
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:a18a1a18-a93e-c666-4862-85a3103e0747@bohboh.info">
<meta http-equiv="Content-Type" content="text/html;
charset=utf-8">
<p>Hello,</p>
<p>in Details, there is (image)...</p>
<p>Thank you<br>
</p>
<pre class="moz-signature" cols="72">---
I'm SoCIaL, MayBe</pre>
<div class="moz-cite-prefix">El 03/11/2017 a las 07:09,
Bogdan-Andrei Iancu escribió:<br>
</div>
<blockquote type="cite"
cite="mid:c64b4a08-3aea-40b6-5c22-ad2a13676c4a@opensips.org">
<meta http-equiv="Content-Type" content="text/html;
charset=utf-8">
<tt>That means the "Gateway" column was *not* found in the DB
query result (in the accounting table).<br>
<br>
Try to click on the CDR details icon to see the raw format
for the CDR - check if your column is there.<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com" moz-do-not-send="true">http://www.opensips-solutions.com</a>
</pre>
<div class="moz-cite-prefix">On 11/03/2017 01:44 PM, Social
Boh wrote:<br>
</div>
<blockquote type="cite"
cite="mid:89b42a3b-f45b-df64-6cfa-5e489d9cb3c2@bohboh.info">
<meta http-equiv="Content-Type" content="text/html;
charset=utf-8">
<p>Hello, I have this message:</p>
<p> PHP Notice: Undefined index: Gateway in
/var/www/html/opensips-cp/web/tools/system/cdrviewer/template/cdrviewer.main.php
on line 236, referer: <a class="moz-txt-link-freetext"
href="http://X.X.X.X/cp/menu.php" moz-do-not-send="true">http://X.X.X.X/cp/menu.php</a></p>
<p>Thank you</p>
<p>Regards<br>
</p>
<pre class="moz-signature" cols="72">---
I'm SoCIaL, MayBe</pre>
<div class="moz-cite-prefix">El 03/11/2017 a las 06:09,
Bogdan-Andrei Iancu escribió:<br>
</div>
<blockquote type="cite"
cite="mid:c1e3c037-a7ba-dc7a-2fa4-9accd7f3f3da@opensips.org">
<meta http-equiv="Content-Type" content="text/html;
charset=utf-8">
<tt>Hi,<br>
<br>
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 ?<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com" moz-do-not-send="true">http://www.opensips-solutions.com</a>
</pre>
<div class="moz-cite-prefix">On 11/02/2017 07:34 PM,
Social Boh wrote:<br>
</div>
<blockquote type="cite"
cite="mid:0587738d-09a1-645b-5df4-b3d11cec75f1@bohboh.info">
<meta http-equiv="Content-Type" content="text/html;
charset=utf-8">
<p>Sorry, <br>
</p>
<p>OpenSIPS Control Panel 7.2.3 :)</p>
<p>I have this line on ACC Configuration:</p>
<p><b>modparam("acc", "extra_fields", "db:
gw->Gateway")</b></p>
<p>To know wich gateway OpenSIPs use to make a call.</p>
<p>I added this field in acc table and i can see the
values.<br>
</p>
<p>My problem is I don't know how modify correctly:</p>
<p><b>config/tools/system/cdrviewer/local.inc.php</b></p>
<p>to see the values of this field on the CDR Viewer
menu. With this:</p>
<p> // what fields to show<br>
$show_field[0]['time'] = "Time" ;<br>
$show_field[1]['method'] = "Method" ;<br>
$show_field[2]['callid'] = "Sip Call ID" ;<br>
$show_field[3]['sip_code'] = "Sip Code" ;<br>
$show_field[4]['sip_reason'] = "Sip Reason" ;<br>
$show_field[5]['setuptime'] = "Setup Time";<br>
$show_field[6]['duration'] = "Duration";<br>
$show_field[7]['from_tag'] = "Sip From Tag" ;<br>
$show_field[8]['to_tag'] = "Sip To Tag";<br>
<b> $show_field[9]['Gateway'] = "SIP Gateway";</b><br>
</p>
<p>(bold) I can see the column but not contain any
value.</p>
<p>Thank you</p>
<p>Regards</p>
<pre class="moz-signature" cols="72">---
I'm SoCIaL, MayBe</pre>
<div class="moz-cite-prefix">El 02/11/2017 a las 12:23,
Bogdan-Andrei Iancu escribió:<br>
</div>
<blockquote type="cite"
cite="mid:a109608b-2fe7-6cce-c0f6-a1da8ad76e8c@opensips.org">Hi,
<br>
<br>
I guess you mean OpenSIPS Control Panel 7.2.3 (and not
OpenSIPS Console). <br>
<br>
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 ? <br>
<br>
Regards, <br>
<br>
Bogdan-Andrei Iancu <br>
OpenSIPS Founder and Developer <br>
<a class="moz-txt-link-freetext"
href="http://www.opensips-solutions.com"
moz-do-not-send="true">http://www.opensips-solutions.com</a>
<br>
<br>
On 11/02/2017 06:56 PM, Social Boh wrote: <br>
<blockquote type="cite">Hello, <br>
<br>
I'm using OpenSIPs 2.3.2 and OpenSIPs Console 7.2.3.
<br>
<br>
I'd like know if is possible to see Acc Extra
Fields, configured on ACC Module, on CDR Viewer
menu. <br>
<br>
I tried modifying <br>
</blockquote>
</blockquote>
<br>
<blockquote type="cite"
cite="mid:a109608b-2fe7-6cce-c0f6-a1da8ad76e8c@opensips.org">
<blockquote type="cite">p without success. <br>
<br>
Regards <br>
<br>
</blockquote>
<br>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" moz-do-not-send="true">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" moz-do-not-send="true">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" moz-do-not-send="true">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" moz-do-not-send="true">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" moz-do-not-send="true">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" moz-do-not-send="true">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</blockquote>
<br>
</body>
</html>