[asterisk-users] SIPAddHeader from a realtime databse

[Rusty Newton]

On Mon, Sep 22, 2014 at 9:43 AM, Ishfaq Malik <ish at pack-net.co.uk> wrote:
> Hi Guys
>
> I'm using asterisk 1.8.23.1
>
> When I add a SIP Header from inside the extensions.conf
> (SIPAddHeader(Alert-Info:<http://www.notused.com>\;info=alert-internal\;x-line-id=0)
> ) it works fine.
>
> When I try to do the same thing from within a database table, all of the
> string apart from x-line-id=0 gets ignored. I've tried escaping the
> semicolon and not escaping it and the result is always the same, just the
> last part of the full string is expressed.
>
> Some of the ways that I have tried to enter the string are below:
> appdata='Alert-Info:<http://www.notused.com>\\;info=alert-internal\\;x-line-id=0'
> appdata='Alert-Info:<http://www.notused.com>;info=alert-internal;x-line-id=0'
> appdata='Alert-Info:<http://www.notused.com>\\\\;info=alert-internal\\\\;x-line-id=0'
>
> Does anyone know the correct format to store this in a DB table for it to be
> expressed correctly? I'm using MySQL.

There is an existing report filed here:
https://issues.asterisk.org/jira/browse/ASTERISK-19254

You can try Walter's suggestion on the issue and report back whether
it works or not.

-- 
Rusty Newton
Digium, Inc. | Community Support Manager
445 Jan Davis Drive NW - Huntsville, AL 35806 - US
direct: +1 256 428 6200

Check us out at: http://digium.com & http://asterisk.org