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@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@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@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users