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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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, [EMAIL PROTECTED] 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 _______________________________________________ --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
