13 Nov
2017
13 Nov
'17
8:38 a.m.
Hello List,
i use kamailio-5.0.4 and i experiment with the drouting module with
mysql-db.
I try to route with "alphanumeric" stuff - like 'tetris' in
sip://tetris@mytest.example
https://www.kamailio.org/docs/db-tables/kamailio-db-devel.html#idp31352844
The DB-Field is an 64 string like route-id. In dr_rules.route-id i can use
"named-routes"
if i leave the prefix empty or i fill in only numbers.
With strings i got this error:
ERROR: drouting [dr_load.c:555]: dr_load_routing_info(): failed to add rule
id 4 -> skipping
SQL Result for rule-id 4:
# dr_rules
# ruleid, groupid, prefix, timerec, priority, routeid, gwlist, description
'4', '9000', 'tetris', '', '0', 'tetris',
'4', 'testroute'
Is drouting only for "number-routing"?
--
Kind Regards
*Karsten Horsmann*
16 Nov
16 Nov
4:40 a.m.
Hi List,
i answer myself if someone search for the same problem and ends with no
solution.
Short answer to "drouting" based on "alphanumeric" prefix question is
- NO.
Only numbers are allowed, maybe a + sign, i dont check that.
2017-11-13 14:38 GMT+01:00 Karsten Horsmann <khorsmann(a)gmail.com>om>:
Hello List,
i use kamailio-5.0.4 and i experiment with the drouting module with
mysql-db.
I try to route with "alphanumeric" stuff - like 'tetris' in
sip://tetris@mytest.example
https://www.kamailio.org/docs/db-tables/kamailio-db-devel.html#idp31352844
The DB-Field is an 64 string like route-id. In dr_rules.route-id i can use
"named-routes"
if i leave the prefix empty or i fill in only numbers.
With strings i got this error:
ERROR: drouting [dr_load.c:555]: dr_load_routing_info(): failed to add
rule id 4 -> skipping
SQL Result for rule-id 4:
# dr_rules
# ruleid, groupid, prefix, timerec, priority, routeid, gwlist, description
'4', '9000', 'tetris', '', '0', 'tetris',
'4', 'testroute'
Is drouting only for "number-routing"?
--
Kind Regards
*Karsten Horsmann*
--
Mit freundlichen Grüßen
*Karsten Horsmann*
8:26 a.m.
Hi
Right now it is decimal digits, '*', '#', '+'
Was the discussion to make the list configurable someday
2017-11-16 12:40 GMT+03:00 Karsten Horsmann <khorsmann(a)gmail.com>om>:
Hi List,
i answer myself if someone search for the same problem and ends with no
solution.
Short answer to "drouting" based on "alphanumeric" prefix question is
- NO.
Only numbers are allowed, maybe a + sign, i dont check that.
2017-11-13 14:38 GMT+01:00 Karsten Horsmann <khorsmann(a)gmail.com>om>:
--
Savolainen Dmitri
Hello List,
i use kamailio-5.0.4 and i experiment with the drouting module with
mysql-db.
I try to route with "alphanumeric" stuff - like 'tetris' in
sip://tetris@mytest.example
https://www.kamailio.org/docs/db-tables/kamailio-db-devel.ht
ml#idp31352844
The DB-Field is an 64 string like route-id. In dr_rules.route-id i can
use "named-routes"
if i leave the prefix empty or i fill in only numbers.
With strings i got this error:
ERROR: drouting [dr_load.c:555]: dr_load_routing_info(): failed to add
rule id 4 -> skipping
SQL Result for rule-id 4:
# dr_rules
# ruleid, groupid, prefix, timerec, priority, routeid, gwlist, description
'4', '9000', 'tetris', '', '0', 'tetris',
'4', 'testroute'
Is drouting only for "number-routing"?
--
Kind Regards
*Karsten Horsmann*
--
Mit freundlichen Grüßen
*Karsten Horsmann*
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
9:48 a.m.
New subject: dr_load_routing_info(): failed to add rule id 4 -> skipping
Hello,
On 16.11.17 14:26, Dmitri Savolainen wrote:
Hi
Right now it is decimal digits, '*', '#', '+'
indeed, these seems to be the supported chars in the prefix value. I
just added the note about them in the docs/.
Was the discussion to make the list configurable someday
I don't recall the
discussion, maybe I haven't paid much attention
because I don't use this module that much and for what I do, it was
enough with these chars, but of course, making the supported chars list
a modparam will add more flexibility, so if anyone does a patch for it,
it will be merged...
Cheers,
Daniel
2017-11-16 12:40 GMT+03:00 Karsten Horsmann <khorsmann(a)gmail.com
<mailto:khorsmann@gmail.com>>:
Hi List,
i answer myself if someone search for the same problem and ends
with no solution.
Short answer to "drouting" based on "alphanumeric" prefix
question
is - NO.
Only numbers are allowed, maybe a + sign, i dont check that.
2017-11-13 14:38 GMT+01:00 Karsten Horsmann <khorsmann(a)gmail.com
<mailto:khorsmann@gmail.com>>:
Hello List,
i use kamailio-5.0.4 and i experiment with the drouting module
with mysql-db.
I try to route with "alphanumeric" stuff - like 'tetris' in
sip://tetris@mytest.example
https://www.kamailio.org/docs/db-tables/kamailio-db-devel.html#idp31352844
<https://www.kamailio.org/docs/db-tables/kamailio-db-devel.html#idp31352844>
The DB-Field is an 64 string like route-id. In
dr_rules.route-id i can use "named-routes"
if i leave the prefix empty or i fill in only numbers.
With strings i got this error:
ERROR: drouting [dr_load.c:555]: dr_load_routing_info():
failed to add rule id 4 -> skipping
SQL Result for rule-id 4:
# dr_rules
# ruleid, groupid, prefix, timerec, priority, routeid, gwlist,
description
'4', '9000', 'tetris', '', '0',
'tetris', '4', 'testroute'
Is drouting only for "number-routing"?
--
Kind Regards
*Karsten Horsmann*
--
Mit freundlichen Grüßen
*Karsten Horsmann*
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org <mailto:sr-users@lists.kamailio.org>
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
<https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users>
--
Savolainen Dmitri
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training, Nov 13-15, 2017, in Berlin - www.asipto.com
Kamailio World Conference - www.kamailioworld.com
9:57 a.m.
New subject: dr_load_routing_info(): failed to add rule id 4 -> skipping
Hello,
On 16.11.17 10:40, Karsten Horsmann wrote:
Hi List,
i answer myself if someone search for the same problem and ends with
no solution.
Short answer to "drouting" based on "alphanumeric" prefix question
is
- NO.
Only numbers are allowed, maybe a + sign, i dont check that.
answered by Dmitri in
another response, the chars allowed in prefix are
the digits, +, * and #.
Anyhow, even making it configurable, if you want to allow all the
alphanumeric chars in the prefix, the indexing of the prefixes becomes
inefficient, at least from memory point of view. The module uses tree
indexing for prefixes and each node is composed by so many items as
possible chars in the prefix, so the node size is going to be big if you
have lot of possible chars in it.
The usual solution in this case is to have two layers of indexing. Use
htable or dialplan modules to map between an alphanumeric value to a
numerical id and then use that id for matching in drouting (or other
tree indexing modules such as mtree).
Cheers,
Daniel
2017-11-13 14:38 GMT+01:00 Karsten Horsmann <khorsmann(a)gmail.com
<mailto:khorsmann@gmail.com>>:
Hello List,
i use kamailio-5.0.4 and i experiment with the drouting module
with mysql-db.
I try to route with "alphanumeric" stuff - like 'tetris' in
sip://tetris@mytest.example
https://www.kamailio.org/docs/db-tables/kamailio-db-devel.html#idp31352844
<https://www.kamailio.org/docs/db-tables/kamailio-db-devel.html#idp31352844>
The DB-Field is an 64 string like route-id. In dr_rules.route-id i
can use "named-routes"
if i leave the prefix empty or i fill in only numbers.
With strings i got this error:
ERROR: drouting [dr_load.c:555]: dr_load_routing_info(): failed to
add rule id 4 -> skipping
SQL Result for rule-id 4:
# dr_rules
# ruleid, groupid, prefix, timerec, priority, routeid, gwlist,
description
'4', '9000', 'tetris', '', '0',
'tetris', '4', 'testroute'
Is drouting only for "number-routing"?
--
Kind Regards
*Karsten Horsmann*
--
Mit freundlichen Grüßen
*Karsten Horsmann*
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training, Nov 13-15, 2017, in Berlin - www.asipto.com
Kamailio World Conference - www.kamailioworld.com
11:35 a.m.
Hello Daniel,
indeed dialplan could solve this. But i dont follow that because i dont
want to manipulate the $rU part.
So for my usecase as siprouter to route "comes from X goes to Y, comes from
Z goes to A" i use permissions module (comes from) and dispatcher (goes to)
.
Thanks for the drouting statement. Its okay. I was trapped by the db-field.
I try it and saw later that it was not the module i need.
Kind Regards
2017-11-16 15:57 GMT+01:00 Daniel-Constantin Mierla <miconda(a)gmail.com>om>:
Hello,
On 16.11.17 10:40, Karsten Horsmann wrote:
Hi List,
i answer myself if someone search for the same problem and ends with no
solution.
Short answer to "drouting" based on "alphanumeric" prefix question is
- NO.
Only numbers are allowed, maybe a + sign, i dont check that.
answered by Dmitri in another response, the chars allowed in prefix are
the digits, +, * and #.
Anyhow, even making it configurable, if you want to allow all the
alphanumeric chars in the prefix, the indexing of the prefixes becomes
inefficient, at least from memory point of view. The module uses tree
indexing for prefixes and each node is composed by so many items as
possible chars in the prefix, so the node size is going to be big if you
have lot of possible chars in it.
The usual solution in this case is to have two layers of indexing. Use
htable or dialplan modules to map between an alphanumeric value to a
numerical id and then use that id for matching in drouting (or other tree
indexing modules such as mtree).
Cheers,
Daniel
2017-11-13 14:38 GMT+01:00 Karsten Horsmann <khorsmann(a)gmail.com>om>:
--
Mit freundlichen Grüßen
*Karsten Horsmann*
Hello List,
i use kamailio-5.0.4 and i experiment with the drouting module with
mysql-db.
I try to route with "alphanumeric" stuff - like 'tetris' in
sip://tetris@mytest.example
https://www.kamailio.org/docs/db-tables/kamailio-db-devel.ht
ml#idp31352844
The DB-Field is an 64 string like route-id. In dr_rules.route-id i can
use "named-routes"
if i leave the prefix empty or i fill in only numbers.
With strings i got this error:
ERROR: drouting [dr_load.c:555]: dr_load_routing_info(): failed to add
rule id 4 -> skipping
SQL Result for rule-id 4:
# dr_rules
# ruleid, groupid, prefix, timerec, priority, routeid, gwlist, description
'4', '9000', 'tetris', '', '0', 'tetris',
'4', 'testroute'
Is drouting only for "number-routing"?
--
Kind Regards
*Karsten Horsmann*
--
Mit freundlichen Grüßen
*Karsten Horsmann*
_______________________________________________
Kamailio (SER) - Users Mailing
Listsr-users@lists.kamailio.orghttps://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierlawww.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training, Nov 13-15, 2017, in Berlin - www.asipto.com
Kamailio World Conference - www.kamailioworld.com
12:52 p.m.
New subject: dr_load_routing_info(): failed to add rule id 4 -> skipping
Hello,
On 16.11.17 17:35, Karsten Horsmann wrote:
Hello Daniel,
indeed dialplan could solve this. But i dont follow that because i
dont want to manipulate the $rU part.
if you do not set subst_exp and repl_exp, then no change is done.
To make that feature more visible, the upcoming 5.1 has a dedicated
function just to do the match:
-
https://www.kamailio.org/docs/modules/devel/modules/dialplan.html#dialplan.…
Cheers,
Daniel
So for my usecase as siprouter to route "comes
from X goes to Y, comes
from Z goes to A" i use permissions module (comes from) and dispatcher
(goes to) .
Thanks for the drouting statement. Its okay. I was trapped by the
db-field. I try it and saw later that it was not the module i need.
Kind Regards
2017-11-16 15:57 GMT+01:00 Daniel-Constantin Mierla <miconda(a)gmail.com
<mailto:miconda@gmail.com>>:
Hello,
On 16.11.17 10:40, Karsten Horsmann wrote:
--
Daniel-Constantin Mierla
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training, Nov 13-15, 2017, in Berlin - www.asipto.com
Kamailio World Conference - www.kamailioworld.com
Hi List,
i answer myself if someone search for the same problem and ends
with no solution.
Short answer to "drouting" based on "alphanumeric" prefix
question is - NO.
Only numbers are allowed, maybe a + sign, i dont check that.
answered by
Dmitri in another response, the chars allowed in
prefix are the digits, +, * and #.
Anyhow, even making it configurable, if you want to allow all the
alphanumeric chars in the prefix, the indexing of the prefixes
becomes inefficient, at least from memory point of view. The
module uses tree indexing for prefixes and each node is composed
by so many items as possible chars in the prefix, so the node size
is going to be big if you have lot of possible chars in it.
The usual solution in this case is to have two layers of indexing.
Use htable or dialplan modules to map between an alphanumeric
value to a numerical id and then use that id for matching in
drouting (or other tree indexing modules such as mtree).
Cheers,
Daniel
2017-11-13 14:38 GMT+01:00 Karsten Horsmann <khorsmann(a)gmail.com
<mailto:khorsmann@gmail.com>>:
Hello List,
i use kamailio-5.0.4 and i experiment with the drouting
module with mysql-db.
I try to route with "alphanumeric" stuff - like 'tetris' in
sip://tetris@mytest.example
https://www.kamailio.org/docs/db-tables/kamailio-db-devel.html#idp31352844
<https://www.kamailio.org/docs/db-tables/kamailio-db-devel.html#idp31352844>
The DB-Field is an 64 string like route-id. In
dr_rules.route-id i can use "named-routes"
if i leave the prefix empty or i fill in only numbers.
With strings i got this error:
ERROR: drouting [dr_load.c:555]: dr_load_routing_info():
failed to add rule id 4 -> skipping
SQL Result for rule-id 4:
# dr_rules
# ruleid, groupid, prefix, timerec, priority, routeid,
gwlist, description
'4', '9000', 'tetris', '', '0',
'tetris', '4', 'testroute'
Is drouting only for "number-routing"?
--
Kind Regards
*Karsten Horsmann*
--
Mit freundlichen Grüßen
*Karsten Horsmann*
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org <mailto:sr-users@lists.kamailio.org>
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
<https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users>
--
Daniel-Constantin Mierla
www.twitter.com/miconda <http://www.twitter.com/miconda> --
www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
Kamailio Advanced Training, Nov 13-15, 2017, in Berlin - www.asipto.com
<http://www.asipto.com>
Kamailio World Conference - www.kamailioworld.com
<http://www.kamailioworld.com>
--
Mit freundlichen Grüßen
*Karsten Horsmann*
2651
days inactive
2654
days old
6 comments
3 participants
participants (3)
-
Daniel-Constantin Mierla -
Dmitri Savolainen -
Karsten Horsmann