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!8 ;