JR Richardson
2006-Mar-28 15:22 UTC
[Asterisk-Users] Asterisk to MySQL Data Lookup Warning Message?
Hi All,
I'm getting a strange warning message when I perform a MYSQL data lookup.
The operation performs fine, I retrive the data I'm looking for and continue
on through the dial sequence without an issue. I'm wondering if this
warning message is something to be concerned about, can't find any info
about it.
warning message:
Mar 28 15:55:40 WARNING[27481]: app_addon_sql_mysql.c:318 aMYSQL_fetch:
ast_MYSQL_fetch: numFields=1
Should I be concerned? Does anyone know what it means?
Thanks.
JR
I'm dialing extension 1001
extensions.conf
[lookupmysql]
exten => _X.,1,MYSQL(Connect connid 10.10.10.110 asteriskdb password table)
exten => _X.,2,MYSQL(Query resultid ${connid} SELECT\ fullcontact\ from\
table_sip\ where\ name=${EXTEN})
exten => _X.,3,MYSQL(Fetch fetchid ${resultid} var1)
exten => _X.,4,MYSQL(Clear ${resultid})
exten => _X.,5,MYSQL(Disconnect ${connid})
exten => _X.,6,GotoIf($["${var1}" =
""]?invalid,i,1:${EXTEN},7)
exten => _X.,7,ChanIsAvail(SIP/${EXTEN}&IAX2/${EXTEN}|sj)
exten => _X.,8,Set(direct=${var1:4})
exten => _X.,9,Dial(SIP/${direct},30,r)
exten => _X.,10,Hangup
exten => _X.,108,Goto(sendtovm,${EXTEN},1)
exten => _X.,109,Hangup
asterisk-cli>
-- Goto (lookupmysql,1001,1)
-- Executing MYSQL("SIP/1239-fc6c", "Connect connid
10.10.10.110 asteriskdb password table") in new stack
-- Executing MYSQL("SIP/1239-fc6c", "Query resultid 1 SELECT
fullcontact from complete_sip where name=1001") in new stack
-- Executing MYSQL("SIP/1239-fc6c", "Fetch fetchid 2
var1") in new stack
Mar 28 15:55:40 WARNING[27481]: app_addon_sql_mysql.c:318 aMYSQL_fetch:
ast_MYSQL_fetch: numFields=1
-- Executing MYSQL("SIP/1239-fc6c", "Clear 2") in new
stack
-- Executing MYSQL("SIP/1239-fc6c", "Disconnect 1") in
new stack
-- Executing GotoIf("SIP/1239-fc6c",
"0?invalid|i|1:1001|7") in new stack
-- Goto (lookupmysql,1001,7)
-- Executing ChanIsAvail("SIP/1239-fc6c",
"SIP/1001&IAX2/1001|sj") in new stack
-- Executing Goto("SIP/1239-fc6c", "sendtovm|1001|1") in
new stack
-- Goto (sendtovm,1001,1)
JR Richardson
Engineering for the Masses
Tim Connolly
2006-Mar-31 11:00 UTC
[Asterisk-Users] Asterisk to MySQL Data Lookup Warning Message?
I've been seeing this for a while. No clue how to fix. The source I have
from my last update says extra_log=0, so it "shouldn't" be showing
this
message at all...
-----Original Message-----
From: asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of JR
Richardson
Sent: Tuesday, March 28, 2006 4:22 PM
To: asterisk-users@lists.digium.com
Subject: [Asterisk-Users] Asterisk to MySQL Data Lookup Warning Message?
Hi All,
I'm getting a strange warning message when I perform a MYSQL data
lookup. The operation performs fine, I retrive the data I'm looking for
and continue on through the dial sequence without an issue. I'm
wondering if this warning message is something to be concerned about,
can't find any info about it.
warning message:
Mar 28 15:55:40 WARNING[27481]: app_addon_sql_mysql.c:318 aMYSQL_fetch:
ast_MYSQL_fetch: numFields=1
Should I be concerned? Does anyone know what it means?
Thanks.
JR
I'm dialing extension 1001
extensions.conf
[lookupmysql]
exten => _X.,1,MYSQL(Connect connid 10.10.10.110 asteriskdb password
table) exten => _X.,2,MYSQL(Query resultid ${connid} SELECT\
fullcontact\ from\ table_sip\ where\ name=${EXTEN}) exten =>
_X.,3,MYSQL(Fetch fetchid ${resultid} var1) exten => _X.,4,MYSQL(Clear
${resultid}) exten => _X.,5,MYSQL(Disconnect ${connid}) exten =>
_X.,6,GotoIf($["${var1}" = ""]?invalid,i,1:${EXTEN},7) exten
=>
_X.,7,ChanIsAvail(SIP/${EXTEN}&IAX2/${EXTEN}|sj)
exten => _X.,8,Set(direct=${var1:4})
exten => _X.,9,Dial(SIP/${direct},30,r)
exten => _X.,10,Hangup
exten => _X.,108,Goto(sendtovm,${EXTEN},1) exten => _X.,109,Hangup
asterisk-cli>
-- Goto (lookupmysql,1001,1)
-- Executing MYSQL("SIP/1239-fc6c", "Connect connid
10.10.10.110
asteriskdb password table") in new stack
-- Executing MYSQL("SIP/1239-fc6c", "Query resultid 1 SELECT
fullcontact from complete_sip where name=1001") in new stack
-- Executing MYSQL("SIP/1239-fc6c", "Fetch fetchid 2
var1") in new
stack Mar 28 15:55:40 WARNING[27481]: app_addon_sql_mysql.c:318
aMYSQL_fetch: ast_MYSQL_fetch: numFields=1
-- Executing MYSQL("SIP/1239-fc6c", "Clear 2") in new
stack
-- Executing MYSQL("SIP/1239-fc6c", "Disconnect 1") in
new stack
-- Executing GotoIf("SIP/1239-fc6c",
"0?invalid|i|1:1001|7") in new
stack
-- Goto (lookupmysql,1001,7)
-- Executing ChanIsAvail("SIP/1239-fc6c",
"SIP/1001&IAX2/1001|sj")
in new stack
-- Executing Goto("SIP/1239-fc6c", "sendtovm|1001|1") in
new stack
-- Goto (sendtovm,1001,1)
JR Richardson
Engineering for the Masses
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users