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

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.cluecon.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org