VoIP Mailing List Archives

[BryantZ at zktech.com]

I have a pjsip install that is not pulling it's realtime registrations from an ODBC database.
When I have them directly pull from a MySQL database everything seems to work.

I am having trouble finding a requirements document for the pjsip realtime registrations.
Is there some kind of special config that has to be used to trigger the connection for realtime registrations over ODBC?

My realtime connections to aors, auths,contacts, and endpoints via ODBC are working as expected.

Any ideas are appreciated.

Asterisk v 13.5.0

Registrations line from sorcery.conf
registrations=realtime,px1_ps_registrations
Line for database from extconfig.conf
px1_ps_registrations => odbc,pjsipRealtime
pjsip show registration
show no return records - even though there are records in the database table.



Thanks Bryant

[jcolp at digium.com]

On 15-10-04 09:54 AM, Bryant Zimmerman wrote:

[BryantZ at zktech.com]

On 15-10-04 09:54 AM, Bryant Zimmerman wrote: > I have a pjsip install that is not pulling it's realtime registrations > from an ODBC database. > When I have them directly pull from a MySQL database everything seems to > work. > I am having trouble finding a requirements document for the pjsip > realtime registrations. > Is there some kind of special config that has to be used to trigger the > connection for realtime registrations over ODBC? > My realtime connections to aors, auths,contacts, and endpoints via ODBC > are working as expected. > Any ideas are appreciated. > Asterisk v 13.5.0 > Registrations line from sorcery.conf > /registrations=realtime,px1_ps_registrations/ This should be: registration=realtime,px1_ps_registrations > Line for database from extconfig.conf > /px1_ps_registrations => odbc,pjsipRealtime/ > pjsip show registration > show no return records - even though there are records in the database > table. > Thanks > > Bryant > > -- Joshua Colp Digium, Inc. | Senior Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - US Check us out at: www.digium.com & www.asterisk.org --

Joshua

Thanks for your reply. It thought the same thing, but when I change the line in the corcery.conf to:
registration=realtime,px1_ps_registrations

Asterisk crashes and won't start. Here is what the log loop.

[Oct 4 16:04:18] WARNING[64823] config_options.c: Cannot update type 'registration' in module 'res_pjsip' because it has no existing documentation!

If I switch to "registrations=realtime,px1_ps_registrations" the error stops, but I get now calls from the px1_ps_registrations table from the database.
What could be missing?

Thanks
Bryant

[jcolp at digium.com]

On 15-10-04 01:09 PM, Bryant Zimmerman wrote:

[BryantZ at zktech.com]

From: "Joshua Colp" <jcolp@digium.com> Sent: Sunday, October 4, 2015 12:12 PM To: asterisk-users@lists.digium.com Subject: Re: [asterisk-users] pjsip realtime registrations not pulling from ODBC
On 15-10-04 01:09 PM, Bryant Zimmerman wrote: > -- > Joshua > Thanks for your reply. It thought the same thing, but when I change the > line in the corcery.conf to: > registration=realtime,px1_ps_registrations > Asterisk crashes and won't start. Here is what the log loop. > [Oct 4 16:04:18] WARNING[64823] config_options.c: Cannot update type > 'registration' in module 'res_pjsip' because it has no existing > documentation! > If I switch to "registrations=realtime,px1_ps_registrations" the error > stops, but I get now calls from the px1_ps_registrations table from the > database. > What could be missing? Outbound registrations are done in res_pjsip_outbound_registration, as a result the registration= needs to be in a section for that module instead. --

Joshua

That seems to have been the issue. Is there a documentation page out there that highlights which options goes under which modules.
I have not run across this yet and am wondering if I am going to bump into any more that need to be pushed under their own config context.

Also is there a trick to what should be used in the client_uri field to make the connection?
I am trying to connect to a sip vendor and I am trying to use sipaccount@venderhostname.vendordomain.net?
Now that the registration table is coming up it is stating I have an invalid client URI.. I put the same thing in for a text based registration and it worked.
Thank you for your assistance.

Bryant

[jcolp at digium.com]

On 15-10-04 01:42 PM, Bryant Zimmerman wrote:

[BryantZ at zktech.com]

