<div dir="ltr">Hello Santosh,<div><br></div><div>It seems that you have not registered the module for app_lua. You can do this by adding the below line.</div><div>modparam("app_lua", "register", "sqlops")<br></div><div><br></div><div>and try again.</div><div><br></div><div class="gmail_extra"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">Thanking You,<br>Sunil More<br>Ph : 9503338275</div></div></div>
<br><div class="gmail_quote">On Tue, Aug 22, 2017 at 6:32 PM, santosh gupta <span dir="ltr"><<a href="mailto:santosh.gupta.g@gmail.com" target="_blank">santosh.gupta.g@gmail.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">Hi,<div><br></div><div>Some more INFO</div><div><br></div><div>kamialio.lua</div><div><br></div><div><div>sr.sqlops.query("cb", "select grp from address where id='1'", "result");</div><div>sr.sqlops.column("result", index);</div><div>sr.sqlops.nrows("result");</div><div>sr.sqlops.ncols("result");</div></div><div><br></div><div><br></div><div>kamailio.cfg</div><div><div>modparam("sqlops","sqlcon","<wbr>cb=>mysql://XXXX:XXXX@<wbr>localhost/XXXX")</div></div><div><br></div></div><div id="m_7524765538298788365DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top:1px solid #d3d4de">
<tbody><tr>
<td style="width:55px;padding-top:13px"><a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png" alt="" width="46" height="29" style="width:46px;height:29px"></a></td>
<td style="width:470px;padding-top:12px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virus-free. <a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" style="color:#4453ea" target="_blank">www.avg.com</a>
</td>
</tr>
</tbody></table><a href="#m_7524765538298788365_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Aug 22, 2017 at 6:18 PM, santosh gupta <span dir="ltr"><<a href="mailto:santosh.gupta.g@gmail.com" target="_blank">santosh.gupta.g@gmail.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"><span style="font-size:12.8px">Hi Robert,</span><div style="font-size:12.8px"><br></div><div style="font-size:12.8px">Hope you are doing good.</div><div style="font-size:12.8px">You have helped me in the past.</div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px">I need to set LCR via app_lua, getting rates and destination from mysql.</div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px">Link which i am following is </div><div style="font-size:12.8px"><a href="https://www.kamailio.org/wiki/embeddedapi/4.0.x/lua" target="_blank">https://www.kamailio.org/wiki/<wbr>embeddedapi/4.0.x/lua</a></div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px">The issue is I am not able to get connect via sr commands for example</div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px"><pre class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-code m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-c" style="white-space:pre-wrap">sr.<span class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-me1">sqlops</span>.<span class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-me1">query</span><span class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-br0">(</span><span class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-st0">"connection"</span><span class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-sy0">,</span> <span class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-st0">"query"</span><span class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-sy0">,</span> <span class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-st0">"result"</span><span class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-br0">)</span></pre><pre class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-code m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-c" style="white-space:pre-wrap">What should be exactly is "connection"<span class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-sy0" style="font-family:arial,sans-serif">,</span><span style="font-family:arial,sans-serif"> </span><span class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-st0" style="font-family:arial,sans-serif">"query"</span><span class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-sy0" style="font-family:arial,sans-serif">,</span><span style="font-family:arial,sans-serif"> </span><span class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-st0" style="font-family:arial,sans-serif">"result"</span></pre><pre class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-code m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-c" style="white-space:pre-wrap"><span class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-st0" style="font-family:arial,sans-serif">Error I am getting in syslog is</span></pre><pre class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-code m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-c" style="white-space:pre-wrap"><span class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-st0"><font face="arial, sans-serif">/usr/local/kamailio/etc/kamail<wbr>io/kamailio.lua:1: attempt to index field 'sqlops' (a nil value)<br></font></span></pre><pre class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-code m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-c" style="white-space:pre-wrap"><span class="m_7524765538298788365m_-6124904187259791916gmail-m_7039119995937919926gmail-br0"><br></span></pre><div>I am using kamailio 5.0.2</div><div><br></div><div>A little bit of headsup will help me.</div><div>Thanks a lot again.</div></div><span class="m_7524765538298788365HOEnZb"><font color="#888888"><div><br></div><div><br></div><div><br></div>-- <br><div class="m_7524765538298788365m_-6124904187259791916gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><span style="font-size:12.8px">Regards </span><br></div><div>Santosh Gupta</div><div>+91 9323043570</div></div></div></div></div></div></div></div></div></div>
</font></span></div><span class="m_7524765538298788365HOEnZb"><font color="#888888"><div id="m_7524765538298788365m_-6124904187259791916DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top:1px solid #d3d4de">
<tbody><tr>
<td style="width:55px;padding-top:13px"><a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png" alt="" width="46" height="29" style="width:46px;height:29px"></a></td>
<td style="width:470px;padding-top:12px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virus-free. <a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" style="color:#4453ea" target="_blank">www.avg.com</a>
</td>
</tr>
</tbody></table><a href="#m_7524765538298788365_m_-6124904187259791916_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div>
</font></span></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="m_7524765538298788365gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><span style="font-size:12.8px">Regards </span><br></div><div>Santosh Gupta</div><div>+91 9323043570</div></div></div></div></div></div></div></div></div></div>
</div>
</div></div><br>______________________________<wbr>_________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/<wbr>cgi-bin/mailman/listinfo/sr-<wbr>users</a><br>
<br></blockquote></div><br></div></div>