[asterisk-users] ODBC connection not connected at 1st call.

[virendra bhati]

Hi list,

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 ?


  -- Executing [_36899XX at incoming:1] Answer("SIP/100-00000034", "") in new
stack
    -- Executing [_36899XX at incoming:2] Set("SIP/100-00000034",
"__StartTime=2011-09-30 11:30:20") in new stack
    -- Executing [_36899XX at incoming:3] Set("SIP/100-00000034",
"__uniqueId=1317362420.155") in new stack
    -- Executing [_36899XX at incoming:4] Set("SIP/100-00000034",
"num=9172341457") in new stack
    -- Executing [_36899XX at incoming:5] Macro("SIP/100-00000034",
"Student_Validation|2011-09-30 11:30:20") in new stack

[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)
[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]...
[Sep 30 11:30:20] WARNING[24266]: res_odbc.c:201 ast_odbc_sanity_check:
Connection is down attempting to reconnect...
[Sep 30 11:30:20] NOTICE[24266]: res_odbc.c:531 odbc_obj_connect: Connecting
class
[Sep 30 11:30:20] NOTICE[24266]: res_odbc.c:559 odbc_obj_connect: res_odbc:
Connected to class [class-conf]
    -- Executing [s at 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
 -- Executing [s at macro-Student_Validation:2] GotoIf("SIP/100-00000034",
"0?notValidUser:ValidUser") in new stack
    -- Goto (macro-Student_Validation,s,6)



-----
Thanks and regards

 Virendra Bhati
+91-9172341457
Software Engineer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110930/da33d752/attachment.htm>