[Asterisk-Users] MySQL

Matthew Boehm mboehm at cytelcom.com
Fri Dec 10 11:18:49 MST 2004 

OK. You don't have most recent version of Asterisk. In the CVS,
mysql-vm-routines.h has been completly removed.

>   What exactly is this new "RealTime" stuff? Is this an existing package
> that's being integrated into Asterisk or something made from scratch?

RealTime is being developed by mark himself into the core of asterisk.
RealTime is an asterisk database abstraction.

RealTime removes TONS of database specific code (look at app_voicemail.c for
example of TONS of code) and replaces it with 1 or 2 lines. The connection
handling, query execution, etc..is all handled by a RealTime "driver". There
are currently only 2 drivers, ODBC and MySQL.

The purpose of this was to (again) remove the specific code from each
application and replace it with "generic" calls. Inside your extconfig.conf
you assign certain key words (aka "families") to be bound to a specific
driver, database and table name.

config.c/config.h handles the registration of these families. So that when
you use RealTime to load a specific family, the driver you associated with
it is called.

wiki is comming this weekend..i promise..

-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: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 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