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', '[EMAIL PROTECTED]', '', 'attach=yes|hidefromdir=yes', 20041015161337); INSERT INTO voicemail_users VALUES (1002, 'cytel', 3027, 3027, 'Leigh Scott', '[EMAIL PROTECTED]', '', '', 20041010114816); Works great over here. -Matthew ----- Original Message ----- From: "Trevor Peirce" <[EMAIL PROTECTED]> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
