asterisk users - Dec 2006 - mySQL and to many connections with SQL statement UPDATE

Hi,

If Iam doing UPDATE SQL statements I got an overload for connection.
am doing everytime an Disconnect ${connid}) but this is ignored.

any idea?

best regards
Thomas

>
> If Iam doing UPDATE SQL statements I got an overload for connection.
> am doing everytime an Disconnect ${connid}) but this is ignored.
>
> any idea?
>
You must clear the resut ID and also issue a disconnect to the
connection ID, see priority 4 and 5.

exten => _X.,1,MYSQL(Connect connid 10.10.10.110 asteriskdb password db)
exten => _X.,2,MYSQL(Query resultid ${connid} SELECT\ fullcontact\
from\ 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},8)
exten => _X.,8,Set(direct=${var1:4}) ;(strip off 'sip:' from
fullcontact info)
exten => _X.,9,Dial(SIP/${direct},15,r)
exten => _X.,10,Goto(sendtovm,${EXTEN},1)
exten => _X.,11,Hangup

Or a simpler method is to setup realtime access to the database and
use the realtime cmd, this will control the mysql access and you won't
have to worry about the connections.

http://www.voip-info.org/wiki/view/Asterisk+cmd+RealTime

-- 
JR Richardson
Engineering for the Masses