[asterisk-users] Realtime SIP peers do not register any more after upgrade to Asterisk 13

[Carlos Chavez]

On 8/15/16 3:16 PM, Jonas Kellens wrote:

> Hello
>
> after I have upgraded from Asterisk 12 to 
> asterisk-certified-13.8-cert1 none of my realtime SIP peers (saved in 
> MySQL DB) register anymore.
>
>
> [Aug 15 22:03:43] NOTICE[30098]: chan_sip.c:28451 
> handle_request_register: Registration from 
> '<sip:testacc77 at 178.19.90.240>' failed for '78.119.140.190:5076' - 
> Wrong password
> [Aug 15 22:04:13] NOTICE[30098]: chan_sip.c:28451 
> handle_request_register: Registration from 
> '<sip:testacc78 at 178.19.90.240>' failed for '78.119.140.190:5072' - 
> Wrong password
> [Aug 15 22:04:43] NOTICE[30098]: chan_sip.c:28451 
> handle_request_register: Registration from 
> '<sip:testacc79 at 178.19.90.240>' failed for '78.119.140.190:5062' - 
> Wrong password
> [Aug 15 22:04:46] NOTICE[30098]: chan_sip.c:28451 
> handle_request_register: Registration from 
> '<sip:testacc80 at 178.19.90.240>' failed for '78.119.140.190:5060' - 
> Wrong password
> [Aug 15 22:04:53] NOTICE[30098]: chan_sip.c:28451 
> handle_request_register: Registration from 
> '<sip:testacc81 at 178.19.90.240>' failed for '78.119.140.190:5060' - 
> Wrong password
>
>
> Is this a known problem ??
>
>
> Second question I have : can I get the complete list of columns that 
> can be used in realtime database for sip peers somewhere (update for 
> Ast 13) ? Are columns like dtlsenable, dtlsverify, dtlscertfile, 
> dtlscafile, dtlssetup possible ??
>
>
     The first thing you need to test is if you are properly loading the 
realtime data.  The best way would be to enable "rtcachefriends=yes" and 
then "sip show peer XXX load".  If you are not getting anything then 
there is a problem with your realtime setup.  I used realtime sip until 
13.7 before switching to PJSIP so it should work.

     I highly recommend that you use alembic to set up your database as 
this will make sure you are always using the correct database schema.  
You should be able to find the "official" structure in the 
contrib/realtime/mysql directory of the Asterisk source.

-- 
Telecomunicaciones Abiertas de México S.A. de C.V.
Carlos Chávez
+52 (55)9116-91161