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

Michael Collins msc at freeswitch.org
Fri Jan 29 07:30:55 PST 2010


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 at 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 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
> >
> >
>
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20100129/1906651b/attachment-0002.html 


More information about the FreeSWITCH-users mailing list