[asterisk-users] database queries from extensions.conf

[Wolfgang Pichler]

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
>