<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <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 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 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 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 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 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 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 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 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>
  </body>
</html>