<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="gmail-m_7039119995937919926gmail-code gmail-m_7039119995937919926gmail-c" style="white-space:pre-wrap">sr.<span class="gmail-m_7039119995937919926gmail-me1">sqlops</span>.<span class="gmail-m_7039119995937919926gmail-me1">query</span><span class="gmail-m_7039119995937919926gmail-br0">(</span><span class="gmail-m_7039119995937919926gmail-st0">"connection"</span><span class="gmail-m_7039119995937919926gmail-sy0">,</span> <span class="gmail-m_7039119995937919926gmail-st0">"query"</span><span class="gmail-m_7039119995937919926gmail-sy0">,</span> <span class="gmail-m_7039119995937919926gmail-st0">"result"</span><span class="gmail-m_7039119995937919926gmail-br0">)</span></pre><pre class="gmail-m_7039119995937919926gmail-code gmail-m_7039119995937919926gmail-c" style="white-space:pre-wrap">What should be exactly is "connection"<span class="gmail-m_7039119995937919926gmail-sy0" style="font-family:arial,sans-serif">,</span><span style="font-family:arial,sans-serif"> </span><span class="gmail-m_7039119995937919926gmail-st0" style="font-family:arial,sans-serif">"query"</span><span class="gmail-m_7039119995937919926gmail-sy0" style="font-family:arial,sans-serif">,</span><span style="font-family:arial,sans-serif"> </span><span class="gmail-m_7039119995937919926gmail-st0" style="font-family:arial,sans-serif">"result"</span></pre><pre class="gmail-m_7039119995937919926gmail-code gmail-m_7039119995937919926gmail-c" style="white-space:pre-wrap"><span class="gmail-m_7039119995937919926gmail-st0" style="font-family:arial,sans-serif">Error I am getting in syslog is</span></pre><pre class="gmail-m_7039119995937919926gmail-code gmail-m_7039119995937919926gmail-c" style="white-space:pre-wrap"><span class="gmail-m_7039119995937919926gmail-st0"><font face="arial, sans-serif">/usr/local/kamailio/etc/<wbr>kamailio/kamailio.lua:1: attempt to index field 'sqlops' (a nil value)<br></font></span></pre><pre class="gmail-m_7039119995937919926gmail-code gmail-m_7039119995937919926gmail-c" style="white-space:pre-wrap"><span class="gmail-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><div><br></div><div><br></div><div><br></div>-- <br><div class="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 id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top:1px solid #d3d4de">
        <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" target="_blank" style="color:#4453ea">www.avg.com</a>
                </td>
        </tr>
</table><a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div>