[Home]

Summary:ASTERISK-26594: res_pjsip_pubsub: Cannot persist outside using ps_subscription_persistence table
Reporter:Carl Fortin (phonefxg)Labels:
Date Opened:2016-11-14 14:08:01.000-0600Date Closed:2016-11-15 07:12:20.000-0600
Priority:MinorRegression?
Status:Closed/CompleteComponents:Resources/res_pjsip_pubsub
Versions:14.1.1 Frequency of
Occurrence
Frequent
Related
Issues:
Environment:Asterisk Realtime 14.1 PJSIP Drivermysql Ver 14.14pjproject 2.5.5spandsp 0.0.6jansson 2.7CentOS 6.6 64 bits on VmwarePhones Attachments:( 0) extconfig.conf
( 1) myDebugLog
( 2) sorcery.conf
Description:I'm using Asterisk 14.1 ARA and I'd to move the subscriptions from astdb to our SQL database.I cannot get it to work with the configuration file included.
The ps_subscription_persistence table has been created with sqlalchemy. It looks like Asterisk is not even trying to use the database defined in sorcery.conf ans extconfig.conf.
In fact ps_registrations do not seem to work either.
Comments:By: Asterisk Team (asteriskteam) 2016-11-14 14:08:02.761-0600

Thanks for creating a report! The issue has entered the triage process. That means the issue will wait in this status until a Bug Marshal has an opportunity to review the issue. Once the issue has been reviewed you will receive comments regarding the next steps towards resolution.

A good first step is for you to review the [Asterisk Issue Guidelines|https://wiki.asterisk.org/wiki/display/AST/Asterisk+Issue+Guidelines] if you haven't already. The guidelines detail what is expected from an Asterisk issue report.

Then, if you are submitting a patch, please review the [Patch Contribution Process|https://wiki.asterisk.org/wiki/display/AST/Patch+Contribution+Process].

By: Carl Fortin (phonefxg) 2016-11-14 14:09:24.505-0600

Configuration files for realtime.

By: Carl Fortin (phonefxg) 2016-11-14 14:11:00.104-0600

My full debug log with debug level at 9 as well as pjsip logger on.
A phone register and subscribe but the info is still going to astdb

By: Joshua C. Colp (jcolp) 2016-11-15 05:39:36.201-0600

What happens if you do:

{noformat}
[res_pjsip_pubsub]
subscription_persistence = realtime,ps_subscription_persistence
{noformat}

By: Carl Fortin (phonefxg) 2016-11-15 07:05:00.474-0600

Well that was easy, it is working now. I'll have to test it in my production system, to see how well it does.
I was hoping to also have the CustomDevstate outside of astdb. Can this be done?
I know, I always ask for more...


By: Joshua C. Colp (jcolp) 2016-11-15 07:12:20.447-0600

Custom device state does not use the same data layer as PJSIP and is not able to be persisted outside of astdb, unless you do it yourself and write an app to set the values.