<!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 Mimi,<br>
      <br>
      Just to be 100% sure there is no bug on opensips side, I would
      love to try to run a "make install" with prefix on your box, to
      see if we can replicate the issue.<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/17/2012 01:18 PM, Mimi Cafe wrote:
    <blockquote cite="mid:50CEE358.7060404@gmail.com" type="cite">
      <meta content="text/html; charset=ISO-8859-1"
        http-equiv="Content-Type">
      <div class="moz-cite-prefix">Hi Bogdan-Andrei<br>
        <br>
        <small>This is not a big issue for me because I added the values
          for database connectivity into</small> <small>osipsconsole
          script, and it works fine for me.</small> <small>My idea was
          to share this so it can be fixed in future revisions (if
          necessarry), otherwise I'm fine.</small> <br>
        <br>
        <small>My OpenSIPS installation is in a lab environment within
          my local LAN and it's not accessible from the internet. BUt if
          you really want to take a look to try to find the root cause
          to fix in </small><small><small>future revisions</small>,
          then I'm happy to allow you access to the network.<br>
          <br>
          Ciao<br>
          <br>
          Mimi</small><br>
        <br>
        On 14/12/2012 12:22, Bogdan-Andrei Iancu wrote:<br>
      </div>
      <blockquote cite="mid:50CB19FA.2060805@opensips.org" type="cite">
        <meta content="text/html; charset=ISO-8859-1"
          http-equiv="Content-Type">
        <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 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/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>
      </blockquote>
      <br>
    </blockquote>
  </body>
</html>