[OpenSER-Users] RE: OpenSER Oracle Connection - sr-users

23 Aug 2007

Hi Martin,

No I did not do any changes in openserctlrc, because I do not do any db
interaction through openserctl. In 1.2 lcr is only working in caching
mode and it just loads all the data from tables lcr and gw into memory.
Run
/usr/local/openser-1.2.x/sbin/openserctl fifo lcr_dump
to see what is in memory.

best regards

George

...
  -----Original Message-----
 From: Martin.Gruber1(a)infineon.com 
 [mailto:Martin.Gruber1@infineon.com] 
 Sent: Wednesday, August 22, 2007 7:02 PM
 To: Papadopoulos Georgios
 Cc: users(a)openser.org
 Subject: RE: OpenSER Oracle Connection

 Hi,

 I am sorry to disturb you again, but did you change your 
 "openserctlrc"
 for using oracle. I need information what openser sends to my Database
 (queries) or what are the rules for LCR.

 Thanks for your help!

 Regards

 Martin 

 -----Original Message-----
 From: Papadopoulos Georgios [mailto:geop@altectelecoms.gr]
 Sent: Wednesday, August 22, 2007 4:48 PM
 To: Gruber Martin (IFKL IT OS NV)
 Cc: users(a)openser.org
 Subject: RE: OpenSER Oracle Connection

 Hi Martin,

 In OpenSER 1.1, the lcr module would not work with oracle 
 through unixodbc when used in the non-caching mode. That was 
 because the query was using functions CHAR_LENGTH and RAND 
 that are unknown to oracle. 
 In OpenSER 1.2 the lcr module is only working in caching 
 mode. So there should be no problem.
 Probably what you need is .* or the appropriate regexp in the 
 from_uri.
 Check the lcr document for more info.

 Best regards

 George

  -----Original Message-----
 From: Martin.Gruber1(a)infineon.com
 [mailto:Martin.Gruber1@infineon.com]
 Sent: Wednesday, August 22, 2007 3:39 PM
 To: Papadopoulos Georgios
 Cc: users(a)openser.org
 Subject: RE: OpenSER Oracle Connection

 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@server.com> from <sip:1004@server.com>
  0(23072) LCR: no gateways found m=INVITE 
 ruri=sip:0004312345586@server.com f=sip:1004@server.com 
 t=sip:0004312345586@server.com ip=xxx.xx.xxx.xxx

 My openser.cfg looks like this:

 if (uri=~"sip:0[0-9]+@.*")
    {
    #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

 Disclaimer
 The information in this e-mail and any attachments is 
 confidential. It is intended solely for the attention and use 
 of the named addressee(s).
 If you are not the intended recipient, or person responsible 
 for delivering this information to the intended recipient, 
 please notify the sender immediately. Unless you are the 
 intended recipient or his/her representative you are not 
 authorized to, and must not, read, copy, distribute, use or 
 retain this message or any part of it. E-mail transmission 
 cannot be guaranteed to be secure or error-free as 
 information could be intercepted, corrupted, lost, destroyed, 
 arrive late or incomplete, or contain viruses.