OK. You don't have most recent version of Asterisk. In the CVS, mysql-vm-routines.h has been completly removed.
> What exactly is this new "RealTime" stuff? Is this an existing package > that's being integrated into Asterisk or something made from scratch? RealTime is being developed by mark himself into the core of asterisk. RealTime is an asterisk database abstraction. RealTime removes TONS of database specific code (look at app_voicemail.c for example of TONS of code) and replaces it with 1 or 2 lines. The connection handling, query execution, etc..is all handled by a RealTime "driver". There are currently only 2 drivers, ODBC and MySQL. The purpose of this was to (again) remove the specific code from each application and replace it with "generic" calls. Inside your extconfig.conf you assign certain key words (aka "families") to be bound to a specific driver, database and table name. config.c/config.h handles the registration of these families. So that when you use RealTime to load a specific family, the driver you associated with it is called. wiki is comming this weekend..i promise.. -Matthew ----- Original Message ----- From: "Bill" <[EMAIL PROTECTED]> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <[EMAIL PROTECTED]> Sent: Friday, December 10, 2004 11:10 AM Subject: Re: [Asterisk-Users] MySQL > I just noticed something regarding my last post about the context issue > with the MySQL and Voicemail. In mysql-vm-routines.h it looks like the > context value in the SQL statement is hardcoded so no matter what my context > is it'll never work unless I change my context to 'default'. > > Bill > > > > > > ----- Original Message ----- > From: Matthew Boehm > To: Asterisk Users Mailing List - Non-Commercial Discussion > Sent: Friday, December 10, 2004 10:02 AM > Subject: Re: [Asterisk-Users] MySQL > > > Post your extconfig.conf. Do you have > /usr/lib/asterisk/modules/res_config_mysql.so installed? Do you have > /etc/asterisk/res_mysql.conf? > > -Matthew > ----- Original Message ----- > From: "Bill" <[EMAIL PROTECTED]> > To: "Asterisk Users Mailing List - Non-Commercial Discussion" > <[EMAIL PROTECTED]> > Sent: Friday, December 10, 2004 8:14 AM > Subject: Re: [Asterisk-Users] MySQL > > > > Matthew, > > > > I followed these instructions this morning and something about it's > not > > working. I was using the voicemail.conf before and I could login and > > everything worked ok but now I can't login at all. One thing that did get > > fixed was the CDR records when I did the "make install" from the > > asterisk-addons folder. > > > > In my /etc/my.conf file I have "log=/var/log/mysqld.log" so I can > watch > > what MySQL does. So far it never tries to do anything with the voicemail. > > That's how I noticed the CDR records started working. > > > > Any ideas? > > > > Bill > > > > > > > > > > ----- Original Message ----- > > From: Matthew Boehm > > To: Asterisk Users Mailing List - Non-Commercial Discussion > > Sent: Thursday, December 09, 2004 5:29 PM > > Subject: Re: [Asterisk-Users] MySQL > > > > > > 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
