On Jan 29, 2010, at 9:51 AM, David Villasmil wrote:

Today what time/timezone?

On Fri, Jan 29, 2010 at 4:30 PM, Michael Collins <msc@freeswitch.org> wrote:
David,

Are you using Lua and lusql for some exotic call handling scenarios? If so,
would you mind posting some examples to the wiki and then linking here?
Also, if you can join the community conference call today that would be
great!

Thanks,
MC

On Fri, Jan 29, 2010 at 7:22 AM, David Villasmil
<david.villasmil.work@gmail.com> wrote:

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

_______________________________________________
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

http://wiki.freeswitch.org/wiki/FS_weekly_2010_01_29

Calling Instructions