VoIP Mailing List Archives

[juanbackson at gmail.com]

Hi,

My lua scripts were working fine until I updated with SVN. I am starting to get errors in my lua scripts that use luasql lib.

Does anyone know what may be causing the problem and how can I fix it?


2008-09-24 20:02:20 [DEBUG] switch_core_state_machine.c:140 switch_core_standard_on_execute() sofia/internal/6002@192.168.1.101 (6002@192.168.1.101) Execute lua(process_pstn_call.lua ) 2008-09-24 20:02:20 [ERR] mod_lua.cpp:177 lua_parse_and_execute() 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: undefined symbol: lua_getfieldstack traceback: [C]: ? [C]: in function 'require' /usr/local/share/lua/5.1/lualib.lua:1: in main chunk [C]: in function 'require' /usr/local/freeswitch/scripts/process_pstn_call.lua:1: in main chunk
2008-09-24 20:02:20 [DEBUG] switch_cpp.cpp:849 destroy() destroy/unlink session from object
2008-09-24 20:02:20 [NOTICE] switch_cpp.cpp:851 destroy() Hangup sofia/internal/6002@192.168.1.101 (6002@192.168.1.101) [CS_EXECUTE] [NORMAL_CLEARING]
2008-09-24 20:02:20 [DEBUG] switch_channel.c:1381 switch_channel_perform_hangup() Kill sofia/internal/6002@192.168.1.101 (6002@192.168.1.101) [KILL]
2008-09-24 20:02:20 [DEBUG] switch_core_session.c:727 switch_core_session_signal_state_change() Kill sofia/internal/6002@192.168.1.101 (6002@192.168.1.101) [BREAK]
2008-09-24 20:02:20 [DEBUG] switch_core_state_machine.c:430 switch_core_session_run() (sofia/internal/6002@192.168.1.101 (6002@192.168.1.101)) State EXECUTE going to sleep
2008-09-24 20:02:20 [DEBUG] switch_core_state_machine.c:365 switch_core_session_run() sofia/internal/6002@192.168.1.101 (6002@192.168.1.101) Running State Change CS_HANGUP
2008-09-24 20:02:20 [DEBUG] switch_core_state_machine.c:393 switch_core_session_run() (sofia/internal/6002@192.168.1.101 (6002@192.168.1.101)) State HANGUP
2008-09-24 20:02:20 [DEBUG] mod_sofia.c:272 sofia_on_hangup() Channel sofia/internal/6002@192.168.1.101 (6002@192.168.1.101) hanging up, cause: NORMAL_CLEARING
2008-09-24 20:02:20 [DEBUG] mod_sofia.c:346 sofia_on_hangup() Responding to INVITE with: 480
2008-09-24 20:02:20 [DEBUG] sofia.c:200 sofia_event_callback() event [nua_i_state] status [480][Temporarily Unavailable] session: sofia/internal/6002@192.168.1.101 (6002@192.168.1.101)
2008-09-24 20:02:20 [ERR] switch_core_sqldb.c:131 switch_core_db_persistant_execute() SQL ERR [table sip_dialogs has no column named profile_name]



Regards,
JB

[mike at jerris.com]

On Sep 24, 2008, at 12:08 AM, Juan Backson wrote:

[juanbackson at gmail.com]

Hi Michael,

Thank you for your prompt reply. I recently updated to the latest svn. I believe the old build that was working fine was from last Friday and the one I updated to was basically the latest as of today.

After updating to the latest svn, all my lua scripts can't run due to the same error.

Any help in getting my FS to work again would be grealy appreciated.

Thanks,
JB


On Wed, Sep 24, 2008 at 10:46 PM, Michael Jerris <mike@jerris.com (mike@jerris.com)> wrote:

[mike at jerris.com]

That looked like an error loading luasql. Nothing changed recently in lua or the freeswitch objects exposed to it.

Mike

On Sep 24, 2008, at 10:57 AM, Juan Backson wrote:

[juanbackson at gmail.com]

Hi Mike,

The second error does seem to be a freeswitch erro: 2008-09-24 20:02:20 [ERR] switch_core_sqldb.c:131 switch_core_db_persistant_execute() SQL ERR [table sip_dialogs has no column named profile_name]

I start to get this with the new build. Is there anything I am missing in my installation?

Thanks,
JB


On Wed, Sep 24, 2008 at 11:06 PM, Michael Jerris <mike@jerris.com (mike@jerris.com)> wrote:

[anthony.minessale at g...]

the table schema has changed

rm /usr/local/freeswitch/db/sofia*.db


On Wed, Sep 24, 2008 at 6:38 PM, Juan Backson <juanbackson@gmail.com (juanbackson@gmail.com)> wrote:

[juanbackson at gmail.com]

Hi,

I just refreshed another working FS enviornment with the latest SVN, that environment was working fine until I installed the latest build. The luasql error starts to pop up. The only working environment I have now is running on last week's build.

If I run run require("luasql.mysql") on unix, I don't see anything wrong.

[anthony.minessale at g...]

what is the exact svn revision of the one that works?

On Wed, Sep 24, 2008 at 6:54 PM, Juan Backson <juanbackson@gmail.com (juanbackson@gmail.com)> wrote:

[juanbackson at gmail.com]

Hi,

The one that is working has version: FreeSWITCH Version 1.0.trunk (9588)
The one that is not working has version: FreeSWITCH Version 1.0.trunk (9634M)


Thanks,
JB

On Thu, Sep 25, 2008 at 7:56 AM, Anthony Minessale <anthony.minessale@gmail.com (anthony.minessale@gmail.com)> wrote:

[mike at jerris.com]

We have confirmed that the change in svn revision 9605 broke this. I am going to look at ways to fix this in the morning.

Mike

On Sep 24, 2008, at 8:50 PM, Juan Backson wrote: