[Freeswitch-users] error loading module 'luasql.mysql'
Rob Forman
rob4manhere at gmail.com
Fri Jan 29 07:59:08 PST 2010
http://wiki.freeswitch.org/wiki/FS_weekly_2010_01_29
Calling Instructions
Friday January 29 at 1700 UTC (1100 CST)
sip:888 at conference.freeswitch.org or via the good old PSTN at
+1-919-386-9900
Or click on this link
Or call Skype the skype user "skypiax5", then press "1" on the Skype
dialpad (max 20 concurrent users).
Codecs: PCMU/PCMA, G.722, CELT, Speex, Skype, among others
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 at 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 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
>>
>>
>> _______________________________________________
>> 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/158765c3/attachment-0002.html
More information about the FreeSWITCH-users
mailing list