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
