[asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

[jon pounder]

On 09/15/2010 12:42 PM, Leif Madsen wrote:
> On 10-09-15 05:25 AM, Jonas Kellens wrote:
>    
>> I think I've found it :
>>
>> Asterisk always reboots on this part :
>>
>> [Sep 15 11:16:32] -- Goto (azura,pbx,1)
>> [Sep 15 11:16:32] -- Executing [pbx at azura:1]
>> NoOp("SIP/INTERTELin-00000000", "3252480333 = pbx formule") in new stack
>> [Sep 15 11:16:32] -- Executing [pbx at azura:2]
>> Set("SIP/INTERTELin-00000000", "CDR(accountcode)=AZURAin") in new stack
>> [Sep 15 11:16:32] -- Executing [pbx at azura:3]
>> Set("SIP/INTERTELin-00000000", "BRON="473555006"<473555006>") in new stack
>> [Sep 15 11:16:32] -- Executing [pbx at azura:4]
>> Goto("SIP/INTERTELin-00000000", "vakantie") in new stack
>> [Sep 15 11:16:32] -- Goto (azura,pbx,5)
>> [Sep 15 11:16:32] -- Executing [pbx at azura:5]
>> Macro("SIP/INTERTELin-00000000", "vakantie,58") in new stack
>> [Sep 15 11:16:32] -- Executing [s at macro-vakantie:1]
>> MYSQL("SIP/INTERTELin-00000000", "Connect connid localhost username
>> passwd AsteriskHosted") in new stack
>> [Sep 15 11:16:32] -- Executing [s at macro-vakantie:2]
>> MYSQL("SIP/INTERTELin-00000000", "Query resultid 1 SELECT ast1 , ast2 ,
>> na , naID FROM vakantiedata where ID=58") in new stack
>> vps2301*CLI>
>> Disconnected from Asterisk server
>> [Sep 15 11:16:32] Executing last minute cleanups
>>
>>
>> Dialplan :
>>
>> [macro-vakantie]
>> exten =>  s,1,MYSQL(Connect connid localhost username passwd AsteriskHosted)
>> exten =>  s,n,MYSQL(Query resultid ${connid} SELECT ast1 , ast2 , na ,
>> naID FROM vakantiedata where ID=${ARG1})
>> exten =>  s,n,MYSQL(Fetch fetchid ${resultid} AST1 AST2 NA naID )
>> exten =>  s,n,NoOp(vakantie-ast1 = ${AST1} vakantie-ast2 = ${AST2} na =
>> ${NA} naID = ${naID})
>> exten =>  s,n,MYSQL(Clear ${resultid})
>> exten =>  s,n,MYSQL(Disconnect ${connid})
>>
>> exten =>  s,n,NoOp(fetchid = ${fetchid})
>> exten =>  s,n,GoToIf($["${fetchid}"=="0"]?exit)
>>
>> exten =>  s,n,NoOp()
>> exten =>  s,n,GoToIfTime(${AST1}?opvakantie)
>> exten =>  s,n,GoToIfTime(${AST2}?opvakantie)
>>
>> exten =>  s,n(exit),NoOp()
>> exten =>  s,n,Set(vakantieresult=continue)
>> exten =>  s,n,MacroExit
>>
>> exten =>  s,n(opvakantie),NoOp(op vakantie !)
>> exten =>  s,n,GoToIf($["${NA}"="hangup"]?hangup:route)
>>
>>
>> Do you guys see why Asterisk has problems with this part of the dialplan ?!
>>      
> I've seen problems with MYSQL() application crashing on customers boxes before.
> It is not that well supported, and would greatly recommend you move to func_odbc
> usage for dialplan<->database integration.
>
> Not only will it simplify your dialplan, but likely will resolve your crashing
> issues as well. I've done this for at least 3 customers who were using MYSQL()
> and all crashing issues stopped and their dialplans ended up becoming
> significantly more readable.
>    

This will also fix any real or perceived mysql takeover issues since 
odbc can be attached to any backend without changing the code.
> Leif.
>
>