[asterisk-users] IVR and MySQL

[Jon Schøpzinsky]

Another way to do this, is to use the func_odbc library. Its very good for production use, on larger sites.
We use it on all of our asterisk servers, and it works great.


Venlig Hilsen/Kind Regards
Jon Leren Schøpzinsky
Solution Engineer
Dansk Erhvervs-Telefon A/S
tlf: +45 88200336
mob: +45 31206709

-----Original Message-----
From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Atis
Sent: 14. august 2007 14:14
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] IVR and MySQL

On 8/14/07, Thiago Maluf <malufrj at gmail.com> wrote:
> Hi Fabio,
> of course that you can.
>
> One way to do it is working with app MYSQL(), where you will put your sql as
> argumment.
> read more in
> http://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL

That's possible, but i wouldn't recommend on large production system.
Using MySQL you would need to connect and disconnect all the time, and
it takes resources.. I would suggest to append that info to CDR
userfield (if you are storing your CDR in MySQL), and run periodically
some script that extracts them. Of course it's more complex, but that
would be my way.

Regards,
Atis

-- 
Atis Lezdins,
IT Responsible of BEST Riga,
atis at BEST.eu.org
ICQ: 142239285
Skype: atis.lezdins
Cell Phone: +371 28806004 [Tele2, Latvia]
Work phone: +1 800 7502835 [Toll free, USA]
?BEST? -> www.BEST.eu.org

_______________________________________________
--Bandwidth and Colocation Provided by http://www.api-digital.com--

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users