Re: [asterisk-users] SIPAddHeader from a realtime databse

2014-09-23 Thread Rusty Newton
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.

-- 
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

-- 
_
-- 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


Re: [asterisk-users] SIPAddHeader from a realtime databse

2014-09-23 Thread Ishfaq Malik
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

[asterisk-users] SIPAddHeader from a realtime databse

2014-09-22 Thread Ishfaq Malik
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: 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