[asterisk-bugs] [JIRA] (ASTERISK-26056) Some realtime columns are wrong typed

[Richard Mudgett (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-26056?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Richard Mudgett updated ASTERISK-26056:
---------------------------------------

    Description: 
Really the problem it's present when I'm using res_config_mysql.so, not res_config_odbc.so, but in the form can't I select from components.

In Asterisk Realtime architecture over mysql config driver, on each PJSIP REGISTER asterisk throw this warnings and error to console:
{noformat}
[May 24 21:42:53] WARNING[1093]: res_config_mysql.c:1208 require_mysql: Realtime table ps_contacts at xxx: Column qualify_timeout cannot be a float
[May 24 21:42:53] WARNING[1093]: res_config_mysql.c:1246 require_mysql: Possibly unsupported column type 'text' on column 'path'
[May 24 21:42:53] WARNING[1093]: res_config_mysql.c:1162 require_mysql: Realtime table xxx at ps_contacts: column 'qualify_frequency' cannot be type 'int(11)' (need char)
[May 24 21:42:53] ERROR[1093]: res_pjsip_registrar.c:523 rx_task_core: Unable to bind contact 'sip:xxx at xxx.xxx.xxx.xxx:xxxxx;transport=UDP;rinstance=xxxxxxxxxxxxxxx' to AOR 'xxx'
{noformat}

res_config_mysql.conf
{noformat}
[asterisk]
dbhost = localhost
dbname = xxxxx
dbuser = xxxxx
dbpass = xxxxx
dbport = 3306
dbcharset = utf8
requirements=warn ; or createclose or createchar
{noformat}

sorcery.conf
{noformat}
[res_pjsip]
transport    = realtime,ps_transports
endpoint     = realtime,ps_endpoints
auth         = realtime,ps_auths
aor          = realtime,ps_aors
domain_alias = realtime,ps_domain_aliases
contact      = realtime,ps_contacts
 
[res_pjsip_outbound_registration]
registration = realtime,ps_registrations
 
[res_pjsip_endpoint_identifier_ip]
identify = realtime,ps_endpoint_id_ips
{noformat}

extconfig.conf
{noformat}
ps_transports      => mysql,asterisk
ps_registrations   => mysql,asterisk
ps_endpoints       => mysql,asterisk
ps_auths           => mysql,asterisk
ps_aors            => mysql,asterisk
ps_domain_aliases  => mysql,asterisk
ps_endpoint_id_ips => mysql,asterisk
ps_contacts        => mysql,asterisk
{noformat}

I'm using a database script from sources in {{contrib/realtime/mysql/mysql_config.sql}}


  was:
Really the problem it's present when I'm using res_config_mysql.so, not res_config_odbc.so, but in the form can't I select from components.

In Asterisk Realtime architecture over mysql config driver, on each PJSIP REGISTER asterisk throw this warnings and error to console:

\[May 24 21:42:53] WARNING\[1093]: res_config_mysql.c:1208 require_mysql: Realtime table ps_contacts at xxx: Column qualify_timeout cannot be a float
\[May 24 21:42:53] WARNING\[1093]: res_config_mysql.c:1246 require_mysql: Possibly unsupported column type 'text' on column 'path'
\[May 24 21:42:53] WARNING\[1093]: res_config_mysql.c:1162 require_mysql: Realtime table xxx at ps_contacts: column 'qualify_frequency' cannot be type 'int(11)' (need char)
\[May 24 21:42:53] ERROR\[1093]: res_pjsip_registrar.c:523 rx_task_core: Unable to bind contact 'sip:xxx at xxx.xxx.xxx.xxx:xxxxx;transport=UDP;rinstance=xxxxxxxxxxxxxxx' to AOR 'xxx'

res_config_mysql.conf

\[asterisk]
dbhost = localhost
dbname = xxxxx
dbuser = xxxxx
dbpass = xxxxx
dbport = 3306
dbcharset = utf8
requirements=warn ; or createclose or createchar

sorcery.conf

\[res_pjsip]
transport    = realtime,ps_transports
endpoint     = realtime,ps_endpoints
auth         = realtime,ps_auths
aor          = realtime,ps_aors
domain_alias = realtime,ps_domain_aliases
contact      = realtime,ps_contacts
 
\[res_pjsip_outbound_registration]
registration = realtime,ps_registrations
 
\[res_pjsip_endpoint_identifier_ip]
identify = realtime,ps_endpoint_id_ips

extconfig.conf

ps_transports      => mysql,asterisk
ps_registrations   => mysql,asterisk
ps_endpoints       => mysql,asterisk
ps_auths           => mysql,asterisk
ps_aors            => mysql,asterisk
ps_domain_aliases  => mysql,asterisk
ps_endpoint_id_ips => mysql,asterisk
ps_contacts        => mysql,asterisk

I'm using a database script from sources in contrib/realtime/mysql/mysql_config.sql



> Some realtime columns are wrong typed
> -------------------------------------
>
>                 Key: ASTERISK-26056
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-26056
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/General
>    Affects Versions: 13.9.0
>         Environment: Debian GNU/Linux 8.4 (jessie) x86_64
>            Reporter: Javier Valencia
>            Severity: Minor
>
> Really the problem it's present when I'm using res_config_mysql.so, not res_config_odbc.so, but in the form can't I select from components.
> In Asterisk Realtime architecture over mysql config driver, on each PJSIP REGISTER asterisk throw this warnings and error to console:
> {noformat}
> [May 24 21:42:53] WARNING[1093]: res_config_mysql.c:1208 require_mysql: Realtime table ps_contacts at xxx: Column qualify_timeout cannot be a float
> [May 24 21:42:53] WARNING[1093]: res_config_mysql.c:1246 require_mysql: Possibly unsupported column type 'text' on column 'path'
> [May 24 21:42:53] WARNING[1093]: res_config_mysql.c:1162 require_mysql: Realtime table xxx at ps_contacts: column 'qualify_frequency' cannot be type 'int(11)' (need char)
> [May 24 21:42:53] ERROR[1093]: res_pjsip_registrar.c:523 rx_task_core: Unable to bind contact 'sip:xxx at xxx.xxx.xxx.xxx:xxxxx;transport=UDP;rinstance=xxxxxxxxxxxxxxx' to AOR 'xxx'
> {noformat}
> res_config_mysql.conf
> {noformat}
> [asterisk]
> dbhost = localhost
> dbname = xxxxx
> dbuser = xxxxx
> dbpass = xxxxx
> dbport = 3306
> dbcharset = utf8
> requirements=warn ; or createclose or createchar
> {noformat}
> sorcery.conf
> {noformat}
> [res_pjsip]
> transport    = realtime,ps_transports
> endpoint     = realtime,ps_endpoints
> auth         = realtime,ps_auths
> aor          = realtime,ps_aors
> domain_alias = realtime,ps_domain_aliases
> contact      = realtime,ps_contacts
>  
> [res_pjsip_outbound_registration]
> registration = realtime,ps_registrations
>  
> [res_pjsip_endpoint_identifier_ip]
> identify = realtime,ps_endpoint_id_ips
> {noformat}
> extconfig.conf
> {noformat}
> ps_transports      => mysql,asterisk
> ps_registrations   => mysql,asterisk
> ps_endpoints       => mysql,asterisk
> ps_auths           => mysql,asterisk
> ps_aors            => mysql,asterisk
> ps_domain_aliases  => mysql,asterisk
> ps_endpoint_id_ips => mysql,asterisk
> ps_contacts        => mysql,asterisk
> {noformat}
> I'm using a database script from sources in {{contrib/realtime/mysql/mysql_config.sql}}



--
This message was sent by Atlassian JIRA
(v6.2#6252)