<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">Hi, <br>
      <br>
      Can you please paste all your "local.inc.php" from the TViewer
      config folder ? It would be a lot easier for me to help. <br>
      <br>
      Best regards,<br>
      Alex <br>
      <br>
      On 11/01/2013 10:52 AM, Ewgeny wrote:<br>
    </div>
    <blockquote cite="mid:52736BE3.2020603@ukr.net" type="cite">
      <meta content="text/html; charset=ISO-8859-1"
        http-equiv="Content-Type">
      <div class="moz-cite-prefix">I have tried to add following lines
        in <tt>TViewer tool config:</tt><br>
        $config-&gt;custom_table = "usr_preferences";
        $config-&gt;custom_table_columns = array ("Id" =&gt; "id","UUID"
        =&gt; "uuid","Username" =&gt; "username","Domain" =&gt;
        "domain","Attribute" =&gt; "attribute","Type" =&gt;
        "type","Value" =&gt; "value");<tt><br>
          <br>
        </tt><br>
        <tt><span tabindex="-1" id="result_box" class="short_text"
            lang="en"><span class="hps">but I get</span> <span
              class="hps">the following</span> <span class="hps">errors:</span></span></tt><tt>
          "Failed to issue query, error message : MDB2 Error: syntax
          error"<br>
          <br>
          in Apache error.log:<br>
          &nbsp;[error] [client 10.10.25.30] PHP Notice:&nbsp; Undefined index: id
          in
          /var/www/openssip-cp/web/tools/system/tviewer/template/tviewer.main.php
          on line 50, referer: <a moz-do-not-send="true"
            class="moz-txt-link-freetext"
            href="http://10.10.25.2/openssip-cp/web/menu.php">http://10.10.25.2/openssip-cp/web/menu.php</a><br>
          &nbsp;[error] [client 10.10.25.30] PHP Notice:&nbsp; Undefined index:
          uuid in
          /var/www/openssip-cp/web/tools/system/tviewer/template/tviewer.main.php
          on line 50, referer: <a moz-do-not-send="true"
            class="moz-txt-link-freetext"
            href="http://10.10.25.2/openssip-cp/web/menu.php">http://10.10.25.2/openssip-cp/web/menu.php</a><br>
          &nbsp;[error] [client 10.10.25.30] PHP Notice:&nbsp; Undefined index:
          username in
          /var/www/openssip-cp/web/tools/system/tviewer/template/tviewer.main.php
          on line 50, referer: <a moz-do-not-send="true"
            class="moz-txt-link-freetext"
            href="http://10.10.25.2/openssip-cp/web/menu.php">http://10.10.25.2/openssip-cp/web/menu.php</a><br>
          &nbsp;[error] [client 10.10.25.30] PHP Notice:&nbsp; Undefined index:
          domain in
          /var/www/openssip-cp/web/tools/system/tviewer/template/tviewer.main.php
          on line 50, referer: <a moz-do-not-send="true"
            class="moz-txt-link-freetext"
            href="http://10.10.25.2/openssip-cp/web/menu.php">http://10.10.25.2/openssip-cp/web/menu.php</a><br>
          &nbsp;[error] [client 10.10.25.30] PHP Notice:&nbsp; Undefined index:
          attribute in
          /var/www/openssip-cp/web/tools/system/tviewer/template/tviewer.main.php
          on line 50, referer: <a moz-do-not-send="true"
            class="moz-txt-link-freetext"
            href="http://10.10.25.2/openssip-cp/web/menu.php">http://10.10.25.2/openssip-cp/web/menu.php</a><br>
          &nbsp;[error] [client 10.10.25.30] PHP Notice:&nbsp; Undefined index:
          type in
          /var/www/openssip-cp/web/tools/system/tviewer/template/tviewer.main.php
          on line 50, referer: <a moz-do-not-send="true"
            class="moz-txt-link-freetext"
            href="http://10.10.25.2/openssip-cp/web/menu.php">http://10.10.25.2/openssip-cp/web/menu.php</a><br>
          &nbsp;[error] [client 10.10.25.30] PHP Notice:&nbsp; Undefined index:
          value in
          /var/www/openssip-cp/web/tools/system/tviewer/template/tviewer.main.php
          on line 50, referer: <a moz-do-not-send="true"
            class="moz-txt-link-freetext"
            href="http://10.10.25.2/openssip-cp/web/menu.php">http://10.10.25.2/openssip-cp/web/menu.php</a><br>
          &nbsp;[error] [client 10.10.25.30] PHP Notice:&nbsp; Undefined property:
          stdClass::$custom_table_primary_key in
          /var/www/openssip-cp/web/tools/system/tviewer/template/tviewer.main.php
          on line 86, referer: <a moz-do-not-send="true"
            class="moz-txt-link-freetext"
            href="http://10.10.25.2/openssip-cp/web/menu.php">http://10.10.25.2/openssip-cp/web/menu.php</a><br>
          <br>
          <br>
          About online users, </tt><tt><span tabindex="-1"
            id="result_box" class="short_text" lang="en"><span
              class="hps">i have</span>&nbsp;<span class="hps">user
              authentication</span> <span class="hps"></span></span></tt><tt><span
            tabindex="-1" id="result_box" class="short_text" lang="en"><span
              class="hps"><span tabindex="-1" id="result_box"
                class="short_text" lang="en"><span class="hps">through </span></span>RADIU</span></span>S
          protocol, </tt><tt><span tabindex="-1" id="result_box"
            class="short_text" lang="en"><span class="hps">my users</span>
            <span class="hps">are not stored</span> <span class="hps">in

              the database</span>.<br>
          </span></tt><tt><span tabindex="-1" id="result_box"
            class="short_text" lang="en"><span tabindex="-1"
              id="result_box" class="short_text" lang="en"><span
                class="hps">will it work</span><span>?</span></span></span><br>
          <br>
        </tt><br>
        30.10.2013 20:50, Bogdan-Andrei Iancu &#1087;&#1080;&#1096;&#1077;&#1090;:<br>
      </div>
      <blockquote cite="mid:527154E2.2040506@opensips.org" type="cite">
        <meta content="text/html; charset=ISO-8859-1"
          http-equiv="Content-Type">
        <tt>Hi Ewgeny,<br>
          <br>
          Actually you can do both now in CP :).<br>
          <br>
          For usr_preferences, you can use the generic TViewer tool
          which can be cloned and mapped over any kind of table, overing
          possibility to add/edit/delete/search. It may be a better
          approach to have a preconfigured </tt><tt>TViewer for
          usr_preferences table.<br>
          <br>
          In regards to online users, in the "Users" section, you can
          choose to see only the Online or Offline users. Also, for each
          user can see the registered contacts (if online).<br>
        </tt><tt><br>
          Regards,</tt><br>
        <pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
        <br>
        On 10/30/2013 07:57 PM, Ewgeny wrote:
        <blockquote cite="mid:52714893.8020502@ukr.net" type="cite">
          <meta content="text/html; charset=ISO-8859-1"
            http-equiv="Content-Type">
          <div class="moz-cite-prefix"><span tabindex="-1"
              id="result_box" class="short_text" lang="en"><span
                class="hps">I want to</span> <span class="hps">add the
                ability to</span> <span class="hps">control table</span>
              "<span class="hps">usr</span></span>_preferences" - that
            means to view, add and remove values from usr_preferences
            table.<br>
            Also i need to <span tabindex="-1" id="result_box"
              class="short_text" lang="en"><span class="hps">view</span>
              <span class="hps">in a convenient form</span> <span
                class="hps">registered SIP UACs</span></span> (like
            'ul_dump'), <span tabindex="-1" id="result_box"
              class="short_text" lang="en"><span class="hps">in</span> <span
                class="hps">Siremis</span> <span class="hps">this</span>
              <span class="hps">feature is</span> <span class="hps">very
                handy</span> <span class="hps">:)</span></span><br>
            <br>
            <br>
            <br>
            30.10.2013 19:21, Bogdan-Andrei Iancu &#1087;&#1080;&#1096;&#1077;&#1090;:<br>
          </div>
          <blockquote cite="mid:5271400C.5050203@opensips.org"
            type="cite">
            <meta content="text/html; charset=ISO-8859-1"
              http-equiv="Content-Type">
            <tt>Reporting bugs or lack of functionality may be a good
              start in doing the CP better - we are open and willing to
              do the coding.<br>
              <br>
              Regards,<br>
            </tt>
            <pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
            <br>
            On 10/30/2013 03:18 PM, Mike Tesliuk wrote:
            <blockquote
