<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#ffffff" text="#000000">
    <tt>Hi,<br>
      <br>
      Just made a test, using "make menuconfig", setting a install path
      to "/tmp/foo" -&gt;<br>
      <br>
      $ grep PATH_CTLRC /tmp/foo/sbin/osipsconsole <br>
      my $PATH_CTLRC = "/tmp/foo//etc/opensips/";<br>
      if ( -e&nbsp; $PATH_CTLRC . "osipsconsolerc" ) {<br>
      &nbsp;&nbsp;&nbsp; $OSIPSCONSOLERC = $PATH_CTLRC . "osipsconsolerc";<br>
      <br>
      It looks like the path to RC was properly set.<br>
      <br>
      Are you sure you are using the latest 1.8 SVN branch (1.8.2) ?<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>
    <br>
    On 12/12/2012 10:12 PM, Mimi Cafe wrote:
    <blockquote cite="mid:50C8E51C.90500@gmail.com" type="cite">
      <meta content="text/html; charset=ISO-8859-1"
        http-equiv="Content-Type">
      <div class="moz-cite-prefix"><small><small>Hi Bogdan<br>
            <br>
            I used the graphical interface by executing&nbsp; "make
            menuconfig". I then specified the installation path as
            "/usr/local/opensips_proxy/" and everything is installed
            within /usr/local/opensips_proxy/ and the config files are
            in /usr/local/opensips_proxy/etc/opensips. <br>
            <br>
            It should be noted that, opensips is able find the other
            config files in /usr/local/opensips_proxy/etc/opensips, but
            it fails to find osipconsolerc.<br>
            <br>
            Mimi<br>
            <br>
            <br>
          </small></small>On 12/12/2012 12:22, Bogdan-Andrei Iancu
        wrote:<br>
      </div>
      <blockquote cite="mid:50C8771D.8040702@opensips.org" type="cite">
        <meta content="text/html; charset=ISO-8859-1"
          http-equiv="Content-Type">
        <tt>Mimi, when doing "make install", the osipsconsile </tt><small>$PATH_CTLRC


          is automatically updated with the installation path (prefix
          variable). So, how did you compile and install opensips (the
          exact commands) ?<br>
          <br>
          Regards,<br>
        </small>
        <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 12/12/2012 01:37 PM, Mimi Cafe wrote:
        <blockquote cite="mid:50C86C5E.5080909@gmail.com" type="cite">
          <meta content="text/html; charset=ISO-8859-1"
            http-equiv="Content-Type">
          <div class="moz-cite-prefix"><small>Thanks for your input. It
              explains why I&nbsp; couldn't add the new gateway earlier on.
              it now worked fine with 24 bit mask.<br>
              <br>
              I'm running version 1.8&nbsp; (sorry I forgit to mention it),
              and osipconsole and osipconsolerc are installed in the
              paths below.<br>
              <br>
              -rwxr-xr-x. 1 opensips opensips 202930 Dec 11 20:33
              /usr/local/opensips_proxy/sbin/osipsconsole<br>
              -rw-r--r--. 1 opensips opensips 2978 Dec&nbsp; 8 20:21
              /usr/local/opensips_proxy/etc/opensips/osipsconsolerc<br>
              <br>
              Looking in osipsconsole again, I now realise $PATH_CTLRC =
              "./scripts/" could be the reason why the config script is
              not found. Is this the case?<br>
              <br>
              <br>
              Cheers<br>
              <br>
              Mimi</small><br>
            <br>
            <br>
            On 12/12/2012 10:37, Bogdan-Andrei Iancu wrote:<br>
          </div>
          <blockquote cite="mid:50C85E59.2090707@opensips.org"
            type="cite">
            <meta content="text/html; charset=ISO-8859-1"
              http-equiv="Content-Type">
            <title></title>
            <tt>Hi Mimi,<br>
              <br>
              starting with 1.7 (if I remember correctly), the address
              mask is not anymore as 255.255.255.0, but as length 24
              (number of bites). So, the osipsconsole works the same
              now.<br>
              <br>
              Simply do:&nbsp; <small>osipsconsole address add 0
                192.168.1.192 24 5060 UDP</small><br>
              <br>
              <br>
              Regarrding the DB issue - do you use osipsconsole from the
              source tree or installed ? if installed, what is the path
              of osipsconsole and what is the path of osipsconsolerc ?
              BTW, what version of opensips are you using ?<br>
            </tt><tt><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 12/11/2012 11:17 PM, Mimi Cafe wrote:
            <blockquote cite="mid:50C7A2EB.9020909@gmail.com"
              type="cite">
              <meta content="text/html; charset=ISO-8859-1"
                http-equiv="Content-Type">
              <div class="moz-cite-prefix">Hi<br>
                <br>
                <small>I have updated osipsconsole via svn and it
                  appears the previous issue is resolved, but I now see
                  two more issues.<br>
                  <br>
                  The mattern below does not match the dot in netmask
                  $cmd[4] !~ /^[0-9]+$/. This seem to look for only one
                  octet? <br>
                  <br>
                  if ( <font color="#ff0000">$cmd[4] !~ /^[0-9]+$/ ||
                    $cmd[4] &lt; 0 || $cmd[4] &gt; 32</font> ) {<br>
                  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; print "mask '$cmd[4]'
                  is not valid - it must be between 0 and 32 (biti)\n";<br>
                  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return;<br>
                  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br>
                  <br>
                  <br>
                  The resulting error is:<br>
                  <br>
                  Control engine FIFO loaded<br>
                  Used database is mysql<br>
                  Warn fallback to local workdir ./mysql<br>
                  mask '255.255.255.255' is not valid - it must be
                  between 0 and 32 (biti)<br>
                  [sbin]$ sudo ./osipsconsole address add 0
                  192.168.1.192 255.255.255.0 5060 UDP<br>
                  which: no md5 in (/sbin:/bin:/usr/sbin:/usr/bin)<br>
                  Control engine FIFO loaded<br>
                  Used database is mysql<br>
                  Warn fallback to local workdir ./mysql<br>
                  mask '255.255.255.0' is not valid - it must be between
                  0 and 32 (biti)<br>
                  <br>
                  <br>
                  The other (trivial) issue is that osipsconsole does
                  not use the database parameters specified in my
                  osicpsconsolerc. Instead, it attempts to use detail
                  values here.<br>
                  <br>
                  [sbin]$ sudo ./osipsconsole address add 0
                  192.168.1.192 255.255.255.255 5060 UDP<br>
                  which: no md5 in (/sbin:/bin:/usr/sbin:/usr/bin)<br>
                  which: no db4.4_dump in
                  (/sbin:/bin:/usr/sbin:/usr/bin)<br>
                  Control engine FIFO loaded<br>
                  Used database is mysql<br>
                  Warn fallback to local workdir ./mysql<br>
                  Failed to connect the configured Database
                  (database=opensips;host=localhost;user=opensips)[babs@mognoreborder
                  sbin]$ sudo vim osipsconsole<br>
                </small><br>
                <small>Mimi</small><br>
                <br>
                <br>
                On 10/12/2012 14:38, Bogdan-Andrei Iancu wrote:<br>
              </div>
              <blockquote cite="mid:50C5F3E4.50509@opensips.org"
                type="cite">Hi Mimi, <br>
                <br>
                I made some fixes in osipsconsole on SVN (trunk and 1.8
                branch) - please update and let me know if now works for
                you. <br>
                <br>
                Regards, <br>
                <br>
                Bogdan-Andrei Iancu <br>
                OpenSIPS Founder and Developer <br>
                <a moz-do-not-send="true" class="moz-txt-link-freetext"
                  href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a>
                <br>
                <br>
                <br>
                On 12/08/2012 11:00 PM, Mimi Cafe wrote: <br>
                <blockquote type="cite">I attempted using osipsconsole
                  to add a gateway address, but it failed because there
                  is no data in the dbaliases table. How is this linked
                  to the dbaliases tables? What is the prerequisite to
                  adding a gateway address in addresses table? <br>
                  <br>
                  osipsconsole address add 0 192.168.18.89
                  255.255.255.255 5060 UDP <br>
                  <br>
                  Control engine FIFO loaded <br>
                  Used database is mysql <br>
                  Retrieving data from table failedYou have an error in
                  your SQL syntax; check the manual that corresponds to
                  your MySQL server version for the right syntax to use
                  near 'WHERE ip='192.168.18.89'' at line 1 <br>
                  Introducing the address rule 0 192.168.18.89
                  255.255.255.255 5060 UDP to the database failed <br>
                  You have an error in your SQL syntax; check the manual
                  that corresponds to your MySQL server version for the
                  right syntax to use near '( grp, ip, mask, port, proto
                  , context_info ) VALUES ( 0, '192.168.18.89', '255.'
                  at line 1 <br>
                  <br>
                  <br>
                  Mimi <br>
                  <br>
                  _______________________________________________ <br>
                  Users mailing list <br>
                  <a moz-do-not-send="true"
                    class="moz-txt-link-abbreviated"
                    href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
                  <br>
                  <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>
                  <br>
                  <br>
                </blockquote>
              </blockquote>
              <br>
            </blockquote>
          </blockquote>
          <br>
        </blockquote>
      </blockquote>
      <br>
    </blockquote>
  </body>
</html>