Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[asterisk-users] Asterisk 13.11 realtime problem registering phones


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users
View previous topic :: View next topic  
Author Message
cursor at telecomabmex...
Guest





PostPosted: Fri Sep 02, 2016 3:48 pm    Post subject: [asterisk-users] Asterisk 13.11 realtime problem registering Reply with quote

I upgraded my office installation from 13.10 to 13.11 yesterday and
now I am having problems registering phones. Here is what I get on the CLI:

[Sep 2 15:38:46] WARNING[2098]: res_config_mysql.c:1162 require_mysql:
Realtime table general@ps_contacts: column 'qualify_timeout' cannot be
type 'int(10)' (need char)
[Sep 2 15:38:46] WARNING[2098]: res_config_mysql.c:1162 require_mysql:
Realtime table general@ps_contacts: column 'expiration_time' cannot be
type 'bigint(20)' (need char)
[Sep 2 15:38:46] WARNING[2098]: res_config_mysql.c:1246 require_mysql:
Possibly unsupported column type 'enum('yes','no')' on column
'authenticate_qualify'
[Sep 2 15:38:46] WARNING[2098]: res_config_mysql.c:1162 require_mysql:
Realtime table general@ps_contacts: column 'via_port' cannot be type
'int(11)' (need char)
[Sep 2 15:38:46] ERROR[2098]: res_pjsip_registrar.c:411
register_aor_core: Unable to bind contact
'sip:2001@192.168.2.203:57776;transport=UDP;rinstance=48d5c7d09b9f2525'
to AOR '2001'
== Contact
2001/sip:2001@192.168.2.203:57776;transport=UDP;rinstance=48d5c7d09b9f2525
has been deleted

The mysql warnings have always been there since version 13.0 and
the "Unable to bind contact..." error has also been present since I
started using PJSIP realtime with Asterisk 13 (13.5 at least). But
starting this version the contact gets deleted immediately after
registration so I cannot receive calls on the phone. I can make calls
from the phone. On the phone web gui it tells me there is a "contact
mismatch". There are some phones working but I am not able to determine
why, no configurations were changed since the upgrade (either on the
database or on the phones themselves). I have two phones of the same
make/model/firmware, one is working and the other one is not and they
basically have the same configuration, only the username and password
change.

I guess realtime finally broke.

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


--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Join the Asterisk Community at the 13th AstriCon, September 27-29, 2016
http://www.asterisk.org/community/astricon-user-conference

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
Back to top
cursor at telecomabmex...
Guest





PostPosted: Sun Sep 04, 2016 11:30 am    Post subject: [asterisk-users] Asterisk 13.11 realtime problem registering Reply with quote

On 2016-09-04 10:11, Max Grobecker wrote:
Quote:
Hi,


Am 02.09.2016 um 22:48 schrieb Carlos Chavez:
Quote:
I upgraded my office installation from 13.10 to 13.11 yesterday
and now I am having problems registering phones. Here is what I get
on the CLI:

[Sep 2 15:38:46] WARNING[2098]: res_config_mysql.c:1162
require_mysql: Realtime table general@ps_contacts: column
'qualify_timeout' cannot be type 'int(10)' (need char)
[Sep 2 15:38:46] WARNING[2098]: res_config_mysql.c:1162
require_mysql: Realtime table general@ps_contacts: column
'expiration_time' cannot be type 'bigint(20)' (need char)
[Sep 2 15:38:46] WARNING[2098]: res_config_mysql.c:1246
require_mysql: Possibly unsupported column type 'enum('yes','no')' on
column 'authenticate_qualify'
[Sep 2 15:38:46] WARNING[2098]: res_config_mysql.c:1162
require_mysql: Realtime table general@ps_contacts: column 'via_port'
cannot be type 'int(11)' (need char)
[Sep 2 15:38:46] ERROR[2098]: res_pjsip_registrar.c:411
register_aor_core: Unable to bind contact
'sip:2001@192.168.2.203:57776;transport=UDP;rinstance=48d5c7d09b9f2525'
to AOR '2001'
== Contact
2001/sip:2001@192.168.2.203:57776;transport=UDP;rinstance=48d5c7d09b9f2525
has been deleted

The mysql warnings have always been there since version 13.0 and
the "Unable to bind contact..." error has also been present since I
started using PJSIP realtime with Asterisk 13 (13.5 at least).

I hope you find this concerning...

Have you upgraded your MySQL realtime tables to the new schema as
introduced with Asterisk 13?
->
https://wiki.asterisk.org/wiki/display/AST/Upgrading+to+Asterisk+13#UpgradingtoAsterisk13-RealTime

It's likely a database error (i.e. a required, but missing table
field) causes this issue.
But even if not, you are getting rid of the warning messages ;-)


Hi Max, I do find it concerning Wink (please do not take it the wrong way,
I just found the usage of the word here funny).

I am using alembic to configure all my database tables so in theory that
is the "official" way to do it. Even so mysql keeps sending those
warnings. I guess the res_mysql_config code does not follow the same
standards as odbc. Like I mentioned, the warnings have been there since
Asterisk 13.0 but everything was working at least. I always run the
alembic upgrade when installing a new version of Asterisk 13 to make
sure realtime tables are up to date.

I not only had to go back to Asterisk 13.10 but had to revert to a
previous backup of the database so I guess what really broke things was
the database update.

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

--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Join the Asterisk Community at the 13th AstriCon, September 27-29, 2016
http://www.asterisk.org/community/astricon-user-conference

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
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services