cite="mid:CAKNtoCHVuhdpnHRmb7jcPS08bXaxh4o0NUFhLO_H8k5LOauUUQ@mail.gmail.com"
              type="cite">
              <div dir="ltr">
                <div>
                  <div>Yep, <br>
                    <br>
                    This is a very good sugestion :)<br>
                    <br>
                  </div>
                  I like OpenSIPS-CP , on my instalation i see some
                  errors that are not a problem for me but can be for
                  other users, but we realy can make some contribuition
                  to this project.<br>
                  <br>
                </div>
                Im not a development dedicated guy, but i know a a litle
                bit of a lot of things , this could be very nice<br>
              </div>
              <div class="gmail_extra"><br>
                <br>
                <div class="gmail_quote">2013/10/30 Bogdan-Andrei Iancu
                  <span dir="ltr">&lt;<a moz-do-not-send="true"
                      href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>&gt;</span><br>
                  <blockquote class="gmail_quote" style="margin: 0pt 0pt
                    0pt 0.8ex; border-left: 1px solid rgb(204, 204,
                    204); padding-left: 1ex;">Hello Ewgeny,<br>
                    <br>
                    Siremis is not designed for OpenSIPS and you may
                    have huge compatibility<br>
                    issues - of course, if you want to dive into this,
                    feel free :).<br>
                    <br>
                    Maybe a better approach (for you and for the rest of
                    the community) is<br>
                    to identify things that should be improved in
                    OpenSIPS Control Panel and<br>
                    let's make it better.<br>
                    <br>
                    Best regards,<br>
                    <br>
                    Bogdan-Andrei Iancu<br>
                    OpenSIPS Founder and Developer<br>
                    <a moz-do-not-send="true"
                      href="http://www.opensips-solutions.com"
                      target="_blank">http://www.opensips-solutions.com</a><br>
                    <div class="HOEnZb">
                      <div class="h5"><br>
                        <br>
                        On 10/28/2013 04:11 PM, Ewgeny wrote:<br>
                        &gt; Hello!<br>
                        &gt;<br>
                        &gt; Is that possible to use Siremis WEB GUI<br>
                        &gt; <a moz-do-not-send="true"
                          href="http://siremis.asipto.com/2013/05/08/siremis-v4-0-0-released/"
                          target="_blank">http://siremis.asipto.com/2013/05/08/siremis-v4-0-0-released/</a>
                        with<br>
                        &gt; Opensips ?<br>
                        &gt; Siremis has better features for SIP
                        Database management then Opensips<br>
                        &gt; Control Panel, and lots of other feature
                        that Opensip CP does'nt have.<br>
                        &gt; I tried to install version 3.2 in
                        conjunction with Opensips, but it<br>
                        &gt; does not work well, a lot of errors.<br>
                        &gt; Maybe someone has experience with Siremis
                        and Opensips adaptation?<br>
                        &gt;<br>
                        &gt;<br>
                        &gt; Best Regards,<br>
                        &gt; Ewgeny<br>
                        &gt;<br>
                        &gt;<br>
                        &gt;<br>
                        &gt;<br>
                        &gt;
                        _______________________________________________<br>
                        &gt; Users mailing list<br>
                        &gt; <a moz-do-not-send="true"
                          href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
                        &gt; <a moz-do-not-send="true"
                          href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
                          target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
                        &gt;<br>
                        <br>
                        _______________________________________________<br>
                        Users mailing list<br>
                        <a moz-do-not-send="true"
                          href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
                        <a moz-do-not-send="true"
                          href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
                          target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
                      </div>
                    </div>
                  </blockquote>
                </div>
                <br>
              </div>
              <pre wrap=""><fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a moz-do-not-send="true" 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>
          </blockquote>
          <br>
        </blockquote>
      </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>