<!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>Strange, I would say .... It may be something really particular
      to your setup or so.<br>
      <br>
      I there any possibility to investigate it directly on the system ?<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/13/2012 09:30 PM, Mimi Cafe wrote:
    <blockquote cite="mid:50CA2CB8.60302@gmail.com" type="cite">
      <meta content="text/html; charset=ISO-8859-1"
        http-equiv="Content-Type">
      <div class="moz-cite-prefix"><small><br>
          I have looked at my command history and as you can see below,
          I pulled version 1.8 from the svn branch (that was before you
          fixed the osipsconfig two days ago).<br>
          <br>
          <br>
          &nbsp; 640&nbsp; sudo svn co <a moz-do-not-send="true"
            class="moz-txt-link-freetext"
href="https://opensips.svn.sourceforge.net/svnroot/opensips/branches/1.8">https://opensips.svn.sourceforge.net/svnroot/opensips/branches/1.8</a>
          opensips-1.8<br>
          &nbsp; 641&nbsp; cd opensips-1.8/<br>
          &nbsp; 642&nbsp; sudo make menuconfig<br>
          &nbsp; <br>
          Also, version info shows reveal the following:<br>
          <br>
          version: opensips 1.8.2-notls (x86_64/linux)<br>
          flags: STATS: Off, USE_IPV6, USE_TCP, DISABLE_NAGLE,
          USE_MCAST, SHM_MEM, SHM_MMAP, PKG_MALLOC, F_MALLOC,
          FAST_LOCK-ADAPTIVE_WAIT<br>
          ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144,
          MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535<br>
          poll method support: poll, epoll_lt, epoll_et, sigio_rt,
          select.<br>
          svnrevision: 2:9454M<br>
          @(#) $Id: main.c 9330 2012-10-16 17:25:38Z bogdan_iancu $<br>
          main.c compiled on 11:53:21 Nov 28 2012 with gcc 4.4.6<br>
          <br>
          <br>
          Hope this helps.<br>
          <br>
          Mimi</small><br>
        <br>
        <br>
        <br>
        On 13/12/2012 13:56, Bogdan-Andrei Iancu wrote:<br>
      </div>
      <blockquote cite="mid:50C9DE85.4080309@opensips.org" type="cite">
        <meta content="text/html; charset=ISO-8859-1"
          http-equiv="Content-Type">
        <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 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 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>
      </blockquote>
      <br>
    </blockquote>
  </body>
</html>