[Asterisk-Users] MySQL

Matthew Boehm mboehm at cytelcom.com
Fri Dec 10 11:13:20 MST 2004 

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