Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

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

[asterisk-users] Mysql PJSIP realtime > 13.10?


 
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: Mon Sep 12, 2016 3:14 pm    Post subject: [asterisk-users] Mysql PJSIP realtime > 13.10? Reply with quote

Has anyone successfully used Mysql realtime PJSIP with Asterisk
13.11? I have tried 13.11, 13.11.1 and 13.11.2 but I always get the
following error now:

Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql:
Realtime table general@ps_contacts: column 'qualify_timeout' cannot be
type 'int(10)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql:
Realtime table general@ps_contacts: column 'expiration_time' cannot be
type 'bigint(20)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1246 require_mysql:
Possibly unsupported column type 'enum('yes','no')' on column
'authenticate_qualify'
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql:
Realtime table general@ps_contacts: column 'via_port' cannot be type
'int(11)' (need char)
[Sep 12 14:42:35] ERROR[24498]: res_pjsip_registrar.c:411
register_aor_core: Unable to bind contact
'sip:2001@192.168.2.165:5060;transport=udp' to AOR '2001'
== Contact 2001/sip:2001@192.168.2.165:5060;transport=udp has been
deleted

Up until 13.10 everything was working despite the warnings about
field types. Now my phones will not register. I can make calls but not
receive. All database modifications are done through alembic so they
are supposed to be up to date. The only way I can find to solve this
issue right now is to restore a 13.10 backup for both the database and
Asterisk.

--
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
annusfictus at gmail.com
Guest





PostPosted: Mon Sep 12, 2016 3:21 pm    Post subject: [asterisk-users] Mysql PJSIP realtime > 13.10? Reply with quote

Hello,

is there any reason you don't use ODBC with MySQL?

Regards


El 12/09/2016 a las 15:14, Carlos Chavez escribió:
Quote:
Has anyone successfully used Mysql realtime PJSIP with Asterisk
13.11? I have tried 13.11, 13.11.1 and 13.11.2 but I always get the
following error now:

Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162
require_mysql: Realtime table general@ps_contacts: column
'qualify_timeout' cannot be type 'int(10)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162
require_mysql: Realtime table general@ps_contacts: column
'expiration_time' cannot be type 'bigint(20)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1246
require_mysql: Possibly unsupported column type 'enum('yes','no')' on
column 'authenticate_qualify'
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162
require_mysql: Realtime table general@ps_contacts: column 'via_port'
cannot be type 'int(11)' (need char)
[Sep 12 14:42:35] ERROR[24498]: res_pjsip_registrar.c:411
register_aor_core: Unable to bind contact
'sip:2001@192.168.2.165:5060;transport=udp' to AOR '2001'
== Contact 2001/sip:2001@192.168.2.165:5060;transport=udp has been
deleted

Up until 13.10 everything was working despite the warnings about
field types. Now my phones will not register. I can make calls but
not receive. All database modifications are done through alembic so
they are supposed to be up to date. The only way I can find to solve
this issue right now is to restore a 13.10 backup for both the
database and Asterisk.



--
_____________________________________________________________________
-- 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
gjoseph at digium.com
Guest





PostPosted: Mon Sep 12, 2016 3:31 pm    Post subject: [asterisk-users] Mysql PJSIP realtime > 13.10? Reply with quote

On Mon, Sep 12, 2016 at 2:14 PM, Carlos Chavez <cursor@telecomabmex.com (cursor@telecomabmex.com)> wrote:
Quote:
    Has anyone successfully used Mysql realtime PJSIP with Asterisk 13.11?  I have tried 13.11, 13.11.1 and 13.11.2 but I always get the following error now:

Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'qualify_timeout' cannot be type 'int(10)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'expiration_time' cannot be type 'bigint(20)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1246 require_mysql: Possibly unsupported column type 'enum('yes','no')' on column 'authenticate_qualify'
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'via_port' cannot be type 'int(11)' (need char)
[Sep 12 14:42:35] ERROR[24498]: res_pjsip_registrar.c:411 register_aor_core: Unable to bind contact 'sip:2001@192.168.2.165:5060;transport=udp' to AOR '2001'
  == Contact 2001/sip:2001@192.168.2.165 ([email]sip%3A2001@192.168.2.165[/email]):5060;transport=udp has been deleted

    Up until 13.10 everything was working despite the warnings about field types.  Now my phones will not register.  I can make calls but not receive.  All database modifications are done through alembic so they are supposed to be up to date.  The only way I can find to solve this issue right now is to restore a 13.10 backup for both the database and Asterisk.


