On 16/04/13 14:17, Gertjan Baarda wrote:
On 16 apr. 2013, at 15:08, Sebastian Arcus <[email protected]> wrote:
I would like to access a Postgresql database directly from my dialplan (to
lookup names based on callerid numbers for incoming calls). Based on everywhere
I looked - it seems the only way to do this is with func_odbc. Considering that
Asterisk seems to be able to access Postgresql databases directly using
res_pgsql for the purposes of realtime functionality (without using odbc - if I
understand correctly) - is there some other generic SQL dialplan function which
would allow access to the Postgresql database from the dialplan without
configuring ODBC and the rest?
Or does anybody know of a simpler way still to do this? My database is a Horde
address book backend - which is in Postgresql - so I would like to use it to
convert the incoming callerid's into names on the fly from the Horde address
book.
AGI is your new friend. Google it. I use it for your the same purpuses
as you want with PHP and Mysql.
With a macro I change the callerid in a name from the DB.
greetz
Thank you Gertjan. I have somehow managed to avoid AGI all these years
and didn't even look into it to see what it does. I've just had a
glance, and it seems to be exactly what I'm after. Thanks again for the
suggestion
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
