I've seen stability problems reported on the list using luasql before. Personally I'd use freeswitch.Dbh as Valliamamod suggests - it'll connect to any database that FS's DSN can which includes ODBC and native support for PostgreSQL and Sqlite, and takes advantage of the database pooling that FS provides that luasql won't.


On 13 July 2014 19:00, Peter Villeneuve <petervnv1@gmail.com> wrote:
Thanks Vallimamod.

I will try to compile and let the list know if that solved it. I highly doubt I'm the only one in this list using lua to connect to mysql with FS.
I wonder if the problem is only with my setup since no one else seems to be having this problem.

Cheers,
Peter


On Sun, Jul 13, 2014 at 6:33 PM, Vallimamod Abdullah <vma@440hz.fr> wrote:
Hi Peter,

The lua_settop function is part of lua C api: http://www.lua.org/pil/24.2.3.html
If you are using your system’s packaged lib, you may have a compatibility problem with the freeswitch shipped lua version. So you should try to compile your lua mysql lib from source with the lua source located in freeswitch/src/mod/languages/mod_lua/lua. First do ‘make linux’ in this directory to build the lua standalone interpreter and then, point to this directory as your lua source / include dir when compiling the mysql lib.

Also, if you are already using a db with freeswith (native postgres or via odbc,) you should use definitely use freeswitch.Dbh (https://wiki.freeswitch.org/wiki/Mod_lua#freeswitch.Dbh)

Hope this help!

Best Regards,
Vallimamod
.


On 13 Jul 2014, at 18:27, Peter Villeneuve <petervnv1@gmail.com> wrote:

> Bump.
> Anyone seen this error before?
>
>
> On Sat, Jul 12, 2014 at 10:29 PM, Peter Villeneuve <petervnv1@gmail.com> wrote:
> Hi,
>
> I'm trying to use a lua script to grab voicemail PINs from Kamailio's db as shown here
>
> However, I get the following error message which is driving me nuts. Googling for the "undefined symbol: lua_settop" error message doesn't seem to return anything relevant, and looking around the FS wiki here didn't help either.
>
> [ERR] mod_lua.cpp:199 error loading module 'luasql.mysql' from file '/usr/lib/x86_64-linux-gnu/lua/5.1/luasql/mysql.so':
>        /usr/lib/x86_64-linux-gnu/lua/5.1/luasql/mysql.so: undefined symbol: lua_settop
> stack traceback:
>        [C]: in ?
>        [C]: in function 'require'
>        /usr/local/freeswitch/scripts/sqluser.lua:14: in main chunk
> 2014-07-12 22:21:17.470474 [ERR] mod_lua.cpp:265 LUA script parse/execute error!
>
>
> Any ideas?
>
> Thanks

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

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


_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

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