[SR-Users] Issue in Dialplan Module

[Logeshwaran G]

Hi,
I have changed the rules as you mentioned

INSERT INTO dialplan(id, dpid, pr, match_op, match_exp, match_len,
subst_exp, repl_exp, attrs) VALUES (1, "1", "1", 1, "^000[0-9]+$ ", 0,
"^000([0-9]+)$", "\\1", " ");

Eventhough its failing.

Thanks & Kind Regards,
Logeshwaran G

On Wed, Aug 9, 2017 at 5:05 PM, Daniel Tryba <d.tryba at pocos.nl> wrote:

> On Wed, Aug 09, 2017 at 01:34:13PM +0530, Logeshwaran G wrote:
> > I have given the below query,
> >
> > INSERT INTO dialplan(id, dpid, pr, match_op, match_exp, match_len,
> > subst_exp, repl_exp, attrs) VALUES (1, "1", "1", 1, "^000[0-9]+$ ", 0,
> > "^000([0-9]+)$", "\1", " ");
> >
> > But the Rule is tking as "1"
>
> See
> https://dev.mysql.com/doc/refman/5.7/en/string-literals.html
> "Within a string, certain sequences have special meaning unless the
> NO_BACKSLASH_ESCAPES SQL mode is enabled. Each of these sequences begins
> with a backslash (\), known as the escape character. MySQL recognizes
> the escape sequences shown in Table 9.1, “Special Character Escape
> Sequences”. For all other escape sequences, backslash is ignored. That
> is, the escaped character is interpreted as if it was not escaped. For
> example, \x is just x. These sequences are case sensitive. For example,
> \b is interpreted as a backspace, but \B is interpreted as B. "
>
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20170810/ae747292/attachment.html>