res_config_mysql has been in "extended" support for some time now and it's possible it just will no longer work.  We only test alembic changes with postgres or odbc now.  Your best bet is to convert to res_odbc.
 

Quote:

--
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




--
George JosephDigium, Inc. | Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - US
Check us out at: www.digium.com & www.asterisk.org
Back to top
gjoseph at digium.com
Guest





PostPosted: Mon Sep 12, 2016 3:40 pm    Post subject: [asterisk-users] Mysql PJSIP realtime > 13.10? Reply with quote

On Mon, Sep 12, 2016 at 2:31 PM, George Joseph <gjoseph@digium.com (gjoseph@digium.com)> wrote:
Quote:


On Mon, Sep 12, 2016 at 2:14 PM, Carlos Chavez <cursor@telecomabmex.com (cursor@telecomabmex.com)> wrote:
Quote:
    Has anyone successfully used Mysql realtime PJSIP with Asterisk 13.11?  I have tried 13.11, 13.11.1 and 13.11.2 but I always get the following error now:

Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'qualify_timeout' cannot be type 'int(10)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'expiration_time' cannot be type 'bigint(20)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1246 require_mysql: Possibly unsupported column type 'enum('yes','no')' on column 'authenticate_qualify'
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'via_port' cannot be type 'int(11)' (need char)
[Sep 12 14:42:35] ERROR[24498]: res_pjsip_registrar.c:411 register_aor_core: Unable to bind contact 'sip:2001@192.168.2.165:5060;transport=udp' to AOR '2001'
  == Contact 2001/sip:2001@192.168.2.165 ([email]sip%3A2001@192.168.2.165[/email]):5060;transport=udp has been deleted

    Up until 13.10 everything was working despite the warnings about field types.  Now my phones will not register.  I can make calls but not receive.  All database modifications are done through alembic so they are supposed to be up to date.  The only way I can find to solve this issue right now is to restore a 13.10 backup for both the database and Asterisk.


res_config_mysql has been in "extended" support for some time now and it's possible it just will no longer work.  We only test alembic changes with postgres or odbc now.  Your best bet is to convert to res_odbc.





Oh yeah, if you really do need res_config_mysql, go ahead and open an issue at issues.asterisk.org and we'll take a look.  Since we don't test with it though, we might not notice if it gets broken again in the future unless someone reports it.


 
Quote:
 

Quote:

--
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




--
George JosephDigium, Inc. | Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - US
Check us out at: www.digium.com & www.asterisk.org










--
George JosephDigium, Inc. | Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - US
Check us out at: www.digium.com & www.asterisk.org
Back to top
cursor at telecomabmex...
Guest





PostPosted: Mon Sep 12, 2016 3:50 pm    Post subject: [asterisk-users] Mysql PJSIP realtime > 13.10? Reply with quote

On 9/12/16 3:21 PM, Annus Fictus wrote:

Quote:
Hello,

is there any reason you don't use ODBC with MySQL?

Regards


El 12/09/2016 a las 15:14, Carlos Chavez escribió:
Quote:
Has anyone successfully used Mysql realtime PJSIP with Asterisk
13.11? I have tried 13.11, 13.11.1 and 13.11.2 but I always get the
following error now:

Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162
require_mysql: Realtime table general@ps_contacts: column
'qualify_timeout' cannot be type 'int(10)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162
require_mysql: Realtime table general@ps_contacts: column
'expiration_time' cannot be type 'bigint(20)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1246
require_mysql: Possibly unsupported column type 'enum('yes','no')' on
column 'authenticate_qualify'
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162
require_mysql: Realtime table general@ps_contacts: column 'via_port'
cannot be type 'int(11)' (need char)
[Sep 12 14:42:35] ERROR[24498]: res_pjsip_registrar.c:411
register_aor_core: Unable to bind contact
'sip:2001@192.168.2.165:5060;transport=udp' to AOR '2001'
== Contact 2001/sip:2001@192.168.2.165:5060;transport=udp has been
deleted

