Just to clarify..my instructions where for setting up with pure MySQL. No ODBC required.
Matthew ----- Original Message ----- From: "VCI Help Desk" <[EMAIL PROTECTED]> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <[EMAIL PROTECTED]> Sent: Friday, December 10, 2004 8:44 AM Subject: Re: [Asterisk-Users] MySQL > Darren, > > Matthew submitted a set of instructions yesterday for setting up > voicemail with mysql and odbc. These are the fields he stated for use with > mysql. > > 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; > > > Bill > > > > > ----- Original Message ----- > From: Matthew Boehm > To: Asterisk Users Mailing List - Non-Commercial Discussion > Sent: Friday, December 10, 2004 8:41 AM > Subject: Re: [Asterisk-Users] MySQL > > > 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
