22 Aug
2007
22 Aug
'07
2:48 p.m.
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.
22 Aug
22 Aug
2:57 p.m.
Hi,
I use OpenSER 1.2 but is there any possiblity to switch caching mode on.
Since Version 1.2 the command
modparam("lcr","db_mode",1) is not available anymore.
I added .* to from_uri, but always get the same error. Do you use LCR
too?
http://openser.org/docs/modules/1.2.x/lcr.html -> do you mean this to be
the lcr document?
Thanks!
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.
4:02 p.m.
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.
6173
days inactive
6173
days old
2 comments
2 participants
participants (2)
-
Martin.Gruber1＠infineon.com -
Papadopoulos Georgios