Up until 13.10 everything was working despite the warnings about
field types. Now my phones will not register. I can make calls but
not receive. All database modifications are done through alembic so
they are supposed to be up to date. The only way I can find to solve
this issue right now is to restore a 13.10 backup for both the
database and Asterisk.



Unless you use non packaged odbc on CentOS 7, Asterisk keeps crashing.

--
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: Mon Sep 12, 2016 4:01 pm    Post subject: [asterisk-users] Mysql PJSIP realtime > 13.10? Reply with quote

On 9/12/16 3:39 PM, George Joseph wrote:
Quote:


On Mon, Sep 12, 2016 at 2:31 PM, George Joseph <gjoseph@digium.com (gjoseph@digium.com)> wrote:
Quote:


On Mon, Sep 12, 2016 at 2:14 PM, Carlos Chavez <cursor@telecomabmex.com (cursor@telecomabmex.com)> wrote:
Quote:
    Has anyone successfully used Mysql realtime PJSIP with Asterisk 13.11?  I have tried 13.11, 13.11.1 and 13.11.2 but I always get the following error now:

Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'qualify_timeout' cannot be type 'int(10)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'expiration_time' cannot be type 'bigint(20)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1246 require_mysql: Possibly unsupported column type 'enum('yes','no')' on column 'authenticate_qualify'
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'via_port' cannot be type 'int(11)' (need char)
[Sep 12 14:42:35] ERROR[24498]: res_pjsip_registrar.c:411 register_aor_core: Unable to bind contact 'sip:2001@192.168.2.165:5060;transport=udp' to AOR '2001'
  == Contact 2001/sip:2001@192.168.2.165 ([email]sip%3A2001@192.168.2.165[/email]):5060;transport=udp has been deleted

    Up until 13.10 everything was working despite the warnings about field types.  Now my phones will not register.  I can make calls but not receive.  All database modifications are done through alembic so they are supposed to be up to date.  The only way I can find to solve this issue right now is to restore a 13.10 backup for both the database and Asterisk.


res_config_mysql has been in "extended" support for some time now and it's possible it just will no longer work.  We only test alembic changes with postgres or odbc now.  Your best bet is to convert to res_odbc.





Oh yeah, if you really do need res_config_mysql, go ahead and open an issue at issues.asterisk.org and we'll take a look.  Since we don't test with it though, we might not notice if it gets broken again in the future unless someone reports it.


 




    I have solved the problem for the moment by changing the ps_contacts table with the "recommendations" res_config_mysql is giving.  I just modified all the fields to varchar and now my phones are registering.  Obviously this is not a solution as the database needs to be modified by alembic on future versions and it will keep breaking.

    I tried to migrate to res_config_odbc about 6 months ago but my Asterisk kept crashing.  I was told that the crashes were due to the version of ODBC distributed by CentOS 7 and that I would have to compile my own to be able to solve the issue.  Has this been solved?  Is the RPM ODBC package included with CentOS 7 still bugged?  I try to avoid using packages not included in the distribution as they make upgrades a pain later on.
Quote:
--
Telecomunicaciones Abiertas de México S.A. de C.V.
Carlos Chávez
+52 (55)9116-91161
Back to top
annusfictus at gmail.com
Guest





PostPosted: Mon Sep 12, 2016 4:21 pm    Post subject: [asterisk-users] Mysql PJSIP realtime > 13.10? Reply with quote

Hello Carlos,
I'm testing CentOS 7 ODBC packages with PJSIP Realtime without problems.
Maybe you use a different configuration?
Regards

El 12/09/2016 a las 16:01, Carlos Chavez escribió:

Quote:

On 9/12/16 3:39 PM, George Joseph wrote:
Quote:


On Mon, Sep 12, 2016 at 2:31 PM, George Joseph <gjoseph@digium.com (gjoseph@digium.com)> wrote:
Quote:


