<div dir="ltr">Hi.<div><br></div><div>Try something like this</div><div><br></div><div>$var(valor)=0;<br></div><div>$var(valor) = $dbr(ra=>[0,0]);<br></div><div><br></div><div>Use $var(valor) for that purpose.</div><div><br></div><div>I will check address table if you plan to use some ip authentication or similar.</div><div><br></div><div>Its more powerful if you are looking for that</div><div><br></div><div>BR</div><div><br></div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-04-28 16:19 GMT+02:00 Shahid Mehmood <span dir="ltr"><<a href="mailto:shahid.ge4@gmail.com" target="_blank">shahid.ge4@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Thanx ur kind reply <div><br></div><div>sql_query("cb", "select ip from ext where ext='$rU'", "ra");</div><div>$var(a)= sql_result_free("ra");<br><div><br></div><div>i have an other question . how i get data return from sql query. i get 1 from <span style="font-size:12.8px">sql_result_free("ra"); i need ip address like below </span></div><div><br></div><div><div>mysql> select ip from ext where ext=202</div><div> -> ;</div><div>+----------------+</div><div>| ip |</div><div>+----------------+</div><div>| 192.168.55.157 |</div><div>+----------------+</div><div>1 row in set (0.00 sec)</div></div><div><br></div><div><br></div></div></div><div class="gmail_extra"><div><div class="h5"><br><div class="gmail_quote">On Thu, Apr 28, 2016 at 4:36 PM, Alberto Sagredo <span dir="ltr"><<a href="mailto:alberto.sagredo@avanzada7.com" target="_blank">alberto.sagredo@avanzada7.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Ups Sorry<div><br></div><div><div>#!ifdef WITH_MYSQL</div><div>loadmodule "db_mysql.so"</div><div>#!endif</div></div><div><br></div><div><span style="font-size:13px">modparam("sqlops","sqlcon","</span><span style="font-size:13px">cb=>mysql://root:pass@IP/</span><span style="font-size:13px">kamailio")</span><br></div><div><span style="font-size:13px"><br></span></div><div><div>if($rU=~"^1[0-9][0-9]$")</div><div>{</div><div><span style="white-space:pre-wrap"> </span>sql_query("cb", "select asterisk from x where extension='$rU'","valora");</div></div><div>sql_result_free("valora");<br></div><div><br></div><div>}</div><div><br></div><div>With no issues..</div><div><br></div><div>Any error on mysql¿</div><div><br></div><div>BR</div><div><br></div><div><br></div></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">2016-04-28 13:33 GMT+02:00 Alberto Sagredo <span dir="ltr"><<a href="mailto:alberto.sagredo@avanzada7.com" target="_blank">alberto.sagredo@avanzada7.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi<div><br></div><div>Im my case</div><div><br></div><div><br></div><div>modparam("sqlops","sqlcon","ca=>mysql://root:pass@IP/kamailio")<br></div><div><br></div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div>2016-04-28 12:13 GMT+02:00 Shahid Mehmood <span dir="ltr"><<a href="mailto:shahid.ge4@gmail.com" target="_blank">shahid.ge4@gmail.com</a>></span>:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div dir="ltr"><span style="font-size:12.8px">Dear All,</span><br style="font-size:12.8px"><span style="font-size:12.8px"> i am getting error when i trying to fetch data from mysql data base using kamailio.</span><br style="font-size:12.8px"><br style="font-size:12.8px"><span style="font-size:12.8px">i have following code into kamailio.cfg file</span><br style="font-size:12.8px"><br style="font-size:12.8px"><span style="font-size:12.8px">loadmodule "db_mysql.so"</span><br style="font-size:12.8px"><span style="font-size:12.8px">loadmodule "sqlops.so"</span><br style="font-size:12.8px"><br style="font-size:12.8px"><span style="font-size:12.8px">..............................</span><span style="font-size:12.8px">..</span><br style="font-size:12.8px"><span style="font-size:12.8px">modparam("sqlops","sqlcon","</span><span style="font-size:12.8px">ca=>mysql://root:123456@</span><span style="font-size:12.8px">localhost/kamailio")</span><br style="font-size:12.8px"><span style="font-size:12.8px">..............................</span><span style="font-size:12.8px">.</span><br style="font-size:12.8px"><span style="font-size:12.8px">..............................</span><span style="font-size:12.8px">.</span><br style="font-size:12.8px"><br style="font-size:12.8px"><span style="font-size:12.8px"> sql_query("ca", "select * from ext", "ra");</span><br style="font-size:12.8px"><span style="font-size:12.8px"> sql_result_free("ra");</span><br style="font-size:12.8px"><br style="font-size:12.8px"><br style="font-size:12.8px"><br style="font-size:12.8px"><br style="font-size:12.8px"><b style="font-size:12.8px">Apr 24 06:30:31 kamalio /usr/sbin/kamailio[1385]: INFO: rr [rr_mod.c:160]: mod_init(): outbound module not available<br>Apr 24 06:30:31 kamalio /usr/sbin/kamailio[1385]: INFO: usrloc [hslot.c:53]: ul_init_locks(): locks array size 1024<br><span style="color:rgb(255,0,0)">Apr 24 06:30:31 kamalio /usr/sbin/kamailio[1385]: ERROR: sqlops [sqlops.c:276]: fixup_sql_query(): invalid connection [ca]<br>Apr 24 06:30:31 kamalio /usr/sbin/kamailio[1385]: ERROR: <core> [route.c:1189]: fix_actions(): fixing failed (code=-1) at cfg://etc/kamailio/kamailio.cfg:514</span><br>Apr 24 06:30:31 kamalio /usr/sbin/kamailio[1385]: ERROR: <core> [route.c:1189]: fix_actions(): fixing failed (code=-1) at cfg://etc/kamailio/kamailio.cfg:534</b><div style="margin:2px 0px 0px;font-size:12.8px"><div><img src="https://ssl.gstatic.com/ui/v1/icons/mail/images/cleardot.gif"></div></div><span><font color="#888888"><div><br></div>-- <br><div>Shahid Mehmood</div>
</font></span></div>
<br></div></div>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br></div>
</blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div></div></div><span class="HOEnZb"><font color="#888888">-- <br><div>Shahid Mehmood</div>
</font></span></div>
<br>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a 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" rel="noreferrer" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br></div>