<br> On 10/21/07, Doug Lytle wrote:<br><br>> Hey everybody,<br>> <br>> I've been using mysql databases more and more. I've run across a couple<br>> of instances where I've either made a mistake on the ip address of the
<br>> mysql database or for whatever reason, mysql wasn't running. In those<br>> instances, I've noted that the mysql command will hang indefinitely<br>> (I've counted to 40 before killing it).<br>>
<br>> The offending line is:<br>> <br>> exten => s,1,MYSQL(Connect connid <a href="http://192.168.103.15">192.168.103.15</a> mysqladmin 'xxxxxxxxx' did)<br><br> there are a couple of things wrong with your MYSQL() call,
<br> you may be confusing the db server because mysqladmin<br> the name of a mysql util, pick another username.<br><br> no quotes around the password.<br><br> Here are my statements, and they don't hang if mysql isn't
<br> running on the db server, the * console shows a connect<br> failed error and continues :<br><br><span style="font-family: courier new,monospace;"> exten => s,n,Set(db_host=<a href="http://192.168.111.11">192.168.111.11
</a></span><span style="font-family: courier new,monospace;">)<br></span><span style="font-family: courier new,monospace;"> exten => s,n,MYSQL(Connect db_connid ${db_host} user pass dbname)<br><br style="font-family: courier new,monospace;">
</span>> Is there a way to specify a timeout for the mysql command?<br>> <br>> I'm not finding anything on Google, voip-info or the documents in the<br>> add-ons directory. Any help would be appreciated.<br>
<br>more info here :<br><br><a href="http://www.voip-info.org/wiki/index.php?page=Asterisk+cmd+MYSQL">http://www.voip-info.org/wiki/index.php?page=Asterisk+cmd+MYSQL</a><br><br>--<br>