<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"><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 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>
  </body>
</html>