asterisk users - Sep 2014 - SIPAddHeader from a realtime databse

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.

Thanks in Advance

Ish

-- 

Ishfaq Malik
Department: VOIP Support
Company: Packnet Limited
t: +44 (0)845 004 4994
f: +44 (0)161 660 9825
e: ish at pack-net.co.uk
w: http://www.pack-net.co.uk

Registered Address: PACKNET LIMITED, Duplex 2, Ducie House
37 Ducie Street
Manchester, M1 2JW
COMPANY REG NO. 04920552
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20140922/c067c094/attachment.html>

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