On Mon, Sep 12, 2016 at 2:14 PM, Carlos Chavez <cursor@telecomabmex.com (cursor@telecomabmex.com)> wrote:
Quote:
    Has anyone successfully used Mysql realtime PJSIP with Asterisk 13.11?  I have tried 13.11, 13.11.1 and 13.11.2 but I always get the following error now:

Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'qualify_timeout' cannot be type 'int(10)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'expiration_time' cannot be type 'bigint(20)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1246 require_mysql: Possibly unsupported column type 'enum('yes','no')' on column 'authenticate_qualify'
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'via_port' cannot be type 'int(11)' (need char)
[Sep 12 14:42:35] ERROR[24498]: res_pjsip_registrar.c:411 register_aor_core: Unable to bind contact 'sip:2001@192.168.2.165:5060;transport=udp' to AOR '2001'
  == Contact 2001/sip:2001@192.168.2.165 ([email]sip%3A2001@192.168.2.165[/email]):5060;transport=udp has been deleted

    Up until 13.10 everything was working despite the warnings about field types.  Now my phones will not register.  I can make calls but not receive.  All database modifications are done through alembic so they are supposed to be up to date.  The only way I can find to solve this issue right now is to restore a 13.10 backup for both the database and Asterisk.


res_config_mysql has been in "extended" support for some time now and it's possible it just will no longer work.  We only test alembic changes with postgres or odbc now.  Your best bet is to convert to res_odbc.





Oh yeah, if you really do need res_config_mysql, go ahead and open an issue at issues.asterisk.org and we'll take a look.  Since we don't test with it though, we might not notice if it gets broken again in the future unless someone reports it.


 




    I have solved the problem for the moment by changing the ps_contacts table with the "recommendations" res_config_mysql is giving.  I just modified all the fields to varchar and now my phones are registering.  Obviously this is not a solution as the database needs to be modified by alembic on future versions and it will keep breaking.

    I tried to migrate to res_config_odbc about 6 months ago but my Asterisk kept crashing.  I was told that the crashes were due to the version of ODBC distributed by CentOS 7 and that I would have to compile my own to be able to solve the issue.  Has this been solved?  Is the RPM ODBC package included with CentOS 7 still bugged?  I try to avoid using packages not included in the distribution as they make upgrades a pain later on.
Quote:
--
Telecomunicaciones Abiertas de México S.A. de C.V.
Carlos Chávez
+52 (55)9116-91161


Back to top
gjoseph at digium.com
Guest





PostPosted: Mon Sep 12, 2016 4:22 pm    Post subject: [asterisk-users] Mysql PJSIP realtime > 13.10? Reply with quote

On Mon, Sep 12, 2016 at 3:01 PM, Carlos Chavez <cursor@telecomabmex.com (cursor@telecomabmex.com)> wrote:
Quote:

On 9/12/16 3:39 PM, George Joseph wrote:
Quote:


On Mon, Sep 12, 2016 at 2:31 PM, George Joseph <gjoseph@digium.com (gjoseph@digium.com)> wrote:
Quote:


On Mon, Sep 12, 2016 at 2:14 PM, Carlos Chavez <cursor@telecomabmex.com (cursor@telecomabmex.com)> wrote:
Quote:
    Has anyone successfully used Mysql realtime PJSIP with Asterisk 13.11?  I have tried 13.11, 13.11.1 and 13.11.2 but I always get the following error now:

Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'qualify_timeout' cannot be type 'int(10)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'expiration_time' cannot be type 'bigint(20)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1246 require_mysql: Possibly unsupported column type 'enum('yes','no')' on column 'authenticate_qualify'
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'via_port' cannot be type 'int(11)' (need char)
[Sep 12 14:42:35] ERROR[24498]: res_pjsip_registrar.c:411 register_aor_core: Unable to bind contact 'sip:2001@192.168.2.165:5060;transport=udp' to AOR '2001'
  == Contact 2001/sip:2001@192.168.2.165 ([email]sip%3A2001@192.168.2.165[/email]):5060;transport=udp has been deleted

    Up until 13.10 everything was working despite the warnings about field types.  Now my phones will not register.  I can make calls but not receive.  All database modifications are done through alembic so they are supposed to be up to date.  The only way I can find to solve this issue right now is to restore a 13.10 backup for both the database and Asterisk.


res_config_mysql has been in "extended" support for some time now and it's possible it just will no longer work.  We only test alembic changes with postgres or odbc now.  Your best bet is to convert to res_odbc.





