[asterisk-users] mySQL connection testing

[Andrew Thomas]

Danny - Thanks, but that wouldn't work either - as I am fetching
multiple rows (not in that example - but I do in a production
environment).

Steve - If mySQL in the dialplan is so bad - why did Digium include it
in the first place?  JFYI - I use mySQL in the dialplan all the time -
and it always works a treat - first time, every time.  I do use AGI for
'other' things (eg. I've completely re-written the AgentCallbackLogin
feature in php) and that also works a treat. Each to their own I guess.

Anyway - back to the question (repeated in case it got lost amongst all
this) "Is there a way to check if a specific MYSQL connection id is
connected or not?".

BTW - using a 'disconnect {connid}' twice doesn't actually break
anything - it just causes an error on the console.  So I can live with a
'no' answer.

Thanks


-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Steve
Edwards
Sent: 03 March 2011 17:23
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] mySQL connection testing


On Thu, 3 Mar 2011, Andrew Thomas wrote:

> Gentlemen, can we please not turn this in to an Asterisk and DB 
> commands
> bashing thread?

I'm just suggesting that maybe you are 'swimming upstream' trying to use

MySQL within the dialplan.

Much the same as if you were proposing an office system using a 'tin
cans 
and string' mesh with carrier pigeons for out of band call signaling and

having a problem with poop buildup on the endpoints -- I might propose 
using Asterisk :)

-- 
Thanks in advance,
------------------------------------------------------------------------
-
Steve Edwards       sedwards at sedwards.com      Voice: +1-760-468-3867
PST
Newline                                              Fax:
+1-760-731-3000

-- _____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
               http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


 If you have received this communication in error we would appreciate
you advising us either by telephone or return of e-mail. The contents
of this message, and any attachments, are the property of DataVox,
and are intended for the confidential use of the named recipient only.
If you are not the intended recipient, employee or agent responsible
for delivery of this message to the intended recipient, take note that
any dissemination, distribution or copying of this communication and
its attachments is strictly prohibited, and may be subject to civil or
criminal action for which you may be liable.
Every effort has been made to ensure that this e-mail or any attachments
are free from viruses. While the company has taken every reasonable
precaution to minimise this risk, neither company, nor the sender can
accept liability for any damage which you sustain as a result of viruses.
It is recommended that you should carry out your own virus checks
before opening any attachments. 

Registered in England. No. 27459085.