[OpenSER-Users] RE: OpenSER Oracle Connection

[Martin.Gruber1 at infineon.com]

Hi Georgios,

I only want to ask you, if you also use the LCR-Tool.
With mysql it was running well, but now I have problems with it. I do
not know, if it is a problem of
Unixodbc (I do not think so).

I use the following table structure:
Lcr:


PREFIX		| 	FROM_URI	|	GRP_ID		|
PRIORITY		|
------------------------------------------------------------------------
------------------------------------------------------------- 
		|			|	1		|
1		|

Gw:

GW_NAME	|	GRP_ID 	|	IP_ADDR	| 	PORT	|
URI_SCHEME	|	TRANSPORT	|   STRIP    |	PREFIX
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-------------
Gw			1			xxx.xx.xxx.xx
5060		
         

Gw_grp:

    GRP_ID GRP_NAME
----------
----------------------------------------------------------------
         1 VIH



I always get the following error:
CALL: Call to international number <sip:0004312345586 at server.com> from
<sip:1004 at server.com>
 0(23072) LCR: no gateways found m=INVITE
ruri=sip:0004312345586 at server.com f=sip:1004 at server.com
t=sip:0004312345586 at server.com ip=xxx.xx.xxx.xxx 

My openser.cfg looks like this:

if (uri=~"sip:0[0-9]+ at .*")
   {
   #authorize if a call is going to PSTN
   if(!proxy_authorize("", "subscriber"))
    {
     proxy_challenge("", "0");
     return;
    };
    xlog("L_INFO", "CALL: Call to international number <$ru> from
<$fu>\n");
    
    perl_exec("dialnr");

    if(!load_gws())
    {
     sl_send_reply("500", "Internal server error, unable to load phone
gateways");
     xlog("L_Info", "LCR: unable to load gateways\n");
     exit;
    }

    if(!next_gw())
     {
      sl_send_reply("503", "Service not available, no gateways found");
      xlog("L_Info", "LCR: no gateways found m=$rm ruri=$ru f=$fu t=$tu
ip=$si id=$ci\n");
      exit;
     };


Can you help me?

Thanks and regards

Martin