Hello all, We would like to pull the RTT of registered endpoints from MySQL for use in a webportal. However it doesn't appear asterisk tables this by default like chan_sip did. I've found some information [1] that a modification of sorcery.conf can get it writing to a table. But I'm struggling to figure out what that configuration is. It seems the object is called "contact_status", and I've tried [2] in sorcery.conf, But I'm not seeing any output or seeing anything else to follow with GoogleFu. [1], A mailinglist crawler, i know: https://asteriskfaqs.org/2015/10/29/asterisk-users/pjsip-and-rtt-in-realtime.html [2], sourcery.conf [res_pjsip] ******stuff*********** contact_status=realtime,ps_contact_status (Which I've also defined in extconfig) *Nick Olsen* Network Engineer Office: 321-408-5000 x103 Mobile: 321-794-0763 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20200526/e61bd7cd/attachment.html>
On Tue, May 26, 2020 at 10:48 AM Nick Olsen < nick at floridavirtualsolutions.com> wrote:> Hello all, > > We would like to pull the RTT of registered endpoints from MySQL for use > in a webportal. However it doesn't appear asterisk tables this by default > like chan_sip did. > > I've found some information [1] that a modification of sorcery.conf can > get it writing to a table. But I'm struggling to figure out what that > configuration is. It seems the object is called "contact_status", and I've > tried [2] in sorcery.conf, But I'm not seeing any output or seeing anything > else to follow with GoogleFu. > > [1], A mailinglist crawler, i know: > https://asteriskfaqs.org/2015/10/29/asterisk-users/pjsip-and-rtt-in-realtime.html > [2], sourcery.conf > [res_pjsip] > ******stuff*********** > contact_status=realtime,ps_contact_status (Which I've also defined in > extconfig > ) >Contact status is not a sorcery object and is kept strictly in memory. There's no ability to store the information in a database, you'd need to query Asterisk. -- Joshua C. Colp Asterisk Technical Lead Sangoma Technologies Check us out at www.sangoma.com and www.asterisk.org -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20200526/80e5d990/attachment.html>
Thanks Joshua, I assume by query asterisk you mean I'll need to query it via AMI? Is that information available via AMI? *Nick Olsen* Network Engineer Office: 321-408-5000 x103 Mobile: 321-794-0763 On Tue, May 26, 2020 at 2:57 PM Joshua C. Colp <jcolp at sangoma.com> wrote:> On Tue, May 26, 2020 at 10:48 AM Nick Olsen < > nick at floridavirtualsolutions.com> wrote: > >> Hello all, >> >> We would like to pull the RTT of registered endpoints from MySQL for use >> in a webportal. However it doesn't appear asterisk tables this by default >> like chan_sip did. >> >> I've found some information [1] that a modification of sorcery.conf can >> get it writing to a table. But I'm struggling to figure out what that >> configuration is. It seems the object is called "contact_status", and I've >> tried [2] in sorcery.conf, But I'm not seeing any output or seeing anything >> else to follow with GoogleFu. >> >> [1], A mailinglist crawler, i know: >> https://asteriskfaqs.org/2015/10/29/asterisk-users/pjsip-and-rtt-in-realtime.html >> [2], sourcery.conf >> [res_pjsip] >> ******stuff*********** >> contact_status=realtime,ps_contact_status (Which I've also defined in >> extconfig >> ) >> > > Contact status is not a sorcery object and is kept strictly in memory. > There's no ability to store the information in a database, you'd need to > query Asterisk. > > -- > Joshua C. Colp > Asterisk Technical Lead > Sangoma Technologies > Check us out at www.sangoma.com and www.asterisk.org > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > Check out the new Asterisk community forum at: > https://community.asterisk.org/ > > New to Asterisk? Start here: > https://wiki.asterisk.org/wiki/display/AST/Getting+Started > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20200526/397c22b8/attachment.html>