[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