Hi, yes - i did have done it myself.
The main difference is that the dbquery application does use the res_mysqlpool - which is a small piece of code which does handle a pool of connections to one or more mysql servers. So you can make a fault tolerant system by using two master - master replicated mysql systems - and have mysqlpool configured to use both servers (and if one fails - it can use the other, and you can turn off one server by setting the conenction count to 0 for maintance). DBQuery does not let you execute direct mysql queries - you have to define them in the config before - but i like it that way... Also the cdr backend with a customized sql querie is handy. regards, Wolfgang Klaus Darilion schrieb: > Wolfgang Pichler schrieb: > >> Hi, >> >> you yould also use DBQuery (does only support mysql) - take a look at >> http://www.voip-info.org/wiki/view/Asterisk+cmd+DBQuery (it does also >> contain a cdr backend to write customzied cdr entries to the database) >> > > hi wolfgang! > > Have you programmed this yourself? > > Do you know how it compares to MYSQL function and func_odbc? > > regards > klaus > > > >> regards, >> Wolfgang >> >> Klaus Darilion schrieb: >> >>> Hi! >>> >>> What is the preferred way to make database lookups from within the dialplan? >>> >>> I only know the MYSQL function from asterisk-addons. Are the other >>> methods too? (e.g. for postgresql, unixodbc) >>> >>> thanks >>> klaus >>> >>> _______________________________________________ >>> -- Bandwidth and Colocation Provided by http://www.api-digital.com -- >>> >>> 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 -- >> >> 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 -- > > 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 -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users