If you are using mysql-vm-routines.h then you are NOT using RealTIme and therefor you can ignore anything I've sent cause I was under the impression that you were using most recent CVS and not 1.0 stable.
-Matthew ----- Original Message ----- From: "Bill" <[EMAIL PROTECTED]> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <[EMAIL PROTECTED]> Sent: Friday, December 10, 2004 11:06 AM Subject: Re: [Asterisk-Users] MySQL > I've got it working better. I started using a different user with a > password instead of using root with no password and I see it trying in the > /var/log/mysql.log file. I also removed the old dbuser,dbpass, etc.. lines > from the voicemail.conf file. > > SELECT * FROM users WHERE mailbox = '540' AND context = 'default' > > Now I don't see where this 'default' context is coming from because I > have that set to 'from-sip' in my extentions.conf and my sip.conf files. > Any ideas where that is? > > extconfig.conf - voicemail => mysql,asterisk,users (I renamed the > table to "users" and created it as such) > > res_mysql.conf > [general] > dbhost = 127.0.0.1 > dbname = asterisk > dbuser = asterisk > dbpass = test > dbport = 3306 > dbsock = /var/lib/mysql/mysql.sock > > The res_config_mysq.so is installed in the modules directory with the > others. > > What exactly is this new "RealTime" stuff? Is this an existing package > that's being integrated into Asterisk or something made from scratch? > > 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
