[asterisk-bugs] [JIRA] (ASTERISK-28112) Asterisk is not able to use newly released mysql connector odbc 8.0.12 for voicemail

[Leandro Dardini (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-28112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=245280#comment-245280 ] 

Leandro Dardini commented on ASTERISK-28112:
--------------------------------------------

I can confirm there is a INT(11) column for origtime. This is the complete export for the current voicemail_message table.

{quote}
CREATE TABLE IF NOT EXISTS `voicemail_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dir` char(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `msgnum` int(11) NOT NULL DEFAULT '0',
  `context` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `macrocontext` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `callerid` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `origtime` int(11) DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  `recording` longblob,
  `flag` char(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `category` char(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mailboxuser` char(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mailboxcontext` char(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `msg_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `transcript` longblob,
  PRIMARY KEY (`id`),
  UNIQUE KEY `dirmsgnum` (`dir`,`msgnum`),
  KEY `voicemail_messages_dir` (`dir`),
  KEY `mailboxcontext` (`mailboxcontext`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3747 ;
{quote}

I have tried running MySQL 5.7 and MySQL 8.0 and that doesn't change the outcome. I tried running MySQL on the same server as asterisk and in a separate server and that doesn't change the outcome. If I use MySQL ODBC 8.0.11 it works perfectly, if I use ODBC 8.0.12, it doesn't work. In MySQL ODBC change log they report they have refactored the codebase removing old legacy code... maybe they have refactored too much.




> Asterisk is not able to use newly released mysql connector odbc 8.0.12 for voicemail
> ------------------------------------------------------------------------------------
>
>                 Key: ASTERISK-28112
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-28112
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Applications/app_voicemail/ODBC
>    Affects Versions: 13.23.1
>         Environment: CentOS 6 and 7, 64bit
>            Reporter: Leandro Dardini
>            Assignee: Leandro Dardini
>            Severity: Minor
>         Attachments: extconfig.conf, func_odbc.conf, odbc.ini, odbcinst.ini, res_odbc.conf, voicemail.conf
>
>
> When upgrading package on CentOS from mysql-connector-odbc version 8.0.11 to 8.0.12, it is no more possible to listen to voicemails. The message returned on the console is 
> {quote}
> Connected to Asterisk 13.23.0 currently running on mirtafrontend (pid = 7318)
> > 0x7f45f400a6a0 – Strict RTP learning complete - Locking on source address 79.37.122.94:4012
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-youhave.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘digits/1.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-INBOX.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-and.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘digits/2.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-Old.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-messages.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-onefor.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-first.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-message.ulaw’ (language ‘en’)
> [2018-09-12 23:01:13] WARNING[7738][C-00000007]: app_voicemail.c:8851 play_message: No origtime?!
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-advopts.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-repeat.ulaw’ (language ‘en’)
> {quote}
> Downgrading ODBC connector to 8.0.11 restores working app_voicemail.



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