Oh yes, here's an example: function dbConnect() -- connect to db require "luasql.mysql" env = assert(luasql.mysql()) conn = assert(env:connect("freeswitch","user","userpass","localhost")) end function getpin() session:streamFile(card_greeting_audio_file) card_pin = session:getDigits(4, "#", 3000); if card_pin > "" then freeswitch.consoleLog("info", "CARD INFO: PIN...........: ".. card_pin .."\n"); cur = assert( conn:execute( "select * from cards_table where pin =".. card_pin ..";" ) ) -- print all rows, the rows will be indexed by field names row = cur:fetch ({}, "a") fsLog("ROWS: ".. cur:numrows() ) if cur:numrows() > 0 then pinok=true end while row do fsLog("CARD INFO: Batch.........: ".. row.batch ) fsLog("CARD INFO: Card Name.....: ".. row.card_name ) fsLog("CARD INFO: Ratetable.....: ".. row.ratetable ) fsLog("CARD INFO: Initial Bal...: ".. row.init_bal ) fsLog("CARD INFO: Curr Balance..: ".. row.balance ) batch, ratetable, init_bal, balance = row.batch, row.ratetable, row.init_bal, row.balance SetVar("card_pin",card_pin) SetVar("card_batch", batch) SetVar("card_ratetable", ratetable) SetVar("card_init_bal", init_bal) SetVar("card_balance", balance) -- reusing the table of results row = cur:fetch (row, "a") end else pinok=false session:streamFile(card_invalid_pin_audio_file) end end On Thu, Jan 28, 2010 at 9:05 PM, Mike van Lammeren <mike@van.lammeren.net> wrote:
And you can make queries against your MySQL database, and get results, etc.?
On Thu, Jan 28, 2010 at 2:43 AM, David Villasmil <david.villasmil.work@gmail.com> wrote:
Hello,
That works fine:
box:~# lua testdb.lua box:~#
David
On Thu, Jan 28, 2010 at 7:27 AM, Mike van Lammeren <mike@van.lammeren.net> wrote:
Have you tried running a Lua script that includes the library from outside of FreeSWITCH? What does that do?
On Wed, Jan 27, 2010 at 11:47 PM, Adam Wilt <wiltingtree@gmail.com> wrote:
I tried running ldconfig on the directory containing mysql.so, but it did not help. So it sounds like there could be a bug in the latter versions?
On Wed, Jan 27, 2010 at 8:09 PM, David Villasmil <david.villasmil.work@gmail.com> wrote:
I got the same error, my script was working with no problems before an update to trunk.
David
On Thu, Jan 28, 2010 at 1:15 AM, Adam Wilt <wiltingtree@gmail.com> wrote:
Hi, I followed the instructions in the Lua documentation for setting up luasql, but when I try to run my script I get: 2010-01-27 19:08:14.799250 [ERR] mod_lua.cpp:182 error loading module 'luasql.mysql' from file '/usr/local/lib/lua/5.1/luasql/mysql.so': /usr/local/lib/lua/5.1/luasql/mysql.so: cannot restore segment prot after reloc: Permission denied stack traceback: [C]: ? [C]: in function 'require' /usr/local/freeswitch/scripts/l.lua:2: in main chunk I'm running FreeSWITCH version 1.4 and luasql version 2.1.1. I changed the permissions for mysql.so and for my script to 777, so I'm not sure where the permission problem could be. I'd appreciate any suggestions. Thanks, Adam
_______________________________________________ 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
_______________________________________________ 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
_______________________________________________ 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
_______________________________________________ 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
_______________________________________________ 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
_______________________________________________ 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