On 23 September 2014 15:04, Rusty Newton <rnew...@digium.com> wrote: > On Mon, Sep 22, 2014 at 9:43 AM, Ishfaq Malik <i...@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. > > > Hi
Replacing the ; with ^3B and removing the \ so column data looks like: Alert-Info:<http://www.notused.com>^3Binfo=alert-internal^3Bx-line-id=0 works perfectly. Thanks for the help. Ish -- Ishfaq Malik Department: VOIP Support Company: Packnet Limited t: +44 (0)845 004 4994 f: +44 (0)161 660 9825 e: i...@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
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users