VoIP Mailing List Archives

[ldardini at gmail.com]

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 ;

[mjordan at digium.com]

On Tue, Jan 20, 2015 at 4:35 PM, Leandro Dardini <ldardini@gmail.com (ldardini@gmail.com)> wrote: