http://www.voip-info.org/tiki-index.php?page=Asterisk+RealTime
Bottom of the page, he just posted the link.
Greg
Darren Wiebe wrote:
I saw that thanks... I was looking for the fields for iax and sip friends, and extensions. If nobody has a list convenient, I will snoop some more and see what I come up with. I thought I saw one once but I have been unable to find it since. Probably mental block on my part. :-(
Darren Wiebe [EMAIL PROTECTED]
Matthew Boehm wrote:
What do you mean? For voicemail, I provided the fields in my instructions.
Matthew ----- Original Message ----- From: "Darren Wiebe" <[EMAIL PROTECTED]> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <[EMAIL PROTECTED]> Sent: Thursday, December 09, 2004 8:49 PM Subject: Re: [Asterisk-Users] MySQL
Does anybody have a list of fields that should be added to tables for a basic setup? I would gladly write a perl script to add them if somebody has a list.
Darren Wiebe [EMAIL PROTECTED]
Matthew Boehm wrote:
Sure. (I really need to write a wiki on this.)
You have two choices here before we start. You can use RealTime one of 2
ways: ODBC or direct MySQL. Currently these are the only two supported
methods.
Since I don't use ODBC and as the author of the MySQL RealTime driver,
I'm
going to instruct on how to use/install it.
The RealTime MySQL driver can be found inside asterisk-addons. Just do
the
standard make, make install.
Now copy asterisk-addons/configs/res_mysql.conf.sample to /etc/asterisk/res_mysql.conf (or whereever your conf dir is).
Edit the res_mysql.conf to your liking.
Now edit /etc/asterisk/extconfig.conf. Down at the bottom is the RealTime
config stuff. If you want voicemail, add this line:
voicemail => mysql,asterisk,voicemail_users
This basically says "Please use the RealTime MySQL driver, the database asterisk and the table voicemail_users and bind that to the voicemail family". You can change to your liking:
voicemail => <driver>,<databasename>,<tablename>
Now go into your mysql server and make the following table:
CREATE TABLE `voicemail_users` ( `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` 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;
Put in some rows. Restart asterisk and it should work. Please let me know
if
it works/doesn't work.
-Matthew
----- Original Message ----- From: "VCI Help Desk" <[EMAIL PROTECTED]> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <[EMAIL PROTECTED]> Sent: Thursday, December 09, 2004 4:44 PM Subject: [Asterisk-Users] MySQL
Does anyone have any instructions for setting up MySQL with the
latest
CVS? I upgraded from an older version this week and none of the MySQL
works
now and I believe it's due to the newer Realtime Architecture. I can't
find
any instructions that explain it very well anywhere. Any help would be appreciated.
Bill
_______________________________________________ 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
_______________________________________________
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
_______________________________________________ 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
