<div dir="ltr">Hello<div><br></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.containers </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">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"><br></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><br></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 "cachedb_memcached.so"</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("cachedb_memcached", "cachedb_url","memcached:default:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(82,48,225)">//localhost:9999,<a href="http://127.0.0.1/">127.0.0.1/</a>")</span></p></div><div><br></div><div>The script i am using is just the basic one, without any additional configuration.<br></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("memcached:default","$tU",$avp(i:601))</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(82,48,225)">;</span></p></div><div><br></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">+-------------+-------------+------+------+------+</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">+-------------+-------------+------+------+------+</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">+-------------+-------------+------+------+------+</span></p></div><div><br></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)<br></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"><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">>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">>95 END</span></p></div><div><br></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_memcached_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"><br></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"><br></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 '^]'.</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"><br></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><br></div><div>Thanks</div><div>Maciej.<br><div><font color="#000000" face="menlo"><span style="font-size:11px"><br></span></font></div><div><br></div><div><p style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><br></p></div><div><br></div><div><br></div><div><br></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-11-15 18:09 GMT+01:00 Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>></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>OK, thank you for the update Maciej,<br>
<br>
Best regards,<br>
</tt><span class="">
<pre class="m_-6364319733152202643moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="m_-6364319733152202643moz-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_-6364319733152202643moz-cite-prefix">On 15.11.2016 18:28, Maciej Bylica
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Hi Bogdan,
<div><br>
</div>
<div>Thanks for reply.</div>
<div>Right, Opensips module was not the source of the problem.</div>
<div>I've managed to solve the issue, memcache is working fine.</div>
<div><br>
</div>
<div>Thanks</div>
<div>Maciej.</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2016-11-10 12:56 GMT+01:00
Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>></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>
As I see, you are manually compiling and installing the
memcached stuff - any special reason for doing that ?
(versus using packages) <br>
<br>
As the problem seems to be in the lib, not in the
OpenSIPS module.<br>
<br>
Regards,<br>
</tt>
<pre class="m_-6364319733152202643m_9202004309374905358moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="m_-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_-6364319733152202643h5">
<div class="m_-6364319733152202643m_9202004309374905358moz-cite-prefix">On 09.11.2016 18:41, Maciej Bylica
wrote:
</div>
</div></div><blockquote type="cite"><div><div class="m_-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 && make install)
memcached-1.4.33 (./configure, make && 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
</usr/local/lib64/opensips/mod<wbr>ules/cachedb_memcached.so>:
/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_-6364319733152202643m_9202004309374905358mimeAttachmentHeader"></fieldset>
</div></div><pre>______________________________<wbr>_________________
Users mailing list
<a class="m_-6364319733152202643m_9202004309374905358moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a class="m_-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><br></div>