[Asterisk-Users] MySQL

[Darren Wiebe]

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
darren at aleph-com.net

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" <admin at vci.net>
>To: "Asterisk Users Mailing List - Non-Commercial Discussion"
><asterisk-users at lists.digium.com>
>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
>>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
>>    
>>
>
>_______________________________________________
>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
>
>  
>