[Asterisk-bsd] CMD MYSQL: disconnect: Invalid connection identifier
Dread
dread at forrestclub.ru
Fri Feb 1 14:29:51 CST 2008
I have
asterisk# uname -a
FreeBSD asterisk.mksplus.local 7.0-PRERELEASE FreeBSD 7.0-PRERELEASE #0:
Fri Feb 1 11:54:59 MSK 2008
dread at asterisk.mksplus.local:/usr/obj/usr/src/sys/ASTERISK i386
asterisk# pkg_info | grep asterisk
asterisk-1.4.17 An Open Source PBX and telephony toolkit
asterisk-addons-1.4.5 GPL modules for the Asterisk Open Source PBX
asterisk#
in my extensions.conf
....
exten => s,n,MYSQL(Connect connid localhost asterisk 'asterisk' asterisk)
..
..
exten => s,n(play),Playback(flash)
exten => s,n,GOTO(s-${PLAYBACKSTATUS},1)
exten=>s-SUCCESS,1,MYSQL(Queryresultid${connid}UPDATE\dial_out\SET\last_call_result=\'SUCCESS\'\WHERE\`calldate`=\'${DIAL_DATE}\'\AND\
`id`=\${CALLER_ID\})
exten => s-SUCCESS,2,MYSQL(Disconnect ${connid})
exten => s-SUCCESS,3,Hangup
Connected to Asterisk 1.4.17 currently running on asterisk (pid = 606)
[Feb 1 23:15:20] WARNING[606]: app_addon_sql_mysql.c:114
find_identifier: Identifier 0, identifier_type 1 not found in identifier
list
[Feb 1 23:15:20] WARNING[606]: app_addon_sql_mysql.c:370
aMYSQL_disconnect: Invalid connection identifier 0 passed in
aMYSQL_disconnect
[Feb 1 23:15:20] NOTICE[606]: pbx_spool.c:346 attempt_thread: Call
failed to go through, reason (3) Remote end Ringing
asterisk*CLI> quit
More information about the Asterisk-BSD
mailing list