[Freeswitch-users] error loading module 'luasql.mysql'

[David Villasmil]

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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>