[Asterisk-Users] Voicemail in Realtime mode

[Luca Lafranchi Lists]

-----Original Message-----
From: Carlos Chavez [mailto:cursor at telecomabmex.com] 
Sent: mercoledì, 2. novembre 2005 19:04
To: Asterisk Users Mailing List - Non-Commercial Discussion;
lists at idea-net.ch
Subject: Re: [Asterisk-Users] Voicemail in Realtime mode

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 HYPERLINK
"http://www.voip-info.org/wiki/view/Asterisk+RealTime+Voicemail"http://www.v
oip-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

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.12.7/157 - Release Date: 02.11.2005
 
  

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.12.7/157 - Release Date: 02.11.2005