Oh yeah, if you really do need res_config_mysql, go ahead and open an issue at issues.asterisk.org and we'll take a look.  Since we don't test with it though, we might not notice if it gets broken again in the future unless someone reports it.


 




    I have solved the problem for the moment by changing the ps_contacts table with the "recommendations" res_config_mysql is giving.  I just modified all the fields to varchar and now my phones are registering.  Obviously this is not a solution as the database needs to be modified by alembic on future versions and it will keep breaking.

    I tried to migrate to res_config_odbc about 6 months ago but my Asterisk kept crashing.  I was told that the crashes were due to the version of ODBC distributed by CentOS 7 and that I would have to compile my own to be able to solve the issue.  Has this been solved?  Is the RPM ODBC package included with CentOS 7 still bugged?  I try to avoid using packages not included in the distribution as they make upgrades a pain later on.


Although CentOS7 is still on 2.3.1 for unixodbc, there were changes made in 13.10.0 that should prevent the crashes.  
http://lists.digium.com/pipermail/asterisk-dev/2016-June/075582.html





 
Quote:

Quote:
--
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




--
George JosephDigium, Inc. | Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - US
Check us out at: www.digium.com & www.asterisk.org
Back to top
cursor at telecomabmex...
Guest





PostPosted: Mon Sep 12, 2016 4:51 pm    Post subject: [asterisk-users] Mysql PJSIP realtime > 13.10? Reply with quote

On 9/12/16 4:21 PM, George Joseph wrote:
Quote:


On Mon, Sep 12, 2016 at 3:01 PM, Carlos Chavez <cursor@telecomabmex.com (cursor@telecomabmex.com)> wrote:
Quote:

On 9/12/16 3:39 PM, George Joseph wrote:
Quote:


On Mon, Sep 12, 2016 at 2:31 PM, George Joseph <gjoseph@digium.com (gjoseph@digium.com)> wrote:
Quote:


On Mon, Sep 12, 2016 at 2:14 PM, Carlos Chavez <cursor@telecomabmex.com (cursor@telecomabmex.com)> wrote:
Quote:
    Has anyone successfully used Mysql realtime PJSIP with Asterisk 13.11?  I have tried 13.11, 13.11.1 and 13.11.2 but I always get the following error now:

Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'qualify_timeout' cannot be type 'int(10)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'expiration_time' cannot be type 'bigint(20)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1246 require_mysql: Possibly unsupported column type 'enum('yes','no')' on column 'authenticate_qualify'
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'via_port' cannot be type 'int(11)' (need char)
[Sep 12 14:42:35] ERROR[24498]: res_pjsip_registrar.c:411 register_aor_core: Unable to bind contact 'sip:2001@192.168.2.165:5060;transport=udp' to AOR '2001'
  == Contact 2001/sip:2001@192.168.2.165 ([email]sip%3A2001@192.168.2.165[/email]):5060;transport=udp has been deleted

    Up until 13.10 everything was working despite the warnings about field types.  Now my phones will not register.  I can make calls but not receive.  All database modifications are done through alembic so they are supposed to be up to date.  The only way I can find to solve this issue right now is to restore a 13.10 backup for both the database and Asterisk.


res_config_mysql has been in "extended" support for some time now and it's possible it just will no longer work.  We only test alembic changes with postgres or odbc now.  Your best bet is to convert to res_odbc.





Oh yeah, if you really do need res_config_mysql, go ahead and open an issue at issues.asterisk.org and we'll take a look.  Since we don't test with it though, we might not notice if it gets broken again in the future unless someone reports it.


 




    I have solved the problem for the moment by changing the ps_contacts table with the "recommendations" res_config_mysql is giving.  I just modified all the fields to varchar and now my phones are registering.  Obviously this is not a solution as the database needs to be modified by alembic on future versions and it will keep breaking.

    I tried to migrate to res_config_odbc about 6 months ago but my Asterisk kept crashing.  I was told that the crashes were due to the version of ODBC distributed by CentOS 7 and that I would have to compile my own to be able to solve the issue.  Has this been solved?  Is the RPM ODBC package included with CentOS 7 still bugged?  I try to avoid using packages not included in the distribution as they make upgrades a pain later on.


