Timur,
Thank you for your response, I realize my mistake.
I didn't understand that the table structures were different for the
static component of real time as apposed to the actual real time part.
Thank you again for your assistance.
Nathan.
Timur V. Elzhov wrote:
On Thu, Aug 11, 2005 at 09:20:36AM -0400, Nathan Alberti wrote:
I'm having a few issues with the MySQL realtime configuration in
CVS-HEAD. I tested it initially with realtime extensions (realtime_ext
=> mysql,asterisk,extensions) and a realtime switch in extensions.conf
and that works fine, So I though I'd go back and test a static
configuration mapping.
I used the table structure from the asterisk guru postgres howto to
create something similar in MySQL (shown below) and included the
following in extconfig;
voicemail.conf => mysql,asterisk,voicemail_users
No, this way is used to store NOT voicemail users info, but ANY
configuration file. To create such a table from the existing config
filr use ast2sql.pl script. Link is given here:
http://www.voip-info.org/tiki-index.php?page=Asterisk+RealTime+Static
But you're probably want to create just the voicemail users config
table:
####MySQL Table####
CREATE TABLE voicemail_users (
id int NOT NULL auto_increment,
customer_id varchar(255) NOT NULL default '0',
context varchar(255) NOT NULL default '',
mailbox varchar(255) NOT NULL default '',
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 datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
);
#######
So the correct line in extconfig.conf must be
voicemail => mysql,asterisk,voicemail_users
not voicemail.conf => mysql,asterisk,voicemail_users
--
Best regards,
Timur.
_______________________________________________
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
