<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <p>Hello,</p>
    <p>those with table fromat output are sql queries done directly to
      db server (e.g., mysql) via db cli (mysql app), so they do not
      depend on kamailio.cfg and kamailio running at that time.</p>
    <p>Those that give "method not found" are rpc commands sent to
      Kamailio and they require that specific modules are loaded.</p>
    <p>In your case, are permissions and domain modules loaded?</p>
    <p>Cheers,<br>
      Daniel<br>
    </p>
    <br>
    <div class="moz-cite-prefix">On 25.01.18 02:09, David Villasmil
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAFGRPVpQXMM1GYU0weJARiPw5oWhCqWCEtgT0A0CrQdi+PdOCQ@mail.gmail.com">
      <div dir="ltr">
        <div>Hello guys,</div>
        <div><br>
        </div>
        <div>This is weird, using kamctl I am able to do things from
          like:</div>
        <div><br>
        </div>
        <div>
          <div><font face="monospace, monospace">kamctl trusted show<br>
+----+--------------+-------+--------------+--------------+------+----------+<br>
              | id | src_ip       | proto | from_pattern | ruri_pattern
              | tag  | priority |<br>
+----+--------------+-------+--------------+--------------+------+----------+<br>
              |  1 | 1.2.3.4      | udp   |              | NULL        
              |      |        0 |<br>
+----+--------------+-------+--------------+--------------+------+----------+<br>
            </font><br>
          </div>
        </div>
        <div>but reloading, etc doesn't work:</div>
        <div><br>
        </div>
        <div>
          <div><font face="monospace, monospace">kamctl trusted reload</font></div>
          <div><font face="monospace, monospace">{</font></div>
          <div><font face="monospace, monospace">  "jsonrpc":  "2.0",</font></div>
          <div><font face="monospace, monospace">  "error":  {</font></div>
          <div><font face="monospace, monospace">    "code": 500,</font></div>
          <div><font face="monospace, monospace">    "message":  "Method
              Not Found"</font></div>
          <div><font face="monospace, monospace">  },</font></div>
          <div><font face="monospace, monospace">  "id": 22107</font></div>
          <div><font face="monospace, monospace">}</font></div>
        </div>
        <div><br>
        </div>
        <div><br>
        </div>
        <div>Other cases:</div>
        <div><br>
        </div>
        <div>
          <div>kamctl domain showdb</div>
          <div><font face="monospace, monospace">+----+-------------------------------------+------+---------------------+</font></div>
          <div><font face="monospace, monospace">| id | domain         
                                  | did  | last_modified       |</font></div>
          <div><font face="monospace, monospace">+----+-------------------------------------+------+---------------------+</font></div>
          <div><font face="monospace, monospace">|  1 | <a
                href="http://proxy.domain.com" moz-do-not-send="true">proxy.domain.com</a> 
                                | NULL | 2018-01-25 00:56:24 |</font></div>
          <div><font face="monospace, monospace">+----+-------------------------------------+------+---------------------+</font></div>
        </div>
        <div><br>
        </div>
        <div>but show:</div>
        <div><br>
        </div>
        <div>
          <div><font face="monospace, monospace">kamctl domain show</font></div>
          <div><font face="monospace, monospace">{</font></div>
          <div><font face="monospace, monospace">  "jsonrpc":  "2.0",</font></div>
          <div><font face="monospace, monospace">  "error":  {</font></div>
          <div><font face="monospace, monospace">    "code": 500,</font></div>
          <div><font face="monospace, monospace">    "message":  "Method
              Not Found"</font></div>
          <div><font face="monospace, monospace">  },</font></div>
          <div><font face="monospace, monospace">  "id": 22277</font></div>
          <div><font face="monospace, monospace">}</font></div>
        </div>
        <div><br>
        </div>
        <div><br>
        </div>
        <div>Any ideas why this might be happening?</div>
        <div><br>
        </div>
        <div><br>
        </div>
        <br clear="all">
        <div>
          <div class="gmail_signature">
            <div dir="ltr">
              <div>Regards,</div>
              <div><br>
              </div>
              David Villasmil
              <div>email: <a
                  href="mailto:david.villasmil.work@gmail.com"
                  target="_blank" moz-do-not-send="true">david.villasmil.work@gmail.com</a></div>
              <div>phone: +34669448337</div>
            </div>
          </div>
        </div>
      </div>
      <div hspace="streak-pt-mark" style="max-height:1px"><img alt=""
          style="width:0px;max-height:0px;overflow:hidden"
src="https://mailfoogae.appspot.com/t?sender=aZGF2aWQudmlsbGFzbWlsLndvcmtAZ21haWwuY29t&type=zerocontent&guid=ed587a75-746b-4835-897d-2b69c816e5c7"
          moz-do-not-send="true"><font size="1" color="#ffffff">ᐧ</font></div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
Kamailio (SER) - Users Mailing List
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a>
<a class="moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
    </blockquote>
    <br>
    <pre class="moz-signature" cols="72">-- 
Daniel-Constantin Mierla
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a class="moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a>
Kamailio Advanced Training - March 5-7, 2018, Berlin - <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a>
Kamailio World Conference - May 14-16, 2018 - <a class="moz-txt-link-abbreviated" href="http://www.kamailioworld.com">www.kamailioworld.com</a></pre>
  </body>
</html>