[Home]

Summary:ASTERISK-17544: error loading module 'luasql.postgres'
Reporter:vfabi (vfabi)Labels:
Date Opened:2011-03-11 18:27:38.000-0600Date Closed:2011-06-07 14:04:47
Priority:MinorRegression?No
Status:Closed/CompleteComponents:PBX/pbx_lua
Versions:1.6.2.17 Frequency of
Occurrence
Related
Issues:
Environment:Attachments:( 0) extensions.lua
Description:Get this error trying to execute extensions.lua:

ERROR[12282]: pbx_lua.c:1090 lua_get_state: Error loading extensions.lua: error loading module 'luasql.postgres' from file '/usr/local/lib/lua/5.1/luasql/postgres.so':
       dynamic libraries not enabled; check your Lua installation

or

call*CLI> reload
call*CLI> [Mar 12 03:29:07] ERROR[22058]: pbx_lua.c:1434 load_or_reload_lua_stuff: Error loading extensions.lua: error loading module 'luasql.postgres' from file '/usr/local/lib/lua/5.1/luasql/postgres.so':
       dynamic libraries not enabled; check your Lua installation

If extensions.lua run from console it's ok, but from asterisk get this error.

extensions.lua:
--
--
--
require "luasql.postgres"

DBNAME = "dbtest"
DBUSER = "tsetuser"
DBPASSWORD = "testpass"
DBHOST = "100.100.100.34"

function get_numbers(did, ip)
       env = assert (luasql.postgres())
       con = assert (env:connect('dbname='..DBNAME..' user='..DBUSER..' password='..DBPASSWORD..' host='..DBHOST))
       cur = assert (con:execute("SELECT cr.numbers FROM dids d INNER JOIN trunks t ON t.id = d.id_trunks INNER JOIN companies c ON c.id = d.id_companies INNER JOIN companies_redirects cr ON cr.id = d.id_companies_redirects WHERE d.did = '"..did.."' AND c.status = 'active' AND cr.status = 'active' AND t.status = 'active' AND t.ip_address = '"..ip.."' "))
       row = assert (cur:fetch())
       cur:close()
       con:close()
       env:close()
       return row
end

function do_some_fun()
   local ext = get_numbers("1234567890","100.100.100.33")
   app.dial("SIP/" .. ext)
end


extensions = {
   dbtest = {
                   ["_X."] = function()
                   app.background("you-entered")
                   do_some_fun()
                   end;
       

   };
   default = {
               include = {"dbtest"};
   };
}
Comments:By: vfabi (vfabi) 2011-03-11 21:29:08.000-0600

OS - CentOS release 5.4

Lua and libs installed from rpms:
lua-5.1.4-4.el5
lua-filesystem-1.4.2-1.el5
lua-devel-5.1.4-4.el5
lua-posix-5.1.7-1.el5
lua-sql-postgresql-2.1.1-7.el5


By: vfabi (vfabi) 2011-03-12 13:19:58.000-0600

[RESOLVED]
To resolve problem recompile lua in dynamic way.