[asterisk-bugs] [JIRA] (ASTERISK-19254) When working in real time with ARA and MySQL the backslashes not works properly

[Ishfaq Malik (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-19254?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=222745#comment-222745 ] 

Ishfaq Malik commented on ASTERISK-19254:
-----------------------------------------

I can confirm that replacing ";" with "^3B" in the column value worked for me.

> When working in real time with ARA and MySQL the backslashes not works properly
> -------------------------------------------------------------------------------
>
>                 Key: ASTERISK-19254
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-19254
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Addons/app_mysql
>    Affects Versions: 1.8.8.2
>         Environment: Debian GNU/Linux 6.0.3
>            Reporter: Janu
>
> Hello.
> I found a problem with MySQL Realtime in the dialplan.
> I'm trying to set different ring tones in a Snom 3xx, like this:
> http://asterisk.snom.com/index.php/Asterisk_1.6/Ringtone_Configuration
> As you can see we have to add this application:
> SIPAddHeader("Alert-Info:<http://nohost>\;info=alert-internal\;x-line-id=0")
> This example works properly in typical static configurations, like this:
> exten => _XXX,1,SIPAddHeader("Alert-Info:<http://nohost>\;info=alert-internal\;x-line-id=0")
> exten => _XXX,n,Dial(SIP/${EXTEN})
> exten => _XXX,n,Hangup
> This is the simple programming dialplan in MySQL database:
> mysql> SELECT * FROM dialplan WHERE exten='_XXX' ORDER BY priority;
> +-----+---------+-------+----------+--------------+------------------------------------------------
> + id  | context | exten | priority | app          | appdata                                                      
> +-----+---------+-------+----------+--------------+------------------------------------------------
> + 597 | intern  | _XXX  |        1 | SIPAddHeader | Alert-Info:<http://nohost>\;info=alert-internal\;x-line-id=0
> + 551 | intern  | _XXX  |        2 | Dial         | SIP/${EXTEN},15,Tt                                          
> + 552 | intern  | _XXX  |        3 | Hangup       |                                                             
> +-----+---------+-------+----------+--------------+------------------------------------------------
> 3 rows in set (0.00 sec)
> The result of the execution in the CLI is:
>   == Using SIP RTP CoS mark 5
>     -- Executing [202 at intern:1] SIPAddHeader("SIP/201-00000000", "x-line-id=0")
>     -- Executing [202 at intern:2] Dial("SIP/201-00000000", "SIP/202,15,Tt")
> Note that only displays the text after the last backslash.
> I found in the archive from the list of digium a user already reported the error in the past:
> http://lists.digium.com/pipermail/asterisk-users/2007-September/196183.html
> Thanks for your time.



--
This message was sent by Atlassian JIRA
(v6.2#6252)