<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <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">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">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
    </blockquote>
    <br>
  </body>
</html>