[Freeswitch-users] freeswitch crash while executing odbc_query

[Ken Rice]

This info is find and good, but its pretty useless with out a back trace
from a debugger such as gdb on linux... See
http://wiki.freeswitch.org/wiki/Debugging_Freeswitch

However if you are using mysql for the database via unixODBC (and I'll bet
you are) make sure you are using the _r version of the client libs as
specified here 
http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core#.2Fetc.2Fodbcinst.ini
_for_MySQL





On 10/8/12 2:52 AM, "Evgeniy Movlyan" <evgeniy at bestnet.kharkov.ua> wrote:

> Hello to all,
> I'm using mod_odbc_query in my dialplan to get nibble_rate, my dialplan is:
> 
> <condition field="${AUTH_RESULT_RADIUS}" expression="^OK$">
>   <action application="set"
> data="effective_caller_id_number=${outbound_caller_id_number}"/>
>   <action application="set"
> data="effective_caller_id_name=${outbound_caller_id_name}"/>
>   <action application="odbc_query" inline="true" data="get_rate"/>
>   <action application="sleep" data="1000"/>
>   <action application="bridge"
> data="{ignore_early_media=ring_ready,enable_heartbeat_events=60,nibble_rate=${
> rate},nibble_account=${caller_id_number}}sofia/gateway/${default_gateway}/${di
> aled_number}"/>
> </condition>
> 
> get_rate query:
> <query name="get_rate" value="SELECT
> radgetprice('${dialed_number}',localtimestamp,60) AS rate"/>
> 
> My problem is that freeswitch crashes when number of active calls
> reaches 5-7.
> Last messages in freeswitch.log are:
> Dialplan: sofia/internal/ABCDE at 1.2.3.4 Action odbc_query(get_rate) INLINE
> EXECUTE sofia/internal/ABCDE at 1.2.3.4 odbc_query(get_rate)
> 
> Can anybody help?

-- 
Ken
http://www.FreeSWITCH.org
http://www.ClueCon.com
http://www.OSTAG.org
irc.freenode.net #freeswitch