Luasql.postgres loading issue
Hi All, I'm using lua to the access the postgresql, but get the error as below. Any help is appreciated.I did a lot search in the list and on internet, however didn't find the solution. 2013-01-03 18:16:02.165155 [NOTICE] switch_ivr.c:1801 Transfer sofia/internal/kevin@192.168.1.200 to XML[9908@default] 2013-01-03 18:16:02.165155 [INFO] mod_dialplan_xml.c:557 Processing kevin <kevin>->9908 in context default 2013-01-03 18:16:02.243548 [ERR] mod_lua.cpp:198 error loading module 'luasql.postgres' from file '/usr/local/lib/lua/5.1/luasql/postgres.so': /usr/lib/libnssutil3.so: undefined symbol: PR_GetDirectorySeparator stack traceback: [C]: ? [C]: in function 'require' /opt/freeswitch/scripts/cbdemo.lua:1: in main chunk Thanks,Kevin
Like to add some additional info:I'm using the latest stable freeswitch and Postgres9.2.1, runing on CentOS6.2.and built the luaSql per the wiki, the config file was changed as below T= postgres #T= sqlite#LUA_INC= $(PREFIX)/include LUA_INC= /usr/local/src/freeswitch/src/mod/languages/mod_lua/lua/ ######## PostgreSQL DRIVER_LIBS= -L/opt/postgres9.2/lib -lpq DRIVER_INCS= -I/opt/postgres9.2/include/.... Thanks,KevinFrom: kevin.jzh@hotmail.com To: freeswitch-users@lists.freeswitch.org Date: Fri, 4 Jan 2013 20:55:55 +0800 Subject: [Freeswitch-users] Luasql.postgres loading issue Hi All, I'm using lua to the access the postgresql, but get the error as below. Any help is appreciated. I did a lot search in the list and on internet, however didn't find the solution. 2013-01-03 18:16:02.165155 [NOTICE] switch_ivr.c:1801 Transfer sofia/internal/kevin@192.168.1.200 to XML[9908@default] 2013-01-03 18:16:02.165155 [INFO] mod_dialplan_xml.c:557 Processing kevin <kevin>->9908 in context default 2013-01-03 18:16:02.243548 [ERR] mod_lua.cpp:198 error loading module 'luasql.postgres' from file '/usr/local/lib/lua/5.1/luasql/postgres.so': /usr/lib/libnssutil3.so: undefined symbol: PR_GetDirectorySeparator stack traceback: [C]: ? [C]: in function 'require' /opt/freeswitch/scripts/cbdemo.lua:1: in main chunk Thanks, Kevin _________________________________________________________________________ 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
I would advise that you don't use the luasql method. Instead use the FS core pgsql support. William King Senior Engineer Quentus Technologies, INC 1037 NE 65th St Suite 273 Seattle, WA 98115 Main: (877) 211-9337 Office: (206) 388-4772 Cell: (253) 686-5518 william.king@quentustech.com On 01/04/2013 07:09 PM, JinKevin wrote:
Like to add some additional info: I'm using the latest stable freeswitch and Postgres9.2.1, runing on CentOS6.2. and built the luaSql per the wiki, the config file was changed as below
T= postgres #T= sqlite #LUA_INC= $(PREFIX)/include LUA_INC= /usr/local/src/freeswitch/src/mod/languages/mod_lua/lua/ ######## PostgreSQL DRIVER_LIBS= -L/opt/postgres9.2/lib -lpq DRIVER_INCS= -I/opt/postgres9.2/include/ ....
Thanks, Kevin ------------------------------------------------------------------------ From: kevin.jzh@hotmail.com To: freeswitch-users@lists.freeswitch.org Date: Fri, 4 Jan 2013 20:55:55 +0800 Subject: [Freeswitch-users] Luasql.postgres loading issue
Hi All,
I'm using lua to the access the postgresql, but get the error as below. Any help is appreciated. I did a lot search in the list and on internet, however didn't find the solution.
2013-01-03 18:16:02.165155 [NOTICE] switch_ivr.c:1801 Transfer sofia/internal/kevin@192.168.1.200 <mailto:sofia/internal/kevin@192.168.1.200> to XML[9908@default] 2013-01-03 18:16:02.165155 [INFO] mod_dialplan_xml.c:557 Processing kevin <kevin>->9908 in context default 2013-01-03 18:16:02.243548 [ERR] mod_lua.cpp:198 error loading module 'luasql.postgres' from file '/usr/local/lib/lua/5.1/luasql/postgres.so': /usr/lib/libnssutil3.so: undefined symbol: PR_GetDirectorySeparator stack traceback: [C]: ? [C]: in function 'require' /opt/freesw itch/scripts/cbdemo.lua:1: in main chunk
Thanks, Kevin
_________________________________________________________________________ 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
participants (2)
-
JinKevin
-
William King