asterisk users - Jul 2005 - Can I introduce sql sentences in the DialPlan (Asterisk Realtime)??

Hallo all!

Know somebody, if exist Dialplan commands (specifically sql sentences)
for Asterisk Realtime?

For example:
I have users defined in mysql database.
In the dialplan, I would like to select one field of a table.
select email from sip_buddies where name=200

I try to use DBget, but I have error. I think because DBget use intern
Database, and can 't connect to mysql.
(Sintaxis:  DBget(varname=family/key))

I think (if it does not exist at the moment) that it is very interesant
we can write in the dialplan sql-sentences
What think about this?

Leonardo F. Bauchwitz


	

	
		
___________________________________________________________ 
1GB gratis, Antivirus y Antispam 
Correo Yahoo!, el mejor correo web del mundo 
http://correo.yahoo.com.ar

Leonardo F. Bauchwitz wrote:
> Hallo all!
> 
> Know somebody, if exist Dialplan commands (specifically sql sentences)
> for Asterisk Realtime?
> 
> For example:
> I have users defined in mysql database.
> In the dialplan, I would like to select one field of a table.
> select email from sip_buddies where name=200
> 
> I try to use DBget, but I have error. I think because DBget use intern
> Database, and can 't connect to mysql.
> (Sintaxis:  DBget(varname=family/key))
> 
> I think (if it does not exist at the moment) that it is very interesant
> we can write in the dialplan sql-sentences
> What think about this?
> 
> Leonardo F. Bauchwitz
CLI> show application realtime

you could do

exten => 12,1,Realtime(sippeers,name,200)

also look at app_addon_mysql if you want to do pure SQL queries not 
supported by realtime

-Matthew