[asterisk-users] cmd mysql

[Benchev]

> I've been using mysql databases more and more.  I've run
> across a couple
> of instances where I've either made a mistake on the ip
> address of the
> mysql database or for whatever reason, mysql wasn't
> running.  In those
> instances, I've noted that the mysql command will hang
> indefinitely
> (I've counted to 40 before killing it).
>
> The offending line is:
>
> exten => s,1,MYSQL(Connect connid 192.168.103.15
> mysqladmin 'xxxxxxxxx' did)
>
> Is there a way to specify a timeout for the mysql
> command?
>
> I'm not finding anything on Google, voip-info or the
> documents in the
> add-ons directory.  Any help would be appreciated.
>
By experience, after every query sequence you should use
MYSQL(Clear ${resultid}) otherwise they'll become 400.
As it is said into app_addon_sql_mysql.c
"Frees memory and datastructures associated with result
set."

Hope that helps,
Benchev

-----------------------------

БТК ADSL Старт - неограничен Интернет трафик само за 19.99 лв./мес. с договор за 2 години.
Само до 31 октомври, избери БТК ADSL пакет и тествай безплатно за 14 дни!
За повече информация:www.btc.bg
http://www.btc.bg/bg/new_btc_adsl_packs.php