[asterisk-users] Mailbox password change problem on realtime engine

[Leandro Dardini]

Hello,
I am struggling with what seems a common unresolved problem, changing the
password from voicemailman when using a realtime engine (adaptive_odbc in
my case, connected to mysql).

I have seen messages dating back to 2007 with this problem and the last one
was bug 5168, reported as closed, but without explaining the fix

https://issues.asterisk.org/jira/browse/ASTERISK-5168?jql=text%20~%20%22voicemail%20password%22

Just to avoid confusion, I do have a uniqueid column and that is primary
key with auto increment.

I checked the mysql log and no attempt is made to change the password.

Any idea about the source of the problem?

This is my voicemail table:

CREATE TABLE IF NOT EXISTS `voicemail` (
  `uniqueid` int(11) NOT NULL AUTO_INCREMENT,
  `te_id` int(11) NOT NULL,
  `context` char(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',
  `mailbox` char(80) COLLATE utf8_unicode_ci NOT NULL,
  `password` char(80) COLLATE utf8_unicode_ci NOT NULL,
  `fullname` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pager` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `attach` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `attachfmt` char(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `serveremail` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `language` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tz` char(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tzbytenant` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `deletevoicemail` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `saycid` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sendvoicemail` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `review` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tempgreetwarn` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `operator` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `envelope` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sayduration` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `saydurationm` int(3) DEFAULT NULL,
  `forcename` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `forcegreetings` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `callback` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dialout` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `exitcontext` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `maxmsg` int(5) DEFAULT NULL,
  `volgain` decimal(5,2) DEFAULT NULL,
  `imapuser` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `imappassword` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
  `welcomeoption` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `category` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fromstring` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `minsecs` int(11) NOT NULL,
  PRIMARY KEY (`uniqueid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=218 ;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20150120/e14f8320/attachment.html>