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 ;
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
