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