[SR-Users] Issue in Dialplan Module

[Logeshwaran G]

Issue Resolved.. Thanks a lot For you Inputs.

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

Thanks & Kind Regards,
Logeshwaran G

On Thu, Aug 10, 2017 at 10:13 AM, Logeshwaran G <logeshwarangs at gmail.com>
wrote:

> 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/a2c12259/attachment.html>