[Asterisk-Users] res_config

[Matthew Boehm]

Yep yep.

extconfig.conf
-------------------
;
; Static and realtime external configuration
; engine configuration
;
[settings]
;
; Static configuration files:
;
; file.conf => driver,database[,table]

; Realtime configuration engine
;
; maps a particular family of realtime
; configuration to a given database driver,
; database and table (or uses the name of
; the family if the table is not specified
;
;<family name> => <driver>,<database name>[,table name]

sipfriends => mysql,asterisk,customer_lines
voicemail => mysql,asterisk,voicemail_users
directory => mysql,asterisk,voicemail_users
realtime_ext => mysql,asterisk,realtime

If you don't have the mysql driver, you can get it here (shameless plug):

http://bugs.digium.com/bug_view_page.php?bug_id=0002613

or just continue to use the ODBC->MySQL method. The beauty of RealTime is
that it doesn't matter which driver you are using, the code doesn't change!

My Voicemail table:

CREATE TABLE voicemail_users (
  uniqueid int(11) NOT NULL auto_increment,
  context varchar(50) NOT NULL default '',
  mailbox int(5) NOT NULL default '0',
  password int(4) NOT NULL default '0',
  fullname varchar(50) NOT NULL default '',
  email varchar(50) NOT NULL default '',
  pager varchar(50) NOT NULL default '',
  options varchar(100) NOT NULL default '',
  stamp timestamp(14) NOT NULL,
  PRIMARY KEY  (uniqueid)
) TYPE=MyISAM;

2 rows of sample data:

INSERT INTO voicemail_users VALUES (1001, 'cytel', 3033, 3189, 'Julie
Stovall', 'js at mycom.com', '', 'attach=yes|hidefromdir=yes', 20041015161337);
INSERT INTO voicemail_users VALUES (1002, 'cytel', 3027, 3027, 'Leigh
Scott', 'le at mycom.com', '', '', 20041010114816);

Works great over here.

-Matthew

----- Original Message ----- 
From: "Trevor Peirce" <tpeirce at digitalcon.ca>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users at lists.digium.com>
Sent: Thursday, December 02, 2004 1:01 PM
Subject: Re: [Asterisk-Users] res_config


> Kristian Kielhofner wrote:
>
> > I am just getting started with res_config and ODBC.  I have MySQL all
> > setup and am filling it with my data.
>
> I've been trying to get started with this as well.  So far I've managed
> to get * to connect to MySQL and can query the tables with the realtime
> commends.
>
> I can't, however, for the life of me figure out how to get VM
> configurations to work.
>
> Does anyone have a working example of extconfig.conf and a dump of their
> VM table that I could peek at?
>
> I'll gladly update the wiki once I get this figured out.
>
> Thanks,
> Trev
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users