[SR-Users] Kamailio APP_LUA

[Sunil More]

Hello Santosh,

It seems that you have not registered the module for app_lua. You can do
this by adding the below line.
modparam("app_lua", "register", "sqlops")

and try again.

Thanking You,
Sunil More
Ph : 9503338275

On Tue, Aug 22, 2017 at 6:32 PM, santosh gupta <santosh.gupta.g at gmail.com>
wrote:

> Hi,
>
> Some more INFO
>
> kamialio.lua
>
> sr.sqlops.query("cb", "select grp from address where id='1'", "result");
> sr.sqlops.column("result", index);
> sr.sqlops.nrows("result");
> sr.sqlops.ncols("result");
>
>
> kamailio.cfg
> modparam("sqlops","sqlcon","cb=>mysql://XXXX:XXXX@localhost/XXXX")
>
>
>
> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free.
> www.avg.com
> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
> <#m_7524765538298788365_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
> On Tue, Aug 22, 2017 at 6:18 PM, santosh gupta <santosh.gupta.g at gmail.com>
> wrote:
>
>> Hi Robert,
>>
>> Hope you are doing good.
>> You have helped me in the past.
>>
>> I need to set LCR via app_lua, getting rates and destination from mysql.
>>
>> Link which i am following is
>> https://www.kamailio.org/wiki/embeddedapi/4.0.x/lua
>>
>> The issue is I am not able to get connect via sr commands for example
>>
>> sr.sqlops.query("connection", "query", "result")
>>
>> What should be exactly is "connection", "query", "result"
>>
>> Error I am getting in syslog is
>>
>> /usr/local/kamailio/etc/kamailio/kamailio.lua:1: attempt to index field 'sqlops' (a nil value)
>>
>>
>> I am using kamailio 5.0.2
>>
>> A little bit of headsup will help me.
>> Thanks a lot again.
>>
>>
>>
>> --
>> Regards
>> Santosh Gupta
>> +91 9323043570
>>
>>
>> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free.
>> www.avg.com
>> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>> <#m_7524765538298788365_m_-6124904187259791916_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>
>
>
>
> --
> Regards
> Santosh Gupta
> +91 9323043570
>
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20170823/30cc218f/attachment.html>