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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 22, 2007 3:39 PM > To: Papadopoulos Georgios > Cc: [email protected] > 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:[EMAIL PROTECTED]> from <sip:[EMAIL PROTECTED]> > 0(23072) LCR: no gateways found m=INVITE > ruri=sip:[EMAIL PROTECTED] f=sip:[EMAIL PROTECTED] > t=sip:[EMAIL PROTECTED] ip=xxx.xx.xxx.xxx > > My openser.cfg looks like this: > > if (uri=~"sip:[EMAIL PROTECTED]") > { > #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. _______________________________________________ Users mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/users
