[asterisk-users] Mysql PJSIP realtime > 13.10?

[Annus Fictus]

Hello,

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

Regards


El 12/09/2016 a las 15:14, Carlos Chavez escribió:
>     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 at 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 at 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 at 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 at 192.168.2.165:5060;transport=udp' to AOR '2001'
>   == Contact 2001/sip:2001 at 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.
>