[Asterisk-Users] MySQL

[Matthew Boehm]

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