[quote=“g2010”]please ignore the previous post. the guy is pushing some convoluted Oracle product which in my opinion sounds like piss… anyway.
You have a couple of options.
1 - There is a third party application called app_dbquery. It works in conjunction with res_mysqlpool and it allows you to do simple DB queries directly from the dialplan. I used it and it worked fine… only problem I found was that on occasion I would get an error about not being able to retrieve a connection from the pool, although there were definitely available connections. (Note: looks like the download page is down. PM me if you want me to email you a tarball of the source package).
2 - You could write a simple AGI script to do the database lookup and either set a channel variable, or do the dial from the AGI script and handle the call cleanup as well. Both Perl and PHP have nice AGI libraries available. I personally use Asterisk-Java and FastAGI, but that’s probably a bit much for this application.
thanks G…for replying my forum…Actually i’m using SIP server to forward the calls and those numbers are registered by user…so i have to dial to those numbers.I’m using phpagi script and MYSQL database.