[Asterisk-Users] MySQL

Bill admin at vci.net
Fri Dec 10 10:10:26 MST 2004


    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 at vci.net>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users at 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 at vci.net>
> To: "Asterisk Users Mailing List - Non-Commercial Discussion"
> <asterisk-users at 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 at 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 at 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 at 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 at 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




More information about the asterisk-users mailing list