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@incoming:1] Answer("SIP/100-00000034", "") in new
stack
-- Executing [_36899XX@incoming:2] Set("SIP/100-00000034",
"__StartTime=2011-09-30 11:30:20") in new stack
-- Executing [_36899XX@incoming:3] Set("SIP/100-00000034",
"__uniqueId=1317362420.155") in new stack
-- Executing [_36899XX@incoming:4] Set("SIP/100-00000034",
"num=9172341457") in new stack
-- Executing [_36899XX@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@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@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
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
