Lua script doesn't connect to Mysql

16 Sep 2014

      Hi, All

I am unable to connect to mysql for querying some data that I could use in
my lua script.
Here is my lua script.

 #!/usr/bin/lua

require "luasql.odbc"

env = assert (luasql.mysql())
con = assert (env:connect("gvt","root","hammer","localhost"))

session:answer();

-- sleep a second
session:sleep(1000);

Caller_number = session:getVariable("caller_id_number")
session:consoleLog("info", Caller_number)

session:streamFile("/opt/song.wav");

session:setVariable("nibble_rate", "0.03");

session:setVariable("nibble_account", "4712296279");
-- play a file

-- hangup
session:hangup();

When i run this i got this error.

2014-09-16 04:59:43.423380 [ERR] mod_lua.cpp:203
/usr/local/freeswitch/scripts/test.lua:3: module 'luasql.odbc' not found:
        no field package.preload['luasql.odbc']
        no file '/usr/local/share/lua/5.2/luasql/odbc.lua'
        no file '/usr/local/share/lua/5.2/luasql/odbc/init.lua'
        no file '/usr/local/lib/lua/5.2/luasql/odbc.lua'
        no file '/usr/local/lib/lua/5.2/luasql/odbc/init.lua'
        no file './luasql/odbc.lua'
        no file '/usr/local/lib/lua/5.2/luasql/odbc.so'
        no file '/usr/local/lib/lua/5.2/loadall.so'
        no file './luasql/odbc.so'
        no file '/usr/local/lib/lua/5.2/luasql.so'
        no file '/usr/local/lib/lua/5.2/loadall.so'
        no file './luasql.so'
stack traceback:
        [C]: in function 'require'
        /usr/local/freeswitch/scripts/test.lua:3: in main chunk

My odbc.ini

[freeswitch]
Driver          = /usr/lib/i386-linux-gnu/odbc/libmyodbc.so
SERVER          = localhost
PORT            = 3306
DATABASE        = gvt
OPTION          = 67108864
USER            = root
PASSWORD        = hammer

and odbcinst.ini

[MySQL]
Description     = MySQL driver
Driver          = /usr/lib/i386-linux-gnu/odbc/libmyodbc.so
Setup           = /usr/lib/i386-linux-gnu/odbc/libodbcmyS.so
UsageCount      = 1
FileUsage       = 1
Threading       = 0

Could someone please help me out how to connect freeswitch to mysql for
querying data..:)
Thanks in Advance

Aqs Younas

Chris Tunbridge

tags

participants (2)