[Serusers] Juha: LCR Module Change
Java Rockx
javarockx at gmail.com
Sun Feb 20 05:36:37 CET 2005
Thanks for clearing that up. Things make much more sense now :-)
Paul
On Sun, 20 Feb 2005 06:10:47 +0200, Juha Heinanen <jh at lohi.tutpro.com> wrote:
> 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