<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div dir="ltr" id="yui_3_16_0_1_1429210732892_84405"><span>Hi Ethan,</span></div><div dir="ltr" id="yui_3_16_0_1_1429210732892_84471"><span><br></span></div><div dir="ltr" id="yui_3_16_0_1_1429210732892_84411"><span id="yui_3_16_0_1_1429210732892_84413">What memcached library are you using with kamailio ?</span></div><div dir="ltr" id="yui_3_16_0_1_1429210732892_84391">What version is you kamailio ?</div><div dir="ltr" id="yui_3_16_0_1_1429210732892_84391">I am sure that the memcached module is working with kamailio 4.0.2 .</div><div dir="ltr" id="yui_3_16_0_1_1429210732892_84391"><br></div><div dir="ltr" id="yui_3_16_0_1_1429210732892_84393"><span>Regards,</span></div><div dir="ltr" id="yui_3_16_0_1_1429210732892_84407"><span>Dragos</span></div><br> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_1_1429210732892_84397"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_1_1429210732892_84396"> <div dir="ltr" id="yui_3_16_0_1_1429210732892_84395"> <hr size="1" id="yui_3_16_0_1_1429210732892_84440"> <font size="2" face="Arial" id="yui_3_16_0_1_1429210732892_84409"> <b><span style="font-weight:bold;">From:</span></b> Ethan Brooks <ethan.brooks@switchsoft.com><br> <b><span style="font-weight: bold;">To:</span></b> sr-users@lists.sip-router.org <br> <b><span style="font-weight: bold;">Sent:</span></b> Friday, April 10, 2015 5:29 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> [SR-Users] memcached module trimming the leading 8 char with innodb module<br> </font> </div> <div class="y_msg_container" id="yui_3_16_0_1_1429210732892_84399"><br><div id="yiv0189896310"><div dir="ltr" id="yui_3_16_0_1_1429210732892_84474">This is very simple Kamailio config and when i access Memcached directly everything seem to be fine but, when accessed via Kamailio he leading 8 char is omitted.<br><br>I have included everything needed to test.<br><br>kamailio<br><br>mpath="/usr/lib/x86_64-linux-gnu/kamailio/modules/"<br>debug=0<br>fork=yes<br><br>loadmodule "tm.so"<br>loadmodule "sl.so"<br>loadmodule "pv.so"<br>loadmodule "xhttp.so"<br>loadmodule "memcached.so"<br>modparam("memcached", "servers", "localhost:11211")<br><br>port=80<br>tcp_accept_no_cl=yes<br>event_route[xhttp:request] {<br>$var(number) = $hu;<br>$var(number) = $(var(number){s.substr,2,0});<br>xhttp_reply("200", "OK", "text/html",<br> "value: $mct(@@lnp.$var(number))");<br>}<br><br><br>mysql:<br>source /usr/share/mysql/innodb_memcached_config.sql<br> install plugin daemon_memcached soname "libmemcached.so";<br>CREATE SCHEMA lnp;<br>CREATE TABLE `lnp`.`lnp` ( `number` bigint(20) NOT NULL, `ported` bigint(20) DEFAULT NULL, PRIMARY KEY (`number`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;<br>insert into lnp.lnp (number,ported) values (8055551212,8053214321);<br><br>insert into innodb_memcache.containers (name,db_schema,db_table,key_columns,value_columns,flags,cas_column, expire_time_column,unique_idx_name_on_key) values ('lnp','lnp','lnp','number','ported', 0,0,0,'PRIMARY');<br><br>url:<br><a rel="nofollow" target="_blank" href="http://localhost/?8055551212">http://localhost/?8055551212</a><br><br>reponse:<br>value: 21<br><br>memcached<br># nc localhost 11211<br>get @@lnp.8055551212<br>VALUE @@lnp.8055551212 0 10<br>8053214321<br>END<br></div></div><br>_______________________________________________<br>SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br><a ymailto="mailto:sr-users@lists.sip-router.org" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br><a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br><br><br></div> </div> </div> </div></body></html>