[Asterisk-Users] MySQL

[Darren Wiebe]

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.

Darren Wiebe
darren at aleph-com.net

Matthew Boehm wrote:

>What do you mean? For voicemail, I provided the fields in my instructions.
>
>Matthew
>----- Original Message ----- 
>From: "Darren Wiebe" <darren at aleph-com.net>
>To: "Asterisk Users Mailing List - Non-Commercial Discussion"
><asterisk-users at lists.digium.com>
>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
>>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
>>>
>>>
>>>
>>>      
>>>
>>_______________________________________________
>>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
>
>  
>