From: "Joshua Colp" <jcolp@digium.com> Sent: Sunday, October 4, 2015 12:44 PM To: asterisk-users@lists.digium.com Subject: Re: [asterisk-users] pjsip realtime registrations not pulling from ODBC
On 15-10-04 01:42 PM, Bryant Zimmerman wrote: > ------------------------------------------------------------------------ > *From*: "Joshua Colp" <jcolp@digium.com> > *Sent*: Sunday, October 4, 2015 12:12 PM > *To*: asterisk-users@lists.digium.com > *Subject*: Re: [asterisk-users] pjsip realtime registrations not pulling > from ODBC > On 15-10-04 01:09 PM, Bryant Zimmerman wrote: >> -- >> Joshua >> Thanks for your reply. It thought the same thing, but when I change the >> line in the corcery.conf to: >> registration=realtime,px1_ps_registrations >> Asterisk crashes and won't start. Here is what the log loop. >> [Oct 4 16:04:18] WARNING[64823] config_options.c: Cannot update type >> 'registration' in module 'res_pjsip' because it has no existing >> documentation! >> If I switch to "registrations=realtime,px1_ps_registrations" the error >> stops, but I get now calls from the px1_ps_registrations table from the >> database. >> What could be missing? > > Outbound registrations are done in res_pjsip_outbound_registration, as a > result the registration= needs to be in a section for that module instead. > > -- > Joshua > That seems to have been the issue. Is there a documentation page out > there that highlights which options goes under which modules. > I have not run across this yet and am wondering if I am going to bump > into any more that need to be pushed under their own config context. I don't think there's a page that describes it unfortunately. > Also is there a trick to what should be used in the client_uri field to > make the connection? > I am trying to connect to a sip vendor and I am trying to use > sipaccount@venderhostname.vendordomain.net? > Now that the registration table is coming up it is stating I have an > invalid client URI.. I put the same thing in for a text based > registration and it worked. You need to put sip: in front to make it a valid SIP URI. -- Joshua

Much thanks for all your direction today. I am sending good karma your way.
Thank You Thank You

Bryant

[RyanT at OscarWinski.com]

-----Original Message-----
From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Joshua Colp
Sent: Sunday, October 04, 2015 12:44 PM
To: asterisk-users@lists.digium.com
Subject: Re: [asterisk-users] pjsip realtime registrations not pulling from ODBC

On 15-10-04 01:42 PM, Bryant Zimmerman wrote:

[jcolp at digium.com]

On 15-10-05 09:16 AM, Ryan, Travis wrote:

[snip]

[RyanT at OscarWinski.com]

Ah ok, thanks.

-----Original Message-----
From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Joshua Colp
Sent: Monday, October 05, 2015 8:20 AM
To: asterisk-users@lists.digium.com
Subject: Re: [asterisk-users] pjsip realtime registrations not pulling from ODBC

On 15-10-05 09:16 AM, Ryan, Travis wrote:

[snip]

[BryantZ at zktech.com]

From: "Ryan, Travis" <RyanT@OscarWinski.com> Sent: Monday, October 5, 2015 8:20 AM To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com> Subject: Re: [asterisk-users] pjsip realtime registrations not pulling from ODBC
Ah ok, thanks. -----Original Message----- From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Joshua Colp Sent: Monday, October 05, 2015 8:20 AM To: asterisk-users@lists.digium.com Subject: Re: [asterisk-users] pjsip realtime registrations not pulling from ODBC On 15-10-05 09:16 AM, Ryan, Travis wrote: [snip] > > > So should anyone using realtime PJSIP be using the registrations line? Even if it's not used for any trunking? A registrations line in sorcery.conf for res_pjsip would do absolutely nothing. If you put it under res_pjsip_outbound_registration and have no outbound registrations it will execute some queries against your database but otherwise do nothing. -- Joshua Colp Digium, Inc. | Senior Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - US Check us out at: www.digium.com & www.asterisk.org -- I am working on a step by step and some internal documentation on pjsip.
Where would the best place to post this information be. I am willing to share what I have it may help others in the same boat I was in.
I have been running pjsip internally for several 6 plus months and still hit config snags occasionally, but our config process is almost complete and is going production by the end of the month.

Bryant

[jcolp at digium.com]

On 15-10-05 10:15 AM, Bryant Zimmerman wrote:

<snip>

[BryantZ at zktech.com]

From: "Joshua Colp" <jcolp@digium.com> Sent: Monday, October 5, 2015 9:20 AM To: asterisk-users@lists.digium.com Subject: Re: [asterisk-users] pjsip realtime registrations not pulling from ODBC
On 15-10-05 10:15 AM, Bryant Zimmerman wrote: <snip> > > -- > I am working on a step by step and some internal documentation on pjsip. > Where would the best place to post this information be. I am willing to > share what I have it may help others in the same boat I was in. > I have been running pjsip internally for several 6 plus months and still > hit config snags occasionally, but our config process is almost complete > and is going production by the end of the month. There's a section on the wiki[1] for configuring PJSIP. You can take a look and see what is missing/could be improved. If you'd like you can add a comment to an initial page and if your suggestions look good then Rusty can provide you wiki edit access. [1] https://wiki.asterisk.org/wiki/display/AST/Configuring+res_pjsip -- Joshua Colp Digium, Inc. | Senior Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - US Check us out at: www.digium.com & www.asterisk.org -- Joshua

That sounds good. I will do this as soon as we know our documentation is good.

Thanks
Bryant