Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[asterisk-users] SIPAddHeader from a realtime databse


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users
View previous topic :: View next topic  
Author Message
ish at pack-net.co.uk
Guest





PostPosted: Mon Sep 22, 2014 9:44 am    Post subject: [asterisk-users] SIPAddHeader from a realtime databse Reply with quote

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

--
Quote:
Ishfaq Malik
Department: VOIP Support
Company: Packnet Limited
t: +44 (0)845 004 4994
f: +44 (0)161 660 9825
e: ish@pack-net.co.uk (ish@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
Back to top
rnewton at digium.com
Guest





PostPosted: Tue Sep 23, 2014 9:06 am    Post subject: [asterisk-users] SIPAddHeader from a realtime databse Reply with quote

On Mon, Sep 22, 2014 at 9:43 AM, Ishfaq Malik <ish@pack-net.co.uk> wrote:
Quote:
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
Back to top
ish at pack-net.co.uk
Guest





PostPosted: Tue Sep 23, 2014 9:56 am    Post subject: [asterisk-users] SIPAddHeader from a realtime databse Reply with quote

On 23 September 2014 15:04, Rusty Newton <rnewton@digium.com (rnewton@digium.com)> wrote:
Quote:
On Mon, Sep 22, 2014 at 9:43 AM, Ishfaq Malik <ish@pack-net.co.uk (ish@pack-net.co.uk)> wrote:
Quote:
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

--
Quote:
Ishfaq Malik
Department: VOIP Support
Company: Packnet Limited
t: +44 (0)845 004 4994
f: +44 (0)161 660 9825
e: ish@pack-net.co.uk (ish@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
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services