over the weekend I migrated my entire system from all the php scripts which configured all the asterisk. now i’ve switched over to asterisk realtime and everything works apart from the voicemail, even my custom apps work, just not the voicemail.
calls seem to hungup when it gets to the Voicemail app.
Thanks for any help that is provided.
[settings]
sipusers => mysql,asteriskrealtime,sipbuddies
sippeers => mysql,asteriskrealtime,sipbuddies
iaxusers => mysql,asteriskrealtime,iaxbuddies
iaxpeers => mysql,asteriskrealtime,iaxbuddies
extensions => mysql,asteriskrealtime,extensions
iaxinbound => mysql,asteriskrealtime,extensions
voicemail => mysql,asteriskrealtime,voicemail_users
queues => mysql,asteriskrealtime,queues
queue_members => mysql,asteriskrealtime,queue_members
CREATE TABLE asteriskrealtime.voicemail_users (
uniqueid int(11) NOT NULL auto_increment,
customer_id varchar(11) NOT NULL default ‘0’,
context varchar(50) NOT NULL default ‘’,
mailbox varchar(11) NOT NULL default ‘0’,
password varchar(5) NOT NULL default ‘0’,
fullname varchar(150) NOT NULL default ‘’,
email varchar(50) NOT NULL default ‘’,
pager varchar(50) NOT NULL default ‘’,
tz varchar(10) NOT NULL default ‘gmt’,
attach varchar(4) NOT NULL default ‘yes’,
saycid varchar(4) NOT NULL default ‘yes’,
dialout varchar(10) NOT NULL default ‘’,
callback varchar(10) NOT NULL default ‘’,
review varchar(4) NOT NULL default ‘no’,
operator varchar(4) NOT NULL default ‘no’,
envelope varchar(4) NOT NULL default ‘no’,
sayduration varchar(4) NOT NULL default ‘no’,
saydurationm tinyint(4) NOT NULL default ‘1’,
sendvoicemail varchar(4) NOT NULL default ‘no’,
delete varchar(4) NOT NULL default ‘no’,
nextaftercmd varchar(4) NOT NULL default ‘yes’,
forcename varchar(4) NOT NULL default ‘no’,
forcegreetings varchar(4) NOT NULL default ‘no’,
hidefromdir varchar(4) NOT NULL default ‘yes’,
stamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (uniqueid),
KEY mailbox_context (mailbox,context)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
$data = array(
‘password’ => $rs->getString(‘vpexVoicemailPin’),
‘email’ => $rs->getString(‘vpexVoicemailEmail’),
‘pager’ => $rs->getString(‘vpexVoicemailEmail’),
‘fullname’ => $rs->getString(‘name’),
‘mailbox’ => $rs->getString(‘vpexExtension’),
‘customer_id’ => $rs->getInt(‘vpexCustomerId’)
);
# now add the extension
$this->database->insert('voicemail_users', $data, 'asteriskrealtime');
