[Serusers] Juha: LCR Module Change

Juha Heinanen jh at lohi.tutpro.com
Sun Feb 20 05:10:47 CET 2005


Java Rockx writes:

 > '%','%','2','1'

you didn't read the readme carefully enough.  prefix is not pattern, but
a prefix.  so if you want a catch all rule, you have to have empty
prefix, not %.

 > However when next_gw() is called the following SQL is executed:
 > 
 > SELECT gw.ip_addr, gw.port 
 > FROM gw, lcr 
 > WHERE 'sip:3212518888 at sip.mycompany.com' LIKE lcr.from_uri AND 
 > '4073195555' LIKE CONCAT(lcr.prefix, '%') AND 
 > lcr.grp_id = gw.grp_id 
 > ORDER BY CHAR_LENGTH(lcr.prefix), lcr.priority DESC, RAND()
 > 
 > The ORDER BY clause causes the group #2 gateway to appear first in the
 > result set because '%' sorts before '407319'.

the last gw will appear first in mysql result, but then gws are added to
avps and the first will be the last.

-- juha




More information about the sr-users mailing list