[asterisk-users] IVR and MySQL

Atis atis at BEST.eu.org
Tue Aug 14 07:14:14 CDT 2007


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



More information about the asterisk-users mailing list