Hi,
I was wondering if there is an app available that would let me run
queries on MySQL or Postgress database through the extensions.conf file
in Asterisk.
My goal is to be able to run a simple query on a database that could
return a value in an ${var} variable, or even the number or rows that
were returned in the query in a ${var}. There are a couple of things
in Asterisk I would like to accomplish, without having to fork an AGI
application, that involved getting/checking data in a database.
If there isn't such an app then I will look into creating one, which
I'd be willing to share.
Brian.
After having just seen this in -dev and responding to it, I have to say... PLEASE do NOT cross post. Almost every person on -dev is also on -user. Post to one place, and wait for your answer. If someone directs you to the other, then fine. Respect our time and resources by not doubling up on your request. On Thu, 2004-07-15 at 13:21, Brian Jones wrote:> Hi, > > I was wondering if there is an app available that would let me run > queries on MySQL or Postgress database through the extensions.conf file > in Asterisk. > > My goal is to be able to run a simple query on a database that could > return a value in an ${var} variable, or even the number or rows that > were returned in the query in a ${var}. There are a couple of things > in Asterisk I would like to accomplish, without having to fork an AGI > application, that involved getting/checking data in a database. > > If there isn't such an app then I will look into creating one, which > I'd be willing to share. > > Brian. > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users-- Steven Critchfield <critch@basesys.com>
Hi!> I was wondering if there is an app available that would let me run > queries on MySQL or Postgress database through the extensions.conf file > in Asterisk.Search for res_odbc http://www.voip-info.org/tiki-index.php?page=Asterisk%20res_config Cheers, Philipp
Brian,
Yes there is such a program - it is called as Perl, as you already may know. It
is simple and the best way to extract the confs from the database and execute.
We are doing it this way.
By the way is anyone using the Mysql Admin tool available here.
http://www.phpmyadmin.net/home_page/
If you dont want to spend the time to prepare the perl code and wants to see a
template that runs against the Mysql database, I can send you the perl code I am
using against Asterisk Conf database, to do exactly what you are planning to do.
Seshu Kanuri
-----Original Message-----
From: asterisk-users-admin@lists.digium.com
[mailto:asterisk-users-admin@lists.digium.com]On Behalf Of Brian Jones
Sent: Thursday, July 15, 2004 2:22 PM
To: asterisk-users@lists.digium.com
Cc: asterisk-dev@lists.digium.com
Subject: [Asterisk-Users] Database App
Hi,
I was wondering if there is an app available that would let me run
queries on MySQL or Postgress database through the extensions.conf file
in Asterisk.
My goal is to be able to run a simple query on a database that could
return a value in an ${var} variable, or even the number or rows that
were returned in the query in a ${var}. There are a couple of things
in Asterisk I would like to accomplish, without having to fork an AGI
application, that involved getting/checking data in a database.
If there isn't such an app then I will look into creating one, which
I'd be willing to share.
Brian.
_______________________________________________
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users