I suppose I just could do sql direct on lcr_gw table like
 
select ip_addr, prefix from lcr_gw where gw_name = "my_termination_provider"
 
What I wanted to know is a module already doing this function.
 
I am looking for a function because in theory it will be more tested and because i heard sql directly is prone to memory leaks
 
 
 


29.11.2017, 11:29, "voipspace voipspace" <voipspace@yandex.com>:
Hi
 
I want to build the following scenerio
 
There should be some sort of database table to hold a list of gateway entries with fields ip, prefix, and name/description.
 
It would be good to use exiting tables to use what is avaiable. Have been looking at the lcr and drouting tables
but it seems they are designed to choose automaticaly for you and not just returning data about specific entries.
 
Please suggest how I may archive the following
 
Kamailio will receive a request it will then send to another Kamailio redirect server.
The response from the redirect will have a sip header value holding the id/name of the gateway choosen.
 
I want Kamailio processing the reponse to use the gateway id/name to lookup on the table and access the full details
ip, prefix details. 
 
This data can then be used to construct the relay parameter.
 
Regards