<div dir="ltr">Hi,<div><br></div><div>Don&#39;t know there the problem was located. Port 9999 was only utilized by memcached process.</div><div>Anyway i hope there are no issues within the memcached module code.</div><div><br></div><div>Thanks</div><div>Maciej.</div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-11-22 10:30 GMT+01:00 Bogdan-Andrei Iancu <span dir="ltr">&lt;<a href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>&gt;</span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
  
    
  
  <div bgcolor="#FFFFFF" text="#000000">
    <tt>Hi Maciej,<br>
      <br>
      That is weired, but I&#39;m glad you solved it. I mean it is weired
      (with the wrong port) why it worked for some and did not for other
      keys :-/<br>
      <br>
      Regards,<br>
    </tt><span class="">
    <pre class="m_-4085030951212019195moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="m_-4085030951212019195moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.<wbr>com</a></pre>
    </span><div><div class="h5"><div class="m_-4085030951212019195moz-cite-prefix">On 21.11.2016 23:44, Maciej Bylica
      wrote:<br>
    </div>
    <blockquote type="cite">
      <div dir="ltr">Ok, i figured it out, that the problem relies in
        port number definition.
        <div>I am getting no issues with 11211.</div>
        <div>
          <div><br>
          </div>
          <div>Thanks</div>
          <div>Maciej</div>
        </div>
      </div>
      <div class="gmail_extra"><br>
        <div class="gmail_quote">2016-11-21 22:20 GMT+01:00 Maciej
          Bylica <span dir="ltr">&lt;<a href="mailto:mbgatherer@gmail.com" target="_blank">mbgatherer@gmail.com</a>&gt;</span>:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div dir="ltr">Hi Bogdan,
              <div><br>
              </div>
              <div>Thanks for the reply.</div>
              <div><br>
              </div>
              <div>It seems it is related to the key, it doesn&#39;t matter
                which query is it.</div>
              <div>First query on the second key does not change
                anything.</div>
              <div>I&#39;ve just added additional key 49101112233 and it
                works (query was fired), but 49331112233 does not.</div>
              <div><br>
              </div>
              <div>Thanks</div>
              <span class="m_-4085030951212019195HOEnZb"><font color="#888888">
                  <div>Maciej.</div>
                  <div><br>
                  </div>
                </font></span></div>
            <div class="m_-4085030951212019195HOEnZb">
              <div class="m_-4085030951212019195h5">
                <div class="gmail_extra"><br>
                  <div class="gmail_quote">2016-11-21 12:59 GMT+01:00
                    Bogdan-Andrei Iancu <span dir="ltr">&lt;<a href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>&gt;</span>:<br>
                    <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
                      <div bgcolor="#FFFFFF" text="#000000"> <tt>Hi
                          Maciej,<br>
                          <br>
                          Thanks for the detailed report.<br>
                          <br>
                          Do you think the error is related to the key
                          you are trying to fetch or is it related to
                          the simply being the second query you perform
                          ?  What if you perform from the very beginning
                          a a query on the second key ?<br>
                          <br>
                          Regards,<br>
                        </tt><span>
                          <pre class="m_-4085030951212019195m_7796866539403131312m_3917994365001789203moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="m_-4085030951212019195m_7796866539403131312m_3917994365001789203moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.<wbr>com</a></pre>
    </span><div><div class="m_-4085030951212019195m_7796866539403131312h5"><div class="m_-4085030951212019195m_7796866539403131312m_3917994365001789203moz-cite-prefix">On 18.11.2016 19:53, Maciej Bylica
      wrote:

    </div>
    <blockquote type="cite">
      <div dir="ltr">Hello
        <div>

        </div>
        <div>As i mentioned before memcached is already installed. I am
          using <span style="color:rgb(0,0,0);font-family:menlo;font-size:11px">innodb_memcache.containe<wbr>rs </span>to
          implement memcached as a plugin.</div>
        <div>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">netstat
              -plnt | grep 9999</span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">tcp   
                  0      0 <a href="http://127.0.0.1:9999" target="_blank">127.0.0.1:9999</a>         
                  0.0.0.0:*                   LISTEN      18421/mysqld </span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">

            </span></p>
        </div>
        <div>Everything looks fine i have full transparency, data
          provided by memcached CLI (telnet) are seen inside innodb
          table and vise versa. </div>
        <div>

        </div>
        <div>I am using the latest 2.2.2 git opensips rel. and memcached
          module loaded:</div>
        <div>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">loadmodule
              &quot;cachedb_memcached.so&quot;</span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">modparam(&quot;cachedb_memcached&quot;,
              &quot;cachedb_url&quot;,&quot;memcached:defau<wbr>lt:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(82,48,225)">//localhost:9999,<a href="http://127.0.0.1/" target="_blank">127.0.0.1/</a><wbr>&quot;)</span></p>
        </div>
        <div>

        </div>
        <div>The script i am using is just the basic one, without any
          additional configuration.

        </div>
        <div>Inside the script there is following operation provided:</div>
        <div>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">cache_fetch(&quot;memcached:default<wbr>&quot;,&quot;$tU&quot;,$avp(i:601))</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(82,48,225)">;</span></p>
        </div>
        <div>

        </div>
        <div>Innodb table contains following data:</div>
        <div>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">+-------------+-------------+-<wbr>-----+------+------+</span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">| id   
                    | num         | c3   | c4   | c5   |</span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">+-------------+-------------+-<wbr>-----+------+------+</span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">|
              49121112233 | 49121112233 |    0 |    3 |    0 |</span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">|
              49221112233 | 49221112233 |    0 |    1 |    0 |</span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">|
              49221112234 | 49221112234 |    0 |    2 |    0 |</span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">+-------------+-------------+-<wbr>-----+------+------+</span></p>
        </div>
        <div>

        </div>
        <div>Now, i am sending INVITE with tU = <span style="color:rgb(0,0,0);font-family:menlo;font-size:11px">49121112233 </span>and
          getting proper behavior which means:</div>
        <div>- no error inside the opensips.log, xlog following<font color="#000000" face="menlo"><span style="font-size:11px"> </span></font><span style="color:rgb(0,0,0);font-family:menlo;font-size:11px">cache_fetch </span>returns
          correct <span style="color:rgb(0,0,0);font-family:menlo;font-size:11px">$avp(i:601)

          </span>- mysqld.log shows</div>
        <div>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">&lt;95
              get 49121112233 </span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">&gt;95
              sending key 49121112233</span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">&gt;95
              END</span></p>
        </div>
        <div>

        </div>
        <div>but really strange is that calling tU = <span style="color:rgb(0,0,0);font-family:menlo;font-size:11px">49221112233 </span>is
          causing quite opposite results:</div>
        <div><span style="color:rgb(0,0,0);font-family:menlo;font-size:11px">- </span>following
          error is shown</div>
        <div>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">DBG:core:cachedb_fetch:
              from script [memcached] - with grp [default]</span></p>
        </div>
        <div>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">ERROR:cachedb_memcached:wrap_m<wbr>emcached_get:
              Failed to get: SYSTEM ERROR</span></p>
          <p style="margin:0px;line-height:normal"><span style="color:rgb(0,0,0);font-family:menlo;font-size:11px;font-variant-ligatures:no-common-ligatures">- </span>no
            mysqld debug is produced</p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">

            </span></p>
          <p style="margin:0px;line-height:normal">The last one example<font color="#000000" face="menlo"><span style="font-size:11px">(</span></font><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small">tU
              = </span><font color="#000000" face="menlo"><span style="font-size:11px">49221112234)</span></font>is
            failing with the same error.</p>
          <p style="margin:0px;line-height:normal">

          </p>
          <p style="margin:0px;line-height:normal">Memcached is loaded
            with all those data</p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">Connected
              to localhost.</span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">Escape
              character is &#39;^]&#39;.</span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">get
              49221112233</span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">VALUE
              49221112233 0 11</span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">49221112233</span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">END</span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">get
              49221112234</span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">VALUE
              49221112234 0 11</span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">49221112234</span></p>
          <p style="margin:0px;line-height:normal">
          </p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">END</span></p>
          <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">

            </span></p>
          but because of some reasons memcached module is not utilized.</div>
        <div>As aforementioned, opensips script does not have any $rU
          filtering setup, so should query for any data it is asked for.</div>
        Maybe i am wrong with some of my assumptions or the way
        memcached is configured, so kindly help me to understand where
        the problem is located.
        <div>

        </div>
        <div>Thanks</div>
        <div>Maciej.

          <div><font color="#000000" face="menlo"><span style="font-size:11px">

              </span></font></div>
          <div>

          </div>
          <div>
            <p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)">

            </p>
          </div>
          <div>

          </div>
          <div>

          </div>
          <div>

          </div>
        </div>
      </div>
      <div class="gmail_extra">

        <div class="gmail_quote">2016-11-15 18:09 GMT+01:00
          Bogdan-Andrei Iancu <span dir="ltr">&lt;<a href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>&gt;</span>:

          <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div bgcolor="#FFFFFF" text="#000000"> <tt>OK, thank you
                for the update Maciej,

                

                Best regards,

              </tt><span>
                <pre class="m_-4085030951212019195m_7796866539403131312m_3917994365001789203m_-6364319733152202643moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="m_-4085030951212019195m_7796866539403131312m_3917994365001789203m_-6364319733152202643moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.<wbr>com</a></pre>
    </span><div><div class="m_-4085030951212019195m_7796866539403131312m_3917994365001789203h5"><div class="m_-4085030951212019195m_7796866539403131312m_3917994365001789203m_-6364319733152202643moz-cite-prefix">On 15.11.2016 18:28, Maciej Bylica
      wrote:

    </div>
    <blockquote type="cite">
      <div dir="ltr">Hi Bogdan,
        <div>

        </div>
        <div>Thanks for reply.</div>
        <div>Right, Opensips module was not the source of the problem.</div>
        <div>I&#39;ve managed to solve the issue, memcache is working fine.</div>
        <div>

        </div>
        <div>Thanks</div>
        <div>Maciej.</div>
      </div>
      <div class="gmail_extra">

        <div class="gmail_quote">2016-11-10 12:56 GMT+01:00
          Bogdan-Andrei Iancu <span dir="ltr">&lt;<a href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>&gt;</span>:

          <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div bgcolor="#FFFFFF" text="#000000"> <tt>Hi Maciej,

                

                As I see, you are manually compiling and installing the
                memcached stuff - any special reason for doing that ?
                (versus using packages) 

                

                As the problem seems to be in the lib, not in the
                OpenSIPS module.

                

                Regards,

              </tt>
              <pre class="m_-4085030951212019195m_7796866539403131312m_3917994365001789203m_-6364319733152202643m_9202004309374905358moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="m_-4085030951212019195m_7796866539403131312m_3917994365001789203m_-6364319733152202643m_9202004309374905358moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.<wbr>com</a></pre><div><div class="m_-4085030951212019195m_7796866539403131312m_3917994365001789203m_-6364319733152202643h5">
    <div class="m_-4085030951212019195m_7796866539403131312m_3917994365001789203m_-6364319733152202643m_9202004309374905358moz-cite-prefix">On 09.11.2016 18:41, Maciej Bylica
      wrote:

    </div>
    </div></div><blockquote type="cite"><div><div class="m_-4085030951212019195m_7796866539403131312m_3917994365001789203m_-6364319733152202643h5">
      <div dir="ltr">Hello

        

        I am struggling with memcached installation with the latest git
        opensips 2.2.2 and centos 6.8

        Here are version releases i am using:

        libmemcached-1.0.18 (./configure, make &amp;&amp; make install)

        memcached-1.4.33 (./configure, make &amp;&amp; make install)

        with LD_LIBRARY_PATH=/usr/local/lib<wbr>:$LD_LIBRARY_PATH

        

        memcached -d -u nobody -m 1048 -p 9999 127.0.0.1

        does not produce any error

        

        but what is really puzzling me during the opensips start is the
        error below:

        DBG:core:load_module: loading module
        /usr/local/lib64/opensips/modu<wbr>les/cachedb_memcached.so

        ERROR:core:sr_load_module: could not open module
        &lt;/usr/local/lib64/opensips/mod<wbr>ules/cachedb_memcached.so&gt;:
        /usr/local/lib/libmemcached.so<wbr>.11: undefined symbol:
        pthread_once

        

        Can someone please guide me how to put memcached up and running
        ?
        <div>Opensips is compiled with cachedb_memcached module.</div>
        <div>

        </div>
        <div>Thanks in advance.</div>
        <div>Maciej</div>
      </div>
      

      <fieldset class="m_-4085030951212019195m_7796866539403131312m_3917994365001789203m_-6364319733152202643m_9202004309374905358mimeAttachmentHeader"></fieldset>
      

      </div></div><pre>______________________________<wbr>_________________
Users mailing list
<a class="m_-4085030951212019195m_7796866539403131312m_3917994365001789203m_-6364319733152202643m_9202004309374905358moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a class="m_-4085030951212019195m_7796866539403131312m_3917994365001789203m_-6364319733152202643m_9202004309374905358moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-<wbr>bin/mailman/listinfo/users</a>
</pre>
    </blockquote>
    

  </div>

</blockquote></div>
</div>



</blockquote>
</div></div></div></blockquote></div>
</div>



</blockquote>
</div></div></div></blockquote></div>
</div>
</div></div></blockquote></div>
</div>



</blockquote>
</div></div></div></blockquote></div><br></div>