Belay that. I was looking at the wrong SQL statement.
Bill
----- Original Message -----
From: Bill
To: Asterisk Users Mailing List - Non-Commercial Discussion
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" <admin@vci.net>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users@lists.digium.com>
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" <admin@vci.net>
> To: "Asterisk Users Mailing List - Non-Commercial Discussion"
> <asterisk-users@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@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@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@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@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
