Hello. Did you ps_contacts table has all columns listed here?
INSERT INTO ps_contacts (id, via_addr, qualify_timeout, call_id, reg_server, path, endpoint, via_port, authenticate_qualify, uri, qualify_frequency, user_agent, expiration_time, outbound_proxy) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Regards, Marcelo H. Terres <[email protected]> IM: [email protected] https://www.mundoopensource.com.br https://twitter.com/mhterres https://linkedin.com/in/marceloterres On 15 September 2017 at 16:18, Bryant Zimmerman <[email protected]> wrote: > Joshua > > We are using MariaDB as the database storage. > We have recreated the database tables with alembic. > > Test 1: > > We enable tables for aors, auths and endpoints only. > With cache turned off the end point registers successfully > We have no way to get any feed back as pjsip show/list returns no objects > found. > pjsip send notify cmd endpoint -- does not work as it says there is no > endpoint. > endpoint can send a call as it appears to be registered, we have no way to > confirm this form the console but calls come in. > > > Test 2: > > We enable cache on the endpoints, auth and aors in the sorcery.conf > > endpoint/cache = > memory_cache,object_lifetime_stale=600,object_lifetime_maximum=1800,expire_on_reload=yes,full_backend_cache=yes > auth/cache=memory_cache,expire_on_reload=yes > aor/cache = > memory_cache,object_lifetime_stale=1500,object_lifetime_maximum=1800,expire_on_reload=yes,full_backend_cache=yes > > We now get an error: > > [2017-09-15 11:02:04] WARNING[3375]: res_pjsip_registrar.c:744 > registrar_on_rx_request: AOR '6162480909-300' has no configured > max_contacts. Endpoint '6162480909-300' unable to register > The aors entry has the max_contacts set to 1 but the error still occurs. > > pjsip show/list shows the endpoint shows endpoints, aors, auths but > registration fails > > > Test 3: > > We enable cache on the endpoints, auth and aors in the sorcery.conf > > endpoint/cache = > memory_cache,object_lifetime_stale=600,object_lifetime_maximum=1800,expire_on_reload=yes > auth/cache=memory_cache,expire_on_reload=yes > aor/cache = > memory_cache,object_lifetime_stale=1500,object_lifetime_maximum=1800,expire_on_reload=yes > > Endpoint registers > pjsip show/list endpoints works the first time and fails there after. > > UBNTU-ROSSI-GUEST*CLI> pjsip show endpoints > Endpoint: <Endpoint/CID.....................................> > <State.....> <Channels.> > I/OAuth: > <AuthId/UserName...........................................................> > Aor: <Aor............................................> > <MaxContact> > Contact: <Aor/ContactUri..........................> <Hash....> > <Status> <RTT(ms)..> > Transport: <TransportId........> <Type> <cos> <tos> > <BindAddress..................> > Identify: > <Identify/Endpoint.........................................................> > Match: <criteria.........................> > Channel: <ChannelId......................................> > <State.....> <Time.....> > Exten: <DialedExten...........> CLCID: <ConnectedLineCID.......> > ========================================================================================== > Endpoint: 6162480909-300 Not in use > 0 of inf > InAuth: 6162480909-300/6162480909-300 > Aor: 6162480909-300 1 > Contact: 6162480909-300/sip:[email protected]. 0475d46ff2 > Unknown nan > Transport: udp-nat udp 0 0 0.0.0.0:5060 > > Objects found: 1 > UBNTU-ROSSI-GUEST*CLI> pjsip show endpoints > No objects found. > > pjsip show/list shows the endpoint fails ever time after the first. > > Test 4: > > Test 1: with the addition of the contacts entry as realtime in sorcery.conf > We get error on registration attempt: > > [2017-09-15 11:16:07] WARNING[3591]: res_config_odbc.c:120 custom_prepare: > SQL Prepare failed! [INSERT INTO ps_contacts (id, via_addr, qualify_timeout, > call_id, reg_server, path, endpoint, via_port, authenticate_qualify, uri, > qualify_frequency, user_agent, expiration_time, outbound_proxy) VALUES (?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] > [2017-09-15 11:16:07] ERROR[3591]: res_pjsip_registrar.c:432 > register_aor_core: Unable to bind contact > 'sip:[email protected]:59758' to AOR '6162480909-300' > > Registration has failed at this point. > > > I can offer the following: > A dump of the database schema that alembic is creating. > extconfig.config > sorcery.conf > > Thanks > Bryant > > ________________________________ > From: "Joshua Colp" <[email protected]> > Sent: Friday, September 15, 2017 9:56 AM > To: [email protected] > Subject: Re: [asterisk-users] Realtime pjsip issues > > On Fri, Sep 15, 2017, at 10:37 AM, Bryant Zimmerman wrote: >> Joshua >> >> That is the interesting part of it. We took our configs and database >> tables from our working 13.12.2 deployments and tried to use them with >> our >> new 13.17.1 deployments and we are having issues where the tables are not >> working. On the new server asterisk keeps saying it can't find the AORS >> entries when we purge the sorcery memory cache it starts finding the aors >> but then it says it cant find the auths. >> >> The wired thing is when it says it can't find the aors and auths entries >> it does not show it is looking for the values in the aors and auth fields >> from the endpoints tables. It keeps putting the value from the endpoints >> id >> field as the entries it can't find. >> >> One point of note the tables we used and created for pjsip back when we >> setup the 13.12.2 version are not what is currently being created when we >> run alembic now.. Also the contact table from alembic creation process >> does >> not work we get insert errors inside of asterisk when contact entry >> attempts are being crated. It shows a number of fields that are not there >> in the created tables. >> >> This is the foundation of my issues. I really have to resolve them in >> some >> manner so I can mover forward with getting these new systems into >> production. >> Any assistance is appreciated. > > You're really throwing a lot of things in here. Please try to simplify > this first and remove the caching. After that what exactly does it say > it can't find when trying to add a contact? What database is in use? Did > you create the tables fresh from alembic? Upgrade existing? If you > enable debug (debug to console in logger.conf and core set debug 5) does > it show it doing database queries? > > As it is right now things haven't been narrowed down enough for me to > give any concrete answer or help. > > -- > 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 > > -- > _____________________________________________________________________ > -- 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 > > > -- > _____________________________________________________________________ > -- 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 -- _____________________________________________________________________ -- 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
