<div dir="ltr">Hi list,<br><br>This is comman issue when we use ODBC connection to get Database values. At the 1st attempt connection is not connected but soon automatically connected by aterisk. What is the real problem ? it this asterisk ODBC issue or else ?<br>
<br><br> -- Executing [_36899XX@incoming:1] Answer("SIP/100-00000034", "") in new stack<br> -- Executing [_36899XX@incoming:2] Set("SIP/100-00000034", "__StartTime=2011-09-30 11:30:20") in new stack<br>
-- Executing [_36899XX@incoming:3] Set("SIP/100-00000034", "__uniqueId=1317362420.155") in new stack<br> -- Executing [_36899XX@incoming:4] Set("SIP/100-00000034", "num=9172341457") in new stack<br>
-- Executing [_36899XX@incoming:5] Macro("SIP/100-00000034", "Student_Validation|2011-09-30 11:30:20") in new stack<br><br><span style="color: rgb(255, 102, 102);">[Sep 30 11:30:20] WARNING[24266]: res_odbc.c:105 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 08S01: [MySQL][ODBC 3.51 Driver][mysqld-5.0.77]MySQL server has gone away (66)</span><br style="color: rgb(255, 102, 102);">
<span style="color: rgb(255, 102, 102);">[Sep 30 11:30:20] WARNING[24266]: res_odbc.c:113 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to class [class-conf]...</span><br style="color: rgb(255, 102, 102);">
<span style="color: rgb(255, 102, 102);">[Sep 30 11:30:20] WARNING[24266]: res_odbc.c:201 ast_odbc_sanity_check: Connection is down attempting to reconnect...</span><br style="color: rgb(255, 102, 102);"><span style="color: rgb(255, 102, 102);">[Sep 30 11:30:20] NOTICE[24266]: res_odbc.c:531 odbc_obj_connect: Connecting class</span><br style="color: rgb(255, 102, 102);">
<span style="color: rgb(255, 102, 102);">[Sep 30 11:30:20] NOTICE[24266]: res_odbc.c:559 odbc_obj_connect: res_odbc: Connected to class [class-conf]</span><br style="color: rgb(255, 102, 102);"><span style="color: rgb(255, 102, 102);"> <span style="color: rgb(0, 0, 0);">-- Executing [s@macro-Student_Validation:1] Set("SIP/100-00000034", "ARRAY(credit|status|num_pin|num_only|__id_card|username|__admin_id|__tariff|__FreeMinUse|__everymonth|__NumWithPin)=375.91000,1,N,Y,2,034896,1,1,,N,N") in new stack</span></span><br>
-- Executing [s@macro-Student_Validation:2] GotoIf("SIP/100-00000034", "0?notValidUser:ValidUser") in new stack<br> -- Goto (macro-Student_Validation,s,6)<br><br><br><div dir="ltr"><br>-----<br>Thanks and regards<br>
<br> Virendra Bhati<br>+91-9172341457<br>Software Engineer<br></div><br>
</div>