[Home]

Summary:ASTERISK-26056: res_config_mysql complains about Alembic MySQL schema
Reporter:Javier Valencia (javier.valencia)Labels:
Date Opened:2016-05-25 02:27:33Date Closed:
Priority:MinorRegression?
Status:Open/NewComponents:Addons/res_config_mysql
Versions:13.9.0 Frequency of
Occurrence		Constant
Related
Issues:
Environment:Debian GNU/Linux 8.4 (jessie) x86_64Attachments:
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@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@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@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}}
Comments:By: Asterisk Team (asteriskteam) 2016-05-25 02:27:34.428-0500

Thanks for creating a report! The issue has entered the triage process. That means the issue will wait in this status until a Bug Marshal has an opportunity to review the issue. Once the issue has been reviewed you will receive comments regarding the next steps towards resolution.

A good first step is for you to review the [Asterisk Issue Guidelines|https://wiki.asterisk.org/wiki/display/AST/Asterisk+Issue+Guidelines] if you haven't already. The guidelines detail what is expected from an Asterisk issue report.

Then, if you are submitting a patch, please review the [Patch Contribution Process|https://wiki.asterisk.org/wiki/display/AST/Patch+Contribution+Process].
By: Rusty Newton (rnewton) 2016-05-25 14:55:51.307-0500

Edit - Ignore my comment. I was wrong about a couple things - looking at this again.

By: Rusty Newton (rnewton) 2016-05-25 16:06:21.056-0500

I'm going to open this up. I'm not sure whether the schema should be adjusted or res_config_mysql should be made to expect the current schema.

Note that res_config_mysql is under extended support. Extended support issues depend upon interested community developers being available to work them. The issue will remain open until a community member starts work on it.