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 Sent from my iPhone > __________________________________________________________________ > -- 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 -- _____________________________________________________________________ -- 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