Although CentOS7 is still on 2.3.1 for unixodbc, there were changes made in 13.10.0 that should prevent the crashes.  
http://lists.digium.com/pipermail/asterisk-dev/2016-June/075582.html








    Ok, thank you for the help.  I'll be trying out ODBC later today and test it for a few days.  You should probably mark res_config_mysql as deprecated now since it will not work with anything higher than 13.10 as is.

Quote:
--


Telecomunicaciones Abiertas de México S.A. de C.V.
Carlos Chávez
+52 (55)9116-91161
Back to top
gjoseph at digium.com
Guest





PostPosted: Mon Sep 12, 2016 5:04 pm    Post subject: [asterisk-users] Mysql PJSIP realtime > 13.10? Reply with quote

On Mon, Sep 12, 2016 at 3:51 PM, Carlos Chavez <cursor@telecomabmex.com (cursor@telecomabmex.com)> wrote:
Quote:

On 9/12/16 4:21 PM, George Joseph wrote:
Quote:


On Mon, Sep 12, 2016 at 3:01 PM, Carlos Chavez <cursor@telecomabmex.com (cursor@telecomabmex.com)> wrote:
Quote:

On 9/12/16 3:39 PM, George Joseph wrote:
Quote:


On Mon, Sep 12, 2016 at 2:31 PM, George Joseph <gjoseph@digium.com (gjoseph@digium.com)> wrote:
Quote:


On Mon, Sep 12, 2016 at 2:14 PM, Carlos Chavez <cursor@telecomabmex.com (cursor@telecomabmex.com)> wrote:
Quote:
    Has anyone successfully used Mysql realtime PJSIP with Asterisk 13.11?  I have tried 13.11, 13.11.1 and 13.11.2 but I always get the following error now:

Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'qualify_timeout' cannot be type 'int(10)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'expiration_time' cannot be type 'bigint(20)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1246 require_mysql: Possibly unsupported column type 'enum('yes','no')' on column 'authenticate_qualify'
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general@ps_contacts: column 'via_port' cannot be type 'int(11)' (need char)
[Sep 12 14:42:35] ERROR[24498]: res_pjsip_registrar.c:411 register_aor_core: Unable to bind contact 'sip:2001@192.168.2.165:5060;transport=udp' to AOR '2001'
  == Contact 2001/sip:2001@192.168.2.165 ([email]sip%3A2001@192.168.2.165[/email]):5060;transport=udp has been deleted

    Up until 13.10 everything was working despite the warnings about field types.  Now my phones will not register.  I can make calls but not receive.  All database modifications are done through alembic so they are supposed to be up to date.  The only way I can find to solve this issue right now is to restore a 13.10 backup for both the database and Asterisk.


res_config_mysql has been in "extended" support for some time now and it's possible it just will no longer work.  We only test alembic changes with postgres or odbc now.  Your best bet is to convert to res_odbc.





Oh yeah, if you really do need res_config_mysql, go ahead and open an issue at issues.asterisk.org and we'll take a look.  Since we don't test with it though, we might not notice if it gets broken again in the future unless someone reports it.


 




    I have solved the problem for the moment by changing the ps_contacts table with the "recommendations" res_config_mysql is giving.  I just modified all the fields to varchar and now my phones are registering.  Obviously this is not a solution as the database needs to be modified by alembic on future versions and it will keep breaking.

    I tried to migrate to res_config_odbc about 6 months ago but my Asterisk kept crashing.  I was told that the crashes were due to the version of ODBC distributed by CentOS 7 and that I would have to compile my own to be able to solve the issue.  Has this been solved?  Is the RPM ODBC package included with CentOS 7 still bugged?  I try to avoid using packages not included in the distribution as they make upgrades a pain later on.


Although CentOS7 is still on 2.3.1 for unixodbc, there were changes made in 13.10.0 that should prevent the crashes.  
http://lists.digium.com/pipermail/asterisk-dev/2016-June/075582.html








    Ok, thank you for the help.  I'll be trying out ODBC later today and test it for a few days.  You should probably mark res_config_mysql as deprecated now since it will not work with anything higher than 13.10 as is.




I created an issue for it anyway:
https://issues.asterisk.org/jira/browse/ASTERISK-26362

 

Quote:
Quote:
--


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




--
George JosephDigium, Inc. | Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - US
Check us out at: www.digium.com & www.asterisk.org
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