[Asterisk-Users] Voicemail in Realtime mode

[lists at idea-net.ch]

> On Wed, 2005-11-02 at 16:56 +0100, Luca Lafranchi Lists wrote:
>> Hi,
>>
>> I have installed the asterisk 1.2 beta version and I have created the
>> voicemail table described on this page
>> http://www.voip-info.org/wiki/view/Asterisk+RealTime+Voicemail,
>>
>> but when I start the asterisk server I receive the following error.
>>
>> Any idea ?
>>
>
>     We are going to need more information if you want help.  What
> database are you using?  Did you configure the res_(database).conf file
> correctly?  Provide your extconfig.conf file.

Yes, the res_mysql.conf it's configured correctly because the sip_buddies
in realtime works fine.

This is my extconfig.conf
;
; Static and realtime external configuration
; engine configuration
;
; Please read doc/README.extconfig for basic table
; formatting information.
;
[settings]

;static
extensions.conf => mysql,pbx,PBX_extensions_conf
queues.conf => mysql,pbx,PBX_queues_conf

;realtime
sipusers => mysql,pbx,PBX_sip_buddies
sippeers => mysql,pbx,PBX_sip_buddies
voicemail => mysql,pbx,PBX_voicemail

this is the voicemail table for realtime in pbx db

CREATE TABLE `PBX_voicemail` (
  `uniqueid` int(11) NOT NULL auto_increment,
  `customer_id` int(11) NOT NULL default '0',
  `context` varchar(50) NOT NULL default '',
  `mailbox` int(5) NOT NULL default '0',
  `password` varchar(4) NOT NULL default '0',
  `fullname` varchar(50) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `pager` varchar(50) NOT NULL default '',
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
  PRIMARY KEY  (`mailbox`),
  KEY `mailbox_context` (`mailbox`,`context`,`uniqueid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


>
>
>
> --
> Carlos Chavez
> Director de Tecnología
> Telecomunicaciones Abiertas de México S.A. de C.V.
> Tel: +52-55-91169161 Ext 2001
>